reviews_authors

40 rows where author_id = 58

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
89 89 <em>Myself in the Way</em> 89 Margaret Farrell 58
149 149 <em>Guitar Music</em> 149 Margaret Farrell 58
355 355 <em>How Do I Get That Star</em> 355 Margaret Farrell 58
529 529 <em>Barbarism</em> 529 Margaret Farrell 58
642 642 <em>EYEYE</em> 642 Margaret Farrell 58
870 870 <em>The Great Regression</em> 870 Margaret Farrell 58
1087 1087 <em>Romeo</em> 1087 Margaret Farrell 58
1314 1314 <em>Mouth Full of Glass</em> 1314 Margaret Farrell 58
3454 3454 <em>Signal</em> 3454 Margaret Farrell 58
3596 3596 <em>Back in the Tall Grass</em> 3596 Margaret Farrell 58
3689 3689 <em>Family Party EP</em> 3689 Margaret Farrell 58
3739 3739 <em>what we say in private</em> 3739 Margaret Farrell 58
3763 3763 <em>Midsommar (Original Score)</em> 3763 Margaret Farrell 58
3886 3886 <em>Boat</em> 3886 Margaret Farrell 58
3946 3946 <em>3</em> 3946 Margaret Farrell 58
3995 3995 <em>Music for Donuts EP</em> 3995 Margaret Farrell 58
4045 4045 <em>Let’s Try the After Vol. 2 EP</em> 4045 Margaret Farrell 58
4071 4071 <em>What a Boost</em> 4071 Margaret Farrell 58
4200 4200 <em>M for Empathy</em> 4200 Margaret Farrell 58
4292 4292 <em>Olympic Girls</em> 4292 Margaret Farrell 58
4353 4353 <em>Tomb</em> 4353 Margaret Farrell 58
4402 4402 <em>Foxwarren</em> 4402 Margaret Farrell 58
4539 4539 <em>Lost EP</em> 4539 Margaret Farrell 58
4553 4553 <em>Premonitions</em> 4553 Margaret Farrell 58
4612 4612 <em>Time ‘n’ Place</em> 4612 Margaret Farrell 58
4721 4721 <em>Twisted Crystal</em> 4721 Margaret Farrell 58
4833 4833 <em>Bell House</em> 4833 Margaret Farrell 58
4866 4866 <em>There’s Always Glimmer</em> 4866 Margaret Farrell 58
4940 4940 <em>Sundays</em> 4940 Margaret Farrell 58
5010 5010 <em>Moodie EP</em> 5010 Margaret Farrell 58
5088 5088 <em>Cruel Practice</em> 5088 Margaret Farrell 58
5197 5197 <em>Sway</em> 5197 Margaret Farrell 58
5302 5302 <em>Haze</em> 5302 Margaret Farrell 58
5431 5431 <em>Smell Smoke</em> 5431 Margaret Farrell 58
5592 5592 <em>Weekend Rocker</em> 5592 Margaret Farrell 58
25361 25361 <em>Norm</em> 25357 Margaret Farrell 58
25435 25435 <em>UK GRIM</em> 25431 Margaret Farrell 58
25710 25710 <em>Sugar the Bruise</em> EP 25706 Margaret Farrell 58
25904 25904 <em>Through the Window</em> 25900 Margaret Farrell 58
25988 25988 <em>Yard</em> 25984 Margaret Farrell 58

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