home / pf

reviews_authors

18 rows where author_id = 89

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
170 170 <em>Live in Cuxhaven 1976</em> 170 Chris O'Connell 89
196 196 <em>I will not use the body’s eyes today.</em> EP 196 Chris O'Connell 89
1108 1108 <em>Ascension Codes</em> 1108 Chris O'Connell 89
1209 1209 <em>Hushed and Grim</em> 1209 Chris O'Connell 89
1351 1351 <em>Comfort to Me</em> 1351 Chris O'Connell 89
1945 1945 <em>In Ferneaux</em> 1945 Chris O'Connell 89
2059 2059 <em>Screamers Demo Hollywood 1977</em> 2059 Chris O'Connell 89
2111 2111 <em>Live at Tubby’s</em> 2111 Chris O'Connell 89
2339 2339 <em>All Thoughts Fly</em> 2339 Chris O'Connell 89
2346 2346 <em>Haunted Painting</em> 2346 Chris O'Connell 89
2473 2473 <em>I Must Be Living Twice EP</em> 2473 Chris O'Connell 89
2564 2564 <em>Ultimate Success Today</em> 2564 Chris O'Connell 89
2677 2677 <em>MTV Unplugged</em> 2677 Chris O'Connell 89
2813 2813 <em>ALPHABETLAND</em> 2813 Chris O'Connell 89
3051 3051 <em>Bloody Kisses</em> 3051 Chris O'Connell 89
3482 3482 <em>SOUND &amp; FURY</em> 3482 Chris O'Connell 89
3703 3703 <em>Immaculada High</em> 3703 Chris O'Connell 89
25728 25728 <em>Life Under the Gun</em> 25724 Chris O'Connell 89

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