Nightfall Ugg Boots

Did you think Nightfall Ugg Boots is a kind of well know boots, that's right, you can see the shepherd wear it walking in the snow. This is the durable boots among the ugg series. Suitable for those who live under the bad weather. Our goal is to let all our customers feel satisfied when shopping online in our Ugg Boots Canada store.
1 Can't create/write to file '/tmp/#sql_2ef_0.MYI' (Errcode: 28)
in:
[select p.products_image, pd.products_name, p.products_quantity, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '20' order by p.products_sort_order, pd.products_name]