home / pf

reviews_authors

22 rows where author_id = 506

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
12713 12713 <em>La Grande</em> 12713 Matthew Solarski 506
14951 14951 <em>Nitetime Rainbows EP</em> 14951 Matthew Solarski 506
15038 15038 <em>Leaving on a Mayday</em> 15038 Matthew Solarski 506
15080 15080 <em>Black Wooden EP</em> 15080 Matthew Solarski 506
15253 15253 <em>Islands</em> 15253 Matthew Solarski 506
15345 15345 <em>Love Is Not Pop</em> 15345 Matthew Solarski 506
15543 15543 <em>Wind's Poem</em> 15543 Matthew Solarski 506
15552 15552 <em>Memoirs at the End of the World</em> 15552 Matthew Solarski 506
15607 15607 <em>Lovetune for Vacuum</em> 15607 Matthew Solarski 506
15620 15620 <em>Of the Cathmawr Yards</em> 15620 Matthew Solarski 506
15621 15621 <em>Radio Wars</em> 15621 Matthew Solarski 506
15650 15650 <em>Azar</em> 15650 Matthew Solarski 506
15676 15676 <em>Life on Earth</em> 15676 Matthew Solarski 506
15841 15841 <em>Lost Channels</em> 15841 Matthew Solarski 506
15877 15877 <em>Vs. Children</em> 15877 Matthew Solarski 506
16030 16030 <em>Rearrange Beds</em> 16030 Matthew Solarski 506
16041 16041 <em>Caught in the Trees</em> 16041 Matthew Solarski 506
16070 16070 <em>Beasts of Seasons</em> 16070 Matthew Solarski 506
16340 16340 <em>Everything/Everything</em> 16340 Matthew Solarski 506
16460 16460 <em>Missiles</em> 16460 Matthew Solarski 506
16528 16528 <em>Lost Wisdom</em> 16528 Matthew Solarski 506
17622 17622 <em>Mount Eerie Pts. 6 &amp; 7</em> 17622 Matthew Solarski 506

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