countdown_genres

21 rows where genre_id = 47

✎ View and edit SQL

This data as json, CSV (advanced)

Link rank genre_id
289,47 289 289 country rock 47
294,47 294 294 country rock 47
346,47 346 346 country rock 47
351,47 351 351 country rock 47
364,47 364 364 country rock 47
399,47 399 399 country rock 47
418,47 418 418 country rock 47
456,47 456 456 country rock 47
466,47 466 466 country rock 47
469,47 469 469 country rock 47
492,47 492 492 country rock 47
523,47 523 523 country rock 47
532,47 532 532 country rock 47
556,47 556 556 country rock 47
609,47 609 609 country rock 47
628,47 628 628 country rock 47
743,47 743 743 country rock 47
796,47 796 796 country rock 47
804,47 804 804 country rock 47
836,47 836 836 country rock 47
878,47 878 878 country rock 47

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