reviews_authors

20 rows where author_id = 161

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
571 571 <em>Time~Lapse Nature</em> 571 Shy Thompson 161
603 603 <em>Prince and the Revolution: Live</em> 603 Shy Thompson 161
672 672 <em>The Last Thing Left</em> 672 Shy Thompson 161
744 744 <em>Air</em> 744 Shy Thompson 161
877 877 <em>peace places: kenyan memories</em> 877 Shy Thompson 161
990 990 <em>For McCoy</em> 990 Shy Thompson 161
1080 1080 <em>Neuromantic</em> 1080 Shy Thompson 161
1120 1120 <em>The Clearing</em> 1120 Shy Thompson 161
1137 1137 <em>Windswept Adan</em> 1137 Shy Thompson 161
1430 1430 <em>Don’t Get Comfy / Nowhere</em> 1430 Shy Thompson 161
1605 1605 <em>About You</em> 1605 Shy Thompson 161
1816 1816 S·F·X / The Endless Talking / Paradise View / Mercuric Dance 1816 Shy Thompson 161
1926 1926 <em>Heisei No Oto: Japanese Left​-​field Pop From the CD Age, 1989​-​1996</em> 1926 Shy Thompson 161
25649 25649 <em>Wave Notation 3: Erik Satie 1984</em> 25645 Shy Thompson 161
25927 25927 <em>CITTA’ ’93</em> 25923 Shy Thompson 161
26042 26042 <em>Audiobook</em> 26038 Shy Thompson 161
26144 26144 <em>Statues I</em> 26140 Shy Thompson 161
26168 26168 <em>The Singing Places</em> 26164 Shy Thompson 161
26236 26236 <em>The Boy and the Heron (Original Soundtrack)</em> 26232 Shy Thompson 161
26313 26313 <em>Quiet Logic</em> 26309 Shy Thompson 161

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