reviews_authors

12 rows where author_id = 42

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
55 55 <em>Spirit Roaming</em>  55 Matthew Ritchie 42
179 179 <em>Church</em> 179 Matthew Ritchie 42
219 219 <em>I Got Issues</em> 219 Matthew Ritchie 42
223 223 <em>$oul $old $eparately</em> 223 Matthew Ritchie 42
283 283 <em>Butcher Brown Presents Triple Trey</em> 283 Matthew Ritchie 42
284 284 <em>Demons Protected by Angels</em> 284 Matthew Ritchie 42
414 414 <em>BodBoy</em> EP 414 Matthew Ritchie 42
25333 25333 <em>Portrait of a Dog</em>  25329 Matthew Ritchie 42
25745 25745 <em>Ganger</em> 25741 Matthew Ritchie 42
25755 25755 <em>Pink Tape</em> 25751 Matthew Ritchie 42
25965 25965 <em>Faith Is a Rock</em> 25961 Matthew Ritchie 42
26215 26215 <em>American Dream</em> 26211 Matthew Ritchie 42

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