SELECT `name`, Market_code, `style`, SUBSTRING_INDEX(`style`, '-', -1) AS BOOM
FROM stir_style
WHERE `style` LIKE 'DT%'
AND `style` NOT LIKE '%-21-%'
AND active = 'Y'
ORDER BY
CASE
WHEN CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(style, '-', 2), '-', -1) AS UNSIGNED) = 195
THEN 0
ELSE 1
END,
CAST(SUBSTRING_INDEX(style, '-', -1) AS UNSIGNED) DESC,
CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(style, '-', 2), '-', -1) AS UNSIGNED) DESC