Art Glass Buttons

Czech art glass buttons are made exclusively by manual pressing. Patterning is based on ancient traditional and well-established patterns as well as on contemporary trends of fashion. Manufacturing of these buttons is a speciality of the region of Jablonec nad Nisou and the origin of the traditions goes back to the year 1764. The offer of our products is very large, sizes vary from 5 to 40 mm in diameter. All of the buttons are lightened using a brass eyelet. Many of buttons are decorated with gold and platinum, or with baking paints. Another technology is application of various surfaces in fine vacuum.

1030 Got error 28 from storage engine
in:
[select p.products_quantity, p.products_image, p.products_weight, pd.products_name, p.products_model, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_items, 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 = '43' order by p.products_model , pd.products_name]