reviews_authors

9 rows where author_id = 442

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
7516 7516 <em>The Dreaming Room</em> 7516 Jia Tolentino 442
8024 8024 <em>Nine Track Mind</em> 8024 Jia Tolentino 442
8169 8169 <em>Wake Up!</em> 8169 Jia Tolentino 442
8255 8255 <em>AMY: The Original Soundtrack</em> 8255 Jia Tolentino 442
8269 8269 <em>AQUARIA</em> 8269 Jia Tolentino 442
8379 8379 <em>A Curious Tale of Trials + Persons</em> 8379 Jia Tolentino 442
8514 8514 <em>Transgressor</em> 8514 Jia Tolentino 442
8870 8870 <em>PC Music Volume 1</em> 8870 Jia Tolentino 442
8955 8955 <em>White Men Are Black Men Too</em> 8955 Jia Tolentino 442

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