SELECT v3.hn, v3.patient_name, v12.pdx, v12.lastvisit, v12.vstdate, v12.old_diagnosis, v12.lastvisit_hour FROM vn_stat v12, visit_name v3 WHERE v3.vn=v12.vn AND v12.vstdate between '2007-03-01' and '2007-03-10' and v12.lastvisit_hour='48'
SELECT v12.hn, v12.pdx, v3.patient_name, s19.vsttime, s19.service3, s19.service4, s19.staff, v12.vstdate, v12.old_diagnosis, v12.lastvisit_hour FROM vn_stat v12, visit_name v3, service_time s19 WHERE v3.vn=v12.vn AND s19.vn=v3.vn and v12.vstdate between '2007-03-01' and '2007-03-30' and v12.lastvisit_hour='<48' and s19.staff='opd'