0
Bourbon
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,'23,151,184,369,378,575,588,592,594,641,690,747,755,809,798,833,840,867,901,1187,1192,1181,1251,1258,1353,1249,1384,1563') OR FIND_IN_SET(C.parentID,'23,151,184,369,378,575,588,592,594,641,690,747,755,809,798,833,840,867,901,1187,1192,1181,1251,1258,1353,1249,1384,1563') )
AND (P.psource IN (1,92,70,80,90,21,105) OR P.both_versions = '1') AND P.brand_id = '114'
GROUP BY P.productID ORDER BY featured DESC LIMIT 12 OFFSET 0
