reviews_authors

11 rows where author_id = 25

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
32 32 <em>Lucifer on the Moon</em> 32 Tal Rosenberg 25
177 177 <em>FOREVERANDEVERNOMORE</em>  177 Tal Rosenberg 25
282 282 <em>People Helping People</em> 282 Tal Rosenberg 25
850 850 <em>Kazemachi Roman</em> 850 Tal Rosenberg 25
6047 6047 <em>Songs From the Big Chair</em> 6047 Tal Rosenberg 25
13969 13969 <em>Floored By Four</em> 13969 Tal Rosenberg 25
13990 13990 <em>Gravity/Bees</em> 13990 Tal Rosenberg 25
14134 14134 <em>DJ-Kicks</em> 14134 Tal Rosenberg 25
14135 14135 <em>Authenticity</em> 14135 Tal Rosenberg 25
14160 14160 <em>Death Gate EP</em> 14160 Tal Rosenberg 25
26161 26161 <em>Every Picture Tells a Story</em> 26157 Tal Rosenberg 25

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