SELECT DISTINCT SACODE, TYPE, A_DATE, A_DESC 
 FROM alltext_sa_codes2_v 
 WHERE 
  LANG = 'G'
  AND SACODE IN ('P59','167','950','P27','105A','115A','205A','201A','204A','211A','257A','258A','259A','611A','658A','159A','651A','671A','463','294','460','498','835','580','059','809','581','579','PAC','494','2XXL','542L','550L','552L','554L','557L','558L','571L','U10','537L','539L','541L','605L','606L','611L','613L','627L','629L','633L','643L','649L','650L','651L','661L','662L','663L','669L','675L','679L','705L','720L','721L','722L','724L','749L','751L','753L','754L','757L','768L','781L','791L','803L','811L','813L','815L','817L','821L','822L','825L','837L','845L','851L','853L','857L','863L','865L','867L','868L','869L','875L','879L','882L','901L','915L','919L','926L','927L','531L','547L','603L','604L','607L','614L','616L','622L','623L','631L','632L','634L','637L','638L','641L','644L','653L','654L','667L','681L','682L','683L','685L','686L','687L','729L','923L','924L','577L','619L','723L','725L','727L','733L','735L','737L','739L','741L','747L','771L','773L','777L','779L','785L','787L','789L','793L','795L','561L','609L','615L','617L','620L','647L','775L','511L','543L','513L','553L','517L','555L','529L','569L','576L','580L','559L','583L','515L','546L','567L','535L','581L','512L','516L','520L','521L','524L','526L','528L','810L','812L','814L','816L','818L','523L','525L','527L','549L','601L','635L','673L','805L','807L','808L','820L','833L','841L','843L','849L','861L','873L','877L','878L','880L','835L','839L','819L','823L','824L','847L','848L','831L','855L','701L')
  AND CLASS = 'P'
  AND (`TYPE` IN ('177','177.0','177.08','177.087') OR (IFNULL(TYPE,'') = '')) 
 ORDER BY SACODE, TYPE, A_DATE