home / pf

reviews_authors

19 rows where author_id = 109

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
240 240 <em>Cool It Down</em> 240 Phillipe Roberts 109
299 299 <em>Invisibility Is an Unnatural Disaster</em> 299 Phillipe Roberts 109
321 321 <em>Heaven Come Crashing</em> 321 Phillipe Roberts 109
342 342 <em>Duty Now for the Future</em> 342 Phillipe Roberts 109
494 494 <em>LOGGERHEAD</em> 494 Phillipe Roberts 109
595 595 <em>Heart Under</em> 595 Phillipe Roberts 109
710 710 <em>gen wo lai (come with me)</em> 710 Phillipe Roberts 109
756 756 <em>Whatever the Weather</em> 756 Phillipe Roberts 109
785 785 <em>Picnic in the Dark</em> 785 Phillipe Roberts 109
1226 1226 <em>Ookii Gekkou</em> 1226 Phillipe Roberts 109
1275 1275 <em>Melodi</em> 1275 Phillipe Roberts 109
1332 1332 <em>Black Encyclopedia of the Air</em> 1332 Phillipe Roberts 109
1372 1372 <em>The Witness</em> 1372 Phillipe Roberts 109
1379 1379 <em>Structure</em> 1379 Phillipe Roberts 109
1500 1500 <em>Blind Obedience</em> 1500 Phillipe Roberts 109
25364 25364 <em>Girl in the Half Pearl</em> 25360 Phillipe Roberts 109
25526 25526 <em>On the Romance of Being</em>  25522 Phillipe Roberts 109
25690 25690 <em>Ticket to Fame</em> 25686 Phillipe Roberts 109
25754 25754 <em>Good Living Is Coming For You</em> 25750 Phillipe Roberts 109

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