reviews_authors

11 rows where author_id = 522

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
16294 16294 <em>My Magic City</em> 16294 Ben Westhoff 522
16679 16679 <em>Doomtree</em> 16679 Ben Westhoff 522
16765 16765 <em>Deuces Wild</em> 16765 Ben Westhoff 522
16910 16910 <em>The In Crowd</em> 16910 Ben Westhoff 522
17050 17050 <em>Warchild</em> 17050 Ben Westhoff 522
17136 17136 <em>The Show</em> 17136 Ben Westhoff 522
17230 17230 <em>Golden Delicious</em> 17230 Ben Westhoff 522
17251 17251 <em>To Serve With Love</em> 17251 Ben Westhoff 522
17356 17356 <em>District Line</em> 17356 Ben Westhoff 522
17372 17372 <em>The Company of Wolves</em> 17372 Ben Westhoff 522
17425 17425 <em>Auditorium</em> 17425 Ben Westhoff 522

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