media_genre
3 rows where genre_id = 10
This data as json, CSV (advanced)
| Link | media_id | genre_id |
|---|---|---|
| 15,10 | Schiller und die Freiheit des Geistes 15 | Biografie 10 |
| 25,10 | The resurrectionist: the lost work of Dr. Spencer Black 25 | Biografie 10 |
| 41,10 | The Danish Girl 41 | Biografie 10 |
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) );