home / pf

reviews_authors

40 rows where author_id = 456

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
8134 8134 <em>Screamadelica</em> 8134 Tom Ewing 456
12052 12052 Roxy Music: The Complete Studio Recordings 1972-1982 12052 Tom Ewing 456
12241 12241 <em>One Day I'm Going to Soar</em> 12241 Tom Ewing 456
12326 12326 <em>The Visitors [Deluxe Edition]</em> 12326 Tom Ewing 456
12512 12512 <em>Viva Hate</em> 12512 Tom Ewing 456
13136 13136 <em>Who's Afraid of the Art of Noise [Deluxe Edition]</em> 13136 Tom Ewing 456
13741 13741 <em>Absolute</em> 13741 Tom Ewing 456
14052 14052 <em>Coals to Newcastle</em> 14052 Tom Ewing 456
14151 14151 <em>Searching for the Young Soul Rebels [30th Anniversary Edition]</em> 14151 Tom Ewing 456
15197 15197 <em>The Catalogue</em> 15197 Tom Ewing 456
15355 15355 Rio [Collector's Edition] / Live at Hammersmith '82! 15355 Tom Ewing 456
15371 15371 <em>Never Cry Another Tear</em> 15371 Tom Ewing 456
15483 15483 <em>Help!</em> 15483 Tom Ewing 456
15484 15484 <em>Beatles For Sale</em> 15484 Tom Ewing 456
15485 15485 <em>A Hard Day's Night</em> 15485 Tom Ewing 456
15486 15486 <em>With the Beatles</em> 15486 Tom Ewing 456
15487 15487 <em>Please Please Me</em> 15487 Tom Ewing 456
16037 16037 <em>Histoire de Melody Nelson</em> 16037 Tom Ewing 456
16193 16193 <em>Factory Records: Communications 1978-92</em> 16193 Tom Ewing 456
16218 16218 <em>Years of Refusal</em> 16218 Tom Ewing 456
16266 16266 <em>Black Diamond</em> 16266 Tom Ewing 456
16322 16322 <em>Zang Tumb Tuum: The ZTT Box Set</em> 16322 Tom Ewing 456
16438 16438 Movement / Power, Corruption and Lies / Low-Life / Brotherhood / Technique [Collector's Editions] 16438 Tom Ewing 456
16458 16458 <em>The Sound of the Smiths</em> 16458 Tom Ewing 456
16498 16498 <em>The Bootleg Series, Vol. 8: Tell Tale Signs: Rare and Unreleased 1986-2006</em> 16498 Tom Ewing 456
16522 16522 <em>Perfect Symmetry</em> 16522 Tom Ewing 456
16709 16709 <em>This Is Alphabeat</em> 16709 Tom Ewing 456
16963 16963 <em>The Dream</em> 16963 Tom Ewing 456
16983 16983 <em>Youth Novels</em> 16983 Tom Ewing 456
17074 17074 <em>Santogold</em> 17074 Tom Ewing 456
17107 17107 <em>Hard Candy</em> 17107 Tom Ewing 456
17142 17142 <em>Dazzle Ships</em> 17142 Tom Ewing 456
17155 17155 <em>Soundboy Rock</em> 17155 Tom Ewing 456
17167 17167 <em>Antidotes</em> 17167 Tom Ewing 456
17228 17228 <em>You Have No Idea What You Are Getting Yourself Into</em> 17228 Tom Ewing 456
17300 17300 <em>Matinée</em> 17300 Tom Ewing 456
17364 17364 <em>Thriller: 25th Anniversary Edition</em> 17364 Tom Ewing 456
17409 17409 <em>Greatest Hits</em> 17409 Tom Ewing 456
17423 17423 <em>Most of the Remixes...</em> 17423 Tom Ewing 456
17577 17577 <em>X</em> 17577 Tom Ewing 456

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