reviews_authors

10 rows where author_id = 356

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
4946 4946 <em>Supreme Blientele</em> 4946 Mike Madden 356
5192 5192 <em>House With a Pool</em> 5192 Mike Madden 356
10951 10951 <em>Evolution</em> 10951 Mike Madden 356
11195 11195 <em>Prisoner of Conscious</em> 11195 Mike Madden 356
11236 11236 <em>King Remembered In Time</em> 11236 Mike Madden 356
11304 11304 <em>Lil Ghetto Boy</em> 11304 Mike Madden 356
11360 11360 <em>The Patriarch</em> 11360 Mike Madden 356
11380 11380 <em>The G... The Growth &amp; Development</em> 11380 Mike Madden 356
11440 11440 <em>New Jet City</em> 11440 Mike Madden 356
11519 11519 <em>Slime Flu 3</em> 11519 Mike Madden 356

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