home / pf

reviews_authors

20 rows where author_id = 224

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
1597 1597 <em>Back of My Mind</em> 1597 Reed Jackson 224
2637 2637 <em>Weight of the World</em> 2637 Reed Jackson 224
2838 2838 <em>SXTP4</em> 2838 Reed Jackson 224
2902 2902 <em>It Is What It Is</em> 2902 Reed Jackson 224
3081 3081 <em>Meet the Woo Vol. 2</em> 3081 Reed Jackson 224
3160 3160 <em>Modus Vivendi</em> 3160 Reed Jackson 224
3213 3213 <em>Bite the Burger</em> 3213 Reed Jackson 224
3233 3233 <em>WT_PRT15.</em> 3233 Reed Jackson 224
3346 3346 <em>Hitler Wears Hermes 7</em> 3346 Reed Jackson 224
3756 3756 <em>ERYS</em> 3756 Reed Jackson 224
3792 3792 <em>The Life of Pi’erre 4</em> 3792 Reed Jackson 224
3847 3847 <em>SAVE ME EP</em> 3847 Reed Jackson 224
4097 4097 <em>Supermarket</em> 4097 Reed Jackson 224
4124 4124 <em>Bad Habits</em> 4124 Reed Jackson 224
4204 4204 <em>1UP</em> 4204 Reed Jackson 224
4221 4221 <em>Gangster Music Vol. 1</em> 4221 Reed Jackson 224
4280 4280 <em>Gangway for Navy</em> 4280 Reed Jackson 224
4685 4685 <em>iridescence</em> 4685 Reed Jackson 224
4688 4688 <em>YBN: The Mixtape</em> 4688 Reed Jackson 224
4880 4880 <em>Head in the Clouds</em> 4880 Reed Jackson 224

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