1021 - Disk full (/tmp/#sql_42e_1.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 = '1' WHERE opa.orders_id IN (422826,418321,407997,377001,341132,339814) AND opa.products_id != 1443620 and p.is_bundle = 0 GROUP BY p.products_id ORDER BY opa.orders_products_id DESC LIMIT 6

[XT SQL Error]