0
Casa Dragones
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)
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,'350,31,568,370,376,684,748,841,900,987,1327,1276,1298,1351,1326,1257,1376,1535,1557,1667') OR FIND_IN_SET(C.parentID,'350,31,568,370,376,684,748,841,900,987,1327,1276,1298,1351,1326,1257,1376,1535,1557,1667') )
AND (P.psource IN (1,92,70,80,90,21,105) OR P.both_versions = '1') AND P.brand_id = '6170'
GROUP BY P.productID ORDER BY featured DESC LIMIT 12 OFFSET 0
