media_filter
2 rows where media_id = 41
This data as json, CSV (advanced)
| Link | media_id | item_id |
|---|---|---|
| 41,4 | REWE Region Südwest 41 | Food 4 |
| 41,6 | REWE Region Südwest 41 | LEH 6 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE media_filter ( media_id INTEGER NOT NULL, item_id INTEGER NOT NULL, PRIMARY KEY (media_id, item_id), FOREIGN KEY(media_id) REFERENCES media (id), FOREIGN KEY(item_id) REFERENCES filter_item (id) );