reviews_authors

18 rows where author_id = 435

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
7260 7260 <em>Science Agrees</em> 7260 Pat Healy 435
7296 7296 <em>Home Wrecking Years</em> 7296 Pat Healy 435
7315 7315 <em>Boronia</em> 7315 Pat Healy 435
7328 7328 <em>One Day All of This Won't Matter Any More</em> 7328 Pat Healy 435
7497 7497 <em>Fire</em> 7497 Pat Healy 435
7621 7621 Taste/Should I Remain Here at Sea? 7621 Pat Healy 435
7649 7649 <em>Pile</em> 7649 Pat Healy 435
7701 7701 <em>Blue Wave</em> 7701 Pat Healy 435
7738 7738 <em>Waltzed in from the Rumbling</em> 7738 Pat Healy 435
7911 7911 <em>Under Summer</em> 7911 Pat Healy 435
8039 8039 <em>Human Ceremony</em> 8039 Pat Healy 435
8047 8047 <em>Night Fiction</em> 8047 Pat Healy 435
8103 8103 <em>Where Have You Been All My Life?</em> 8103 Pat Healy 435
8348 8348 <em>Beach Music</em> 8348 Pat Healy 435
8447 8447 <em>Ad Infinitum</em> 8447 Pat Healy 435
8466 8466 <em>Turkey</em> 8466 Pat Healy 435
8821 8821 <em>Boys</em> 8821 Pat Healy 435
8951 8951 <em>Glitterbug</em> 8951 Pat Healy 435

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