home / pf

reviews_authors

10 rows where author_id = 462

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
8364 8364 <em>Age of Transparency</em> 8364 Puja Patel 462
10664 10664 <em>Lost</em> 10664 Puja Patel 462
10913 10913 <em>High Beams EP</em> 10913 Puja Patel 462
10980 10980 <em>Without Your Love</em> 10980 Puja Patel 462
10995 10995 <em>Planta</em> 10995 Puja Patel 462
11058 11058 <em>Chapter II</em> 11058 Puja Patel 462
11090 11090 <em>Modern Worship</em> 11090 Puja Patel 462
11319 11319 <em>The Empire Never Ended</em> 11319 Puja Patel 462
11521 11521 <em>0181</em> 11521 Puja Patel 462
11553 11553 <em>Fabriclive 67</em> 11553 Puja Patel 462

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