SELECT p.`part_number`, p.`type`, p.`thumbnail_outlines`, CONCAT(p.`size`, p.`size_unit`) AS `size`, CONCAT(p.`length`, p.`length_unit`) AS `length`, j.`color` AS `dilator_color`, j.`material` AS `dilator_material`, j2.`color` AS `sheath_hub_color`, j2.`material` AS `sheath_material`, j3.`color` AS `dilator_hub_color`, j3.`material` AS `hub_material` FROM `product` p LEFT JOIN `product` j ON p.`dilator` = j.`part_number` LEFT JOIN `product` j2 ON p.`sheath` = j2.`part_number` LEFT JOIN `product` j3 ON j.`hub` = j3.`part_number` WHERE p.`type` = 'Valved Tearaway' AND p.`part_number` NOT LIKE 'fake%' ${data}

IMG	PART NUMBER	SIZE	LENGTH	SHEATH HUB COLOR	DILATOR HUB COLOR
	${type}
	${part_number}	${size}	${length}	${sheath_hub_color}	${dilator_hub_color}