reviews_authors

13 rows where author_id = 519

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
15716 15716 <em>Spoils</em> 15716 Mike McGonigal 519
15736 15736 <em>The Freak of Araby</em> 15736 Mike McGonigal 519
16315 16315 <em>The Living and the Dead</em> 16315 Mike McGonigal 519
16701 16701 <em>Dragging a Dead Deer Up a Hill</em> 16701 Mike McGonigal 519
16846 16846 <em>Sick to Death</em> 16846 Mike McGonigal 519
16870 16870 <em>I Miss This</em> 16870 Mike McGonigal 519
16984 16984 <em>Songs in A&amp;E</em> 16984 Mike McGonigal 519
17012 17012 <em>Crystal Stilts</em> 17012 Mike McGonigal 519
17077 17077 <em>You're Never Alone with a Cigarette (Singles, Vol. 1)</em> 17077 Mike McGonigal 519
17102 17102 <em>AM</em> 17102 Mike McGonigal 519
17233 17233 <em>Retribution Gospel Choir</em> 17233 Mike McGonigal 519
17447 17447 <em>Black Mirror: Reflections in Global Music (1918-1955)</em> 17447 Mike McGonigal 519
17461 17461 <em>Melodii Tuvi: Throat Songs and Folk Tunes from Tuva</em> 17461 Mike McGonigal 519

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