countdown_genres

11 rows where genre_id = 11

✎ View and edit SQL

This data as json, CSV (advanced)

Link rank genre_id
479,11 479 479 alternative rock 11
513,11 513 513 alternative rock 11
544,11 544 544 alternative rock 11
555,11 555 555 alternative rock 11
577,11 577 577 alternative rock 11
625,11 625 625 alternative rock 11
665,11 665 665 alternative rock 11
676,11 676 676 alternative rock 11
700,11 700 700 alternative rock 11
714,11 714 714 alternative rock 11
791,11 791 791 alternative rock 11

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