reviews_authors

25 rows where author_id = 26

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
33 33 <em>A Complete Anthology of Solo and Duo Violin Pieces</em>  33 Vanessa Ague 26
294 294 <em>Andrew McIntosh: Little Jimmy</em> 294 Vanessa Ague 26
305 305 <em>Two Sisters</em>  305 Vanessa Ague 26
329 329 <em>Music for Four Guitars</em> 329 Vanessa Ague 26
470 470 <em>Spectral</em> 470 Vanessa Ague 26
502 502 <em>Amplified Guitar</em> 502 Vanessa Ague 26
555 555 <em>Houses of the Wind</em> 555 Vanessa Ague 26
648 648 <em>West Kensington</em> 648 Vanessa Ague 26
738 738 <em>The Turning Year</em> 738 Vanessa Ague 26
922 922 <em>4 Hands</em> 922 Vanessa Ague 26
1095 1095 <em>Old Friends New Friends</em> 1095 Vanessa Ague 26
1199 1199 <em>Reticence / Resistance</em> 1199 Vanessa Ague 26
1201 1201 <em>Collected Pieces II</em> 1201 Vanessa Ague 26
2130 2130 <em>Odin’s Raven Magic</em> 2130 Vanessa Ague 26
3107 3107 <em>Parasite: Original Motion Picture Score</em> 3107 Vanessa Ague 26
25264 25264 <em>Liquiddd Changesss</em> 25260 Vanessa Ague 26
25396 25396 <em>1980</em> 25392 Vanessa Ague 26
25600 25600 <em>Naldjorlak</em> 25596 Vanessa Ague 26
25849 25849 <em>Chthonic</em> 25845 Vanessa Ague 26
25910 25910 <em>Braintrust of Fiends and Werewolves</em> 25906 Vanessa Ague 26
25985 25985 <em>Shone a Rainbow Light On</em> 25981 Vanessa Ague 26
25999 25999 <em>Goodbye, Hotel Arkada</em> 25995 Vanessa Ague 26
26086 26086 <em>Long Gradus</em> 26082 Vanessa Ague 26
26126 26126 <em>A Charlie Brown Thanksgiving (50th Anniversary Edition)</em> 26122 Vanessa Ague 26
26372 26372 <em>Moves in the Field</em> 26368 Vanessa Ague 26

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