reviews_authors

18 rows where author_id = 213

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
1352 1352 <em>Before I Die</em> 1352 Minna Zhou 213
1797 1797 <em>Birdy Island</em> 1797 Minna Zhou 213
3746 3746 <em>Rouge</em> 3746 Minna Zhou 213
6605 6605 <em>Cubafonía</em> 6605 Minna Zhou 213
6640 6640 <em>Uyai</em> 6640 Minna Zhou 213
7068 7068 <em>After Hours</em> 7068 Minna Zhou 213
7620 7620 Wake Up You!: The Rise &amp; Fall of Nigerian Rock 1972-1977 7620 Minna Zhou 213
7700 7700 <em>Egyptian Lover 1983-1988</em> 7700 Minna Zhou 213
7881 7881 <em>Trotro</em> 7881 Minna Zhou 213
7912 7912 <em>Zelalem</em> 7912 Minna Zhou 213
7977 7977 <em>Né So</em> 7977 Minna Zhou 213
8564 8564 <em>Bahdeni Nami</em> 8564 Minna Zhou 213
8691 8691 <em>Amanecer</em> 8691 Minna Zhou 213
8906 8906 <em>Verde EP</em> 8906 Minna Zhou 213
8937 8937 <em>Zoy Zoy</em> 8937 Minna Zhou 213
9117 9117 <em>Ibeyi</em> 9117 Minna Zhou 213
25468 25468 <em>YIAN</em>  25464 Minna Zhou 213
26274 26274 <em>The Closest Thing to Silence</em> 26270 Minna Zhou 213

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