0
Whiskey
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,'25,162,180,182,183,380,556,585,587,589,593,641,642,687,703,739,844,838,813,820,831,824,808,805,868,907,1189,1308,1292,1268,1282,1272,1263,1287,1309,1296,1307,1315,981,1396,1377,1470,1404,1394,1488,1665') OR FIND_IN_SET(C.parentID,'25,162,180,182,183,380,556,585,587,589,593,641,642,687,703,739,844,838,813,820,831,824,808,805,868,907,1189,1308,1292,1268,1282,1272,1263,1287,1309,1296,1307,1315,981,1396,1377,1470,1404,1394,1488,1665') )
AND (P.psource IN (1,92,70,80,90,21,105) OR P.both_versions = '1') AND P.brand_id = '95'
GROUP BY P.productID ORDER BY featured DESC LIMIT 12 OFFSET 0
