home / pf

reviews_authors

18 rows where author_id = 322

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
3879 3879 <em>In the West</em> 3879 Sam Hockley-Smith 322
3963 3963 <em>Here Comes the Cowboy</em> 3963 Sam Hockley-Smith 322
4016 4016 <em>Truck Music</em> 4016 Sam Hockley-Smith 322
6823 6823 <em>Changer</em> 6823 Sam Hockley-Smith 322
8021 8021 <em>Past Cloaks</em> 8021 Sam Hockley-Smith 322
9373 9373 <em>Let's Cry and Do Pushups at the Same Time</em> 9373 Sam Hockley-Smith 322
9466 9466 <em>No Energy</em> 9466 Sam Hockley-Smith 322
10418 10418 <em>Clapper Is Still</em> 10418 Sam Hockley-Smith 322
11238 11238 <em>Bored Nothing</em> 11238 Sam Hockley-Smith 322
11498 11498 <em>LAST</em> 11498 Sam Hockley-Smith 322
11718 11718 <em>Sequitur</em> 11718 Sam Hockley-Smith 322
11787 11787 <em>2</em> 11787 Sam Hockley-Smith 322
11848 11848 <em>No Can Do</em> 11848 Sam Hockley-Smith 322
13330 13330 <em>Finally Famous</em> 13330 Sam Hockley-Smith 322
13689 13689 <em>Defaults</em> 13689 Sam Hockley-Smith 322
13808 13808 <em>VWETO</em> 13808 Sam Hockley-Smith 322
13999 13999 <em>Public Service Announcement</em> 13999 Sam Hockley-Smith 322
14179 14179 <em>Under the Jaguar Sun</em> 14179 Sam Hockley-Smith 322

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 53.458ms