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

select p.products_id, p.customer_id, pd.products_name, pd.products_description, p.products_image, pd.products_url, p.customer_id, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available,p.mbp, p.manufacturers_id,pr.minimaltime, pr.pricegeneric, pr.stay1, pr.pricestay1, pr.stay2, pr.pricestay2, pr.priceweekends, pr.fri, pr.sat, pr.sun, pr.fechainicio, pr.fechafin, pr.name, pr.eventprice from products p, products_description pd,products_rates pr, products_to_categories p2c, categories c where p.products_id=pr.products_id and pr.tipo='G' AND products_internal_status = '1' AND p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and pd.products_id = p.products_id and p2c.categories_id =24 and pd.language_id = '1' ORDER BY RAND() LIMIT 10;