countdown_genres
10 rows where genre_id = 19
This data as json, CSV (advanced)
| Link | rank | genre_id |
|---|---|---|
| 263,19 | 263 263 | baroque pop 19 |
| 283,19 | 283 283 | baroque pop 19 |
| 320,19 | 320 320 | baroque pop 19 |
| 362,19 | 362 362 | baroque pop 19 |
| 453,19 | 453 453 | baroque pop 19 |
| 522,19 | 522 522 | baroque pop 19 |
| 740,19 | 740 740 | baroque pop 19 |
| 747,19 | 747 747 | baroque pop 19 |
| 842,19 | 842 842 | baroque pop 19 |
| 856,19 | 856 856 | baroque pop 19 |
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);