countdown_genres

15 rows where genre_id = 79

✎ View and edit SQL

This data as json, CSV (advanced)

Link rank genre_id
279,79 279 279 glam rock 79
380,79 380 380 glam rock 79
381,79 381 381 glam rock 79
384,79 384 384 glam rock 79
512,79 512 512 glam rock 79
534,79 534 534 glam rock 79
562,79 562 562 glam rock 79
567,79 567 567 glam rock 79
642,79 642 642 glam rock 79
685,79 685 685 glam rock 79
739,79 739 739 glam rock 79
779,79 779 779 glam rock 79
797,79 797 797 glam rock 79
816,79 816 816 glam rock 79
848,79 848 848 glam rock 79

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