countdown_genres
22 rows where genre_id = 24
This data as json, CSV (advanced)
| Link | rank | genre_id |
|---|---|---|
| 265,24 | 265 265 | blues rock 24 |
| 294,24 | 294 294 | blues rock 24 |
| 307,24 | 307 307 | blues rock 24 |
| 344,24 | 344 344 | blues rock 24 |
| 364,24 | 364 364 | blues rock 24 |
| 398,24 | 398 398 | blues rock 24 |
| 442,24 | 442 442 | blues rock 24 |
| 525,24 | 525 525 | blues rock 24 |
| 566,24 | 566 566 | blues rock 24 |
| 632,24 | 632 632 | blues rock 24 |
| 653,24 | 653 653 | blues rock 24 |
| 687,24 | 687 687 | blues rock 24 |
| 698,24 | 698 698 | blues rock 24 |
| 700,24 | 700 700 | blues rock 24 |
| 701,24 | 701 701 | blues rock 24 |
| 718,24 | 718 718 | blues rock 24 |
| 727,24 | 727 727 | blues rock 24 |
| 741,24 | 741 741 | blues rock 24 |
| 753,24 | 753 753 | blues rock 24 |
| 791,24 | 791 791 | blues rock 24 |
| 800,24 | 800 800 | blues rock 24 |
| 861,24 | 861 861 | blues rock 24 |
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);