reviews_authors

8 rows where author_id = 493

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
10733 10733 <em>10x</em> 10733 Patrick Bowman 493
10890 10890 <em>Lenses</em> 10890 Patrick Bowman 493
10905 10905 <em>Ruby Red</em> 10905 Patrick Bowman 493
10921 10921 <em>Fantasy</em> 10921 Patrick Bowman 493
11038 11038 <em>Carolina EP</em> 11038 Patrick Bowman 493
11088 11088 <em>The Ways We Separate</em> 11088 Patrick Bowman 493
11175 11175 <em>She Beats</em> 11175 Patrick Bowman 493
11293 11293 <em>Caveman</em> 11293 Patrick Bowman 493

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