reviews_authors

12 rows where author_id = 84

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
161 161 <em>All Blue</em> 161 Brady Gerber 84
544 544 <em>Dripfield</em> 544 Brady Gerber 84
585 585 <em>Vanishing Act</em> 585 Brady Gerber 84
822 822 <em>SZNZ: Spring</em> 822 Brady Gerber 84
1019 1019 <em>Strictly a One-Eyed Jack</em> 1019 Brady Gerber 84
1026 1026 <em>The Overload</em> 1026 Brady Gerber 84
3113 3113 <em>I Was Born Swimming</em> 3113 Brady Gerber 84
3429 3429 <em>Singles Too</em> 3429 Brady Gerber 84
25313 25313 <em>Asking for a Ride</em> 25309 Brady Gerber 84
25720 25720 <em>3D Country</em> 25716 Brady Gerber 84
26177 26177 <em>Paradise EP</em> 26173 Brady Gerber 84
26326 26326 <em>Playing Favorites</em> 26322 Brady Gerber 84

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