SELECT DISTINCT SACODE, TYPE, A_DATE, A_DESC 
 FROM alltext_sa_codes2_v 
 WHERE 
  LANG = 'I'
  AND SACODE IN ('RG8','X13','X19','XG4','XG6','XL7','XL8','Z12','ZG1','ZG2','ZG3','ZG4','Z11','A50','RH2','XB6','ZM1','MD4','RH3','ZS8','XB3','XG9','ZU7','ZU8','XR7','RY2','X44','FI3','ZJ7','O42','W02','ZU9','MA6','MB6','MP6','X01','XC6','ZL3','W94','W93','524L','528L','810L','812L','MA4','MA5','MF7','MP5','X95','ZW1','MG1','MG2','MG3','MG4','MR2','WV1','XR2','XU2','X43','X52','XR4','XT2','X42','X62','X63','X49','X54','X58','X60','XR0','XR1','XR3','XR5','XR6','XS3','XS4','XS5','XS8','XS9','XU1','XU3','XU5','XU6','XU8','XU9','X47','X48','X50','X45','X46','XS1','XU4','MC9','XR8','X53','MG5','MH1','MH3','MH5','MH7','MH8','MP0','Z07','XS7','641L','MS9','XO1','879L','MC4','X86','XT1','775L','H11','H12','HZ5','HZ9','Z18','R87','RH9','ZU4','HH9','G42','HH7','H08','D50','D51','D53','D64','HH5','XM0','MI1','MI2','MS0','HX1','Y44','Y10','Q10','Q20','Q22','Q50','513L','531L','533L','537L','539L','543L','544L','547L','551L','553L','557L','559L','571L','576L','577L','580L','583L','625L','F50','IL1','515L','517L','523L','525L','527L','529L','535L','541L','542L','546L','516L','520L','526L','549L','550L','554L','555L','558L','561L','567L','569L','581L','821L','819L','675L','771L','813L','815L','822L','833L','843L','847L','853L','882L','BE2','808L','820L','MC6','MF4','MZ2','MI6','MR3','MR4','E28','E32','795L','XC8','XB4','XA4','XL4','Z30','9147','5373','5376','5389','5957','E30','MV3','G40','XY9','W33','XY8','ZX8','ZX9','XY7','XY0','KP2','RL5','RL7','R60','MD5','MD3','MK2','XY1','XY2','XY3','Z37','ZP2','1212','2603','9723','9744','9040','9197','3626','5345','5360','ZU1','Y16','ZH5','UL1','UM1','XS2','T57','T58','HK4','D03','MS3','FX0','T82','V36','S20','SH7','Y43','ED4','IM0','ZO1','ZO2','ZO3','MY9','XY4','XY5','XY6','V42','VC4','IL4','XC9','Z41')
  AND CLASS = 'T'
  AND (`TYPE` IN ('906','906.7','906.73','906.731') OR (IFNULL(TYPE,'') = '')) 
 ORDER BY SACODE, TYPE, A_DATE