SELECT o.hn,concat(p.pname,p.fname," ",p.lname) AS ptname,v.age_y,p.hometel,opd.bw,opd.height,
dt.name,o.vstdate,o.nextdate
FROM opitemrece op
LEFT OUTER JOIN vn_stat v ON op.vn=v.vn
LEFT OUTER JOIN oapp o ON op.vn=o.vn
LEFT OUTER JOIN opdscreen opd ON opd.vn=op.vn
LEFT OUTER JOIN patient p ON p.hn=op.hn
LEFT OUTER JOIN drugitems dt ON op.icode=dt.icode
WHERE o.vstdate BETWEEN "2009-09-01" AND "2009-09-30"
AND op.icode IN ("1490164","1490163","1510908","1490166","1490076","1510909",
"1460503","1490139","1470510","1510907","1460283","1460285","1430501","1490175","1490173","1500044","1500046","1500050",
"1460526","1460562","1460286","1470002","1470003","1470004","1490167")
GROUP BY op.vn
ORDER BY o.vstdate ,o.hn