home / pf

reviews_authors

20 rows where author_id = 204

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
1124 1124 <em>Voyage to Mars</em> 1124 Ashley Bardhan 204
1622 1622 <em>Troubled Paradise</em> 1622 Ashley Bardhan 204
1685 1685 <em>Sparkles &amp; Debris</em> 1685 Ashley Bardhan 204
1732 1732 <em>Build a Problem</em> 1732 Ashley Bardhan 204
1962 1962 <em>Trauma Factory</em> 1962 Ashley Bardhan 204
1975 1975 <em>Who Am I?</em> 1975 Ashley Bardhan 204
2058 2058 <em>Demidevil</em> 2058 Ashley Bardhan 204
2106 2106 <em>Weird!</em> 2106 Ashley Bardhan 204
2157 2157 <em>ALIAS EP</em> 2157 Ashley Bardhan 204
2181 2181 <em>Monument</em> 2181 Ashley Bardhan 204
2314 2314 <em>mama’s boy</em> 2314 Ashley Bardhan 204
2360 2360 <em>A Day in a Yellow Beat</em> 2360 Ashley Bardhan 204
2415 2415 <em>The Baby</em> 2415 Ashley Bardhan 204
2660 2660 <em>South Somewhere Else</em> 2660 Ashley Bardhan 204
2865 2865 <em>Garden of Lucid</em> 2865 Ashley Bardhan 204
2960 2960 <em>A Little Rhythm and a Wicked Feeling EP</em> 2960 Ashley Bardhan 204
2968 2968 <em>Truth or Consequences</em> 2968 Ashley Bardhan 204
3040 3040 <em>Myopia</em> 3040 Ashley Bardhan 204
3108 3108 <em>Walls</em> 3108 Ashley Bardhan 204
26267 26267 <em>She Reaches Out to She Reaches Out to She</em> 26263 Ashley Bardhan 204

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