SELECT DISTINCT SACODE, TYPE, A_DATE, A_DESC 
 FROM alltext_sa_codes2_v 
 WHERE 
  LANG = 'T'
  AND SACODE IN ('Y686','Y438','Y444','Y414','Y419','Y583','Y584','Y268','Y591','Y484','Y487','Y488','Y270','Y577','Y271','Y578','Y467','Y587','Y472','Y473','Y588','Y474','Y485','Y572','Y573','Y509','Y222','Y575','Y311','Y600','Y224','Y603','Y312','Y533','Y534','Y536','Y538','Y539','Y540','Y543','Y544','Y546','Y545','Y547','Y548','Y549','Y552','Y553','Y240','Y201','Y241','Y559','Y202','Y562','Y564','Y203','Y565','Y252','Y204','Y569','Y570','Y254','Y592','Y205','Y519','Y593','Y594','Y255','Y596','Y206','Y597','Y598','Y259','Y599','Y207','Y601','Y602','Y260','Y208','Y605','Y606','Y262','Y607','Y608','Y209','Y609','Y610','Y611','Y612','Y210','Y613','Y614','Y615','Y616','Y211','Y617','Y618','Y619','Y212','Y622','Y623','Y277','Y624','Y625','Y213','Y214','Y280','Y626','Y215','Y281','Y627','Y216','Y630','Y193','Y673','Y674','Y675','Y676','Y677','Y678','Y679','Y631','Y680','Y194','Y628','Y629','Y195','Y632','Y633','Y634','Y635','Y197','Y198','Y199','Y200','Y515','Y516','Y517','Y520','Y580','Y581','Y574','Y242','Y243','Y244','Y245','Y246','Y249','Y250','Y636','Y638','Y639','Y640','Y641','Y642','Y643','Y644','Y645','Y646','Y647','Y648','Y649','Y650','Y651','Y652','Y653','Y655','Y656','Y657','Y658','Y659','Y660','Y661','Y662','Y663','Y664','Y665','Y666','Y667','Y668','Y669','Y670','Y672','Y226','Y227','Y229','Y230','Y235','Y236','Y237','Y263','Y293','Y294','Y295','Y296','Y297','Y298','Y299','Y304','Y305','Y306','Y307','Y308','Y309','Y313','Y314','Y315','Y370','Y371','Y374','Y375','Y379','Y380','Y383','Y393','Y395','Y396','Y400','Y401','Y403','Y404','Y420','Y424','Y428','Y430','Y431','Y432','Y433','Y434','Y435','Y436','Y439','Y440','Y441','Y446','Y447','Y448','Y449','Y480','Y481','Y482','Y483','Y486','Y491','Y493','B01','I78','V90','460','494','252','I01','V52','220','537','V95','218','877','V89','561','P02','535','B97','B99','I77','U82','211','213','505','584','557','C05','C08','I16','S99','V39','V78','V79','258','885','V69','V19','V40','B03','ICCA','ICDA','ICLA','ICPA','ICTA','ICVA','K97','S41','873','562','558','556','ICBA','ICXA','54P','B80','V24','A01','A03','429','410','426','B91','E56','348','E01','805','806','807','808','809','822','845','496','498','829','837','823','826','830','842','825','832','833','841','821','828','834','843','820','B53','625','836','844','B54','B57','V85','V97','J43','238','V54','V03','B92','B90','800','913','524L','526L','546L','554L','569L','580L','581L','675L','705L','793L','817L','875L','I29','771L','775L','529L','531L','535L','537L','539L','542L','543L','583L','823L','831L','837L','839L','547L','549L','553L','555L','559L','561L','567L','737L','853L','855L','923L','924L','927')
  AND CLASS = 'F'
  AND (`TYPE` IN ('453','453.3','453.34','453.344') OR (IFNULL(TYPE,'') = '')) 
 ORDER BY SACODE, TYPE, A_DATE