reviews_authors

13 rows where author_id = 417

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
6567 6567 <em>It's a Myth</em> 6567 Sean Murray 417
24761 24761 <em>Melodie Citronique EP</em> 24757 Sean Murray 417
24789 24789 <em>The Museum of Imaginary Animals</em> 24785 Sean Murray 417
24838 24838 <em>Out of Nowhere</em> 24834 Sean Murray 417
24847 24847 <em>Mad for Sadness</em> 24843 Sean Murray 417
24858 24858 <em>The Unseen</em> 24854 Sean Murray 417
24927 24927 <em>Inside the Dream Syndicate, Volume I: Day of Niagara (1965)</em> 24923 Sean Murray 417
24946 24946 <em>The Imp Years EP</em> 24942 Sean Murray 417
24968 24968 <em>Goodbye Enemy Airship the Landlord is Dead</em> 24964 Sean Murray 417
24986 24986 <em>Broken by Whispers</em> 24982 Sean Murray 417
25003 25003 <em>Villiger</em> 24999 Sean Murray 417
25105 25105 <em>Pick Up</em> 25101 Sean Murray 417
25234 25234 <em>Clinic</em> 25230 Sean Murray 417

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