UPDATE trisco_e_clickrates set `queueid`=SUBSTR(`queueid`, 1, 36);
SELECT t2.uid, t2.mail, IF(t2.status=0, 1, 0) AS unsubscribed, COUNT(DISTINCT t1.queueid ) AS mailsclicked, if( MAX(t1.guid) IS NULL, 0, if( COUNT(DISTINCT t1.queueid )>=10, 3,  IF( COUNT(DISTINCT t1.queueid )>=5, 2, 1))) AS mailgroup
FROM users0 t2 LEFT JOIN trisco_mailing_queue t3 ON t3.user_id=t2.uid
LEFT JOIN trisco_e_clickrates t1 ON t3.hash = t1.queueid
GROUP BY t2.uid
ORDER BY mailsclicked DESC