SELECT IF(d1.item_price>0,"","(ÂÒà´ÔÁ)") AS olddrug,d1.*,v1.income,v1.an,i.name AS pdxname,do.shortname,i2.paidst,SUM(d1.item_price) AS dd
FROM doctor_order_print d1
LEFT OUTER JOIN an_stat v1 ON v1.an=d1.vn
LEFT OUTER JOIN ipt o1 ON o1.an=d1.vn
LEFT OUTER JOIN icd101 i ON i.code=v1.pdx
LEFT OUTER JOIN doctor do ON d1.doctor_code = do.code
LEFT OUTER JOIN incith i2 ON i2.an=d1.vn
WHERE d1.vn='530000550' AND d1.print_server='IPD1'
AND d1.print_mode =1
GROUP BY d1.icode
ORDER BY d1.drug_name , d1.item_no