reviews_authors

9 rows where author_id = 461

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
8361 8361 <em>I Need New Eyes</em> 8361 Abby Garnett 461
8478 8478 <em>Tetrachromat EP</em> 8478 Abby Garnett 461
8709 8709 <em>It's It's Remix Time Time EP</em> 8709 Abby Garnett 461
8809 8809 <em>Tundra</em> 8809 Abby Garnett 461
8988 8988 <em>Rave Cave EP</em> 8988 Abby Garnett 461
9183 9183 <em>Signs Under Test</em> 9183 Abby Garnett 461
9329 9329 <em>Seeing Sound</em> 9329 Abby Garnett 461
9790 9790 <em>The Phoenix</em> 9790 Abby Garnett 461
9990 9990 <em>Product of Industry</em> 9990 Abby Garnett 461

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