reviews_authors

403 rows where author_id = 12

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
15 15 <em>The 7&quot; Singles</em> 15 Jayson Greene 12
36 36 <em>Type 4: City on the Type of Forever</em> 36 Jayson Greene 12
56 56 <em>Onwards!</em> 56 Jayson Greene 12
96 96 <em>They’re All Gonna Laugh at You!</em> 96 Jayson Greene 12
113 113 <em>SAP</em> 113 Jayson Greene 12
151 151 <em>Building Something Beautiful for Me</em> 151 Jayson Greene 12
211 211 <em>Ghost Dog: The Way of the Samurai</em> 211 Jayson Greene 12
235 235 <em>Older (Super Deluxe)</em> 235 Jayson Greene 12
279 279 <em>Words &amp; Music, May 1965</em> 279 Jayson Greene 12
457 457 <em>The Social Network</em> 457 Jayson Greene 12
480 480 <em>Hellfire</em> 480 Jayson Greene 12
554 554 <em>Farm to Table</em> 554 Jayson Greene 12
598 598 <em>Versions of Modern Performance</em> 598 Jayson Greene 12
618 618 <em>Blue Skies</em> 618 Jayson Greene 12
735 735 <em>When Disaster Strikes…</em> 735 Jayson Greene 12
799 799 <em>Quitters</em> 799 Jayson Greene 12
830 830 <em>Recordings From the Åland Islands</em> 830 Jayson Greene 12
852 852 <em>Frank</em> 852 Jayson Greene 12
895 895 <em>Ocean Child: Songs of Yoko Ono</em> 895 Jayson Greene 12
938 938 <em>Blackberry Rose</em> 938 Jayson Greene 12
980 980 <em>Few Good Things</em> 980 Jayson Greene 12
1025 1025 <em>Optimism</em> 1025 Jayson Greene 12
1084 1084 <em>Embryo EP</em> 1084 Jayson Greene 12
1186 1186 <em>Kid A Mnesia</em> 1186 Jayson Greene 12
1240 1240 <em>Wayfinder</em> 1240 Jayson Greene 12
1840 1840 <em>Renée Reed</em> 1840 Jayson Greene 12
1929 1929 <em>Show Me How You Disappear</em> 1929 Jayson Greene 12
1954 1954 <em>Echo</em> 1954 Jayson Greene 12
2052 2052 <em>Infamous Angel</em> 2052 Jayson Greene 12
2060 2060 <em>Two Saviors</em> 2060 Jayson Greene 12
2073 2073 <em>Petrichor</em> 2073 Jayson Greene 12
2276 2276 <em>Nobody Lives Here Anymore</em> 2276 Jayson Greene 12
2430 2430 <em>Pussy Cats</em> 2430 Jayson Greene 12
2679 2679 <em>Built to Spill Plays the Songs of Daniel Johnston</em> 2679 Jayson Greene 12
2768 2768 <em>græ</em> 2768 Jayson Greene 12
2844 2844 <em>Fear of Music</em> 2844 Jayson Greene 12
3032 3032 <em>color theory</em> 3032 Jayson Greene 12
3067 3067 <em>Changes</em> 3067 Jayson Greene 12
3290 3290 <em>Hidden History of the Human Race</em> 3290 Jayson Greene 12
3437 3437 <em>True Love</em> 3437 Jayson Greene 12
3462 3462 <em>uknowhatimsayin¿</em> 3462 Jayson Greene 12
3549 3549 <em>When We Are Inhuman</em> 3549 Jayson Greene 12
3554 3554 <em>Hollywood’s Bleeding</em> 3554 Jayson Greene 12
3662 3662 <em>Wide Prairie</em> 3662 Jayson Greene 12
3702 3702 <em>Moon Pix</em> 3702 Jayson Greene 12
3788 3788 <em>Ágætis byrjun</em> 3788 Jayson Greene 12
3846 3846 <em>Shepherd in a Sheepskin Vest</em> 3846 Jayson Greene 12
4063 4063 <em>El Chan</em> 4063 Jayson Greene 12
4096 4096 <em>Symphony of Sorrowful Songs</em> 4096 Jayson Greene 12
4272 4272 <em>After its own death / Walking in a spiral towards the house</em> 4272 Jayson Greene 12
4349 4349 <em>Future Hndrxx Presents: The WIZRD</em> 4349 Jayson Greene 12
4392 4392 <em>Nothing New in the West</em> 4392 Jayson Greene 12
4393 4393 <em>War in My Pen</em> 4393 Jayson Greene 12
4436 4436 <em>The Pains of Growing</em> 4436 Jayson Greene 12
4480 4480 <em>Ghost Forests</em> 4480 Jayson Greene 12
4491 4491 <em>Shiny and Oh So Bright, Vol. 1 / LP: No Past. No Future. No Sun.</em> 4491 Jayson Greene 12
4525 4525 <em>Come Over When You’re Sober Pt. 2</em> 4525 Jayson Greene 12
4563 4563 <em>Halloween: Original Motion Picture Soundtrack</em> 4563 Jayson Greene 12
4596 4596 <em>J.S. Bach: Six Suites for Viola Solo</em> 4596 Jayson Greene 12
4624 4624 <em>abysskiss</em> 4624 Jayson Greene 12
4652 4652 <em>Wanderer</em> 4652 Jayson Greene 12
4749 4749 <em>Safe in the Hands of Love</em> 4749 Jayson Greene 12
4794 4794 <em>Anno</em> 4794 Jayson Greene 12
4818 4818 <em>Mulberry Violence</em> 4818 Jayson Greene 12
4987 4987 <em>Renaissance Man</em> 4987 Jayson Greene 12
5051 5051 <em>Kids See Ghosts</em> 5051 Jayson Greene 12
5161 5161 <em>7</em> 5161 Jayson Greene 12
5292 5292 <em>Bark Your Head Off, Dog</em> 5292 Jayson Greene 12
5342 5342 <em>Boarding House Reach</em> 5342 Jayson Greene 12
5659 5659 <em>Book of Sound</em> 5659 Jayson Greene 12
5759 5759 <em>Red Pill Blues</em> 5759 Jayson Greene 12
5854 5854 <em>The OOZ</em> 5854 Jayson Greene 12
5898 5898 <em>He’s the DJ, I’m the Rapper</em> 5898 Jayson Greene 12
5930 5930 <em>Wonderful Wonderful</em> 5930 Jayson Greene 12
5945 5945 <em>Concrete and Gold</em> 5945 Jayson Greene 12
5982 5982 <em>Sleep Well Beast</em> 5982 Jayson Greene 12
5996 5996 <em>Popeye: Original Motion Picture Soundtrack</em> 5996 Jayson Greene 12
6081 6081 <em>Tessellatum</em> 6081 Jayson Greene 12
6248 6248 <em>OK Computer OKNOTOK 1997 2017</em> 6248 Jayson Greene 12
6260 6260 <em>Boomiverse</em> 6260 Jayson Greene 12
6306 6306 <em>RELAXER</em> 6306 Jayson Greene 12
6346 6346 <em>T-Wayne</em> 6346 Jayson Greene 12
6388 6388 <em>Reasonable Doubt</em> 6388 Jayson Greene 12
6432 6432 <em>All This I Do for Glory</em> 6432 Jayson Greene 12
6445 6445 <em>Humanz</em> 6445 Jayson Greene 12
6585 6585 <em>More Life</em> 6585 Jayson Greene 12
6632 6632 <em>Born Again</em> 6632 Jayson Greene 12
6723 6723 <em>Messes</em> 6723 Jayson Greene 12
6909 6909 <em>The Hamilton Mixtape</em> 6909 Jayson Greene 12
7059 7059 <em>Big Baby D.R.A.M.</em> 7059 Jayson Greene 12
7534 7534 <em>All Things Must Pass</em> 7534 Jayson Greene 12
7625 7625 <em>Four Organs / Phase Patterns</em> 7625 Jayson Greene 12
7675 7675 <em>A Moon Shaped Pool</em> 7675 Jayson Greene 12
7764 7764 <em>Sorrow - A Reimagining of Gorecki's 3rd Symphony</em> 7764 Jayson Greene 12
7842 7842 <em>A Good Night in the Ghetto</em> 7842 Jayson Greene 12
7985 7985 <em>The Life of Pablo</em> 7985 Jayson Greene 12
8000 8000 <em>Heaven Adores You</em> Soundtrack 8000 Jayson Greene 12
8020 8020 <em>Islah</em> 8020 Jayson Greene 12
8060 8060 <em>Wait &amp; See EP</em> 8060 Jayson Greene 12
8070 8070 <em>Purple Reign</em> 8070 Jayson Greene 12

Next page

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