sql_error:
(select 'blog' as rectype, blogid as recid,blogtitle as rectitle,
zonerank(2,'Connecticut','blog',blogid) as score2,
zonerank(1,'US','blog',blogid) as score1,
zonerank(0,'','blog',blogid) as score0 from blogs
having ifnull(score0,0)+ifnull(score1,0)+ifnull(score2,0)>0
)