SELECT d.name, concat(dr.name," ",dr.strength," ",dr.units) AS drugname, COUNT(o.icode) AS icode_count, SUM(o.qty) AS qty
FROM opitemrece o
LEFT OUTER JOIN doctor d ON d.code=o.doctor
LEFT OUTER JOIN drugitems dr ON dr.icode=o.icode
WHERE o.vstdate BETWEEN "2014-01-01" AND "2014-01-31"
AND (dr.did LIKE "41%" OR dr.did LIKE "42%")
GROUP BY o.doctor, dr.icode
ORDER BY d.name, dr.name