home / pf

reviews_authors

25 rows where author_id = 147

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
434 434 <em>Ultra</em> 434 Ned Raggett 147
8501 8501 <em>The Pale Horse</em> 8501 Ned Raggett 147
8914 8914 <em>Wire</em> 8914 Ned Raggett 147
9016 9016 <em>The Silence</em> 9016 Ned Raggett 147
10063 10063 <em>Box Set</em> 10063 Ned Raggett 147
10331 10331 <em>moon</em> 10331 Ned Raggett 147
10853 10853 <em>Waterdrawn</em> 10853 Ned Raggett 147
10871 10871 <em>Vehicle</em> 10871 Ned Raggett 147
10941 10941 <em>Dear Mark J Mulcahy I Love You</em> 10941 Ned Raggett 147
10971 10971 <em>Late Night Tales</em> 10971 Ned Raggett 147
11084 11084 In The Golden Autumn / Under Wartime Conditions / Songs For A Fallow Land 11084 Ned Raggett 147
11276 11276 <em>English Electric</em> 11276 Ned Raggett 147
11501 11501 <em>The Jazz Age</em> 11501 Ned Raggett 147
11745 11745 <em>At the Down-turned Jagged Rim of the Sky</em> 11745 Ned Raggett 147
11950 11950 <em>Palindrome Hunches</em> 11950 Ned Raggett 147
12057 12057 <em>Anastasis</em> 12057 Ned Raggett 147
12074 12074 <em>Copenhagen Dreams</em> 12074 Ned Raggett 147
12336 12336 Shot Forth Self Living / The Buried Life 12336 Ned Raggett 147
12383 12383 <em>Echoes and Rhymes</em> 12383 Ned Raggett 147
12391 12391 Blow Away Your Troubles / On Any Normal Monday / Midnight Cleaners 12391 Ned Raggett 147
12426 12426 Blackwater Park [Legacy Edition] / Deliverance [Reissue] / Damnation [Reissue] / Lamentations [Reissue] 12426 Ned Raggett 147
12561 12561 <em>Where the Sands Turn to Gold</em> 12561 Ned Raggett 147
12626 12626 <em>Recollected</em> 12626 Ned Raggett 147
12827 12827 HDCD Box Set 12827 Ned Raggett 147
12867 12867 Gish [Deluxe Edition] / Siamese Dream [Deluxe Edition] 12867 Ned Raggett 147

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