1 - Can't create/write to file '/tmp/#sql_448_1.MYI' (Errcode: 122)

SELECT DISTINCT p.products_id, p.products_fsk18, pd.products_name, pd.products_name_id, pd.products_short_description, p.products_image, p.products_price, p.products_vpe, p.products_vpe_status, p.products_vpe_value, p.products_tax_class_id, p.products_date_added, manufacturers.manufacturers_name FROM categories c, products_to_categories p2c, products p LEFT JOIN manufacturers ON p.manufacturers_id = manufacturers.manufacturers_id LEFT JOIN products_description pd ON p.products_id = pd.products_id AND pd.language_id = '4' WHERE c.categories_status=1 AND p.products_id = p2c.products_id AND c.categories_id = p2c.categories_id AND p.products_price> 0 AND products_status = '1' AND p.products_date_added> '2021.01.31' ORDER BY RAND() DESC LIMIT 6

[XT SQL Error]