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 = 'mersilk-5-0-rb-nw-5081'Array
(
[id] => 858
[product_code] => R01042
[url_code] => mersilk-5-0-rb-nw-5081
[quantity] =>
[category_id] => 43
[product_name] => MERSILK 5-0 RB NW 5081
[shape] => 1
[colour] =>
[cut] =>
[weight] =>
[origin] =>
[promo_line] =>
[product_description] =>
[meta_desc] => MERSILK 5-0 RB NW 5081
[meta_keyword] =>
[min_stock] => 0
[added_date] => 2023-06-23 18:08:59
[unit] =>
[rate] => 0
[include_vat] => 1
[added_by] => 0
[featured] => 0
[newproduct] => 0
[discounted] => 0
[bestseller] => 0
[status] => 0
[cat_id_2] =>
[cat_id_3] =>
[new_product] =>
[name] => Medical Devices
[cat_cod] => medical-devices
)
MERSILK 5-0 RB NW 5081 Medicines Nepal
