reviews_authors

7 rows where author_id = 78

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
144 144 <em>Cyclorama</em> 144 Gio Santiago 78
353 353 <em>Greatest Hits ’88 - ’16</em> 353 Gio Santiago 78
634 634 <em>HYPNOS</em> 634 Gio Santiago 78
854 854 <em>It Was a Home</em> 854 Gio Santiago 78
1298 1298 <em>Colourgrade</em> 1298 Gio Santiago 78
1338 1338 <em>Deja</em> 1338 Gio Santiago 78
25409 25409 <em>Red Moon in Venus</em> 25405 Gio Santiago 78

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)
);