home / pf

reviews_authors

33 rows where author_id = 121

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
270 270 <em>demon time</em> 270 Cat Zhang 121
280 280 <em>Hold the Girl</em> 280 Cat Zhang 121
666 666 <em>Breakaway</em> 666 Cat Zhang 121
963 963 <em>never stop texting me</em> 963 Cat Zhang 121
991 991 <em>Laurel Hell</em> 991 Cat Zhang 121
1037 1037 <em>CAPRISONGS</em> 1037 Cat Zhang 121
1239 1239 <em>Simple, Sweet, and Smiling</em> 1239 Cat Zhang 121
1293 1293 <em>Animal</em> 1293 Cat Zhang 121
1380 1380 <em>Any Shape You Take</em> 1380 Cat Zhang 121
1520 1520 <em>Sling</em> 1520 Cat Zhang 121
2004 2004 <em>Impostor EP</em> 2004 Cat Zhang 121
2317 2317 <em>True Romantic</em> 2317 Cat Zhang 121
2359 2359 <em>BREACH</em> 2359 Cat Zhang 121
2456 2456 <em>Show Pony EP</em> 2456 Cat Zhang 121
2553 2553 <em>Ugly Is Beautiful</em> 2553 Cat Zhang 121
2583 2583 <em>1000 gecs &amp; The Tree of Clues</em> 2583 Cat Zhang 121
2724 2724 <em>Dedicated Side B</em> 2724 Cat Zhang 121
2767 2767 <em>Sorceress</em> 2767 Cat Zhang 121
2806 2806 <em>The Mother Stone</em> 2806 Cat Zhang 121
2820 2820 <em>farawayfrom-everyoneyouknow</em> 2820 Cat Zhang 121
2993 2993 <em>~how i’m feeling~</em> 2993 Cat Zhang 121
3046 3046 <em>Wild Wild East</em> 3046 Cat Zhang 121
3210 3210 <em>Remember the Silver</em> 3210 Cat Zhang 121
3326 3326 <em>Trophy</em> 3326 Cat Zhang 121
3505 3505 <em>MISCREANT</em> 3505 Cat Zhang 121
3586 3586 <em>Master</em> 3586 Cat Zhang 121
25360 25360 <em>Desire, I Want to Turn Into You</em> 25356 Cat Zhang 121
25487 25487 <em>The Record</em> 25483 Cat Zhang 121
25653 25653 <em>Everyone’s Crushed</em> 25649 Cat Zhang 121
25789 25789 <em>Barbie the Album</em> 25785 Cat Zhang 121
25839 25839 <em>murmuring chasms of nostalgia</em> 25835 Cat Zhang 121
25913 25913 <em>GUTS</em> 25909 Cat Zhang 121
25928 25928 <em>The Land Is Inhospitable and So Are We</em> 25924 Cat Zhang 121

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.156ms