testingselect p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_related_code, p.manufacturers_id, p.products_ordered, p.products_ordered_extra, p.products_special_text, p.products_special_promo_text, p.products_price, p.products_rental_price, p.products_color,p.products_retail_price, p.products_tax_class_id, p.products_coming_soon_status, p.address_key, p.products_new_in_start, p.products_hot_item_start, p.products_bestseller_start, p.products_new_in, p.products_hot_item, p.products_bestseller, p.products_related_tag, p.pwp_group_id, p.products_offer_icon, p.products_offer_icon_position, p.products_offer_icon_startdate, p.products_offer_icon_enddate, p.products_wheel_chair_status, p.agent_contact from products p, products_description pd, manufacturers m where p.products_status = '1' and p.products_free_gift_status = '0' and p.products_third_party_status = '0' and pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '127' order by p.products_out_of_stock_status asc, (p.products_ordered + p.products_ordered_extra) desc, p.products_new desc, pd.products_name

Home Appliances 20 / 26 Products Select: Popularity New Arrivals Lowest Price Highest Price Name (A-Z) Name (Z-A) Highest Discount Rating 20 Per Page 40 Per Page 60 Per Page Prev1 2Next Sold Out 3M Tegaderm Transparent Film Dressing 10... RM 4.00 273 Sold Sold Out 3M Durapore Surgical Tape 1 Inx10Yd (2.5... RM 6.90 136 Sold Sold Out 3M Micropore 1/2" X 10Yd With Dispenser ... RM 3.50 94 Sold Sold Out 3M Micropore 2" X 10Yd With Dispenser 1s RM 6.90 93 Sold Sold Out 3M Micropore 1/2" X 10Yd Refill 1s RM 2.50 87 Sold Sold Out 3M Micropore 1/2" X 10Yd With Dispenser ... RM 59.00 86 Sold Sold Out 3M Micropore 1" X 10Yd With Dispenser 1s RM 4.50 85 Sold Sold Out 3M Transpore White (1534-2) 2 Inch X 10Y... RM 9.80 84 Sold Sold Out 3M Transpore White (1534-2) 2 Inch X 10Y... RM 55.50 82 Sold Sold Out 3M Micropore 3" X 10Yd With Dispenser 1s RM 15.50 78 Sold Sold Out 3M Micropore 1" X 10Yd With Dispenser 1s... RM 52.50 76 Sold Sold Out 3M Micropore 3" X 10Yd With Dispenser 1s... RM 62.00 76 Sold Sold Out 3M Micropore 3" X 10Yd Refill 1s RM 9.00 64 Sold Sold Out 3M Micropore 1" X 10Yd Refill 1s RM 4.00 61 Sold Sold Out 3M Transpore White (1534-0) 1/2 Inch X 1... RM 52.50 60 Sold Sold Out 3M Micropore 1" X 10Yd Refill 1s x12 RM 39.50 56 Sold Sold Out 3M Transpore White (1534-1) 1 Inch X 10Y... RM 59.00 54 Sold Sold Out 3M Micropore 3" X 10Yd Refill 1s x4 RM 35.00 53 Sold Sold Out 3M Micropore 2" X 10Yd Refill 1s RM 6.30 49 Sold Sold Out 3M Durapore Surgical Tape 1 Inx10Yd (2.5... RM 71.90 44 Sold Prev1 2Next Sorry, you must select the options in order to add to cart.