SELECT `Show`.`id`, `Show`.`title`, `Show`.`slug`, `Show`.`start_year`, `Show`.`season_count`, IF Show.title == 'Lost' THEN '1' ELSE '0' END IF AS is_exact, `Country`.`name`, `Country`.`id` FROM `shows` AS `Show` LEFT JOIN `countries` AS `Country` ON (`Show`.`country_id` = `Country`.`id`)  WHERE `Show`.`active` = 1 AND `Show`.`title` LIKE '%Lost%'   ORDER BY `show_subscription_count` DESC, INSTR(`Show`.`title`, 'Lost') ASC, `start_year` DESC  LIMIT 10