SELECT `part_number`, `description`, CONCAT(`color`, ' ', `material`) AS `colormat`, `type`, `thumbnail_outlines`, `color`, `material` FROM `product` WHERE (`type` REGEXP 'Guidewire|-Channel Clip' OR `part_number` = 'PPM0034A') AND `part_number` NOT LIKE 'fake%' ORDER BY FIELD(`type`, 'Guidewire Advancer', 'Guidewire Straightener', 'Guidewire Tip Protector', 'Female Luer', 'Two-Channel Clip', 'Three-Channel Clip', 'Four-Channel Clip', 'Five-Channel Clip', 'Six-Channel Clip') ${data}

IMG	PART NUMBER	DESCRIPTION	COLOR/MATERIAL
	${type}
	${part_number}	${description}	${colormat}