Thank you very much for your very quick and useful answer! Glad to know that it is a known bug. Anyway, I have been playing around, and made it work! For some reason it does work. Have no idea why though.. select a+b+c+d segment ,min(r) ,max(r) ,count(ANYID) COUNTER from ( select ANYID ,r ,if(r >= 0.005,1,0) a ,if(r >= 0.0175,1,0) b ,if(r >= 0.08,1,0) c ,if(r >= 0.025,1,0) d from ( select ANYID,RAND(unix_timestamp()) r from ANYTABLE ) foo ) bar group by segment order by segment Do you have any idea why It does work? 🙂 Thanks Andras ... View more