SELECT 
				products.*,
				catalog.name AS cat_name, catalog.cid AS cat_id, 
				manufacturers.manufacturer_name AS manufacturer_name,
				COALESCE(product_gift_wrap.price,0) AS gift_wrap_price,
				COALESCE(product_gift_wrap.cost,0) AS gift_wrap_cost,
				product_gift_wrap.pgw_id
			FROM (products
			INNER JOIN catalog ON  products.cid = catalog.cid 
			LEFT JOIN manufacturers ON products.manufacturer_id = manufacturers.manufacturer_id AND manufacturers.is_visible='1')
			LEFT OUTER JOIN product_gift_wrap ON products.pid=product_gift_wrap.pid
			WHERE products.pid='163' AND products.is_visible='Yes'