SELECT * FROM catalogues
LEFT JOIN fichiers ON FiIndex = CtNum AND FiType = 'ctimage1'
WHERE CtPere = 12 and ctvisible = 1 order by CtOrder
2 way ball valve
3 way ball valve
• Full bore
• Body, ball and socket brass CW617N
• temperature -20°C to +160°C
• PN 40
• Double waterproofness : 2 FKM o-rings and 1 PTFE packing gland
• Long threads ISO 7-1 • Lot number and production date printed on the handle and the body