home / bibliothek

media_genre

5 rows where genre_id = 22

✎ View and edit SQL

This data as json, CSV (advanced)

Link media_id genre_id
43,22 BONES UK 43 Rock 22
47,22 The Battle at Garden’s Gate 47 Rock 22
49,22 Five 49 Rock 22
50,22 Evolve 50 Rock 22
51,22 Origins 51 Rock 22

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.395ms