SELECT p.*, c.name, c.cat_cod FROM products AS p INNER JOIN category AS c ON p.category_id = c.id WHERE p.url_code = 'haore-sunscreen-spf-50-60g'Array ( [id] => 13898 [product_code] => R18049 [url_code] => haore-sunscreen-spf-50-60g [quantity] => [category_id] => 36 [product_name] => HAORE SUNSCREEN SPF 50 60G [shape] => 1 [colour] => [cut] => [weight] => [origin] => [promo_line] => [product_description] => [meta_desc] => HAORE SUNSCREEN SPF 50 60G [meta_keyword] => [min_stock] => 0 [added_date] => 2023-06-23 18:08:59 [unit] => [rate] => 996 [include_vat] => 1 [added_by] => 0 [featured] => 0 [newproduct] => 0 [discounted] => 0 [bestseller] => 0 [status] => 1 [cat_id_2] => [cat_id_3] => [new_product] => [name] => Skincare Products [cat_cod] => skincare-products ) HAORE SUNSCREEN SPF 50 60G Medicines Nepal

HAORE SUNSCREEN SPF 50 60G

  • 1

Rs. 996.00
Chat in Whatsapp

Related Products

jkasfkd
HAORE SUN CREAM SPF 50+ GEL 60G

HAORE SUN CREAM SPF 50+ GEL 60G

Rs. 996.00

Chat in whatsapp
jkasfkd
HAORE SUNSCREEN SPF 50 60G

HAORE SUNSCREEN SPF 50 60G

Rs. 996.00

Chat in whatsapp
Gairigaon
Tinkune
Nepal
+977-9801232296
medicinesnepal@gmail.com