SELECT T.REGISTRO, T.DTCTRLREFSAL FROM TRABALHADOR T
WHERE T.EMPRESA = '001'
AND T.REGISTRO IN ('009467',
'009517',
'004044',
'003052',
'003713',
'003183',
'009191',
'007921',
'009444',
'009470',
'007534',
'002901',
'002837',
'002817',
'003038',
'007790',
'009510',
'007956',
'007643',
'009459',
'003040',
'004103',
'009297',
'009162',
'006330',
'007785',
'007817',
'009541',
'006419',
'006378',
'009526',
'006407',
'007599',
'002968',
'003979',
'003012',
'007936',
'002985',
'006215',
'003990',
'001758',
'002722',
'008011',
'002856',
'009493',
'007928',
'007764',
'009423',
'009420',
'008623',
'002962',
'004019',
'009496',
'009447',
'007855',
'007907',
'007897',
'005043',
'004112',
'002804',
'002854',
'004252',
'007849',
'007297',
'003973',
'007589',
'007993',
'003096',
'007836',
'009547',
'002865',
'002823',
'005032',
'006450',
'009150',
'008027',
'007789',
'009283',
'002902',
'007666',
'009249',
'009427',
'001686',
'002992',
'009226',
'003133',
'002921',
'006424',
'004915',
'003951',
'004969',
'009532',
'003893',
'006466',
'006336',
'003887',
'007999',
'009418',
'009240',
'007759',
'009469',
'007824',
'009425',
'007762',
'004022',
'009539',
'006455',
'003909',
'007944',
'008024',
'004078',
'008009',
'003957',
'003105',
'010267',
'003036',
'009546',
'009072',
'009252',
'007833',
'009512',
'004960',
'007933',
'007779',
'006456',
'009408',
'007846',
'009468',
'004115',
'006451',
'004093',
'003952',
'009250',
'008982',
'007791',
'007379',
'007793',
'007579',
'009534',
'009274',
'009454',
'004024',
'002824',
'002989',
'007841',
'005020',
'002827',
'001661',
'009227',
'007516',
'003943',
'007622',
'009316',
'007637',
'003919',
'004092',
'007591',
'009463',
'009307',
'009260',
'003079',
'004020',
'003031',
'006444',
'003965',
'003918',
'006449',
'001731',
'004021',
'007770',
'003961',
'006468',
'001761',
'009450',
'009247',
'004105',
'007857',
'008005',
'009491',
'009375',
'009503',
'002976',
'001728',
'002838',
'007904',
'009531',
'009257',
'007555',
'003103',
'003123',
'007842',
'007988',
'008073',
'007745',
'005173',
'007782',
'007829',
'009516',
'009488',
'004038',
'002872',
'004027',
'005036',
'004036',
'004091',
'007975',
'007903',
'003139',
'002931',
'004883',
'007754',
'007940',
'009255',
'002867',
'007763',
'004015',
'001662',
'008012',
'007816',
'002814',
'009456',
'006298',
'004025',
'009458',
'007987',
'008002',
'007968',
'002841',
'002978',
'007995',
'003891',
'004032',
'007780',
'004072',
'007959',
'003914',
'007756',
'004068',
'003101',
'002832',
'007777',
'005170',
'004975',
'009407',
'001710',
'009239',
'007946',
'001720',
'009482',
'002904',
'007766',
'002810',
'006415',
'008067',
'004076',
'007879',
'004013',
'007584',
'004037',
'003168',
'001633',
'007781',
'007881',
'007893',
'009472',
'004901',
'006411',
'007768',
'004065',
'004095',
'004099',
'007860',
'002602',
'001628',
'003639',
'003059',
'005024',
'003885',
'004108',
'006432',
'004660',
'007760',
'009233',
'008096',
'009476',
'009310',
'002946',
'003936',
'003671',
'004804',
'009254',
'007935',
'008003',
'002556',
'009278',
'008010',
'009474',
'003136',
'007954',
'007815',
'002826',
'002965',
'003913',
'007957',
'006435',
'009550',
'007559',
'007802',
'009414',
'003894',
'004808',
'004096',
'009405',
'008015',
'003131',
'009306',
'007911',
'009428',
'007761',
'006399',
'009422',
'004963',
'004087',
'007594',
'003889',
'003199',
'003934',
'002879',
'009277',
'007843',
'007769',
'007776',
'007686',
'001614',
'006453',
'009314',
'004957',
'003381',
'003742',
'003899',
'009507',
'006365',
'008014',
'009308',
'004070',
'009276',
'009462',
'007616',
'009537',
'007617',
'009501',
'003912',
'007823',
'003225',
'009485',
'009380',
'002461',
'005049',
'009256',
'005030',
'006433',
'007792',
'007845',
'007861',
'002752',
'002936',
'001743',
'009246',
'009479',
'009286',
'009234',
'003089',
'002920',
'007787',
'007580',
'009538',
'007834',
'004110',
'003940',
'007774')
AND T.CONTRATO = 1
--AND extract(year from T.DTCTRLREFSAL) < '2020'
ORDER BY
T.NOME