SELECT cod,codrnd,concat(concat(lpad(year(dtalt),4,'0'),'-',lpad(month(dtalt),2,'0'),'-',lpad(day(dtalt),2,'0')),'T',concat(hralt,''),'-03:00')as ultedi,(select nome from prodtxt where cod=prod.cod and idi=3 limit 0,1)as nome,(select nomeurl from prodtxt where cod=prod.cod and idi=3 limit 0,1)as nomeurl from prod where excluida=0 and cod in(select prod FROM prodgrupoexibicao where grupoexibicao=2) and cod BETWEEN 13001 AND 14000 order by rand()