home / bibliothek

media_genre

3 rows where genre_id = 10

✎ View and edit SQL

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

CSV options:

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)
);
Powered by Datasette · Queries took 4.365ms