reviews_authors

6 rows where author_id = 332

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
4167 4167 <em>Psychodrama</em> 4167 Ciaran Thapar 332
4224 4224 <em>Big Bad...</em> 4224 Ciaran Thapar 332
4531 4531 <em>Wild Yout EP</em> 4531 Ciaran Thapar 332
4731 4731 <em>SPACEMAN</em> 4731 Ciaran Thapar 332
5064 5064 <em>Strata EP</em> 5064 Ciaran Thapar 332
5210 5210 <em>Crop Circle</em> 5210 Ciaran Thapar 332

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