Pelican Worldwide

Innovation in Valves & Sealing

Pelican Worldwide e-Store

You need to be a registered user and logged-in to order on-line.

In order to view your prices for each product/part, as well as to order on-line, you need to register and log-in with your login name and password.

No results. Please refine your search.
SELECT P.*, T.Date_Created AS DatePart, IF(P.Date_Created > '2018-02-06',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 = 23) && 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