SELECT ca.customer_id
     , COUNT(DISTINCT IFNULL(ca.device_id, -1)) AS q
FROM yii_doc.customer_auth ca
GROUP BY ca.customer_id
HAVING q > 1;