SELECT p.`part_number`, p.`type`, p.`thumbnail_outlines`, CONCAT(p.`size`, p.`size_unit`) AS `size`, CONCAT(j.`length`, j.`length_unit`) AS `dilator_length`, j.`material` as `dilator_material`, CONCAT(j2.`length`, j2.`length_unit`) AS `sheath_length`, j2.`color` AS `sheath_color`, j2.`material` AS `sheath_material`, j3.`color` AS `hub_color` 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` = 'Straight Wing Tearaway' AND p.`part_number` NOT LIKE 'fake%' ${data}

IMG	PART NUMBER	SIZE	DILATOR LENGTH	SHEATH LENGTH	HUB COLOR
	${type}
	${part_number}	${size}	${dilator_length}	${sheath_length}	${hub_color}