media_genre
2 rows where genre_id = 12
This data as json, CSV (advanced)
| Link | media_id | genre_id |
|---|---|---|
| 13,12 | Die Sonnenfinsternis am 11. August 1999: das Phänomen und seine spirituelle Dimension 13 | Schule & Lernen 12 |
| 18,12 | Dead Poets Society 18 | Schule & Lernen 12 |
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) );