reviews_authors

9 rows where author_id = 414

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
6486 6486 <em>Americana</em> 6486 Barry Walters 414
6547 6547 <em>Mental Illness</em> 6547 Barry Walters 414
6777 6777 <em>Behaviour</em> 6777 Barry Walters 414
7560 7560 <em>Hounds of Love</em> 7560 Barry Walters 414
7715 7715 <em>Dirty Mind</em> 7715 Barry Walters 414
8062 8062 <em>Diamond Dogs</em> 8062 Barry Walters 414
8284 8284 <em>Muscle Up</em> 8284 Barry Walters 414
8929 8929 Little Earthquakes / Under the Pink 8929 Barry Walters 414
9073 9073 <em>Ultra-High Frequencies: The Chicago Party</em> 9073 Barry Walters 414

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