reviews_authors

15 rows where author_id = 545

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
25497 25497 <em>The Great Escape</em> 25493 Dash Lewis 545
25621 25621 <em>Legacy Volume 2</em> 25617 Dash Lewis 545
25656 25656 <em>Nothing Bigger Than the Program</em> 25652 Dash Lewis 545
25709 25709 <em>The Onederful Nephew</em> 25705 Dash Lewis 545
25791 25791 <em>Journey to the Moon and Beyond</em> 25787 Dash Lewis 545
25855 25855 <em>Lord of the Shithouse</em> 25851 Dash Lewis 545
25907 25907 <em>Playing Robots Into Heaven</em> 25903 Dash Lewis 545
25930 25930 <em>66689 Blvd Prequel</em> 25926 Dash Lewis 545
25956 25956 <em>V</em> 25952 Dash Lewis 545
26050 26050 <em>How To Capture Playful</em> 26046 Dash Lewis 545
26115 26115 <em>HeadSpace</em> 26111 Dash Lewis 545
26120 26120 <em>A Grisaille Wedding</em> 26116 Dash Lewis 545
26235 26235 <em>Selected Jambient Works Vol. 1</em> 26231 Dash Lewis 545
26244 26244 <em>The Legend of ABM</em> 26240 Dash Lewis 545
26343 26343 <em>Pinball</em> 26339 Dash Lewis 545

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