Error Message:
1021: Disk full (/var/mysqltmp/#sql_614e_19.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 (3,164,165,166,167,168,169,170,171,172,81,4,173,174,175,176,5,206,207,208,209,210,211,212,213,6,214,215,216,217,218,219,7,192,193,194,195,196,197,8,236,237,238,239,240,241,242,243,244,245,246,247,248,9,249,250,251,10,220,221,222,223,224,225,226,227,228,229,230,231,11,232,233,234,235,162,187,188,189,190,191,265,163,198,199,200,201,202,203,204,205,2) OR C.cat_id in (3,164,165,166,167,168,169,170,171,172,81,4,173,174,175,176,5,206,207,208,209,210,211,212,213,6,214,215,216,217,218,219,7,192,193,194,195,196,197,8,236,237,238,239,240,241,242,243,244,245,246,247,248,9,249,250,251,10,220,221,222,223,224,225,226,227,228,229,230,231,11,232,233,234,235,162,187,188,189,190,191,265,163,198,199,200,201,202,203,204,205,2) ) GROUP BY I.productId order by productId DESC