select count(hn) as ptcount,hn,pdx
from vn_stat
where vn in
( select vn from er_regist
where vstdate between '2008-05-01' and '2008-05-31')
and lastvisit_hour<=48
and pdx not like 'Z%'
group by hn,pdx
having count(hn)>1
order by vstdate
คืนนี้จะโต้รุ่งอีกหรือป่าวครับพี่