 -Stainless Steel -Can be used with any Martech® Football Tunneler |
 -Can be Fully Annealed -Can be used with any Martech® Sleeve |
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`, 'trocar_1500.jpg', 'trocar_00129.jpg',
'trocar_3744.jpg', 'tunneler_3643.jpg', 'tunneler_5241.jpg', 'tunneler_5081.jpg',
'tunneler_3788.jpg', 'tunneler_04440.jpg', 'tunneler_03593.jpg', 'tunneler_football.jpg')
', '') 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`, 'trocar_1500.jpg', 'trocar_00129.jpg',
'trocar_3744.jpg', 'tunneler_3643.jpg', 'tunneler_5241.jpg', 'tunneler_5081.jpg',
'tunneler_3788.jpg', 'tunneler_04440.jpg', 'tunneler_03593.jpg', 'tunneler_football.jpg')
| « Click a Product to Begin |
|