Error description 3: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where 1 and uploadedat <> '0000-00-00' order by mid(producttitle,17) limit 0,1' at line 1
SELECT network,`group`,case when manufacturerbrand = '' or sitename like concat('%',manufacturerbrand,'%') then case when category2 = '' then category1 else category2 end else manufacturerbrand end as category,category1,category2,category3,category4,category5,productTitle,shortdescription,longdescription, imageurl,deeplink,price,deliverycost,uniqueid,sitename,manufacturerbrand,uploadedat from where 1 and uploadedat <> '0000-00-00' order by mid(producttitle,17) limit 0,1other prods Error description 6 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where 1 and uploadedat <> '0000-00-00' order by mid(producttitle,17) limit 0,1' at line 1
SELECT distinct network,`group`,case when manufacturerbrand = '' or sitename like concat('%',manufacturerbrand,'%') then case when category2 = '' then category1 else category2 end else manufacturerbrand end as category,category1,category2,category3,category4,category5,productTitle,shortdescription,longdescription, imageurl,deeplink,price,deliverycost,uniqueid,sitename,manufacturerbrand,uploadedat from where 1 and uploadedat <> '0000-00-00' order by mid(producttitle,17) limit 0,13