1 Can't create/write to file '/tmp/#sql_760_0.MYI' (Errcode: 30)
in:
[SELECT DISTINCT p.products_id, pd.products_name, pd.products_description, p.products_image, GREATEST(p.products_date_added, IFNULL(p.products_last_modified, 0)) AS products_date, p.products_ordered, p.products_price_sorter as price, p.products_tax_class_id, p.products_quantity, p.products_model, p.products_weight, p.manufacturers_id, m.manufacturers_name, r.reviews_rating FROM products p LEFT JOIN products_description pd ON (pd.products_id = p.products_id) LEFT JOIN manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN reviews r ON (p.products_id = r.products_id) WHERE p.products_status = 1 AND p.products_ordered > 0 AND pd.language_id = 2 ORDER BY p.products_ordered DESC, pd.products_name LIMIT 100]