Error Message:
1021: Disk full (/var/mysqltmp/#sql_34b1_22.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
SQL:
SELECT DISTINCT ( I.productId ), C.cat_id, I.productCode, I.description, I.image, I.price, I.name, I.popularity, I.sale_price, I.stock_level, I.useStockLevel, description,image,weight,price,pkr_list_price,amz_price,amz_list_price,name,sale_price,prod_flag,status FROM cubecart_cats_idx AS C INNER JOIN cubecart_inventory AS I ON C.productId = I.productId WHERE prod_flag=0 AND status=0 AND C.cat_id >0 AND ( I.cat_id in (12,263,42,43,44,45,46,47,48,49,50,51,52,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,13,72,73,74,75,76,77,14,15,78,82,83,84,16,17,27,118,119,120,121,20,125,126,127,129,130,131,264,21,22,23,150,151,152,153,149,24,106,107,108,109,110,111,25,132,133,134,135,136,137,138,26,95,96,97,98,99,28,29,154,155,156,157,158,159,31,160,161,90,91,92,93,94,32,145,146,147,148,33,34,122,123,124,35,112,113,114,115,116,117,36,100,101,102,103,104,105,37,18,19,41,39,38,139,140,141,142,144,30,85,86,87,88,89,1) OR C.cat_id in (12,263,42,43,44,45,46,47,48,49,50,51,52,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,13,72,73,74,75,76,77,14,15,78,82,83,84,16,17,27,118,119,120,121,20,125,126,127,129,130,131,264,21,22,23,150,151,152,153,149,24,106,107,108,109,110,111,25,132,133,134,135,136,137,138,26,95,96,97,98,99,28,29,154,155,156,157,158,159,31,160,161,90,91,92,93,94,32,145,146,147,148,33,34,122,123,124,35,112,113,114,115,116,117,36,100,101,102,103,104,105,37,18,19,41,39,38,139,140,141,142,144,30,85,86,87,88,89,1) ) GROUP BY I.productId order by productId DESC