SELECT `part_number`, `description`, `type`, `material`, `color`, `thumbnail_outlines`,
`annealable`, `use_any_football`, `use_any_sleeve`,
CONCAT(`length`, `length_unit`) AS `trocar_length`,
CONCAT(`diameter`, `diameter_unit`) AS `diameter`,
if(`annealable` = 'Yes', '

', '') AS `icon_annealable`,
if(`use_any_football` = 'Yes', '

', '') AS `icon_football`,
if(`use_any_sleeve` = 'Yes', '

', '') AS `icon_sleeve`,
if(`material` LIKE '%Stainless Steel', '

', '') AS `icon_steel`
FROM `product`
WHERE `type` REGEXP '^Trocar|Tunneler$'
AND `part_number` NOT LIKE 'fake%'
ORDER BY FIELD(`thumbnail_outlines`,
'/products/thumbnail_outlines/trocar_1500.jpg', '/products/thumbnail_outlines/trocar_00129.jpg',
'/products/thumbnail_outlines/trocar_3744.jpg', '/products/thumbnail_outlines/tunneler_3643.jpg',
'/products/thumbnail_outlines/tunneler_5241.jpg', '/products/thumbnail_outlines/tunneler_5081.jpg',
'/products/thumbnail_outlines/tunneler_3788.jpg', '/products/thumbnail_outlines/tunneler_04440.jpg',
'/products/thumbnail_outlines/tunneler_03593.jpg', '/products/thumbnail_outlines/tunneler_football.jpg')