reviews_authors

13 rows where author_id = 62

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
106 106 <em>Protector</em> 106 Brian Coney 62
348 348 <em>Earth Patterns</em> 348 Brian Coney 62
383 383 <em>The Distance Between Heart and Mouth</em> 383 Brian Coney 62
961 961 <em>W</em> 961 Brian Coney 62
1123 1123 <em>Buds</em> 1123 Brian Coney 62
1291 1291 <em>Moebius Strips</em> 1291 Brian Coney 62
1629 1629 <em>Butterfly 3000</em> 1629 Brian Coney 62
1709 1709 <em>Ice Melt</em> 1709 Brian Coney 62
1745 1745 <em>Diptych</em> 1745 Brian Coney 62
1854 1854 <em>Blexxed Rec</em> 1854 Brian Coney 62
2195 2195 Didn’t You Hear? // Lucifer: Black Mass // Ataraxia: The Unexplained // Music From Patch Cord Productions 2195 Brian Coney 62
2500 2500 <em>This Devastating Map</em> 2500 Brian Coney 62
2839 2839 <em>Antarctica</em> 2839 Brian Coney 62

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