countdown_genres
9 rows where genre_id = 177
This data as json, CSV (advanced)
| Link | rank | genre_id |
|---|---|---|
| 370,177 | 370 370 | soul jazz 177 |
| 417,177 | 417 417 | soul jazz 177 |
| 450,177 | 450 450 | soul jazz 177 |
| 475,177 | 475 475 | soul jazz 177 |
| 480,177 | 480 480 | soul jazz 177 |
| 638,177 | 638 638 | soul jazz 177 |
| 657,177 | 657 657 | soul jazz 177 |
| 742,177 | 742 742 | soul jazz 177 |
| 744,177 | 744 744 | soul jazz 177 |
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);