home / pf

reviews_authors

9 rows where author_id = 95

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
184 184 <em>grow your hair long if you​’​re wanting to see something that you can change</em> 184 Mia Hughes 95
316 316 <em>Separation</em> 316 Mia Hughes 95
530 530 <em>GUV IV</em> 530 Mia Hughes 95
588 588 <em>40 oz. to Fresno</em> 588 Mia Hughes 95
650 650 <em>Communion</em> 650 Mia Hughes 95
696 696 <em>Car Therapy Sessions</em> 696 Mia Hughes 95
25290 25290 <em>Songs for the Willow EP</em> 25286 Mia Hughes 95
25363 25363 <em>Moments of Clarity</em> 25359 Mia Hughes 95
25379 25379 <em>Like Dying Stars, We’re Reaching Out</em> 25375 Mia Hughes 95

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