home / pf

reviews_authors

22 rows where author_id = 428

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
6974 6974 <em>No Waves</em> 6974 Jes Skolnik 428
7958 7958 <em>Love Yes</em> 7958 Jes Skolnik 428
7978 7978 <em>neo</em> 7978 Jes Skolnik 428
8056 8056 <em>Paradise</em> 8056 Jes Skolnik 428
8153 8153 <em>right on!</em> 8153 Jes Skolnik 428
8239 8239 <em>Fit Me In EP</em> 8239 Jes Skolnik 428
8271 8271 <em>Stop Suffering EP</em> 8271 Jes Skolnik 428
8383 8383 <em>1000 Days</em> 8383 Jes Skolnik 428
8416 8416 <em>Positive Energy</em> 8416 Jes Skolnik 428
8422 8422 <em>Kunk</em> 8422 Jes Skolnik 428
8452 8452 <em>Till It’s All Forgotten</em> 8452 Jes Skolnik 428
8472 8472 <em>Metalmania</em> 8472 Jes Skolnik 428
8484 8484 <em>Cranekiss</em> 8484 Jes Skolnik 428
8528 8528 <em>The Blackest Eye EP</em> 8528 Jes Skolnik 428
8688 8688 <em>Still</em> 8688 Jes Skolnik 428
8783 8783 <em>Consumer Complaints</em> 8783 Jes Skolnik 428
8907 8907 <em>Permanent Exile</em> 8907 Jes Skolnik 428
8943 8943 <em>Know America</em> 8943 Jes Skolnik 428
9111 9111 <em>I Want to Grow Up</em> 9111 Jes Skolnik 428
9233 9233 <em>Lost Weekend</em> 9233 Jes Skolnik 428
26097 26097 <em>The Derivative Sounds Of... or... A Dog Always Returns to Its Vomit</em> 26093 Jes Skolnik 428
26102 26102 <em>Death Is Home</em> 26098 Jes Skolnik 428

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)
);
Powered by Datasette · Queries took 60.641ms