reviews_authors

8 rows where author_id = 349

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
4644 4644 <em>Welcome 2 Detroit</em> 4644 Edwin “STATS” Houghton 349
4750 4750 <em>Hope River</em> 4750 Edwin “STATS” Houghton 349
5639 5639 <em>Fela Kuti Box Set #4</em> 5639 Edwin “STATS” Houghton 349
6716 6716 <em>DROGAS Light</em> 6716 Edwin “STATS” Houghton 349
6950 6950 <em>L.A. Heartbreak</em> 6950 Edwin “STATS” Houghton 349
7034 7034 <em>Black America Again</em> 7034 Edwin “STATS” Houghton 349
25934 25934 <em>Born for Greatness</em> 25930 Edwin “STATS” Houghton 349
26077 26077 <em>’Til Shiloh</em> 26073 Edwin “STATS” Houghton 349

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