media_filter

5 rows where item_id = 5

✎ View and edit SQL

This data as json, CSV (advanced)

Link media_id item_id
4,5 Cinemaxx 4 Non-Food 5
8,5 Drogerie Müller - 8 Non-Food 5
35,5 MediaMarkt 35 Non-Food 5
43,5 SATURN 43 Non-Food 5
47,5 toom Baumarkt 47 Non-Food 5

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);