reviews_authors

10 rows where author_id = 337

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
4363 4363 <em>The Dreaming</em> 4363 Daphne Carr 337
24157 24157 <em>Hands in the Estuary, Torso in the Lake</em> 24153 Daphne Carr 337
24200 24200 <em>Nectar</em> 24196 Daphne Carr 337
24223 24223 <em>Antidote</em> 24219 Daphne Carr 337
24258 24258 <em>Haus de Snaus</em> 24254 Daphne Carr 337
24267 24267 <em>What We Did</em> 24263 Daphne Carr 337
24360 24360 <em>Give It to Her</em> 24356 Daphne Carr 337
24407 24407 <em>Find Your Home</em> 24403 Daphne Carr 337
24415 24415 <em>The Silver Sound Sessions EP</em> 24411 Daphne Carr 337
24433 24433 <em>Other Animals</em> 24429 Daphne Carr 337

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