reviews_authors

9 rows where author_id = 247

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
2035 2035 <em>On All Fours</em> 2035 Ben Hewitt 247
2168 2168 <em>Idiot Prayer: Nick Cave Alone at Alexandra Palace</em> 2168 Ben Hewitt 247
2643 2643 <em>Kitchen Sink</em> 2643 Ben Hewitt 247
2809 2809 <em>Harkin</em> 2809 Ben Hewitt 247
3307 3307 <em>Thanks for the Dance</em> 3307 Ben Hewitt 247
3567 3567 <em>Lost Girls</em> 3567 Ben Hewitt 247
3908 3908 <em>California Son</em> 3908 Ben Hewitt 247
4239 4239 <em>Lung Bread for Daddy</em> 4239 Ben Hewitt 247
4361 4361 <em>The Sensual World</em> 4361 Ben Hewitt 247

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