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=1 limit 0,1)as nome,(select nomeurl from prodtxt where cod=prod.cod and idi=1 limit 0,1)as nomeurl from prod where excluida=0 and cod in(select prod FROM prodgrupoexibicao where grupoexibicao=) and cod BETWEEN 1 AND 1000 order by rand()

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[MySQL][ODBC 3.51 Driver][mysqld-5.5.5-10.6.5-MariaDB]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') and cod BETWEEN 1 AND 1000 order by rand()' at line 1

/sitemapimage.asp, line 52