fail 4 select 611,tp.idpromocao,RAND()*100 from tb_cliente tc,tb_promocoes_living tp,tb_promocoes_search ts ,tb_promocoes_cidades tpc ,tb_promocoes_is_new new where tp.idpromocao=new.idpromocao and tp.idcliente=tc.idcliente and ts.idpromocao=tp.idpromocao and tpc.idcidade in('1',0) and tp.idpromocao=tpc.idpromocao and tp.idarea='26%E2%88%A8der=distance' group by tp.idpromocao order by rand()