home / pf

reviews_authors

41 rows where author_id = 293

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
3185 3185 <em>Enema of the State</em> 3185 Jeremy Gordon 293
4745 4745 <em>The Song Remains the Same</em> 4745 Jeremy Gordon 293
7383 7383 <em>Blood Sugar Sex Magik</em> 7383 Jeremy Gordon 293
7477 7477 <em>Primary Colours</em> 7477 Jeremy Gordon 293
7578 7578 <em>Future Present Past EP</em> 7578 Jeremy Gordon 293
7642 7642 <em>Teens of Denial</em> 7642 Jeremy Gordon 293
7884 7884 <em>III EP</em> 7884 Jeremy Gordon 293
7940 7940 <em>This Unruly Mess I've Made</em> 7940 Jeremy Gordon 293
7963 7963 <em>Seth Bogart</em> 7963 Jeremy Gordon 293
8010 8010 <em>Pool</em> 8010 Jeremy Gordon 293
8199 8199 <em>Side by Side EP</em> 8199 Jeremy Gordon 293
8279 8279 <em>Teens of Style</em> 8279 Jeremy Gordon 293
8365 8365 <em>V</em> 8365 Jeremy Gordon 293
8560 8560 <em>Another One</em> 8560 Jeremy Gordon 293
8590 8590 <em>The Most Lamentable Tragedy</em> 8590 Jeremy Gordon 293
8693 8693 <em>Grand Romantic</em> 8693 Jeremy Gordon 293
8860 8860 <em>California Nights</em> 8860 Jeremy Gordon 293
8970 8970 <em>Beat the Champ</em> 8970 Jeremy Gordon 293
8981 8981 <em>It Follows OST</em> 8981 Jeremy Gordon 293
9071 9071 <em>Perfect Abandon</em> 9071 Jeremy Gordon 293
9181 9181 <em>Teaspoon to the Ocean</em> 9181 Jeremy Gordon 293
9220 9220 <em>Natalie Prass</em> 9220 Jeremy Gordon 293
9235 9235 <em>Girls in Peacetime Want to Dance</em> 9235 Jeremy Gordon 293
9441 9441 <em>77</em> 9441 Jeremy Gordon 293
9649 9649 <em>Chorus</em> 9649 Jeremy Gordon 293
9896 9896 <em>Dalliance</em> 9896 Jeremy Gordon 293
9953 9953 <em>Boys</em> 9953 Jeremy Gordon 293
9964 9964 <em>Hour of the Dawn</em> 9964 Jeremy Gordon 293
9979 9979 <em>Bermuda Waterfall</em> 9979 Jeremy Gordon 293
9985 9985 <em>Youth Culture Forever</em> 9985 Jeremy Gordon 293
10053 10053 <em>The Way &amp; The Color</em> 10053 Jeremy Gordon 293
10228 10228 <em>Island Intervals</em> 10228 Jeremy Gordon 293
10328 10328 <em>The Age of Fracture</em> 10328 Jeremy Gordon 293
10336 10336 <em>Too Much Information</em> 10336 Jeremy Gordon 293
10354 10354 <em>Morgan Delt</em> 10354 Jeremy Gordon 293
10465 10465 <em>Dominae</em> 10465 Jeremy Gordon 293
10480 10480 <em>Harlem River</em> 10480 Jeremy Gordon 293
10610 10610 <em>Wish Hotel EP</em> 10610 Jeremy Gordon 293
10615 10615 <em>Brain Holiday</em> 10615 Jeremy Gordon 293
10773 10773 <em>Sundowning</em> 10773 Jeremy Gordon 293
25552 25552 <em>The Notorious Byrd Brothers</em> 25548 Jeremy Gordon 293

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 48.495ms