SELECT `part_number`, `description`, CONCAT(`color`, ' ', `material`) AS `colormat`, `color`, `material`, `type`, `thumbnail_outlines` FROM `product` WHERE `type` = '"Y" Adapter' AND `part_number` NOT LIKE 'fake%' ${data}

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