reviews_authors

6 rows where author_id = 534

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
21504 21504 <em>Muswell Hillbillies</em> 21502 Jason Josephes 534
25230 25230 <em>Singles 1989-1991</em> 25226 Jason Josephes 534
25241 25241 <em>Keep it Like a Secret</em> 25237 Jason Josephes 534
25246 25246 <em>All-In</em> 25242 Jason Josephes 534
25254 25254 <em>Out of Tune</em> 25250 Jason Josephes 534
25255 25255 <em>Left for Dead in Malaysia</em> 25251 Jason Josephes 534

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