KFOG, But Not 10@10

[mshray]

The first three songs of the 11:00 hour:

Cracker "Low" - major kudos
Death Cab's latest
Hot Tuna "Hesitation Blues" - ARE YOU KIDDING ME!?!?!?  Outside of perhaps the late-lamented KPIG, when/where has anyone heard that in regular airplay?  I'm getting gobsmacked on a daily basis lately.

[RGMike]

The first three songs of the 11:00 hour:

Cracker "Low" - major kudos
Death Cab's latest
Hot Tuna "Hesitation Blues" - ARE YOU KIDDING ME!?!?!?  Outside of perhaps the late-lamented KPIG, when/where has anyone heard that in regular airplay?  I'm getting gobsmacked on a daily basis lately.

impressive, tho' they still need to dial back on Train and the like. Speaking of, as I walked into CitiField last week for Mets/Giants... they were playing "Hey 'Ho Blister". No place is safe!

[mshray]

The first three songs of the 11:00 hour:

Cracker "Low" - major kudos
Death Cab's latest
Hot Tuna "Hesitation Blues" - ARE YOU KIDDING ME!?!?!?  Outside of perhaps the late-lamented KPIG, when/where has anyone heard that in regular airplay?  I'm getting gobsmacked on a daily basis lately.

impressive, tho' they still need to dial back on Train and the like. Speaking of, as I walked into CitiField last week for Mets/Giants... they were playing "Hey 'Ho Blister". No place is safe!

I think I'm detecting a deliberate No Cal bias (Hot Tuna & Train are SF, Cracker is Santa Cruz, even Sara B. is Mendo County) in their new programming, so maybe we're stuck with Train (unless/until they make a big deal out of moving to somewhere else!). 

[RGMike]

I think I'm detecting a deliberate No Cal bias (Hot Tuna & Train are SF, Cracker is Santa Cruz, even Sara B. is Mendo County) in their new programming, so maybe we're stuck with Train (unless/until they make a big deal out of moving to somewhere else!). 

You may be onto something -- just looked at the "just played" list and in the past hour they actually played "Genesis" by Jorma Kaukonen! which is even more gobsmacking than "Hesitation Blues" (and both on the same day!)

[radical347]

Gobsmack trump card (for me, anwyay): it's 1:46 AM and they're playing a remix of Garbage - "Special" that would not sound out of place on a smooth jazz station.  My mind is completely blown.

[RGMike]

Death Cab's latest

damn, they sure are playing that one a LOT.

[darryl]

I heard something that seemed new to me the other day:  Lee Michael's "Do You Know What I Mean?"

My database says that *wow*, it hasn't been dug out in over 4 years (!):

http://www.rudebadmood.com/foglist/index.php?qnewartist=&qnewsong=do+you+know+what+i+mean&qnewstart=&qnewstop=&copy=checkbox&qoldartist=&qoldsong=do+you+know+what+i+mean&qoldalbum=&qoldstart=&qoldstop=&iscopy=checkbox&Submit=Submit

Please feel free to hammer on the database, let me know if you find any bugs (there is definitely bad data in there, because KFOG's computers apparently sometime reuses song IDs, and you see completely misidentified songs show up.)

And if anybody out there knows SQL, I'd love to see a query that would try to ferret out "new" tracks as they show up.

[darryl]

Also, that Hot Tuna track is also definitely new to KFOG:  http://www.rudebadmood.com/foglist/hack.php?qnewartist=&qnewsong=Hesitation+Blues&qnewstart=&qnewstop=&copy=checkbox&qoldartist=&qoldsong=Hesitation+Blues&qoldalbum=&qoldstart=&qoldstop=&iscopy=checkbox&Submit=Submit

[RGMike]

I heard something that seemed new to me the other day:  Lee Michael's "Do You Know What I Mean?"

"new" in terms of regular KFOG playlist, probably, tho' it's a serious Katrina, 10@10-wise.  It makes sense, I guess, as it's a pop-leaning '70s hit (like the previously discussed "Danny's Song" and "Rock On") that The Bone or K-Fox would never play, but for me it's a song I never have to hear again as long as I live.

[ggould]

I heard something that seemed new to me the other day:  Lee Michael's "Do You Know What I Mean?"

"new" in terms of regular KFOG playlist, probably, tho' it's a serious Katrina, 10@10-wise.  It makes sense, I guess, as it's a pop-leaning '70s hit (like the previously discussed "Danny's Song" and "Rock On") that The Bone or K-Fox would never play, but for me it's a song I never have to hear again as long as I live.

I almost agree with Mike on this.  It's very familiar to me, being a '71 hit, and it reminds me of way too many San Jose parties back then, blasting through loud Pioneer stereo speakers.

[RGMike]

yet another gobsmacker: this morning around 6:30 they played "Peace Like a River" from the first Paul Simon LP. Everyone in the studio claimed they'd never heard it before; hard to tell if they're serious when they say stuff like that (Greg & Renee, maybe, but Peter & Webster are both 50+).

[Lightnin' Rod]

And if anybody out there knows SQL, I'd love to see a query that would try to ferret out "new" tracks as they show up.

I don't know your tables at all, but something like this would give you songs played once, and the date they were played:

* snippet

select
  song_name, played
from
 (select song_name, count(*) times_played, max(date_played) played
   from SONGS
   group by song_name) S
where
 times_played = 1

*end snippet

ETA:  Again, it's hard to say when I don't know what your tables look like or how you are inserting the data.  But if you add a new_flag column to your SONG (or whatever it's called) table and you insert a row at a time, you could always check the dataset in your insert procedure and set the flag if not:

insert into SONGS
song name,
...,
...,
new_flag
select
@song_name,
...,
...,
case when (select count(*) from SONGS s2 where @song_name = s2.song_name) = 0 then 1 else 0 end

Or something like that...

[RGMike]

And they just now did the Jackson Browne tracking-"Take it Easy"-into-"Our Lady of the Well" thing again. Always brings back a memory of laying in bed at 6am on a December morning in '73 -- the day of the famous ice storm that was featured in the novel & movie The Ice Storm -- and waking up to that very segue.

[mshray]

Biggest surprise yet: sortly before 6, they played Jackson Browne's version of "take it Easy"... and lo, they actually let it track into "Our Lady of the Well". Gobsmacked is hardly the word.  Irish Greg got to play the role of outsider and say "I'd never heard that song before".

They just did that again before 10at10 today.  In fact, check out the whole list that preceeded today's set:

Song: DRIVER 8  Artist: REM
Song: TAKE IT EASY/OUR LADY OF  Artist: JACKSON BROWNE
Song: JUST SAY YES  Artist: SNOW PATROL
Song: IS IT LIKE TODAY?  Artist: WORLD PARTY
Song: COLD SWEAT  Artist: JAMES BROWN
Song: HEY HEY HEY  Artist: MICHAEL FRANTI
Song: I MELT WITH YOU  Artist: MODERN ENGLISH 
Song: ISLAND IN THE SUN  Artist: WEEZER
Song: ONE LOVE/ PEOPLE GET READY  Artist: BOB MARLEY
 

[RGMike]

Biggest surprise yet: sortly before 6, they played Jackson Browne's version of "take it Easy"... and lo, they actually let it track into "Our Lady of the Well". Gobsmacked is hardly the word.  Irish Greg got to play the role of outsider and say "I'd never heard that song before".

They just did that again before 10at10 today.  In fact, check out the whole list that preceeded today's set:

Song: DRIVER 8  Artist: REM
Song: TAKE IT EASY/OUR LADY OF  Artist: JACKSON BROWNE
Song: JUST SAY YES  Artist: SNOW PATROL
Song: IS IT LIKE TODAY?  Artist: WORLD PARTY
Song: COLD SWEAT  Artist: JAMES BROWN
Song: HEY HEY HEY  Artist: MICHAEL FRANTI
Song: I MELT WITH YOU  Artist: MODERN ENGLISH 
Song: ISLAND IN THE SUN  Artist: WEEZER
Song: ONE LOVE/ PEOPLE GET READY  Artist: BOB MARLEY
 

and here's Mr Franti again, post-10@10.  a moratorium, please.