home / pf

reviews_authors

24 rows where author_id = 143

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
411 411 <em>Out Front</em> 411 Hank Shteamer 143
10348 10348 <em>20th Adversary of Emptiness</em> 10348 Hank Shteamer 143
10477 10477 <em>What The...</em> 10477 Hank Shteamer 143
10616 10616 <em>Aftershock</em> 10616 Hank Shteamer 143
10754 10754 <em>Surgical Steel</em> 10754 Hank Shteamer 143
10810 10810 <em>Colored Sands</em> 10810 Hank Shteamer 143
11071 11071 <em>13</em> 11071 Hank Shteamer 143
11113 11113 <em>Life in the Sugar Candle Mines</em> 11113 Hank Shteamer 143
11169 11169 <em>Kingdom of Conspiracy</em> 11169 Hank Shteamer 143
11338 11338 <em>Meir</em> 11338 Hank Shteamer 143
11527 11527 <em>The Bootleg Series, Volume 2: Live in Europe 1969</em> 11527 Hank Shteamer 143
11655 11655 <em>The Jazz Workshop Concerts 1964–65</em> 11655 Hank Shteamer 143
11796 11796 <em>Honor Found In Decay</em> 11796 Hank Shteamer 143
11994 11994 <em>Serpentine Path</em> 11994 Hank Shteamer 143
12361 12361 <em>Complete Discography</em> 12361 Hank Shteamer 143
12469 12469 <em>Dusk | Subside</em> 12469 Hank Shteamer 143
12546 12546 <em>Wreck</em> 12546 Hank Shteamer 143
12620 12620 <em>Corrosion of Conformity</em> 12620 Hank Shteamer 143
12759 12759 <em>Iron Balls of Steel</em> 12759 Hank Shteamer 143
12898 12898 <em>Carbon-Based Anatomy EP</em> 12898 Hank Shteamer 143
12961 12961 <em>Sessions 1981–83</em> 12961 Hank Shteamer 143
13041 13041 <em>The Bootleg Series, Volume 1: Live in Europe 1967</em> 13041 Hank Shteamer 143
25268 25268 <em>Emergency!</em> 25264 Hank Shteamer 143
26358 26358 <em>The Carnegie Hall Concert</em> 26354 Hank Shteamer 143

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.963ms