SELECT p.`part_number`, p.`material`, CONCAT(p.`length`, p.`length_unit`) AS `tube_length`, CAST(p.`length` AS UNSIGNED) AS `sort`, 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` FROM `product` p LEFT JOIN `product` j ON j.`part_number` REGEXP(p.`luer`) WHERE p.`type` = 'Standard Pressure Monitoring Line' AND p.`part_number` NOT LIKE 'fake%' GROUP BY p.`part_number` ORDER BY `luers` DESC, p.`outer_diameter` DESC, `sort` ${data}

IMG	PART NUMBER	MATERIAL	LENGTH	OD x ID	LUERS
	${type} (${luers})
	${part_number}	${material}	${tube_length}	${outer_diameter} OD x ${inner_diameter} ID	${luers}