reviews_authors

10 rows where author_id = 81

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
155 155 <em>Stumpwork</em> 155 Kieran Press-Reynolds 81
286 286 <em>Lyfë</em> 286 Kieran Press-Reynolds 81
418 418 <em>NOT TiGHT</em> 418 Kieran Press-Reynolds 81
454 454 <em>quinn</em> 454 Kieran Press-Reynolds 81
1553 1553 <em>SGV1</em> 1553 Kieran Press-Reynolds 81
25575 25575 <em>dSX.fm</em> EP 25571 Kieran Press-Reynolds 81
25603 25603 <em>If Looks Could Kill</em> 25599 Kieran Press-Reynolds 81
26030 26030 <em>Census Designated</em> 26026 Kieran Press-Reynolds 81
26147 26147 <em>Night Killaz Vol.1 EP</em> 26143 Kieran Press-Reynolds 81
26320 26320 <em>Lip Flip</em> EP 26316 Kieran Press-Reynolds 81

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