Error No8
select productvariants.desc1 as desc1, productvariants.desc2 as desc2, supplierrecid as supplierid, supplier as supplier, productvariants.artnr as productno, products.imgbigsrc as image, productvariants.price as price, imgthumbalt as imgthumbalt, imgbigalt as imgbigalt, delivery as delivery, minonstock as minonstock, longdesc as longdesc, CAST(products.IsPublish AS unsigned integer) as IsPublish, varheader as varheader, varstring as varstring, eanno as eanno, priceimpact as impact, supplierno as supplierno, imgsrc as supplierimage, imgalt as suppliersimgalt, supplierNo as supplierNo, supplierrecid as supplierrecid, zoomsrc as zoomsrc from products left join suppliers on products.supplierrecid = suppliers.recid left join productvariants on products.recid = productvariants.productrecid left join zoomimages on products.recid = zoomimages.productrecid where productvariants.productrecid = and isdefaultvar = 1 limit 1
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 'and isdefaultvar = 1 limit 1' at line 1