Martech® Medical Products » Needles/OTN

IMG	PART NUMBER	DIAMETER / THICKNESS	(A)* LENGTH	HUB COLOR / MATERIAL	GUIDEWIRE	ECHO TIP
	Super Sharp Needle
	AC1845TW	18ga / TW	2.75"	Pink Polypropylene	.035"	No
	AC1845ETW	18ga / ETW	2.75"	Pink Polypropylene	.038"	No
	AC1845UTW	18ga / UTW	2.75"	Pink Polypropylene	.038"	No
	AC1846TW	19ga / TW	2.75"	Brown Polypropylene	.025"	No
	AC1846ETW	19ga / ETW	2.75"	Brown Polypropylene	.032"	No
	AC1846UTW	19ga / UTW	2.75"	Brown Polypropylene	.032"	No
	AC1847TW	20ga / TW	2.75"	Yellow Polypropylene	.018"	No
	AC1847ETW	20ga / ETW	2.75"	Yellow Polypropylene	.025"	No
	AC1847UTW	20ga / UTW	2.75"	Yellow Polypropylene	.025"	No
	AC1877TW	21ga / TW	2.75"	Green Polypropylene	.018"	No
	AC1877ETW	21ga / ETW	2.75"	Green Polypropylene	.018"	No
	AC1877UTW	21ga / UTW	2.75"	Green Polypropylene	.018"	No
	AC1878TW	18ga / TW	2.75"	Pink Polypropylene	.035"	Yes
	AC1878ETW	18ga / ETW	2.75"	Pink Polypropylene	.038"	Yes
	AC1878UTW	18ga / UTW	2.75"	Pink Polypropylene	.038"	Yes
	AC1879TW	19ga / TW	2.75"	Brown Polypropylene	.025"	Yes
	AC1879ETW	19ga / ETW	2.75"	Brown Polypropylene	.032"	Yes
	AC1879UTW	19ga / UTW	2.75"	Brown Polypropylene	.032"	Yes
	AC1866TW	20ga / TW	2.75"	Yellow Polypropylene	.018"	Yes
	AC1866ETW	20ga / ETW	2.75"	Yellow Polypropylene	.025"	Yes
	AC1866UTW	20ga / UTW	2.75"	Yellow Polypropylene	.025"	Yes
	AC1849TW	21ga / TW	2.75"	Green Polypropylene	.018"	Yes
	AC1849ETW	21ga / ETW	2.75"	Green Polypropylene	.018"	Yes
	AC1849UTW	21ga / UTW	2.75"	Green Polypropylene	.018"	Yes

SELECT p.`type`, p.`part_number`, p.`thickness`, CONCAT(p.`diameter`, p.`diameter_unit`) AS `diameter`, CONCAT(p.`length`, p.`length_unit`) AS `needle_length`, j.`color` AS `hub_color`, j.`material` AS `hub_material`, CONCAT(j2.`diameter`, j2.`diameter_unit`) AS `guidewire`, p.`echo_tip`, p.`thumbnail_outlines` FROM `product` p LEFT JOIN `product` j ON p.`hub` = j.`part_number` LEFT JOIN `product` j2 ON p.`guidewire` = j2.`part_number` WHERE p.`type` = 'Super Sharp Needle' AND p.`part_number` NOT LIKE 'fake%' ORDER BY p.`echo_tip` DESC, p.`diameter`, FIELD(p.`thickness`, 'TW', 'ETW', 'UTW') ${data}

IMG	PART NUMBER	DIAMETER / THICKNESS	(A)* LENGTH	HUB COLOR / MATERIAL	GUIDEWIRE	ECHO TIP
	${type}
	${part_number}	${diameter} / ${thickness}	${needle_length}	${hub_color} ${hub_material}	${guidewire}	${echo_tip}