select count(*),l.ordPk,lo.yfhj,l.ordNO,bu.username,bu.telephone,l.createDat FROM LgtOrder l
LEFT JOIN LgtOrderCarriage lo on l.ordPk=lo.ordPk
left join BaseUserInfo bu on bu.userPk=l.shipper where l.ordPk=40 AND bu.username like '%管%' AND lo.createDat BETWEEN '2016-8-1' and '2017-8-9' ;
怎么写出来 自定义吗