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` = 'Tearaway Over The Needle' 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}