1021 - Disk full (/tmp/#sql_42e_34.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

SELECT p.*, pd.* FROM orders_products opa INNER JOIN products p ON p.products_id = opa.products_id AND p.products_nobuy != 1 AND p.products_status = '1' INNER JOIN products_description pd ON pd.products_id = opa.products_id AND pd.language_id = '2' WHERE opa.orders_id IN (315713) AND opa.products_id != 1271472 and p.is_bundle = 0 GROUP BY p.products_id ORDER BY opa.orders_products_id DESC LIMIT 6

[XT SQL Error]