countdown_genres

14 rows where genre_id = 142

✎ View and edit SQL

This data as json, CSV (advanced)

Link rank genre_id
277,142 277 277 punk 142
284,142 284 284 punk 142
315,142 315 315 punk 142
410,142 410 410 punk 142
426,142 426 426 punk 142
481,142 481 481 punk 142
485,142 485 485 punk 142
520,142 520 520 punk 142
593,142 593 593 punk 142
708,142 708 708 punk 142
721,142 721 721 punk 142
780,142 780 780 punk 142
857,142 857 857 punk 142
873,142 873 873 punk 142

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