home / pf

reviews_authors

41 rows where author_id = 303

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
3546 3546 <em>Lifetime</em> 3546 Thea Ballard 303
3759 3759 <em>Who is experimental music?</em> 3759 Thea Ballard 303
3863 3863 <em>Pale Bloom</em> 3863 Thea Ballard 303
3876 3876 <em>Hot Spring</em> 3876 Thea Ballard 303
4054 4054 <em>Imperial Flood</em> 4054 Thea Ballard 303
4320 4320 <em>Comp x Comp</em> 4320 Thea Ballard 303
4958 4958 <em>Ignis EP</em> 4958 Thea Ballard 303
5198 5198 <em>Miro Tape</em> 5198 Thea Ballard 303
5385 5385 <em>Eucalyptus EP</em> 5385 Thea Ballard 303
5540 5540 <em>Make Me Know You Sweet</em> 5540 Thea Ballard 303
5732 5732 <em>Music for Nine Postcards</em> 5732 Thea Ballard 303
5748 5748 <em>Hesaitix</em> 5748 Thea Ballard 303
5780 5780 <em>Value</em> 5780 Thea Ballard 303
5840 5840 <em>Lune Rouge</em> 5840 Thea Ballard 303
5873 5873 <em>U Feel Anything?</em> 5873 Thea Ballard 303
5928 5928 <em>Experiencing the Deposit of Faith</em> 5928 Thea Ballard 303
5951 5951 <em>Event Horizon</em> 5951 Thea Ballard 303
6050 6050 <em>Warmth</em> 6050 Thea Ballard 303
6121 6121 <em>Lack</em> 6121 Thea Ballard 303
6127 6127 <em>Greenspan and Taraval EP</em> 6127 Thea Ballard 303
6156 6156 <em>Solid Rain</em> 6156 Thea Ballard 303
6280 6280 <em>Planetarium</em> 6280 Thea Ballard 303
6430 6430 <em>Grafts</em> 6430 Thea Ballard 303
6452 6452 <em>How I Creep</em> 6452 Thea Ballard 303
6504 6504 <em>AZD</em> 6504 Thea Ballard 303
6556 6556 <em>Sand</em> 6556 Thea Ballard 303
6578 6578 <em>All That Is Solid Melts Into Air</em> 6578 Thea Ballard 303
6701 6701 <em>A Pink Sunset For No One</em> 6701 Thea Ballard 303
6765 6765 <em>Performance</em> 6765 Thea Ballard 303
6776 6776 <em>Drawing the Target Around the Arrow</em> 6776 Thea Ballard 303
6865 6865 <em>Nadir</em> 6865 Thea Ballard 303
6892 6892 <em>Throat</em> 6892 Thea Ballard 303
6935 6935 <em>Remain Calm</em> 6935 Thea Ballard 303
6946 6946 <em>PC Music, Vol. 2</em> 6946 Thea Ballard 303
6992 6992 <em>$uccessor (ded004)</em> 6992 Thea Ballard 303
7085 7085 <em>EP A</em> 7085 Thea Ballard 303
7185 7185 <em>Dang</em> 7185 Thea Ballard 303
7318 7318 <em>5TARB01</em> 7318 Thea Ballard 303
7344 7344 <em>Interior Architecture</em> 7344 Thea Ballard 303
7365 7365 <em>Circle of Light</em> 7365 Thea Ballard 303
7429 7429 <em>2016 / 1986</em> 7429 Thea Ballard 303

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