MySQL Error Occurred

Error Message:
1021: Disk full (/tmp/#sql_4552_0.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.productStatus, I.price, I.name, I.affiliate_id, I.popularity, I.sale_price, I.stock_level, I.useStockLevel FROM CubeCart_cats_idx AS C INNER JOIN CubeCart_inventory AS I ON C.productId = I.productId WHERE I.status = 1 AND I.disabled = '0' AND C.cat_id > 0 AND C.cat_id IN (16) GROUP BY I.productId ORDER BY date_added DESC, name ASC