SELECT ce.customer_id
     , GROUP_CONCAT(ce.id) AS ids
     , SUM(main) AS s
FROM customers_email ce
GROUP BY ce.customer_id
HAVING s = 0;