SELECT P.productID,P.productName,P.seoUri,P.productSKU,P.brandName,P.USDproductPrice,P.xOrder,P.USDspecialPrice,P.dateModified,DD.brandName AS designerBrandName,P.visibilityID,P.isDTR,P.featuredID,P.productImg,P.instagramImg,P.productPrice,P.specialPrice,P.customField,GROUP_CONCAT(DISTINCT(PI.imageName) ORDER BY PI.imgXorder ASC) AS multiImg,SUM(PS.productQuantity) AS stockCount FROM fx_product AS P INNER JOIN fx_product_category AS PC ON P.productID=PC.productID INNER JOIN fx_productimages AS PI ON P.productID=PI.productID INNER JOIN fx_designer_details AS DD ON P.designerID=DD.designerID AND DD.status='1' INNER JOIN fx_product_specification AS PS ON P.productID=PS.productID WHERE P.status='1' AND P.productStatus='0' AND PC.categoryID IN(3,7,9,11,12,14,16,17,18,20,22,25,26,28,29,30,32,33,35,36,38,40,42,43,45,47,48,49,50,52,53,54,55,166,167,168,169,170,171,172,173,174,175,176,178,179,180) GROUP BY P.productID HAVING stockCount>0 ORDER BY P.xOrder ASC LIMIT 3528,42
SELECT P.productID,P.productName,P.seoUri,P.productSKU,P.brandName,P.USDproductPrice,P.xOrder,P.USDspecialPrice,P.dateModified,DD.brandName AS designerBrandName,P.visibilityID,P.isDTR,P.featuredID,P.productImg,P.instagramImg,P.productPrice,P.specialPrice,P.customField,GROUP_CONCAT(DISTINCT(PI.imageName) ORDER BY PI.imgXorder ASC) AS multiImg,SUM(PS.productQuantity) AS stockCount FROM fx_product AS P INNER JOIN fx_product_category AS PC ON P.productID=PC.productID INNER JOIN fx_productimages AS PI ON P.productID=PI.productID INNER JOIN fx_designer_details AS DD ON P.designerID=DD.designerID AND DD.status='1' INNER JOIN fx_product_specification AS PS ON P.productID=PS.productID WHERE P.status='1' AND P.productStatus='0' AND PC.categoryID IN(3,7,9,11,12,14,16,17,18,20,22,25,26,28,29,30,32,33,35,36,38,40,42,43,45,47,48,49,50,52,53,54,55,166,167,168,169,170,171,172,173,174,175,176,178,179,180) GROUP BY P.productID HAVING stockCount>0 ORDER BY P.xOrder ASC LIMIT 3528,42
Disk got full writing '.(temporary)' (Errcode: 28 "No space left on device")