home / pf

reviews_authors

18 rows where author_id = 80

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
148 148 <em>Malign Hex</em> 148 Zhenzhen Yu 80
559 559 <em>Emerald Sea</em> 559 Zhenzhen Yu 80
724 724 <em>Shunka Ryougen</em> 724 Zhenzhen Yu 80
803 803 <em>The ReVe Festival 2022 - Feel My Rhythm</em> 803 Zhenzhen Yu 80
898 898 <em>Love on My Mind</em> 898 Zhenzhen Yu 80
956 956 <em>Visitor</em> 956 Zhenzhen Yu 80
1018 1018 <em>The Runner (Original Soundtrack)</em> 1018 Zhenzhen Yu 80
1024 1024 Tissues 1024 Zhenzhen Yu 80
1106 1106 <em>The Sacrifice EP</em> 1106 Zhenzhen Yu 80
1150 1150 <em>För Allting</em> 1150 Zhenzhen Yu 80
1179 1179 <em>Hyd EP</em> 1179 Zhenzhen Yu 80
1317 1317 <em>Sable (Original Video Game Soundtrack)</em> 1317 Zhenzhen Yu 80
1450 1450 <em>Bloodslide EP</em> 1450 Zhenzhen Yu 80
25262 25262 <em>Hotel Insomnia</em> 25258 Zhenzhen Yu 80
25436 25436 <em>Godcaster</em> 25432 Zhenzhen Yu 80
25458 25458 <em>Kosogor</em> 25454 Zhenzhen Yu 80
26032 26032 <em>Jonny</em> 26028 Zhenzhen Yu 80
26071 26071 <em>Half Eaten by Dogs</em> 26067 Zhenzhen Yu 80

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