home / pf

reviews_authors

21 rows where author_id = 102

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
212 212 <em>Let’s Have a Dream (1974 One Step Festival)</em> 212 Owen Myers  102
399 399 <em>Funk Wav Bounces Vol. 2</em> 399 Owen Myers  102
857 857 <em>Crash</em> 857 Owen Myers  102
1529 1529 <em>Ry Ry World</em> 1529 Owen Myers  102
1567 1567 <em>Born This Way the Tenth Anniversary</em> 1567 Owen Myers  102
2070 2070 <em>Dangerous: The Double Album</em> 2070 Owen Myers  102
2191 2191 <em>The Angel You Don’t Know</em> 2191 Owen Myers  102
2421 2421 <em>Club Future Nostalgia</em> 2421 Owen Myers  102
2631 2631 <em>What’s Your Pleasure?</em> 2631 Owen Myers  102
2885 2885 <em>Song for Our Daughter</em> 2885 Owen Myers  102
2898 2898 <em>I’m Your Empress Of</em> 2898 Owen Myers  102
3451 3451 <em>Tell All Your Friends</em> 3451 Owen Myers  102
3994 3994 <em>ARIZONA BABY</em> 3994 Owen Myers  102
4110 4110 <em>English Rose</em> 4110 Owen Myers  102
4130 4130 <em>Hi This Is Flume</em> 4130 Owen Myers  102
4420 4420 <em>Puff O’Gigio</em> 4420 Owen Myers  102
4616 4616 <em>Ella Mai</em> 4616 Owen Myers  102
25298 25298 <em>Impossible Princess</em> 25294 Owen Myers  102
25706 25706 <em>Smash – The Singles 1985 – 2020</em> 25702 Owen Myers  102
26296 26296 <em>Adult Contemporary</em> 26292 Owen Myers  102
26348 26348 <em>Everything I Thought It Was</em> 26344 Owen Myers  102

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