home / pf

reviews_authors

25 rows where author_id = 54

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
79 79 <em>CAZIMI</em> 79 Brad Shoup 54
1021 1021 <em>Age of Apathy</em> 1021 Brad Shoup 54
1364 1364 <em>M Field EP</em> 1364 Brad Shoup 54
1479 1479 <em>Jesus Freak</em> 1479 Brad Shoup 54
1738 1738 <em>SKA DREAM</em> 1738 Brad Shoup 54
5145 5145 <em>In the Rainbow Rain</em> 5145 Brad Shoup 54
5223 5223 <em>Complicit EP</em> 5223 Brad Shoup 54
5291 5291 <em>The Louder I Call, the Faster It Runs</em> 5291 Brad Shoup 54
5448 5448 <em>All at Once</em> 5448 Brad Shoup 54
5929 5929 <em>I’m a Harmony</em> 5929 Brad Shoup 54
5952 5952 <em>The Aviary</em> 5952 Brad Shoup 54
6143 6143 <em>Sacred Hearts Club</em> 6143 Brad Shoup 54
25408 25408 <em>Soul’d Out: The Complete Wattstax Collection</em> 25404 Brad Shoup 54
25564 25564 <em>First Two Pages of Frankenstein</em> 25560 Brad Shoup 54
25605 25605 <em>ATUM</em> 25601 Brad Shoup 54
25753 25753 <em>If We Stayed Alive</em> 25749 Brad Shoup 54
25815 25815 <em>AUSTIN</em> 25811 Brad Shoup 54
25854 25854 <em>Mr. Greg &amp; Cass McCombs Sing and Play New Folk Songs for Children</em> 25850 Brad Shoup 54
25877 25877 <em>Domino</em> 25873 Brad Shoup 54
26000 26000 <em>Permission to Land… Again (20th Anniversary Edition)</em> 25996 Brad Shoup 54
26079 26079 <em>Hard Light</em> 26075 Brad Shoup 54
26182 26182 <em>Who’s a Good Boy</em> 26178 Brad Shoup 54
26192 26192 <em>Troper Sings Brion</em> 26188 Brad Shoup 54
26306 26306 <em>Daniel</em> 26302 Brad Shoup 54
26324 26324 <em>Bleachers</em> 26320 Brad Shoup 54

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)
);
Powered by Datasette · Queries took 60.532ms