countdown_genres

12 rows where genre_id = 123

✎ View and edit SQL

This data as json, CSV (advanced)

Link rank genre_id
270,123 270 270 newgrass 123
336,123 336 336 newgrass 123
406,123 406 406 newgrass 123
408,123 408 408 newgrass 123
444,123 444 444 newgrass 123
553,123 553 553 newgrass 123
601,123 601 601 newgrass 123
619,123 619 619 newgrass 123
725,123 725 725 newgrass 123
770,123 770 770 newgrass 123
809,123 809 809 newgrass 123
824,123 824 824 newgrass 123

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