reviews_authors

25 rows where author_id = 82

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
156 156 <em>Steady</em> 156 Jesse Locke 82
206 206 <em>At Scaramouche</em> 206 Jesse Locke 82
524 524 <em>SZNZ: Summer</em> 524 Jesse Locke 82
533 533 <em>Estrela Acesa</em> 533 Jesse Locke 82
620 620 <em>Deep in View</em> 620 Jesse Locke 82
686 686 <em>Kumoyo Island</em> 686 Jesse Locke 82
779 779 <em>Warping All by Yourself</em> 779 Jesse Locke 82
901 901 <em>Ballad of a Tryhard</em> 901 Jesse Locke 82
1089 1089 <em>Wave Your Moonlight Hat for the Snowfall Train</em> 1089 Jesse Locke 82
1162 1162 <em>Rhythm and Paranoia: The Best of Bush Tetras</em> 1162 Jesse Locke 82
1198 1198 <em>Mandatory Enjoyment</em> 1198 Jesse Locke 82
1284 1284 <em>Only the End</em> 1284 Jesse Locke 82
1312 1312 <em>I’ll Be Your Mirror: A Tribute to the Velvet Underground and Nico</em> 1312 Jesse Locke 82
1333 1333 <em>PICTURA DE IPSE: Musique directe</em> 1333 Jesse Locke 82
1347 1347 <em>Antiphonals</em> 1347 Jesse Locke 82
1682 1682 <em>The Best of Lily Konigsberg Right Now</em> 1682 Jesse Locke 82
1747 1747 <em>Pink Dogs on the Green Grass</em> 1747 Jesse Locke 82
1888 1888 <em>Number One</em> 1888 Jesse Locke 82
1968 1968 <em>iii EP</em> 1968 Jesse Locke 82
1991 1991 <em>Lines Redacted</em> 1991 Jesse Locke 82
2140 2140 <em>Mamalarky</em> 2140 Jesse Locke 82
25894 25894 <em>Private Recordings, August 1970</em> 25890 Jesse Locke 82
26049 26049 <em>Foxy</em> 26045 Jesse Locke 82
26139 26139 <em>Migration Magic</em> 26135 Jesse Locke 82
26159 26159 <em>Ahora Más Que Nunca</em> 26155 Jesse Locke 82

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)
);