home / pf

reviews_authors

17 rows where author_id = 183

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
881 881 <em>Diplo</em> 881 Megan Buerger 183
1068 1068 <em>The Nearer the Fountain, More Pure the Stream Flows</em> 1068 Megan Buerger 183
1148 1148 <em>Music for Psychedelic Therapy</em> 1148 Megan Buerger 183
1992 1992 <em>She’s Calling EP</em> 1992 Megan Buerger 183
2148 2148 <em>III</em> 2148 Megan Buerger 183
2186 2186 <em>Código de Barras</em> 2186 Megan Buerger 183
2608 2608 <em>Both of Us / Are U Down</em> 2608 Megan Buerger 183
2923 2923 <em>Cenizas</em> 2923 Megan Buerger 183
3120 3120 <em>High Road</em> 3120 Megan Buerger 183
3154 3154 <em>R.Y.C.</em> 3154 Megan Buerger 183
3370 3370 <em>Inside Unsolved EP</em> 3370 Megan Buerger 183
4211 4211 <em>Good at Falling</em> 4211 Megan Buerger 183
4379 4379 <em>DISRUPTION EP</em> 4379 Megan Buerger 183
5173 5173 <em>Mixtape</em> 5173 Megan Buerger 183
5375 5375 <em>Physically Sick 2</em> 5375 Megan Buerger 183
5405 5405 <em>Álbum Desconhecido</em> 5405 Megan Buerger 183
5525 5525 <em>Slow Fade EP</em> 5525 Megan Buerger 183

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