home / pf

reviews_authors

33 rows where author_id = 327

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
4052 4052 <em>Song Feel</em> 4052 Harley Brown 327
4129 4129 <em>Bodyguard</em> 4129 Harley Brown 327
4149 4149 <em>Jag Trax</em> 4149 Harley Brown 327
4259 4259 <em>Cherushii &amp; Maria Minerva</em> 4259 Harley Brown 327
4384 4384 <em>Shadows of Death and Desire</em> 4384 Harley Brown 327
9935 9935 <em>In Cold Blood</em> 9935 Harley Brown 327
9981 9981 <em>Nabuma Rubberband</em> 9981 Harley Brown 327
10031 10031 <em>Shriek</em> 10031 Harley Brown 327
10048 10048 <em>Patterns EP</em> 10048 Harley Brown 327
10476 10476 <em>Lockjaw EP</em> 10476 Harley Brown 327
10564 10564 <em>The Swamps EP</em> 10564 Harley Brown 327
10599 10599 <em>Boardwalk</em> 10599 Harley Brown 327
10674 10674 <em>VII</em> 10674 Harley Brown 327
10690 10690 <em>B-Room</em> 10690 Harley Brown 327
10758 10758 <em>Olive Juice</em> 10758 Harley Brown 327
10814 10814 <em>Love Now</em> 10814 Harley Brown 327
10885 10885 <em>Tides End</em> 10885 Harley Brown 327
11069 11069 <em>Saltwater</em> 11069 Harley Brown 327
11121 11121 <em>Crawling Up the Stairs</em> 11121 Harley Brown 327
11124 11124 <em>Kids in L.A.</em> 11124 Harley Brown 327
11278 11278 <em>Birthmarks</em> 11278 Harley Brown 327
11283 11283 <em>They're Flowers</em> 11283 Harley Brown 327
11445 11445 <em>Flume</em> 11445 Harley Brown 327
11453 11453 <em>Island Universe</em> 11453 Harley Brown 327
11558 11558 <em>Wash the Sins Not Only the Face</em> 11558 Harley Brown 327
11565 11565 <em>Beta Love</em> 11565 Harley Brown 327
11575 11575 <em>Almanac</em> 11575 Harley Brown 327
11604 11604 <em>Loyal</em> 11604 Harley Brown 327
11755 11755 <em>Ark</em> 11755 Harley Brown 327
11794 11794 <em>Young Hunger</em> 11794 Harley Brown 327
11840 11840 <em>Tender New Signs</em> 11840 Harley Brown 327
11854 11854 <em>Colored Emotions</em> 11854 Harley Brown 327
11955 11955 <em>Field Report</em> 11955 Harley Brown 327

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