SELECT p.`type`, p.`part_number`, p.`thickness`, if(p.`part_number` LIKE 'AC185_', '*', '') AS `star`, 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` = 'Standard Introducer Needle' AND p.`part_number` NOT LIKE 'fake%' ORDER BY p.`length` DESC, p.`diameter` ${data}

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