SELECT 
							p.p_id,
							p.p_code,
							p.p_name,
							p.cat_id, 
							cat.cat_seoname,
							p.p_manufacturer_id, 
							p.p_active,
							p.p_is_visible,
							p.p_status_id,
							p.p_valid_from,
							p.p_valid_until,
							p.p_vat_val,
							p.p_sell_mu,
							p.p_sell_mu_ratio, 
							pm.p_manufacturer_name,
							pm.p_manufacturer_logo,
							pa.*,
							p.p_id,
							pmr.p_mu_relation_id,
							pmr.p_mu_relation_ratio
					FROM product p 
					LEFT JOIN product_attribute pa 
						ON pa.p_id=p.p_id 
					JOIN category cat 
						ON p.cat_id=cat.cat_id 
					LEFT JOIN product_manufacturer pm
						ON p.p_manufacturer_id = pm.p_manufacturer_id
					LEFT JOIN product_mu_relation pmr
						ON pmr.p_id = p.p_id AND pmr.measure_unit_id = p.p_sell_mu
					WHERE p.p_id='27312' LIMIT 1