Using a 'COUNT as' in a 'WHERE'

   
SELECT customers.lead_type
, ac0
, ac1
, ac2
, ac3
, ac4
, active
, daily 
, timezone
, run
, pri
, customers.id
, customers.carrier
, customers.state
,customers.customer
, MAX(xferleads.timestamp)AS maxTimeStamp
,COUNT( CASE WHEN xferleads.timestamp >= CURRENT_DATE 
                    AND xferleads.timestamp  < CURRENT_DATE + INTERVAL 1 DAY 
                   AND woactive>0
                   THEN xferleads.customer
                   ELSE NULL END ) AS countdaily

FROM customers 
LEFT JOIN xferleads ON xferleads.customer = customers.id
LEFT JOIN fulfillment ON fulfillment.id = customers.id



WHERE 
     (customers.lead_type='PRE' OR customers.lead_type = 'ANY') 
     AND (ac0 =818 OR ac1 = 818 OR ac2 = 818 OR ac3 = 818 OR ac4 = 818) 
     AND active=1 AND countdaily < (daily * 1.5) 
     AND Tue = 1 

GROUP BY customers.customer

WHERE 
     (customers.lead_type='PRE' OR customers.lead_type = 'ANY') 
     AND (ac0 =818 OR ac1 = 818 OR ac2 = 818 OR ac3 = 818 OR ac4 = 818) 
     AND active=1 AND countdaily < (daily * 1.5) 
     AND Tue = 1 
GROUP BY customers.customer

 WHERE customers.lead_type IN ('PRE','ANY') 
   AND 818 IN (ac0,ac1,ac2,ac3,ac4) 
   AND active = 1 
   AND Tue = 1 
GROUP 
    BY customers.customer
     , daily
HAVING countdaily < (daily * 1.5)