Pelican Worldwide

Innovation in Valves & Sealing

order



No results. Please refine your search.
SELECT P.*, T.Date_Created AS DatePart, IF(P.Date_Created > '2018-04-09',CONCAT('new product #',P.CodeProduct,' : ',P.Product),CONCAT('new part #',T.CodePart,' : ',T.Part)) AS NewType FROM PW_xProduct AS P LEFT JOIN PW_xPart AS T ON FIND_IN_SET(T.Part_ID,P.ListPartID) WHERE (P.Groupe_ID = 80) && P.Mark_Active > 0 && (P.Area LIKE '%europe%') GROUP BY P.Product_ID ORDER by P.Mark_Owner, P.Product, P.Product_ID


ISO9001 certificate