reviews_authors

14 rows where author_id = 30

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
38 38 <em>HIS HAPPINESS SHALL COME FIRST EVEN THOUGH WE ARE SUFFERING</em>  38 Adlan Jackson 30
136 136 <em>Trouble the Water</em>  136 Adlan Jackson 30
500 500 <em>Jazz Codes</em> 500 Adlan Jackson 30
968 968 <em>IRÉ</em> 968 Adlan Jackson 30
1243 1243 <em>Juno</em> 1243 Adlan Jackson 30
1580 1580 <em>Mood Valiant</em> 1580 Adlan Jackson 30
1666 1666 <em>When Smoke Rises</em> 1666 Adlan Jackson 30
1857 1857 <em>DEACON</em> 1857 Adlan Jackson 30
1874 1874 <em>Survive EP</em> 1874 Adlan Jackson 30
2012 2012 <em>Somewhere</em> 2012 Adlan Jackson 30
2239 2239 <em>Wachito Rico</em> 2239 Adlan Jackson 30
2901 2901 <em>I Feel Alive</em> 2901 Adlan Jackson 30
3343 3343 <em>Analog Fluids of Sonic Black Holes</em> 3343 Adlan Jackson 30
25359 25359 <em>Pollen</em> 25355 Adlan Jackson 30

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