home / pf

reviews_authors

18 rows where author_id = 383

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
5490 5490 <em>Stankonia</em> 5490 kris ex 383
6634 6634 <em>Life After Death</em> 6634 kris ex 383
6988 6988 <em>We got it from Here... Thank You 4 Your service</em> 6988 kris ex 383
7345 7345 <em>The Land OST</em> 7345 kris ex 383
7362 7362 <em>Major Key</em> 7362 kris ex 383
7418 7418 <em>HEAVN</em> 7418 kris ex 383
7586 7586 <em>The Fan-Tas-Tic Box Set</em> 7586 kris ex 383
7590 7590 <em>iiiDrops</em> 7590 kris ex 383
7653 7653 <em>Coloring Book</em> 7653 kris ex 383
7749 7749 <em>The Diary</em> 7749 kris ex 383
7775 7775 <em>Nat Love</em> 7775 kris ex 383
7905 7905 <em>untitled unmastered.</em> 7905 kris ex 383
8069 8069 <em>Something About April II</em> 8069 kris ex 383
8089 8089 <em>King Stays King</em> 8089 kris ex 383
8155 8155 <em>Chi-Raq OST</em> 8155 kris ex 383
8230 8230 <em>People's Instinctive Travels and the Paths of Rhythm</em> 8230 kris ex 383
8645 8645 <em>Nina Revisited… A Tribute to Nina Simone</em> 8645 kris ex 383
8924 8924 <em>Black Bastards</em> 8924 kris ex 383

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