SELECT trunkname AS trunkname FROM `cc10_today_pbxcdrs` WHERE proname='zl' AND DATE_FORMAT(starttime,'%Y-%m-%D')=DATE_FORMAT(CURDATE()-1,'%Y-%m-%D')
SELECT trunkname AS trunkname FROM `cc10_today_pbxcdrs` WHERE proname='zl'
AND DATEDIFF(NOW(),starttime)=1
SELECT trunkname AS trunkname FROM `cc10_today_pbxcdrs` WHERE proname='zl'
AND DATEDIFF(NOW(),starttime)=1