1021 - Disk full (/tmp/#sql_42e_6.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 (401183,367437,305658,305658,51095) AND opa.products_id != 1033527 and p.is_bundle = 0 GROUP BY p.products_id ORDER BY opa.orders_products_id DESC LIMIT 6

[XT SQL Error]