hth: music_press: 13 rows where release

13 rows where release_id = 10

descending

id ▼	publish	publish_on	title	date	source_url	quote	release_id	body
68	1	2014-05-05 15:53:27	PopMatters	2014-05-05	http://www.popmatters.com/feature/181468-now-hear-this-hallelujah-the-hills-have-you-ever-done-something-evil/	1	Have You Ever Done Something Evil? 10	Another giant step forward
69	1	2014-05-01 15:57:47	Spin	2014-05-01	http://www.spin.com/articles/hallelujah-the-hills-do-you-have-romantic-courage-video/	1	Have You Ever Done Something Evil? 10	It might just take the enduring strength of their forthcoming full-length Have You Ever Done Something Evil? to bring their long-deserving recognition.
70	1	2014-05-09 16:15:01	Ryan's Smashing Life	2014-05-09	http://www.rslblog.com/2014/05/hallelujah-hills-and-incredible-have.html	1	Have You Ever Done Something Evil? 10	This is a brilliant record.
71	1	2014-12-18 22:10:30	Blurt Magazine	2014-05-13	http://blurtonline.com/review/hallelujah-hills-ever-done-something-evil/	1	Have You Ever Done Something Evil? 10	This is maybe the smartest music you will ever hoist a beer to
72	1	2014-12-18 22:12:08	Captains Dead	2014-12-09	http://captainsdead.com/captains-deads-favorite-record-year-part-1-4.html	1	Have You Ever Done Something Evil? 10	Pretty much as close to perfect as any band/artist could ever hope to get.
73	1	2014-12-18 22:13:29	Noisey	2014-04-23	http://noisey.vice.com/blog/hallelujah-the-hills-we-are-what-we-say-we-are-premiere	1	Have You Ever Done Something Evil? 10	Put on this song, shut up, and kiss someone.
74	1	2014-12-18 22:15:38	Wake the Deaf	2014-05-02	http://wakethedeaf.co.uk/post/84522326361/halleujah-the-hills-have-you-ever-done-something	1	Have You Ever Done Something Evil? 10	Easily my favourite rock and roll album of the year
76	1	2014-12-18 22:19:12	The Line of Best Fit	2014-05-06	http://www.thelineofbestfit.com/reviews/albums/hallelujah-the-hills-have-you-ever-done-something-evil	1	Have You Ever Done Something Evil? 10	Dizzying, heaving at its brim, full of ideas both lyrical and musical
77	1	2014-12-18 22:19:49	WBUR	2014-05-27	https://artery.wbur.org/2014/05/27/the-hallelujah-the-hills-interview-worst-gig-ever-romance-and-rock-n-roll	1	Have You Ever Done Something Evil? 10	Infuses euphoric melodies with lyrical wit and imagination
78	1	2015-01-04 09:02:15	2014 Bests and Favorites	2015-01-01		0	Have You Ever Done Something Evil? 10	#1 - Popmatters Overlooked Records of the Year #1 - Captains Dead records of the year #1 - Pop HeadWound Albums Of The Year #3 - Beat Surrender's best rock/pop/indie of the year #6 - One Chord to Another's Top 30 Albums of the year #12 & #54 Top Songs Of 2014 - The Boston Herald #4 webzine millefeuille Top Albums 2014 Doom & Gloom from the Tomb - Best Of 2014 Merge Records Staff Lists - Favorites of 2014 Bradley's Almanac - Favorite LPs of the year Improv4Humans Podcast - Best of Music Cafe Copa Y Puro - Discos Inmortales del 2014 #3 The Year In Music - NewsReview Best Songs of the Year - Oceans Never Listen Upright Citizen's Brigade Founder Matt Besser's Best of 2014
82	1	2015-04-16 06:14:44.284000	Aquarium Drunkard	2015-03-19	http://www.aquariumdrunkard.com/2015/03/19/hallelujah-the-hills-have-you-ever-done-something-evil/	1	Have You Ever Done Something Evil? 10	Few do it with the style and imagination of Hallelujah the Hills. [It's] is a blast from start to finish, every minute packed with hooky twists and turns. Mastermind Ryan Walsh can write a hell of a chorus, too, hitting plenty of Pollard-ian, singalong sweet spots over the album’s 12 tunes.
83	1	2015-04-16 06:17:53.577000	Stereogum	2015-03-25	http://www.stereogum.com/1789511/hallelujah-the-hills-destroy-this-poem-video-stereogum-premiere/video/	1	Have You Ever Done Something Evil? 10	A hometown cult following and pockets of hardcore fans scattered throughout the country.
84	1	2015-04-16 06:21:03	Brooklyn Vegan	2015-03-26	http://www.brooklynvegan.com/archives/2015/03/hallelujah_the.html	1	Have You Ever Done Something Evil? 10	Anthemic.

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE "music_press" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "publish" bool NOT NULL, "publish_on" datetime NULL, "title" varchar(200) NOT NULL, "date" date NOT NULL, "source_url" varchar(200) NOT NULL, "quote" bool NOT NULL, "release_id" integer NULL REFERENCES "music_release" ("id"), "body" text NOT NULL);
CREATE INDEX "music_press_release_id_5a017a78" ON "music_press" ("release_id");