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.`protector`, 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` = 'Introducer Needle with Base Plate' AND p.`part_number` NOT LIKE 'fake%' ORDER BY p.`length` DESC, p.`diameter`, FIELD(p.`thickness`, 'TW', 'ETW', 'UTW') ${data}

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