1021 - Disk full (/tmp/#sql_42e_7.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 (390709,77093,73433,32183,23642,22573,14213,7675,4401,3178) AND opa.products_id != 978 and p.is_bundle = 0 GROUP BY p.products_id ORDER BY opa.orders_products_id DESC LIMIT 6

[XT SQL Error]