countdown_genres

6 rows where genre_id = 199

✎ View and edit SQL

This data as json, CSV (advanced)

Link rank genre_id
358,199 358 358 yacht rock 199
367,199 367 367 yacht rock 199
458,199 458 458 yacht rock 199
480,199 480 480 yacht rock 199
588,199 588 588 yacht rock 199
638,199 638 638 yacht rock 199

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);