reviews_authors

17 rows where author_id = 148

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
443 443 <em>Extra Presence</em> 443 Dave Segal 148
1269 1269 <em>Amanita (25th Anniversary Edition)</em> 1269 Dave Segal 148
1277 1277 <em>Mod Prog Sic</em> 1277 Dave Segal 148
1318 1318 <em>Máscaras</em> 1318 Dave Segal 148
1394 1394 <em>Cracks</em> 1394 Dave Segal 148
1777 1777 <em>Exoplanet</em> 1777 Dave Segal 148
1828 1828 <em>Course in Fable</em> 1828 Dave Segal 148
2017 2017 <em>Rebirth of Wonky</em> 2017 Dave Segal 148
2129 2129 <em>Sand Like Stardust</em> 2129 Dave Segal 148
2138 2138 <em>Strum &amp; Thrum: The American Jangle Underground 1983 - 1987</em> 2138 Dave Segal 148
2373 2373 <em>voyage au soleil</em> 2373 Dave Segal 148
2405 2405 Solo / Solo II 2405 Dave Segal 148
2626 2626 <em>You’re a Crusher / drocan!</em> 2626 Dave Segal 148
2658 2658 <em>Maggot Brain</em> 2658 Dave Segal 148
2890 2890 <em>T.V. Sun</em> 2890 Dave Segal 148
25616 25616 <em>Try and Love</em> 25612 Dave Segal 148
26304 26304 <em>Ghost / Second Time Around / Temple Stone</em> 26300 Dave Segal 148

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