reviews_authors

11 rows where author_id = 376

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
5341 5341 <em>Deep Soundscapes</em> 5341 Jesse Weiss 376
5696 5696 <em>Plant Age</em> 5696 Jesse Weiss 376
5767 5767 <em>Have You Been There, Have You Seen It EP</em> 5767 Jesse Weiss 376
5797 5797 <em>Joli Mai</em> 5797 Jesse Weiss 376
5985 5985 <em>Ariadna</em> 5985 Jesse Weiss 376
6010 6010 <em>Bicep</em> 6010 Jesse Weiss 376
6131 6131 <em>Strange Days</em> 6131 Jesse Weiss 376
6292 6292 <em>Paradygm Shift</em> 6292 Jesse Weiss 376
6391 6391 <em>Black Populous</em> 6391 Jesse Weiss 376
6463 6463 <em>Ledyanoy Album</em> 6463 Jesse Weiss 376
6642 6642 <em>Sunrise EP</em> 6642 Jesse Weiss 376

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