reviews_authors

56 rows where author_id = 34

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
43 43 <em>Upright and Even</em> EP 43 Sophie Kemp 34
65 65 <em>Redcar les adorables étoiles (prologue)</em> 65 Sophie Kemp 34
331 331 <em>honeybee table at the butterfly feast</em> 331 Sophie Kemp 34
832 832 <em>Warm Chris</em> 832 Sophie Kemp 34
868 868 <em>Oxy Music</em> 868 Sophie Kemp 34
937 937 <em>Suburban Lawns</em> 937 Sophie Kemp 34
1036 1036 <em>Old Dead Young: B-Sides &amp; Rarities</em> 1036 Sophie Kemp 34
1169 1169 <em>Zigzag Wombat</em> 1169 Sophie Kemp 34
1232 1232 <em>Fast Idol</em> 1232 Sophie Kemp 34
1492 1492 <em>Change</em> 1492 Sophie Kemp 34
1497 1497 <em>Life, and Another</em> 1497 Sophie Kemp 34
1540 1540 <em>Twin Shadow</em> 1540 Sophie Kemp 34
1618 1618 <em>Path of Wellness</em> 1618 Sophie Kemp 34
1723 1723 <em>The Music Industry Is Poisonous</em> 1723 Sophie Kemp 34
1818 1818 <em>ENTERTAINMENT, DEATH</em> 1818 Sophie Kemp 34
1829 1829 <em>Paradigmes</em> 1829 Sophie Kemp 34
1851 1851 <em>Menneskekollektivet</em> 1851 Sophie Kemp 34
2003 2003 <em>Me and Ennui Are Friends, Baby</em> 2003 Sophie Kemp 34
2264 2264 <em>Someone New</em> 2264 Sophie Kemp 34
2271 2271 <em>Sundowner</em> 2271 Sophie Kemp 34
2284 2284 <em>As Long As You Are</em> 2284 Sophie Kemp 34
2461 2461 <em>Songs for the General Public</em> 2461 Sophie Kemp 34
2496 2496 <em>Purple Noon</em> 2496 Sophie Kemp 34
2535 2535 <em>Skullcrusher EP</em> 2535 Sophie Kemp 34
2648 2648 <em>Somewhere</em> 2648 Sophie Kemp 34
2746 2746 <em>Consummation</em> 2746 Sophie Kemp 34
2832 2832 <em>Agitprop Alterna</em> 2832 Sophie Kemp 34
2964 2964 <em>Ricky Music</em> 2964 Sophie Kemp 34
2999 2999 <em>Heavy Light</em> 2999 Sophie Kemp 34
3029 3029 <em>Full Hand</em> 3029 Sophie Kemp 34
3308 3308 <em>More Brilliant Is the Hand that Throws the Coin</em> 3308 Sophie Kemp 34
3390 3390 <em>Cry</em> 3390 Sophie Kemp 34
3501 3501 <em>Hot Motion</em> 3501 Sophie Kemp 34
3575 3575 <em>Forever Turned Around</em> 3575 Sophie Kemp 34
3656 3656 <em>Any Human Friend</em> 3656 Sophie Kemp 34
3704 3704 <em>Angels on the Slope</em> 3704 Sophie Kemp 34
3770 3770 <em>Waves</em> 3770 Sophie Kemp 34
3878 3878 <em>The Peyote Dance</em> 3878 Sophie Kemp 34
3901 3901 <em>i'll show you stronger</em> 3901 Sophie Kemp 34
3927 3927 <em>Living Theatre</em> 3927 Sophie Kemp 34
3980 3980 <em>This Mess Is a Place</em> 3980 Sophie Kemp 34
4013 4013 <em>Fishing for Fishies</em> 4013 Sophie Kemp 34
4048 4048 <em>I Must Be the Devil</em> 4048 Sophie Kemp 34
4170 4170 <em>PUNK</em> 4170 Sophie Kemp 34
4193 4193 <em>SASAMI</em> 4193 Sophie Kemp 34
4313 4313 <em>Gallipoli</em> 4313 Sophie Kemp 34
4318 4318 <em>Mystery Hour</em> 4318 Sophie Kemp 34
4337 4337 <em>Highway Hypnosis</em> 4337 Sophie Kemp 34
4478 4478 <em>Love in the Time of Lexapro EP</em> 4478 Sophie Kemp 34
4560 4560 <em>Deerhoof Plays Music of the Shining</em> 4560 Sophie Kemp 34
4632 4632 <em>Working Class Woman</em> 4632 Sophie Kemp 34
25376 25376 <em>extra life EP</em> 25372 Sophie Kemp 34
25416 25416 <em>WOW</em> 25412 Sophie Kemp 34
25634 25634 <em>The Sex EP</em> 25630 Sophie Kemp 34
25992 25992 <em>Out and About</em> 25988 Sophie Kemp 34
26175 26175 <em>Playing With a Different Sex</em> 26171 Sophie Kemp 34

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