1021. Query Error Query: SELECT DISTINCT p.*,p.id,alsobought.orders_count,(p.count > 0 || p.count IS NULL) AS in_stock FROM shop_product p JOIN (SELECT oi1.product_id, COUNT(*) orders_count FROM shop_order_items oi1 JOIN ( SELECT order_id FROM shop_order_items WHERE product_id = 79 ORDER BY id DESC LIMIT 2000 ) t ON oi1.order_id = t.order_id WHERE oi1.product_id != 79 AND oi1.type = "product" GROUP BY oi1.product_id ORDER BY orders_count DESC LIMIT 50) alsobought ON p.id = alsobought.product_id WHERE p.status = 1 ORDER BY in_stock DESC,alsobought.orders_count DESC LIMIT 12 Error: 1021 Message: Disk full (/tmp/#sql_1aed_2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")