0
Gift Certificates
Error:
Disk got full writing '.(temporary)' (Errcode: 28 "No space left on device")
SELECT DISTINCT P.productID,P.avg_rating,P.tot_reviews, P.free_shipping,P.seo_parameter, P.productTitle, P.mom_price, P.mom_url, P.mom_img_url,
P.mom_id,P.productDesc, P.retailPrice, P.dealPrice, P.productImage, P.mom_size,
P.quantity, P.regionID, IF(P.dealPrice>0, P.dealPrice, P.retailPrice) AS price, P.itemCode, P.psource
FROM products AS P
INNER JOIN product_categories PC ON (PC.productID=P.productID)
INNER JOIN categories C ON (C.categoryID=PC.categoryID)
LEFT JOIN product_promotions PROM ON (PROM.productID = P.productID)
WHERE 1 AND P.outdated ='0' AND (P.usa='1' OR P.both_versions = '1') and P.status=1 AND P.quantity > 0 AND P.productTitle!='' AND ( FIND_IN_SET(PC.categoryID,'958') OR FIND_IN_SET(C.parentID,'958') )
AND (P.psource IN (1,92,70,80,90,21,105) OR P.both_versions = '1')
GROUP BY P.productID ORDER BY featured DESC LIMIT 12 OFFSET 0
