reviews_authors

87 rows where author_id = 20

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
24 24 <em>Snake Chain</em> 24 Madison Bloom 20
47 47 <em>And I Have Been</em> 47 Madison Bloom 20
118 118 <em>Fashion Nugget</em> 118 Madison Bloom 20
307 307 <em>I Love You Jennifer B</em> 307 Madison Bloom 20
474 474 <em>New Pleasures</em> 474 Madison Bloom 20
537 537 <em>Heaven Is Here</em> 537 Madison Bloom 20
665 665 <em>Ama Gogela</em> 665 Madison Bloom 20
691 691 <em>Super Champon</em> 691 Madison Bloom 20
708 708 <em>Void</em> 708 Madison Bloom 20
804 804 <em>The Specials</em> 804 Madison Bloom 20
905 905 <em>Regards to the End</em> 905 Madison Bloom 20
1016 1016 <em>Distance on Ground</em> 1016 Madison Bloom 20
1049 1049 <em>sometimes i feel like i have no friends</em> 1049 Madison Bloom 20
1069 1069 <em>Breathe Suite EP</em> 1069 Madison Bloom 20
1088 1088 <em>Concrete</em> 1088 Madison Bloom 20
1247 1247 <em>Sediments We Move</em> 1247 Madison Bloom 20
1287 1287 <em>Girl, Buried</em> 1287 Madison Bloom 20
1448 1448 <em>Sinner Get Ready</em> 1448 Madison Bloom 20
1469 1469 <em>Yes/And</em> 1469 Madison Bloom 20
1623 1623 <em>Mommy Issues EP</em> 1623 Madison Bloom 20
1650 1650 <em>Avow</em> 1650 Madison Bloom 20
1721 1721 <em>Bright Green Field</em> 1721 Madison Bloom 20
1922 1922 <em>Unlocked 1.5</em> 1922 Madison Bloom 20
1985 1985 <em>Let My People Go</em> 1985 Madison Bloom 20
2010 2010 <em>Gestalt</em> 2010 Madison Bloom 20
2034 2034 <em>Painting the Roses</em> 2034 Madison Bloom 20
2069 2069 <em>Drunk Tank Pink</em> 2069 Madison Bloom 20
2174 2174 <em>Muvaland EP</em> 2174 Madison Bloom 20
2237 2237 <em>acts of rebellion</em> 2237 Madison Bloom 20
2477 2477 <em>To Feel Embraced</em> 2477 Madison Bloom 20
2505 2505 <em>Songbook EP</em> 2505 Madison Bloom 20
2558 2558 <em>Half Price at 3​:​30</em> 2558 Madison Bloom 20
2611 2611 <em>National Freedom</em> 2611 Madison Bloom 20
2671 2671 <em>S/T EP</em> 2671 Madison Bloom 20
2706 2706 <em>Flamagra (Instrumentals)</em> 2706 Madison Bloom 20
2763 2763 <em>Set My Heart on Fire Immediately</em> 2763 Madison Bloom 20
2780 2780 <em>What’s New, Tomboy?</em> 2780 Madison Bloom 20
2848 2848 <em>Little Creatures</em> 2848 Madison Bloom 20
2876 2876 <em>The Loves of Your Life</em> 2876 Madison Bloom 20
2896 2896 <em>Hot and Flustered</em> 2896 Madison Bloom 20
3030 3030 <em>Milkteeth</em> 3030 Madison Bloom 20
3164 3164 <em>Munich 2016</em> 3164 Madison Bloom 20
3166 3166 <em>Losst and Founnd</em> 3166 Madison Bloom 20
3253 3253 <em>Still Young EP</em> 3253 Madison Bloom 20
3330 3330 <em>Becoming Peter Ivers</em> 3330 Madison Bloom 20
3394 3394 <em>(GI)</em> 3394 Madison Bloom 20
3463 3463 <em>The Third Ascension</em> 3463 Madison Bloom 20
3489 3489 <em>Weeping Icon</em> 3489 Madison Bloom 20
3649 3649 <em>Perfumed Earth</em> 3649 Madison Bloom 20
3949 3949 <em>Age Hasn’t Spoiled You</em> 3949 Madison Bloom 20
3968 3968 <em>A Thousand Leaves</em> 3968 Madison Bloom 20
3969 3969 <em>The Dots</em> 3969 Madison Bloom 20
4061 4061 <em>Only You Can See It</em> 4061 Madison Bloom 20
4083 4083 <em>Dog Whistle</em> 4083 Madison Bloom 20
4268 4268 <em>In a Galaxy</em> 4268 Madison Bloom 20
4356 4356 <em>Love Hates What You Become</em> 4356 Madison Bloom 20
4437 4437 <em>Utopia Teased</em> 4437 Madison Bloom 20
4443 4443 <em>Merrie Land</em> 4443 Madison Bloom 20
4811 4811 <em>Our Garden Needs Its Flowers</em> 4811 Madison Bloom 20
4830 4830 <em>Heart Head West</em> 4830 Madison Bloom 20
4922 4922 <em>Sculptor</em> 4922 Madison Bloom 20
5044 5044 <em>No Shame</em> 5044 Madison Bloom 20
5062 5062 <em>LUMP</em> 5062 Madison Bloom 20
5229 5229 <em>am i happy, singing_</em> 5229 Madison Bloom 20
5319 5319 <em>Your Queen Is a Reptile</em> 5319 Madison Bloom 20
5428 5428 <em>Basic Behaviour</em> 5428 Madison Bloom 20
5539 5539 <em>Could It Be Different?</em> 5539 Madison Bloom 20
25256 25256 <em>Come Around</em> 25252 Madison Bloom 20
25330 25330 <em>Wendy</em> 25326 Madison Bloom 20
25482 25482 <em>3D &amp; the Holograms</em> 25478 Madison Bloom 20
25509 25509 <em>Bastard Jargon</em> 25505 Madison Bloom 20
25530 25530 <em>Blondshell</em> 25526 Madison Bloom 20
25548 25548 <em>Yallah Beibe</em> 25544 Madison Bloom 20
25671 25671 <em>Roach</em> 25667 Madison Bloom 20
25675 25675 <em>R U Saved?</em> 25671 Madison Bloom 20
25775 25775 <em>Bringing Down the Horse</em> 25771 Madison Bloom 20
25817 25817 <em>Eyeroll</em> 25813 Madison Bloom 20
25824 25824 <em>Prestige</em> 25820 Madison Bloom 20
25863 25863 <em>phantasea pharm</em> EP 25859 Madison Bloom 20
26014 26014 <em>Wasn’t Tomorrow Wonderful?</em> 26010 Madison Bloom 20
26045 26045 <em>Sator Arepo</em> 26041 Madison Bloom 20
26080 26080 <em>a time to love, a time to die</em> 26076 Madison Bloom 20
26188 26188 <em>Infinite Hatch</em> 26184 Madison Bloom 20
26189 26189 <em>Àlááfíà</em> 26185 Madison Bloom 20
26212 26212 <em>Big Sigh</em> 26208 Madison Bloom 20
26251 26251 <em>Lovegaze</em> 26247 Madison Bloom 20
26379 26379 <em>Forest Scenes</em> 26375 Madison Bloom 20

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