Rotary

Rotary


Warning: [MYSQL] Unknown column 'final_price' in 'order clause' (1054): [QUERY] select distinct p.products_id from osc_products p left join osc_product_attributes pa on (p.products_id = pa.products_id) left join osc_templates_boxes tb on (pa.id = tb.id and tb.code = "manufacturers"), osc_products_description pd, osc_categories c, osc_products_to_categories p2c where p.products_status = 1 and p.products_id = pd.products_id and pd.language_id = 1 and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.products_id = p.products_id and p2c.products_id = pd.products_id and p2c.categories_id in (18) order by final_price , pd.products_name limit 0, 20 in /home/medisys/domains/medisysltd.com/public_html/includes/classes/database.php on line 72
There are no products available in this category.
recently_visited_title
recently_visited_products_title
  1. Diamond+ Diamond Burs 531
    Diamond+ Diamond Burs 531
    ฿0.00 (recently_visited_item_in_category)
  2. EXCAVATOR 145-146
    EXCAVATOR 145-146
    ฿0.00 (recently_visited_item_in_category)
  3. Diamond+ Diamond Burs 521
    Diamond+ Diamond Burs 521
    ฿0.00 (recently_visited_item_in_category)
  4. Diamond+ Diamond Burs 555
    Diamond+ Diamond Burs 555
    ฿0.00 (recently_visited_item_in_category)
  5. Diamond+ Diamond Burs 530
    Diamond+ Diamond Burs 530
    ฿0.00 (recently_visited_item_in_category)
recently_visited_categories_title
  1. Rotary
  2. Matrix Systems
  3. Consumables
Manufacturers
 
(try our advanced search)
Languages
English
Currencies