home / pf

reviews_authors

12 rows where author_id = 403

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
6198 6198 <em>Grateful</em> 6198 Rebecca Haithcoat 403
6327 6327 <em>Neva Left</em> 6327 Rebecca Haithcoat 403
6652 6652 <em>HNDRXX</em> 6652 Rebecca Haithcoat 403
6874 6874 <em>Love You to Death</em> 6874 Rebecca Haithcoat 403
6979 6979 <em>Nightride</em> 6979 Rebecca Haithcoat 403
7200 7200 <em>Hard II Love</em> 7200 Rebecca Haithcoat 403
7348 7348 <em>Generationwhy</em> 7348 Rebecca Haithcoat 403
7453 7453 <em>blackSUMMERS’night</em> 7453 Rebecca Haithcoat 403
7517 7517 <em>Moog for Love</em> 7517 Rebecca Haithcoat 403
7596 7596 <em>Suck on This</em> 7596 Rebecca Haithcoat 403
7845 7845 <em>I'm a Piece of Shit</em> 7845 Rebecca Haithcoat 403
8225 8225 <em>Free TC</em> 8225 Rebecca Haithcoat 403

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