INVALID SQL: 1064 : 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 ''GIANFRANCO FERRE'')
ORDER BY
rand()
LIMIT 0,3' at line 14 SQL QUERY FAILURE:
SELECT
xcart_products.*,
xcart_products.list_price AS price ,
IF(xcart_products_lng.productid != '', xcart_products_lng.product, xcart_products.product) as product,
IF(xcart_products_lng.productid != '', xcart_products_lng.descr, xcart_products.descr) as descr,
IF(xcart_products_lng.productid != '', xcart_products_lng.fulldescr, xcart_products.fulldescr) as fulldescr
FROM
xcart_products
INNER JOIN xcart_products_categories USING (productid)
LEFT JOIN xcart_products_lng ON xcart_products_lng.productid = xcart_products.productid AND xcart_products_lng.code = 'US'
WHERE
xcart_products.forsale!='N' AND
categoryid='1' AND
manufacturerid IN (SELECT manufacturerid FROM xcart_manufacturers WHERE MID(xcart_manufacturers.manufacturer, LOCATE('[', xcart_manufacturers.manufacturer)+1, LOCATE(']', xcart_manufacturers.manufacturer)-2) = 'GIANFRANCO FERRE'')
ORDER BY
rand()
LIMIT 0,3 Gianfranco ferre gianfranco ferre shirt :: GIGLIO fashion worldwide
P.I. 05654840825 - Credits
+39 091 625 7729
