hth: published_songs: 9 rows where track = 2

9 rows where track = 2

descending

id	slug	publish	publish_on	title	credits	lyrics	track	release_id
2	wave-backwards	1	2007-06-01 00:00:00	Wave Backwards To Massachusetts	Written by Ryan Walsh, © 2007 Reverse The Tape Decks (ASCAP)	a blizzard a mallard a stillborn Chinese baby speaking backwards my peephole in the cabin keep an eye on loggers preparing for battle and textbooks glow like they know where we're going but it's just a guess they planted in the pages and flags unfurl like they know why we're sewing a certain kind of stars into the fabric can't keep topping my count's bestsellers pieced together in damp dark cellars flipped out fury it's a wigged out wish so creep creep crawl your way into the heartland when the clocks explode we'll sing a crooked path back to our home there is no context for this progress a village epidemic reaches congress an idea or a light bulb smashed on concrete outside of the nightclub a cat with a windchime skeleton but it's not like he's in charge of city planning greet the deep sea diver as he dives within he hides secrets behind all of the paneling we will find him before the party resumes treating cape houses like Egyptian tombs tricked out tremors in my nervous system don't sink sink sink sink sink into the pavement when the clocks explode we'll sing a crooked path back to our home wave backwards to Massachusetts we'll sing a crooked path back to our home	2	1
27	might-come-back-club	1	2009-07-01 00:00:00	The Might Come Back Club	Written by Ryan Walsh, © 2009 Reverse The Tape Decks (ASCAP)	collect your cobwebs saw off your antlers between blizzards we are free the front lawn’s hosting the strangest vine growth that will in time entangle all we see devastating news-hype hand delivered via secret hymns the might come back club’s rites of recall are etched out on the bones of these limbs open your kimono you hassle magnet let me see what all the kids are killing for consulting the Fates from far northern states with escape routes scrawled on their back doors fanatics follow the freedom of fandom hitting straw men with plastic swords rip up the floor boards find what you’ve come for you’re a guest they’ll begrudgingly endure I was in the kitchen with the grieving uncle and a drinking game that only he played so in tender spirits he went up on the rooftop to chant for the flying chariot brigade To our amazement out came the horses who’s commanding? hell if I know the might come back club’s rules of order tell us in this case we must row so start rowing	2	3
42	country-before-kings	1	2013-05-07 20:00:00	Country Before Kings		Knock, knock here I am a civilian outpost I’ve been dreaming for two We look out for quicksand Cuz we bottle and rebrand and return nightly home to you C’mon Ghost-o, is this your card? I’ve been rehearsing this trick for weeks Summoned and sunburned, enormously ticked off I’d fade away if this wasn’t sweet Last night I figured out how this will work And it’s not some slight of hand It’s a different way not to die You could trust me and try it for awhile Country Before Kings! And kings after: 1) This most pleasant evening 2) Your horoscope’s meaning I finally figured it out For Christ’s sake knock it off The cameras are rolling Let’s explore the least we could be Two tandem sleepers Like twin engine heaters Hold a light & carry this through There is no song, there is no guide To lend a clue where we ought to be Exalted and poised to type out a paean This isn’t for the king it’s for me Country Before Kings! And kings after: 1) This most pleasant evening 2) Your horoscope’s meaning I finally figured it out	2	9
47	nightingale-lightning	1	2012-04-01 21:11:40	Nightingale Lightning	David Bentley - guitar David Bryson - drums Elio DeLuca - guitar, moog, backing vocals Joseph Marrett - tambourine, cuatro Brian Rutledge - trumpet Ryan Walsh - vocals, guitar, samples Nicholas Giadone Ward - bass	Watch as this falls apart Ballet in reverse Revival of sins and critics who You thought had moved on To pastures of green Or somewhere just as baroque Nightingale Lightning! Nightingale Lightning! Hello! Hello! Hello! This is somewhat unique For a man of my class And stance and stature To stand and smoke down to the bone My cigarette And blow the smoke into the FILMS THE POPULAR SONGS THE HEADLINE PARADES THE STARS OF THE STAGE & TV SO THAT WHEN THEY REMEMBER THEY WILL REMEMBER IN A HAZE Hello! Nightingale Lightning! Nightingale Lightning! Hello! Hello!	2	7
65	try-instead	1	2014-05-03 08:22:04	Try This Instead		Just read my rights in the cadence we agreed on crush every pill wrap me in love dig all the holes try not to deceive your mind it's hard to start again in the shadow of malediction rename the moons tune up the bike bust through the door don't forget what's at stake try this instead i'll be here forever in weekly increments what's behind the words you've selected for me this evening sing no regret light up the board open your heart don’t forget not to die Let's punch up the storylines we'll show up covered in brine yes, we come from the ocean you see that, we said so we're all dressed up for someone to come home try this instead i'll be here forever in weekly increments	2	10
77	devil-level-zero	1	2015-04-06 21:20:50.023000	Devil Level Zero			2	11
81	we-have-the-perimeter-surrounded	1	2016-02-25 06:03:27	We Have The Perimeter Surrounded		real good major plotlines coasting building danger rescue homelife every single thing that I could think of we have the perimeter surrounded woody guthrie once had a weird dream he fronted a punk band called Exed Out they were amazing every single thing that I could think of we have the perimeter surrounded Twister! Ouija! Fault lines freebies! Stag films my maps bookmarks & adoration every single thing that I could think of we have the perimeter surrounded you see, we were part of the light brigade dumping wattage on hate parades getting dusked in the deep the crew was me and marty and carol two we didn't do what they told us to which was part of the deal but now, when I think back on those days I can't believe we behaved that way you know we could've been killed love, l-o-v-e-y-o-u could maybe do what it used to do you wanna give it a chance? real good major plotlines coasting building danger rescue homelife every single thing that I could think of we have the perimeter surrounded	2	12
92	the-alphabet	1	2016-07-04 16:40:24.312000	The Alphabet			2	13
98	folk-music-is-insane	1	2019-09-24 00:13:55	Folk Music Is Insane		it started with contraband wandering the poet blinked twice she can see the deepest impossible sea and we’re walking together singing the songs of some SOB stuck in a dream with a dancer and a praying monster don’t you know there’s a killer on the road? Slam cut to present day America there’s weirdness in the woods i’m alone and I can’t stop looking at my phone now we’re cheering on assassins adjusting our glasses pretending that a verse would set us free or a bad joke or a single helix it’s all the same to a ghost with a guitar folk music is insane folk music is insane we’re back in a different time who knows where i’ve been here before hear those chimes of the brand names washed out with the tide and you’re better than ever your mood like the weather is overcast with a chance of regret prepared piano and tape loops and the rarest of b-sides have absolutely ruined my life folk music is insane folk music is insane folk music is insane folk music is insane it’s something to behold but it’s out of reach and you can’t explain you’ll never get close folk music is insane I know it’s not nostalgia won’t you meet me in the parlor we can’t escape forever and there’s something in the water folk music is insane	2	15

Advanced export

JSON shape: default, array, newline-delimited

CREATE VIEW published_songs as
select * from music_song where publish;

published_songs (view)

9 rows where track = 2

Advanced export