reviews_authors

23 rows where author_id = 35

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
45 45 <em>Broken Spectre</em> 45 Matthew Blackwell 35
58 58 <em>The Hands of Grace</em> 58 Matthew Blackwell 35
72 72 <em>Almanac Behind</em> 72 Matthew Blackwell 35
78 78 <em>Tempus</em> 78 Matthew Blackwell 35
82 82 <em>Chimæra I</em> 82 Matthew Blackwell 35
100 100 <em>Through a Room</em> 100 Matthew Blackwell 35
264 264 <em>Darklife</em> 264 Matthew Blackwell 35
25261 25261 <em>Matter</em> 25257 Matthew Blackwell 35
25271 25271 <em>Ultratronics</em> 25267 Matthew Blackwell 35
25291 25291 <em>The Predator Nominate EP</em> 25287 Matthew Blackwell 35
25369 25369 <em>Maritz</em> 25365 Matthew Blackwell 35
25383 25383 <em>Our Likeness</em> 25379 Matthew Blackwell 35
25419 25419 <em>I Play My Bass Loud</em> 25415 Matthew Blackwell 35
25475 25475 <em>Requiem for Jazz</em>  25471 Matthew Blackwell 35
25569 25569 <em>Jump on It</em> 25565 Matthew Blackwell 35
25601 25601 <em>Secret Life</em> 25597 Matthew Blackwell 35
25806 25806 <em>New Future City Radio</em> 25802 Matthew Blackwell 35
25858 25858 <em>Resolve</em> 25854 Matthew Blackwell 35
26064 26064 <em>Polygon</em> 26060 Matthew Blackwell 35
26091 26091 <em>Return to Archive</em> 26087 Matthew Blackwell 35
26107 26107 <em>I was too young to hear silence</em> 26103 Matthew Blackwell 35
26302 26302 <em>Spectral Evolution</em> 26298 Matthew Blackwell 35
26359 26359 <em>Meat Puppets II</em> 26355 Matthew Blackwell 35

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