home / pf

reviews_authors

9 rows where author_id = 556

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
25905 25905 <em>E3</em> 25901 Hattie Lindert 556
25943 25943 <em>Destiny</em> 25939 Hattie Lindert 556
25967 25967 <em>Strange Disciple</em> 25963 Hattie Lindert 556
26038 26038 <em>A Host for All Kinds of Life</em> 26034 Hattie Lindert 556
26094 26094 <em>I&lt;3UQTINVU</em> 26090 Hattie Lindert 556
26150 26150 <em>Life After Neph</em> 26146 Hattie Lindert 556
26231 26231 <em>EKKSTACY</em> 26227 Hattie Lindert 556
26242 26242 <em>#HEAVENSGATE</em> 26238 Hattie Lindert 556
26249 26249 <em>The Ceremony</em> 26245 Hattie Lindert 556

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