reviews_authors

12 rows where author_id = 321

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
3860 3860 <em>Never Say Goodbye</em> 3860 Rebecca Bengal 321
3866 3866 <em>Originals</em> 3866 Rebecca Bengal 321
3965 3965 <em>Sister</em> 3965 Rebecca Bengal 321
4236 4236 <em>Los Angeles</em> 4236 Rebecca Bengal 321
4426 4426 <em>Send Flowers</em> 4426 Rebecca Bengal 321
5261 5261 <em>Johnny Cash: Forever Words</em> 5261 Rebecca Bengal 321
5343 5343 <em>Music and Poetry of the Kesh</em> 5343 Rebecca Bengal 321
5601 5601 <em>Nasty Gal</em> 5601 Rebecca Bengal 321
5719 5719 <em>Red Headed Stranger</em> 5719 Rebecca Bengal 321
5751 5751 <em>Phases</em> 5751 Rebecca Bengal 321
5809 5809 <em>Any Other Way</em> 5809 Rebecca Bengal 321
6268 6268 <em>Rose Colored Corner</em> 6268 Rebecca Bengal 321

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