reviews_authors

234 rows where author_id = 300

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
3396 3396 <em>Tremble Under Boom Lights</em> 3396 Paul Thompson 300
3598 3598 <em>Are You Sleepy</em> 3598 Paul Thompson 300
4475 4475 <em>The Lillywhite Sessions</em> 4475 Paul Thompson 300
4506 4506 I Can See My House From Here 4506 Paul Thompson 300
4693 4693 <em>The Three EPs</em> 4693 Paul Thompson 300
5754 5754 <em>Vante EP</em> 5754 Paul Thompson 300
5897 5897 <em>Relatives in Descent</em> 5897 Paul Thompson 300
5938 5938 <em>Electric Trim</em> 5938 Paul Thompson 300
5984 5984 <em>The Echo of Pleasure</em> 5984 Paul Thompson 300
6083 6083 <em>Shitty Hits</em> 6083 Paul Thompson 300
6166 6166 <em>Deep Marble Sunrise</em> 6166 Paul Thompson 300
6448 6448 <em>Snow</em> 6448 Paul Thompson 300
6555 6555 <em>Strike a Match</em> 6555 Paul Thompson 300
6947 6947 <em>Mystery Cove</em> 6947 Paul Thompson 300
8543 8543 <em>Works for Tomorrow</em> 8543 Paul Thompson 300
8581 8581 <em>King Heavy Metal</em> 8581 Paul Thompson 300
8852 8852 <em>II</em> 8852 Paul Thompson 300
8976 8976 <em>Director</em> 8976 Paul Thompson 300
9091 9091 <em>You're Better Than This</em> 9091 Paul Thompson 300
9153 9153 <em>I Sell the Circus</em> 9153 Paul Thompson 300
9314 9314 <em>Confidence</em> 9314 Paul Thompson 300
9325 9325 <em>Out of Time</em> 9325 Paul Thompson 300
9343 9343 <em>Aliens in the Outfield EP</em> 9343 Paul Thompson 300
9456 9456 <em>Still Life</em> 9456 Paul Thompson 300
9478 9478 <em>Negative Qualities</em> 9478 Paul Thompson 300
9560 9560 <em>The Long Con</em> 9560 Paul Thompson 300
9605 9605 <em>Cowboy's Prayer EP</em> 9605 Paul Thompson 300
9811 9811 <em>Mosaics Within Mosaics</em> 9811 Paul Thompson 300
9814 9814 <em>White Reaper EP</em> 9814 Paul Thompson 300
9885 9885 <em>Bodies and Control and Money and Power</em> 9885 Paul Thompson 300
9903 9903 <em>Because I'm Worth It</em> 9903 Paul Thompson 300
9962 9962 <em>Days of Abandon</em> 9962 Paul Thompson 300
10040 10040 <em>Who Would Ever Want Anything So Broken? EP</em> 10040 Paul Thompson 300
10073 10073 <em>World of Joy</em> 10073 Paul Thompson 300
10130 10130 <em>Real People EP</em> 10130 Paul Thompson 300
10137 10137 <em>Teeth Dreams</em> 10137 Paul Thompson 300
10187 10187 <em>Joyland</em> 10187 Paul Thompson 300
10233 10233 <em>Wave 1</em> 10233 Paul Thompson 300
10274 10274 <em>Blame Confusion</em> 10274 Paul Thompson 300
10297 10297 <em>Real Hair EP</em> 10297 Paul Thompson 300
10350 10350 <em>Innocence</em> 10350 Paul Thompson 300
10360 10360 <em>Where Shine New Lights</em> 10360 Paul Thompson 300
10368 10368 <em>Shy Boys</em> 10368 Paul Thompson 300
10384 10384 <em>Eighteen Hours of Static</em> 10384 Paul Thompson 300
10399 10399 <em>Forever</em> 10399 Paul Thompson 300
10456 10456 <em>Blazing Gentlemen</em> 10456 Paul Thompson 300
10462 10462 <em>Live at Brixton</em> 10462 Paul Thompson 300
10541 10541 <em>Julia with Blue Jeans On</em> 10541 Paul Thompson 300
10545 10545 <em>Good Mood Fool</em> 10545 Paul Thompson 300
10632 10632 <em>Uncanney Valley</em> 10632 Paul Thompson 300
10649 10649 <em>Sunlight on the Moon</em> 10649 Paul Thompson 300
10654 10654 <em>Sway</em> 10654 Paul Thompson 300
10679 10679 <em>Body Language</em> 10679 Paul Thompson 300
10729 10729 <em>Brass</em> 10729 Paul Thompson 300
10745 10745 <em>Weird Sister</em> 10745 Paul Thompson 300
10753 10753 <em>Nobody Realizes This Is Nowhere</em> 10753 Paul Thompson 300
10789 10789 <em>Golden Suits</em> 10789 Paul Thompson 300
10794 10794 <em>Generic Treasure</em> 10794 Paul Thompson 300
10805 10805 <em>Flaamingos</em> 10805 Paul Thompson 300
10845 10845 <em>Pura Vida Conspiracy</em> 10845 Paul Thompson 300
10865 10865 <em>Edward Sharpe &amp; the Magnetic Zeros</em> 10865 Paul Thompson 300
10900 10900 <em>Tiny Rebels</em> 10900 Paul Thompson 300
11056 11056 <em>Pythons</em> 11056 Paul Thompson 300
11066 11066 <em>Evil Friends</em> 11066 Paul Thompson 300
11085 11085 <em>How Far Away</em> 11085 Paul Thompson 300
11089 11089 <em>Anarchic Breezes</em> 11089 Paul Thompson 300
11120 11120 <em>One Kiss Ends It All</em> 11120 Paul Thompson 300
11178 11178 <em>Fain</em> 11178 Paul Thompson 300
11207 11207 <em>English Little League</em> 11207 Paul Thompson 300
11229 11229 <em>II</em> 11229 Paul Thompson 300
11245 11245 <em>Rat Farm</em> 11245 Paul Thompson 300
11273 11273 <em>You Have Already Gone To The Other World</em> 11273 Paul Thompson 300
11280 11280 <em>Recurring Dream</em> 11280 Paul Thompson 300
11394 11394 <em>Deathfix</em> 11394 Paul Thompson 300
11435 11435 <em>Optica</em> 11435 Paul Thompson 300
11474 11474 <em>Spectral Park</em> 11474 Paul Thompson 300
11515 11515 <em>Oddfellows</em> 11515 Paul Thompson 300
11534 11534 <em>La Busta Gialla</em> 11534 Paul Thompson 300
11581 11581 <em>California X</em> 11581 Paul Thompson 300
11591 11591 <em>Light Up Gold</em> 11591 Paul Thompson 300
11595 11595 <em>Selling My Soul</em> 11595 Paul Thompson 300
11824 11824 <em>Over &amp; Over EP</em> 11824 Paul Thompson 300
11838 11838 <em>System Preferences</em> 11838 Paul Thompson 300
11865 11865 <em>Lonesome Dreams</em> 11865 Paul Thompson 300
11885 11885 <em>Soft Fall</em> 11885 Paul Thompson 300
11959 11959 <em>Mary's Voice</em> 11959 Paul Thompson 300
11965 11965 <em>Negotiations</em> 11965 Paul Thompson 300
12046 12046 Reissues 12046 Paul Thompson 300
12069 12069 <em>Forever So</em> 12069 Paul Thompson 300
12174 12174 <em>Meat Mountain EP</em> 12174 Paul Thompson 300
12185 12185 <em>Longtime Companion</em> 12185 Paul Thompson 300
12192 12192 <em>Class Clown Spots a UFO</em> 12192 Paul Thompson 300
12293 12293 <em>Spirits</em> 12293 Paul Thompson 300
12351 12351 <em>Royal Headache</em> 12351 Paul Thompson 300
12357 12357 <em>OFF!</em> 12357 Paul Thompson 300
12385 12385 <em>Strange Land</em> 12385 Paul Thompson 300
12420 12420 <em>Candy Salad</em> 12420 Paul Thompson 300
12490 12490 <em>Mouseman Cloud</em> 12490 Paul Thompson 300
12495 12495 <em>Both Lights</em> 12495 Paul Thompson 300
12514 12514 <em>The Revolution EP</em> 12514 Paul Thompson 300

Next page

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