home / bibliothek

media_genre

5 rows where genre_id = 25

✎ View and edit SQL

This data as json, CSV (advanced)

Link media_id genre_id
42,25 WHEN WE ALL FALL ASLEEP, WHERE DO WE GO? 42 Pop 25
46,25 Poesiealbum 46 Pop 25
50,25 Evolve 50 Pop 25
51,25 Origins 51 Pop 25
55,25 Staub 55 Pop 25

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