home / pf

reviews_authors

16 rows where author_id = 407

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
6329 6329 <em>True to Self</em> 6329 David Turner 407
6802 6802 <em>GTTM: Goin Thru the Motions</em> 6802 David Turner 407
6891 6891 <em>American Boyfriend: A Suburban Love Story</em> 6891 David Turner 407
8534 8534 <em>AndSeeThatsTheThing EP</em> 8534 David Turner 407
8792 8792 <em>Casino Life 2: Brown Bag Legend</em> 8792 David Turner 407
9043 9043 <em>B4FRVR</em> 9043 David Turner 407
9219 9219 <em>No One Is $afe</em> 9219 David Turner 407
9257 9257 <em>Preacher's Son</em> 9257 David Turner 407
9279 9279 <em>Law 3: Now or Never</em> 9279 David Turner 407
9914 9914 <em>Gz II Godz</em> 9914 David Turner 407
9960 9960 <em>FreeBase EP</em> 9960 David Turner 407
9965 9965 <em>Sincerely Yours</em> 9965 David Turner 407
10035 10035 <em>Young Thugga Mane La Flare</em> 10035 David Turner 407
10356 10356 <em>Come to Life</em> 10356 David Turner 407
11210 11210 <em>Live in Concert</em> 11210 David Turner 407
12709 12709 <em>Lock Out</em> 12709 David Turner 407

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