countdown_genres

15 rows where genre_id = 117

✎ View and edit SQL

This data as json, CSV (advanced)

Link rank genre_id
260,117 260 260 motown 117
292,117 292 292 motown 117
299,117 299 299 motown 117
305,117 305 305 motown 117
323,117 323 323 motown 117
339,117 339 339 motown 117
342,117 342 342 motown 117
446,117 446 446 motown 117
478,117 478 478 motown 117
524,117 524 524 motown 117
587,117 587 587 motown 117
661,117 661 661 motown 117
764,117 764 764 motown 117
801,117 801 801 motown 117
827,117 827 827 motown 117

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