home / pf

reviews_authors

18 rows where author_id = 203

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
1109 1109 <em>Ocean to Ocean</em> 1109 Maura Johnston 203
1466 1466 <em>Stand for Myself</em> 1466 Maura Johnston 203
1599 1599 <em>Wary + Strange</em> 1599 Maura Johnston 203
3452 3452 <em>Old LP</em> 3452 Maura Johnston 203
3629 3629 <em>Taylor Swift</em> 3629 Maura Johnston 203
4410 4410 <em>Icarus Falls</em> 4410 Maura Johnston 203
4483 4483 <em>Caution</em> 4483 Maura Johnston 203
4577 4577 4AM Mulholland EP / After 4AM EP 4577 Maura Johnston 203
5311 5311 <em>Raw Like Sushi</em> 5311 Maura Johnston 203
5421 5421 <em>All Nerve</em> 5421 Maura Johnston 203
5605 5605 <em>DH00278 (Live From The O2, London, 12/16/2016)</em> 5605 Maura Johnston 203
5864 5864 <em>Full Moon Fever</em> 5864 Maura Johnston 203
5965 5965 <em>Native Invader</em> 5965 Maura Johnston 203
6062 6062 <em>Like a Prayer</em> 6062 Maura Johnston 203
6173 6173 <em>Appetite for Destruction</em> 6173 Maura Johnston 203
6397 6397 <em>Pollinator</em> 6397 Maura Johnston 203
6594 6594 <em>Ultramega OK</em> 6594 Maura Johnston 203
7714 7714 <em>1999</em> 7714 Maura Johnston 203

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