reviews_authors

100 rows where author_id = 33

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ review_id author_id
42 42 <em>Hejira</em> 42 Jenn Pelly 33
605 605 <em>Big Time</em> 605 Jenn Pelly 33
940 940 <em>Life on Earth</em> 940 Jenn Pelly 33
977 977 <em>Pompeii</em> 977 Jenn Pelly 33
1524 1524 <em>Kirtan: Turiya Sings</em> 1524 Jenn Pelly 33
1750 1750 <em>Joan Armatrading</em> 1750 Jenn Pelly 33
1778 1778 <em>Tears to Grow EP</em> 1778 Jenn Pelly 33
1789 1789 <em>epic Ten</em> 1789 Jenn Pelly 33
2422 2422 <em>Whole New Mess</em> 2422 Jenn Pelly 33
2528 2528 Totally Crushed Out! / Retreat From the Sun 2528 Jenn Pelly 33
2617 2617 <em>The Passion Of</em> 2617 Jenn Pelly 33
2864 2864 <em>Fetch the Bolt Cutters</em> 2864 Jenn Pelly 33
2986 2986 <em>Every Bad</em> 2986 Jenn Pelly 33
3003 3003 <em>Post</em> 3003 Jenn Pelly 33
3106 3106 <em>Likewise</em> 3106 Jenn Pelly 33
3225 3225 <em>Tapestry</em> 3225 Jenn Pelly 33
3317 3317 <em>Iowa Dream</em> 3317 Jenn Pelly 33
3580 3580 <em>Norman Fucking Rockwell!</em> 3580 Jenn Pelly 33
3711 3711 <em>Caligula</em> 3711 Jenn Pelly 33
3964 3964 <em>EVOL</em> 3964 Jenn Pelly 33
4235 4235 <em>While We Wait</em> 4235 Jenn Pelly 33
4326 4326 <em>Isa</em> 4326 Jenn Pelly 33
4412 4412 <em>Sistahs</em> 4412 Jenn Pelly 33
4464 4464 <em>Look Now Look Again</em> 4464 Jenn Pelly 33
4476 4476 <em>Acrylic</em> 4476 Jenn Pelly 33
4549 4549 <em>Aviary</em> 4549 Jenn Pelly 33
4569 4569 <em>Car Wheels on a Gravel Road</em> 4569 Jenn Pelly 33
4631 4631 <em>The Singles</em> 4631 Jenn Pelly 33
4725 4725 <em>Heaven</em> 4725 Jenn Pelly 33
4779 4779 <em>Dance on the Blacktop</em> 4779 Jenn Pelly 33
4863 4863 <em>Amici</em> 4863 Jenn Pelly 33
4902 4902 <em>Collected Acknowledgements</em> 4902 Jenn Pelly 33
4961 4961 <em>How Many Times Have You Driven By EP</em> 4961 Jenn Pelly 33
4976 4976 <em>Incesticide</em> 4976 Jenn Pelly 33
5033 5033 <em>Consolation EP</em> 5033 Jenn Pelly 33
5053 5053 <em>Shannon in Nashville</em> 5053 Jenn Pelly 33
5098 5098 <em>Sink EP</em> 5098 Jenn Pelly 33
5178 5178 <em>Beyondless</em> 5178 Jenn Pelly 33
5232 5232 <em>Hippo Lite</em> 5232 Jenn Pelly 33
5251 5251 <em>Capture the Flag</em> 5251 Jenn Pelly 33
5324 5324 <em>Vessel</em> 5324 Jenn Pelly 33
5400 5400 <em>Feeling EP</em> 5400 Jenn Pelly 33
5414 5414 <em>Clean</em> 5414 Jenn Pelly 33
5432 5432 <em>Landfall</em> 5432 Jenn Pelly 33
5463 5463 <em>Room Inside the World</em> 5463 Jenn Pelly 33
5499 5499 <em>Metal Aether</em> 5499 Jenn Pelly 33
5522 5522 <em>Lionheart</em> 5522 Jenn Pelly 33
5537 5537 <em>Snares Like a Haircut</em> 5537 Jenn Pelly 33
5542 5542 <em>Vessel of Love</em> 5542 Jenn Pelly 33
5574 5574 <em>Voice Hardcore</em> 5574 Jenn Pelly 33
5642 5642 <em>Laughing at the System EP</em> 5642 Jenn Pelly 33
6072 6072 <em>Tidal</em> 6072 Jenn Pelly 33
6201 6201 <em>Something to Tell You</em> 6201 Jenn Pelly 33
6401 6401 <em>World Spirituality Classics 1: The Ecstatic Music of Alice Coltrane Turiyasangitananda</em> 6401 Jenn Pelly 33
6572 6572 <em>II</em> 6572 Jenn Pelly 33
6749 6749 <em>Not Even Happiness</em> 6749 Jenn Pelly 33
6829 6829 <em>Germfree Adolescents</em> 6829 Jenn Pelly 33
6857 6857 <em>First Songs</em> 6857 Jenn Pelly 33
7153 7153 <em>Blood Bitch</em> 7153 Jenn Pelly 33
7221 7221 <em>Sunergy</em> 7221 Jenn Pelly 33
7261 7261 <em>My Woman</em> 7261 Jenn Pelly 33
7322 7322 <em>Kiid</em> 7322 Jenn Pelly 33
7458 7458 <em>Resolutionary (Songs 1979-1982)</em> 7458 Jenn Pelly 33
7695 7695 <em>HOPELESSNESS</em> 7695 Jenn Pelly 33
7790 7790 <em>Human Performance</em> 7790 Jenn Pelly 33
7899 7899 <em>Glitterbust</em> 7899 Jenn Pelly 33
8309 8309 <em>Dream All Over</em> 8309 Jenn Pelly 33
8569 8569 <em>L​.​P​.​1. aka &quot;14 Year Old High School PC​-​Fascist Hype Lords...</em> 8569 Jenn Pelly 33
8646 8646 <em>The Wild Animals in My Life</em> 8646 Jenn Pelly 33
8899 8899 <em>II EP</em> 8899 Jenn Pelly 33
9210 9210 <em>On Your Own Love Again</em> 9210 Jenn Pelly 33
9240 9240 <em>No Cities to Love</em> 9240 Jenn Pelly 33
9432 9432 Start Together 9432 Jenn Pelly 33
9505 9505 <em>Social Rust</em> 9505 Jenn Pelly 33
9816 9816 <em>Typical System</em> 9816 Jenn Pelly 33
10076 10076 <em>Yeah Yeah Yeah Yeah</em> 10076 Jenn Pelly 33
10312 10312 <em>July</em> 10312 Jenn Pelly 33
10486 10486 <em>Event of Your Leaving</em> 10486 Jenn Pelly 33
10635 10635 <em>Hoax</em> 10635 Jenn Pelly 33
10705 10705 <em>Hell Bent</em> 10705 Jenn Pelly 33
10771 10771 <em>Pain Is Beauty</em> 10771 Jenn Pelly 33
10847 10847 <em>Versions</em> 10847 Jenn Pelly 33
11154 11154 <em>Hard Coming Down</em> 11154 Jenn Pelly 33
11291 11291 <em>Cruise Your Illusion</em> 11291 Jenn Pelly 33
11730 11730 <em>Our House on the Hill</em> 11730 Jenn Pelly 33
11775 11775 <em>La-Di-Da Recordings</em> 11775 Jenn Pelly 33
11905 11905 <em>Sundowning</em> 11905 Jenn Pelly 33
12033 12033 <em>Swearin'</em> 12033 Jenn Pelly 33
12099 12099 <em>Sorry</em> 12099 Jenn Pelly 33
12131 12131 <em>A Collection of Rarities and Previously Unreleased Material</em> 12131 Jenn Pelly 33
12144 12144 <em>Wink With Both Eyes</em> 12144 Jenn Pelly 33
12225 12225 <em>Walk on Heads EP</em> 12225 Jenn Pelly 33
12360 12360 <em>The Electronic Anthology Project of Dinosaur Jr.</em> 12360 Jenn Pelly 33
12411 12411 <em>Ugly</em> 12411 Jenn Pelly 33
12445 12445 <em>Spring EP</em> 12445 Jenn Pelly 33
12531 12531 <em>Foreign Body</em> 12531 Jenn Pelly 33
12715 12715 936 Remixes 12&quot; / 936 Remixed EP 12715 Jenn Pelly 33
12913 12913 <em>Bad Penny</em> 12913 Jenn Pelly 33
26146 26146 <em>Riot!</em> 26142 Jenn Pelly 33
26219 26219 <em>Little Rope</em> 26215 Jenn Pelly 33

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