reviews_authors

8 rows where author_id = 47

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
66 66 <em>Big Time Things</em> 66 Ted Davis 47
261 261 <em>Music for Animals</em> 261 Ted Davis 47
265 265 <em>Shepherd Head</em> 265 Ted Davis 47
379 379 <em>Apricot Angel</em> 379 Ted Davis 47
404 404 <em>Fleeting Adventure</em>  404 Ted Davis 47
462 462 <em>Expressed, I Noticed Silence</em> 462 Ted Davis 47
2486 2486 <em>Goodbye, Nowhere!</em> 2486 Ted Davis 47
25347 25347 <em>Colours of Air</em> 25343 Ted Davis 47

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