media_genre
5 rows where genre_id = 25
This data as json, CSV (advanced)
| Link | media_id | genre_id |
|---|---|---|
| 42,25 | WHEN WE ALL FALL ASLEEP, WHERE DO WE GO? 42 | Pop 25 |
| 46,25 | Poesiealbum 46 | Pop 25 |
| 50,25 | Evolve 50 | Pop 25 |
| 51,25 | Origins 51 | Pop 25 |
| 55,25 | Staub 55 | Pop 25 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE media_genre ( media_id INTEGER NOT NULL REFERENCES media(id), genre_id INTEGER NOT NULL REFERENCES genre(id), PRIMARY KEY (media_id, genre_id) );