SELECT `part_number`, `description`, `color`, `material`, `type`, `thumbnail_outlines`, CONCAT(`thru_hole`, `diameter_unit`) AS `thru_hole` FROM `product` WHERE `type` = 'TBA Cap' AND `part_number` NOT LIKE 'fake%' ORDER BY `thru_hole` ${data}

IMG	PART NUMBER	DESCRIPTION	MATERIAL
	${type}
	${part_number}	${description}	${color} ${material}