home / bibliothek

media_genre

9 rows where genre_id = 11

✎ View and edit SQL

This data as json, CSV (advanced)

Link media_id genre_id
17,11 Tschick 17 Krimi & Thriller 11
23,11 Shelter 23 Krimi & Thriller 11
30,11 Fayra: das Herz der Phönixtochter 30 Krimi & Thriller 11
37,11 Die Therapie 37 Krimi & Thriller 11
58,11 If We Were Villains: A Novel 58 Krimi & Thriller 11
117,11 The Hyde Park Headsman 117 Krimi & Thriller 11
124,11 Roter Drache 124 Krimi & Thriller 11
139,11 Die Schattenhand 139 Krimi & Thriller 11
140,11 Die Tote in der Bibliothek 140 Krimi & Thriller 11

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 5.026ms