hth: published_songs: 8 rows where track = 7

8 rows where track = 7

descending

id	slug	publish	publish_on	title	credits	lyrics	track	release_id
7	slow-motion-records	1	2007-06-01 00:00:00	Slow Motion Records Broken At Break Neck Speeds	Written by Ryan Walsh, © 2007 Reverse The Tape Decks (ASCAP)	here's the crux of the cameraman buried deep in his master plan here's a format becoming defunct a bunch of tapes on a ship that sunk electric outlet in a public place so new rappers get to show their face if you're human and you're feeling displaced we've got news for you it's the kind that makes you shake in your boots and crumble down to the floor Tommy Beta with his life on pause his college thesis stored in his parents garage are you into the olive branch? (are you, Tommy?) or shooting arrows in an American trance list your prescriptions on your resume and polish bullets saved for our prey add sinking feelings and we'll call it a day I wear a mask to sleep and it's old and it's made of clay and I have no idea why I do that if you're guilty of some heinous crime I'll write your defense down in metered rhyme we'll make believe we got it right this time I've got news for you and me and him and her and us and everything's crumbling and rotting away but I'm content to sit here and watch it all happen with you	7	1
13	nurses-5-float-past	1	2008-04-08 00:00:00	Nurses 5 Float Past	Written by Ryan Walsh, © 2008 Reverse The Tape Decks (ASCAP)	it's the memory you let go not the stimuli of the ghost injecting opera, in the corridor of the queen's latest estate and so you slip on past the bazaar troubles d.o.a. thus far “I'm not so criminal in a cathedral” you remark as the blimps fade away “is this an epilogue?” doc asks while the nurses 5 float past “we'd like to regulate but not aggravate and bring this dance to a close” and while you sit and think about that something invisible falls flat and we'll not know today what it had to say but I'm sure it'll be back	7	9
32	grand-national-championships	1	2009-07-01 00:00:00	Variations On The Grand National Championships	Written by Ryan Walsh, © 2009 Reverse The Tape Decks (ASCAP)	I can see you in my telescope that punctures time like a needle through paper you’re washing dishes during the civil war as your husband’s stabbing your dad they never met so it’s not even realized how heavy truly the moment and in the present in a shopping line my sugar refuses to scan oh, the time has come to crash right through the gates of ivory towers we must find a way to topple all the thrones you were right this light it comes from the night and takes the shame out of being so latent everything that’s been scheduled for you you call random and sleep through the days so you invest in every angle and hinge hoping there’s something to swing from or hide in but now there’s nothing but a precipice and an old song to sing through the night oh, the time has come to crash right through the gates of ivory towers we must find a way to topple all the thrones oh the time has come! oh the time has come! can we quake these tectonic plates? would it shake the street that you live on? portraits tumble to the hardwood floor leaving dents and impressions of me I fall asleep on an empty highway as my truck crashes into the woodlands my feet are caught but I reach the flare gun shoot it off but it’s the 4th of July	7	3
52	people-breathe-into-other-people	1	2012-04-01 21:14:16	People Breathe Into Other People	David Bentley - guitar, backing vocals David Bryson - drums Elio DeLuca - rhodes, organ, backing vocals Joseph Marrett - backing vocals Brian Rutledge - trumpet, backing vocals Ryan Walsh - vocals, guitar, samples Nicholas Giadone Ward - bass, backing vocals	Well I paced for some duration And the sum of the steps left us scarred With a trap door heart and an X-Ray head, we depart Now there’s no such thing as sleeping And there’s no such thing as the past The dares from the crowd Were spoken out loud And that’s that What is this world? What is this world? Now let’s walk through the next few moments With the caution and care of a fawn Like paper mache if you’re poetic that way But you’re not What is this world? What is this world? People Breathe Into Other People And Bring Them Back To Life People Breathe Into Other People And Bring Them Back To Life People Breathe Into Other People And Bring Them Back To Life People Breathe Into Other People And Bring Them Back To Life People Breathe Into Other People And Bring Them Back To Life People Breathe Into Other People And Bring Them Back To Life People Breathe Into Other People And Bring Them Back To Life People Breathe Into Other People And Bring Them Back To Life People Breathe Into Other People And Bring Them Back To Life People Breathe Into Other People And Bring Them Back To Life What is this world?	7	7
70	a-domestic-zone	1	2014-05-03 08:24:29	A Domestic Zone		Meet my wife we’re as thick as thieves we’ve been up for days now we’re on our knees Watch your back we’re not alone we’re coming to in a domestic zone in a domestic zone Let’s slow down this violent pace put the tv on watch a famous face Watch your back we’re not alone we’re coming to in a domestic zone in a domestic zone Tap the phone break the locks curse this house stop the clocks Watch your back we’re not alone we’re coming to in a domestic zone in a domestic zone	7	10
86	play-it-as-it-loops	1	2016-02-25 06:05:55	Play It As It Loops		I should have scattered my private life like a magazine in the trees got tangled in telemarketing dialed homesteads, look at these it's a wow, i'm on fire, it's amazing so bring it to me I couldn't suspend my disbelief or invest in foreshadowing unreliable narrators in my bed how will they describe how I sleep? “through the night / he lays bare in the morning he's not even here” it is what it is but it's not what we thought I passed through the mirror to see I passed through the mirror to see I converted atoms to bees I pulled on the forces in threes But I left out that part of the dream it's a wow, i'm on fire, it's amazing so bring it to me	7	12
97	somethings-coming	1	2016-07-04 16:42:10.667000	Something's Coming			7	13
104	it-still-floors-me	1	2019-10-03 11:56:57	It Still Floors Me		I just now started to take my own advice I know you sent the message over twice this is the way the old gods entice it still floors me it still floors me Sometimes I did drugs I found on the floor kept the search on point evermore pounding out words on a door it still floors me it still floors me when you solve the mystery you become one yourself as you sink into everyone else you ask, “is this how it feels to be you?” it still floors me it still floors me confused by classics / mistaken for miracles I was trying to read myself my rights I was trying to embrace endless nights it still floors me it still floors me it still floors me it still floors me time travel is real but there’s a price you pay I came back to check out the places you stayed there’s something in the water that’s driving us out of minds this only counts if I stay alive I know that Karen’s on our side it still floors me it still floors me you’re only harmless when you’re asleep and darling you’re never asleep and darling you’re never asleep and darling you’re never asleep it still floors me break light / all night / try to go out of your mind it still floors me somebody nobody knew: that’s me it still floors me	7	15

Advanced export

JSON shape: default, array, newline-delimited

CREATE VIEW published_songs as
select * from music_song where publish;

published_songs (view)

8 rows where track = 7

Advanced export