1021 - Disk full (/tmp/#sql_42e_11.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 (2144444444,442902,441871,407012,404017,399608,381054,373275,366787,365432,365077,362204,358767,347568,332551,315313,314688,314198,313501,310759,245477,239046,230108,228028) AND opa.products_id != 1369156 and p.is_bundle = 0 GROUP BY p.products_id ORDER BY opa.orders_products_id DESC LIMIT 6

[XT SQL Error]