home / pf

reviews_authors

39 rows where author_id = 500

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
12344 12344 <em>Prophet</em> 12344 Paul Thompson 500
14297 14297 <em>Lisbon</em> 14297 Paul Thompson 500
14320 14320 <em>Hood Pass Intact EP</em> 14320 Paul Thompson 500
14340 14340 <em>DJ /rupture Presents CIAfrica</em> 14340 Paul Thompson 500
14393 14393 <em>Tiger Flower Circle Sun</em> 14393 Paul Thompson 500
14400 14400 <em>Jungle Music: Mixed With Love: Essential &amp; Unreleased Remixes 1976-1986</em> 14400 Paul Thompson 500
14419 14419 <em>Cloud Seed</em> 14419 Paul Thompson 500
14534 14534 <em>Jazeera Nights: Folk and Pop Sounds of Syria</em> 14534 Paul Thompson 500
14593 14593 <em>Living</em> 14593 Paul Thompson 500
14644 14644 <em>Holy Ground: NYC Live with the Wordless Music Orchestra</em> 14644 Paul Thompson 500
14680 14680 <em>Blackjazz</em> 14680 Paul Thompson 500
14694 14694 <em>Dettmann</em> 14694 Paul Thompson 500
15598 15598 <em>Midlife: A Beginner's Guide to Blur</em> 15598 Paul Thompson 500
15907 15907 <em>Broken Record Prayers</em> 15907 Paul Thompson 500
15919 15919 <em>More Heart Than Brains</em> 15919 Paul Thompson 500
15927 15927 <em>Everything She Touched Turned Ampexian</em> 15927 Paul Thompson 500
15937 15937 <em>Yes</em> 15937 Paul Thompson 500
15955 15955 <em>Agorapocalypse</em> 15955 Paul Thompson 500
15957 15957 Let's Stay Together / I'm Still In Love With You / Greatest Hits 15957 Paul Thompson 500
15959 15959 <em>Dance Mother</em> 15959 Paul Thompson 500
15969 15969 <em>Good Evening</em> 15969 Paul Thompson 500
15971 15971 <em>Swoon</em> 15971 Paul Thompson 500
15984 15984 <em>A Fool For Everyone</em> 15984 Paul Thompson 500
15994 15994 <em>Join the Q</em> 15994 Paul Thompson 500
15997 15997 <em>Trailer Park: Legacy Edition</em> 15997 Paul Thompson 500
16046 16046 <em>Havilah</em> 16046 Paul Thompson 500
16047 16047 <em>Early Output: 1996-1998</em> 16047 Paul Thompson 500
16052 16052 <em>The Proper Sex</em> 16052 Paul Thompson 500
16077 16077 <em>I Blame You</em> 16077 Paul Thompson 500
19545 19545 <em>First Thought, Best Thought</em> 19545 Paul Thompson 500
20274 20274 <em>Broken Ear Record</em> 20274 Paul Thompson 500
20278 20278 <em>Gypsy Punks: Underdog World Strike</em> 20278 Paul Thompson 500
20578 20578 <em>Team Sleep</em> 20577 Paul Thompson 500
21676 21676 <em>Laputa</em> 21674 Paul Thompson 500
22295 22295 <em>The Black Album</em> 22291 Paul Thompson 500
24529 24529 <em>Grinning Cat</em> 24525 Paul Thompson 500
24548 24548 <em>Neu!</em> 24544 Paul Thompson 500
24610 24610 <em>Beautiful</em> 24606 Paul Thompson 500
24790 24790 <em>Sakura</em> 24786 Paul Thompson 500

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