reviews_authors

14 rows where author_id = 115

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
251 251 <em>Exister</em> 251 Max Freedman 115
397 397 <em>Gold Arc</em> EP <em>/ Construction</em> EP 397 Max Freedman 115
410 410 <em>Castle in the Sky</em> 410 Max Freedman 115
556 556 <em>Up and Away</em> 556 Max Freedman 115
823 823 <em>Famously Alive</em> 823 Max Freedman 115
864 864 <em>Broken Equipment</em> 864 Max Freedman 115
869 869 <em>Mark VI</em> 869 Max Freedman 115
1015 1015 <em>Sin Miedo</em> EP 1015 Max Freedman 115
1112 1112 <em>Are You Happy EP</em> 1112 Max Freedman 115
1114 1114 <em>Water</em> 1114 Max Freedman 115
1138 1138 <em>... EP</em> 1138 Max Freedman 115
1279 1279 <em>one hand on the steering wheel the other sewing a garden</em> 1279 Max Freedman 115
1410 1410 <em>’Til I Start Speaking</em> 1410 Max Freedman 115
1544 1544 <em>Nastavi, Calliope</em> 1544 Max Freedman 115

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)
);