home / pf

reviews_authors

18 rows where author_id = 76

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
140 140 <em>DJ-Kicks: Theo Parrish</em> 140 Piotr Orlov 76
2330 2330 <em>Wuddaji</em> 2330 Piotr Orlov 76
2563 2563 <em>African Rhythms 1970-1982</em> 2563 Piotr Orlov 76
2601 2601 <em>Symphonie Pacifique</em> 2601 Piotr Orlov 76
3008 3008 <em>I Think I’m Good</em> 3008 Piotr Orlov 76
3366 3366 <em>FIBS</em> 3366 Piotr Orlov 76
3400 3400 <em>Hometown: Detroit Sessions 1990​-​2014</em> 3400 Piotr Orlov 76
3537 3537 <em>Blacks’ Myths II</em> 3537 Piotr Orlov 76
4121 4121 <em>Ancestral Recall</em> 4121 Piotr Orlov 76
4455 4455 <em>Ens</em> 4455 Piotr Orlov 76
4495 4495 <em>Jazz in Detroit / Strata Concert Gallery / 46 Selden</em> 4495 Piotr Orlov 76
4758 4758 <em>New Hymn to Freedom</em> 4758 Piotr Orlov 76
4832 4832 <em>RAM 7: August 1791</em> 4832 Piotr Orlov 76
7186 7186 <em>Crooked Man</em> 7186 Piotr Orlov 76
7294 7294 <em>&quot;Fantasy Live 1999&quot;</em> 7294 Piotr Orlov 76
7541 7541 <em>Alpha</em> 7541 Piotr Orlov 76
25944 25944 <em>The Beach Album</em> 25940 Piotr Orlov 76
26125 26125 <em>Rainbow Revisited</em> 26121 Piotr Orlov 76

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