home / pf

reviews_authors

10 rows where author_id = 22

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
26 26 <em>Divine Symmetry</em>  26 Jane Bua 22
133 133 <em>Light Moving Time</em> 133 Jane Bua 22
232 232 <em>Evergreen</em> 232 Jane Bua 22
260 260 <em>Moss</em> 260 Jane Bua 22
351 351 <em>Duo Geloso</em> 351 Jane Bua 22
402 402 <em>Fairy Rust</em> 402 Jane Bua 22
25299 25299 <em>Drifting</em> 25295 Jane Bua 22
25401 25401 <em>Good Riddance</em>  25397 Jane Bua 22
25516 25516 <em>Mythologies</em> 25512 Jane Bua 22
25957 25957 <em>Karaoke Night EP</em> 25953 Jane Bua 22

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