countdown_genres
20 rows where genre_id = 22
This data as json, CSV (advanced)
| Link | rank | genre_id |
|---|---|---|
| 270,22 | 270 270 | bluegrass 22 |
| 285,22 | 285 285 | bluegrass 22 |
| 295,22 | 295 295 | bluegrass 22 |
| 321,22 | 321 321 | bluegrass 22 |
| 336,22 | 336 336 | bluegrass 22 |
| 346,22 | 346 346 | bluegrass 22 |
| 377,22 | 377 377 | bluegrass 22 |
| 406,22 | 406 406 | bluegrass 22 |
| 408,22 | 408 408 | bluegrass 22 |
| 418,22 | 418 418 | bluegrass 22 |
| 444,22 | 444 444 | bluegrass 22 |
| 531,22 | 531 531 | bluegrass 22 |
| 579,22 | 579 579 | bluegrass 22 |
| 601,22 | 601 601 | bluegrass 22 |
| 619,22 | 619 619 | bluegrass 22 |
| 725,22 | 725 725 | bluegrass 22 |
| 770,22 | 770 770 | bluegrass 22 |
| 796,22 | 796 796 | bluegrass 22 |
| 809,22 | 809 809 | bluegrass 22 |
| 836,22 | 836 836 | bluegrass 22 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);