SELECT p.`part_number`, p.`material`, CONCAT(p.`length`, p.`length_unit`) AS `tube_length`, CONCAT(p.`outer_diameter`, p.`diameter_unit`) AS `outer_diameter`, CONCAT(p.`inner_diameter`, p.`diameter_unit`) AS `inner_diameter`, p.`type`, p.`thumbnail_outlines`, CAST( GROUP_CONCAT(j.`gender` SEPARATOR '/') AS CHAR ) AS `luers`, if(p.`swivel` IS NULL, 'No', 'Yes') AS `swivel`, if(j2.`material` IS NULL, 'N/A', j2.`material`) AS `swivel_material` FROM `product` p LEFT JOIN `product` j ON j.`part_number` REGEXP(p.`luer`) LEFT JOIN `product` j2 ON p.`swivel` = j2.`part_number` WHERE p.`type` LIKE 'Low Pressure Roentgenography%' AND p.`part_number` NOT LIKE 'fake%' GROUP BY p.`part_number` ${data}

IMG	PART NUMBER	LENGTH	LUERS	SWIVEL	SWIVEL MATERIAL
	${type}
	${part_number}	${tube_length}	${luers}	${swivel}	${swivel_material}