countdown_genres

12 rows where genre_id = 105

✎ View and edit SQL

This data as json, CSV (advanced)

Link rank genre_id
370,105 370 370 jazz 105
417,105 417 417 jazz 105
450,105 450 450 jazz 105
475,105 475 475 jazz 105
493,105 493 493 jazz 105
592,105 592 592 jazz 105
626,105 626 626 jazz 105
654,105 654 654 jazz 105
657,105 657 657 jazz 105
742,105 742 742 jazz 105
841,105 841 841 jazz 105
882,105 882 882 jazz 105

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