Martech® Medical Products » Needles/OTN » Over The Needle Catheters

IMG	PART NUMBER	CATHETER SIZE	NEEDLE LENGTH (A)* / SIZE	HUB COLOR / MATERIAL	PROTECTOR	POROUS PLUG
	Over The Needle Catheter
	AC2025	9FR	3.25" / 13ga	Clear PVC	PE1141	No
	AC2026	4FR	2.25" / 17ga	Natural Polypropylene	PPO1753	Yes
	AC2027	5FR	2.25" / 15ga	Natural Polypropylene	PPO1753	Yes
	AC2028	6FR	2.25" / 14ga	Natural Polypropylene	PPO1753	Yes
	AC2034-1	6FR	5.00" / 14ga	Natural Polypropylene	PE1141	Yes
	AC2035	14ga	2.75" / 16ga	Natural Polypropylene	PPO1756	Yes
	AC2037	16ga	2.75" / 18ga	Pink Polystyrene	PPO1756	Yes
	AC2039	16ga	2.50" / 20ga	Natural Polypropylene	PPO1753	Yes
	AC2041	18ga	2.50" / 19.5ga	Natural Polypropylene	PPO1753	No
	AC2043	20ga	1.25" / 22ga	Natural Polypropylene	PPO1760	Yes
	AC2050	14ga	5.50" / 17ga	Natural Polypropylene	PE1141	Yes

SELECT p.`type`, p.`part_number`, p.`plug`, p.`protector`, p.`thumbnail_outlines`, CONCAT(j.`size`, j.`size_unit`) AS `catheter_size`, CONCAT(j2.`length`, j2.`length_unit`) AS `needle_length`, CONCAT(j2.`size`, j2.`size_unit`) AS `needle_size`, j3.`color` AS `hub_color`, j3.`material` AS `hub_material` FROM `product` p LEFT JOIN `product` j ON p.`catheter` = j.`part_number` LEFT JOIN `product` j2 ON p.`needle` = j2.`part_number` LEFT JOIN `product` j3 ON j2.`hub` = j3.`part_number` WHERE p.`type` = 'Over The Needle Catheter' AND p.`part_number` NOT LIKE 'fake%' ${data}

IMG	PART NUMBER	CATHETER SIZE	NEEDLE LENGTH (A)* / SIZE	HUB COLOR / MATERIAL	PROTECTOR	POROUS PLUG
	${type}
	${part_number}	${catheter_size}	${needle_length} / ${needle_size}	${hub_color} ${hub_material}	${protector}	${plug}