home / pf

reviews_authors

16 rows where author_id = 140

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
390 390 <em>Half Moon Bay</em> 390 Gabriel Szatan 140
2297 2297 <em>Hybrid Theory (20th Anniversary Edition)</em> 2297 Gabriel Szatan 140
2328 2328 <em>Transmissions: The Music of Beverly Glenn-Copeland</em> 2328 Gabriel Szatan 140
2738 2738 <em>For You</em> 2738 Gabriel Szatan 140
2861 2861 <em>Born To Do It</em> 2861 Gabriel Szatan 140
3267 3267 <em>Tunes 2011 to 2019</em> 3267 Gabriel Szatan 140
3374 3374 <em>ISS004</em> 3374 Gabriel Szatan 140
3772 3772 <em>The Legend of Zelda: Ocarina of Time</em> 3772 Gabriel Szatan 140
10295 10295 <em>Freezing Opening Thawing EP</em> 10295 Gabriel Szatan 140
10379 10379 <em>Fabriclive 73</em> 10379 Gabriel Szatan 140
10388 10388 <em>Mr. Jones</em> 10388 Gabriel Szatan 140
10419 10419 <em>The Ancient Tonalities Of…</em> 10419 Gabriel Szatan 140
10479 10479 <em>Moods of Future Joy</em> 10479 Gabriel Szatan 140
10503 10503 <em>Land vs Air</em> 10503 Gabriel Szatan 140
25613 25613 <em>Random Access Memories (10th Anniversary Edition)</em> 25609 Gabriel Szatan 140
26253 26253 <em>Live at the Liquid Room, Tokyo</em> 26249 Gabriel Szatan 140

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE reviews_authors (
	review_id integer NOT NULL,
	author_id integer NOT NULL,
	FOREIGN KEY(review_id) REFERENCES reviews(id),
	FOREIGN KEY(author_id) REFERENCES authors(id),
	UNIQUE(review_id,author_id)
);
Powered by Datasette · Queries took 59.936ms