countdown_genres

11 rows where genre_id = 86

✎ View and edit SQL

This data as json, CSV (advanced)

Link rank genre_id
279,86 279 279 hard rock 86
282,86 282 282 hard rock 86
415,86 415 415 hard rock 86
476,86 476 476 hard rock 86
496,86 496 496 hard rock 86
516,86 516 516 hard rock 86
519,86 519 519 hard rock 86
703,86 703 703 hard rock 86
728,86 728 728 hard rock 86
819,86 819 819 hard rock 86
853,86 853 853 hard rock 86

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