reviews_authors

6 rows where author_id = 191

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
958 958 <em>Lighten Up</em> 958 Natalie Weiner 191
2556 2556 <em>Gaslighter</em> 2556 Natalie Weiner 191
2894 2894 <em>Southside</em> 2894 Natalie Weiner 191
4242 4242 <em>Modern Sounds in Country &amp; Western Music Volumes 1 &amp; 2</em> 4242 Natalie Weiner 191
5373 5373 <em>Communion</em> 5373 Natalie Weiner 191
5465 5465 <em>Way Out West</em> 5465 Natalie Weiner 191

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