home / pf

reviews_authors

20 rows where author_id = 202

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
1083 1083 <em>Brilliant Adventure (1992-2001)</em> 1083 Sean T. Collins 202
1933 1933 <em>Vol. 4 (Super Deluxe)</em> 1933 Sean T. Collins 202
2921 2921 Ghosts V: Together / Ghosts VI: Locusts 2921 Sean T. Collins 202
3186 3186 <em>Watchmen (Music from the HBO Series)</em> 3186 Sean T. Collins 202
3513 3513 <em>The Brighter the Light</em> 3513 Sean T. Collins 202
3527 3527 <em>None More Negative</em> 3527 Sean T. Collins 202
3830 3830 <em>Klaus Nomi</em> 3830 Sean T. Collins 202
4371 4371 <em>Bird Box (Abridged) Original Score</em> 4371 Sean T. Collins 202
4444 4444 <em>Glastonbury 2000</em> 4444 Sean T. Collins 202
4546 4546 <em>...And Justice for All</em> 4546 Sean T. Collins 202
5466 5466 <em>Sir</em> 5466 Sean T. Collins 202
5531 5531 <em>Impossible Star</em> 5531 Sean T. Collins 202
5933 5933 <em>Luciferian Towers</em> 5933 Sean T. Collins 202
6066 6066 <em>Anthology Resource Vol. 1 △△</em> 6066 Sean T. Collins 202
6138 6138 <em>Add Violence EP</em> 6138 Sean T. Collins 202
6287 6287 <em>Lindsey Buckingham / Christine McVie</em> 6287 Sean T. Collins 202
6409 6409 <em>Slowdive</em> 6409 Sean T. Collins 202
6554 6554 <em>Silver Eye</em> 6554 Sean T. Collins 202
6844 6844 The Fragile (2017 Definitive Edition) / The Fragile: Deviations 1 6844 Sean T. Collins 202
7877 7877 <em>Barbara Barbara, we face a shining future</em> 7877 Sean T. Collins 202

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