SELECT `a`.`video_sn`, `b`.`sn`, `a`.`catalog_name_eng`, `a`.`order_sn` FROM `catalog_link` as `a` INNER JOIN `customer` `b` ON `b`.`member_serial` = `a`.`company_sn`WHERE (`b`.`member_serial` LIKE '%MT609%' OR `b`.`semi_keyword` LIKE '%MT609%' ) AND `a`.`video_sn` != '' AND `a`.`on_eng` = 'Y' AND `a`.`on_line` = 'Y' ORDER BY `a`.`order_sn` ASC, `a`.`video_sn` ASC