countdown_genres

5 rows where genre_id = 157

✎ View and edit SQL

This data as json, CSV (advanced)

Link rank genre_id
257,157 257 257 rock and roll 157
372,157 372 372 rock and roll 157
496,157 496 496 rock and roll 157
819,157 819 819 rock and roll 157
853,157 853 853 rock and roll 157

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