Error Message:
126: Incorrect key file for table '/tmp/#sql_1fa4_0.MYI'; try to repair it
SQL:
SELECT DISTINCT(I.productId), C.cat_id, I.productCode, I.description, I.image, I.price, I.name, I.popularity, I.sale_price, I.retail_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.disabled = '0' AND C.cat_id > 0 AND C.cat_id = '48' GROUP BY I.productId