home / xpn_countdown

countdown_genres

11 rows where genre_id = 174

✎ View and edit SQL

This data as json, CSV (advanced)

Link rank genre_id
266,174 266 266 soft rock 174
268,174 268 268 soft rock 174
358,174 358 358 soft rock 174
374,174 374 374 soft rock 174
413,174 413 413 soft rock 174
422,174 422 422 soft rock 174
458,174 458 458 soft rock 174
511,174 511 511 soft rock 174
563,174 563 563 soft rock 174
602,174 602 602 soft rock 174
666,174 666 666 soft rock 174

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE countdown_genres (
            rank INTEGER,
            genre_id INTEGER,
            FOREIGN KEY (rank) REFERENCES countdown(rank),
            FOREIGN KEY (genre_id) REFERENCES genres(id),
            PRIMARY KEY (rank, genre_id)
        );
CREATE INDEX idx_countdown_genres_genre ON countdown_genres(genre_id);
Powered by Datasette · Queries took 4.359ms