home / pf

reviews_authors

70 rows where author_id = 499

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
12251 12251 <em>Synthetica</em> 12251 Matthew Perpetua 499
12295 12295 <em>Magic Hour</em> 12295 Matthew Perpetua 499
12358 12358 <em>Oh Holy Molar</em> 12358 Matthew Perpetua 499
12522 12522 <em>MDNA</em> 12522 Matthew Perpetua 499
12647 12647 <em>Reign of Terror</em> 12647 Matthew Perpetua 499
12682 12682 <em>The Singles</em> 12682 Matthew Perpetua 499
12752 12752 <em>Something</em> 12752 Matthew Perpetua 499
12902 12902 <em>Part Lies, Part Heart, Part Truth, Part Garbage: 1982-2011</em> 12902 Matthew Perpetua 499
13109 13109 <em>Paradise</em> 13109 Matthew Perpetua 499
13271 13271 <em>Ritual Union</em> 13271 Matthew Perpetua 499
13425 13425 <em>Leisure Seizure</em> 13425 Matthew Perpetua 499
13440 13440 <em>W</em> 13440 Matthew Perpetua 499
13552 13552 <em>thecontrollersphere EP</em> 13552 Matthew Perpetua 499
13607 13607 <em>w h o k i l l</em> 13607 Matthew Perpetua 499
13686 13686 <em>Who You Are</em> 13686 Matthew Perpetua 499
13696 13696 <em>Starting From Nowhere</em> 13696 Matthew Perpetua 499
13764 13764 <em>Trash Hit</em> 13764 Matthew Perpetua 499
13816 13816 <em>Demo</em> 13816 Matthew Perpetua 499
13997 13997 <em>Bonus Tracks 2008-2009</em> 13997 Matthew Perpetua 499
14054 14054 <em>We Love</em> 14054 Matthew Perpetua 499
14091 14091 <em>WYWH</em> 14091 Matthew Perpetua 499
14114 14114 <em>Opticks</em> 14114 Matthew Perpetua 499
14207 14207 <em>Marnie Stern</em> 14207 Matthew Perpetua 499
14226 14226 <em>Bubblegum</em> 14226 Matthew Perpetua 499
14333 14333 <em>Scott Pilgrim vs. the World OST</em> 14333 Matthew Perpetua 499
14334 14334 <em>Without Why</em> 14334 Matthew Perpetua 499
14416 14416 <em>Candle to Your Eyes</em> 14416 Matthew Perpetua 499
14477 14477 <em>Fables of the Reconstruction [Deluxe Edition]</em> 14477 Matthew Perpetua 499
14487 14487 <em>/ \ / \ / \ Y / \</em> 14487 Matthew Perpetua 499
14516 14516 <em>Night Work</em> 14516 Matthew Perpetua 499
14582 14582 <em>How to Destroy Angels</em> 14582 Matthew Perpetua 499
14662 14662 <em>The ArchAndroid</em> 14662 Matthew Perpetua 499
14675 14675 <em>The People's Record</em> 14675 Matthew Perpetua 499
14717 14717 <em>Together</em> 14717 Matthew Perpetua 499
14740 14740 <em>What We Lose in the Fire We Gain in the Flood</em> 14740 Matthew Perpetua 499
14828 14828 <em>Future Factory</em> 14828 Matthew Perpetua 499
14927 14927 <em>Quarantine the Past</em> 14927 Matthew Perpetua 499
14948 14948 <em>Yeah So</em> 14948 Matthew Perpetua 499
15010 15010 <em>The Calcination of Scout Niblett</em> 15010 Matthew Perpetua 499
15045 15045 <em>Paper Dolls</em> 15045 Matthew Perpetua 499
15097 15097 <em>Transference</em> 15097 Matthew Perpetua 499
15124 15124 <em>Rejoicer</em> 15124 Matthew Perpetua 499
15155 15155 <em>Echo Kid</em> 15155 Matthew Perpetua 499
15193 15193 <em>New Worlds</em> 15193 Matthew Perpetua 499
15232 15232 Don't Stop / All Night EP 15232 Matthew Perpetua 499
15238 15238 <em>Machine Dreams</em> 15238 Matthew Perpetua 499
15286 15286 <em>Greatest Hits</em> 15286 Matthew Perpetua 499
15302 15302 <em>Live at the Olympia</em> 15302 Matthew Perpetua 499
15304 15304 <em>Hors d'Oeuvres</em> 15304 Matthew Perpetua 499
15336 15336 <em>The Real Feel</em> 15336 Matthew Perpetua 499
15372 15372 <em>Scars</em> 15372 Matthew Perpetua 499
15403 15403 <em>LOVEWORLD</em> 15403 Matthew Perpetua 499
15521 15521 <em>To Swift Mars</em> 15521 Matthew Perpetua 499
15628 15628 <em>I'm Going Away</em> 15628 Matthew Perpetua 499
15635 15635 <em>Change Remains</em> 15635 Matthew Perpetua 499
15660 15660 <em>Bandages for the Heart</em> 15660 Matthew Perpetua 499
15694 15694 <em>UUVVWWZ</em> 15694 Matthew Perpetua 499
15708 15708 <em>Wilco (The Album)</em> 15708 Matthew Perpetua 499
15744 15744 <em>Skeletons</em> 15744 Matthew Perpetua 499
15816 15816 <em>Polly Scattergood</em> 15816 Matthew Perpetua 499
15840 15840 <em>Clues</em> 15840 Matthew Perpetua 499
15859 15859 <em>Modern Silence</em> 15859 Matthew Perpetua 499
15869 15869 <em>Down With Liberty... Up With Chains!</em> 15869 Matthew Perpetua 499
15891 15891 <em>I Feel Cream</em> 15891 Matthew Perpetua 499
15898 15898 <em>Actor</em> 15898 Matthew Perpetua 499
15914 15914 <em>Ape School</em> 15914 Matthew Perpetua 499
15985 15985 <em>Songs About Dancing and Drugs</em> 15985 Matthew Perpetua 499
15990 15990 <em>Telekinesis!</em> 15990 Matthew Perpetua 499
15999 15999 <em>Inside Your Guitar</em> 15999 Matthew Perpetua 499
16014 16014 <em>Baby</em> 16014 Matthew Perpetua 499

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