SELECT
    *
FROM
    obpm2.tenant_organizations
WHERE
        supervise_depart_id IN (
                                'TLK_DMT2014',
                                'TLK_DMT132',
                                'TLK_DMT188',
                                'TLK_DMT121',
                                'TLK_DMT29',
                                'TLK_DMT205',
                                'TLK_DMT2019',
                                'TLK_DMT240',
                                'TLK_DMT160',
                                'TLK_DMT129',
                                'TLK_DMT223',
                                'TLK_DMT83',
                                'TLK_DMT303',
                                'TLK_DMT104',
                                'TLK_DMT277',
                                'TLK_DMT218',
                                'TLK_DMT363',
                                'TLK_DMT2030',
                                'TLK_DMT2004',
                                'TLK_DMT39',
                                'TLK_DMT210',
                                'TLK_DMT68',
                                'TLK_DMT319',
                                'TLK_DMT406',
                                'TLK_DMT382',
                                'TLK_DMT46',
                                'TLK_DMT280',
                                'TLK_DMT4',
                                'TLK_DMT35',
                                'TLK_DMT1000',
                                'TLK_DMT353',
                                'TLK_DMT1003',
                                'TLK_DMT171',
                                'TLK_DMT66',
                                'TLK_DMT288',
                                'TLK_DMT125',
                                'TLK_DMT146',
                                'TLK_DMT17',
                                'TLK_DMT295',
                                'TLK_DMT75',
                                'TLK_DMT389',
                                'TLK_DMT381',
                                'TLK_DMT48',
                                'TLK_DMT376',
                                'TLK_DMT2005',
                                'TLK_DMT349',
                                'TLK_DMT151',
                                'TLK_DMT306',
                                'TLK_DMT105',
                                'TLK_DMT238',
                                'TLK_DMT291',
                                'TLK_DMT141',
                                'TLK_DMT157',
                                'TLK_DMT183',
                                'TLK_DMT21',
                                'TLK_DMT114',
                                'TLK_DMT248',
                                'TLK_DMT296',
                                'TLK_DMT97',
                                'TLK_DMT72',
                                'TLK_DMT150',
                                'TLK_DMT230',
                                'TLK_DMT9',
                                'TLK_DMT52',
                                'TLK_DMT49',
                                'TLK_DMT242',
                                'TLK_DMT2015',
                                'TLK_DMT207',
                                'TLK_DMT87',
                                'TLK_DMT198',
                                'TLK_DMT79',
                                'TLK_DMT62',
                                'TLK_DMT47',
                                'TLK_DMT2003',
                                'TLK_DMT321',
                                'TLK_DMT387',
                                'TLK_DMT169',
                                'TLK_DMT206',
                                'TLK_DMT27',
                                'TLK_DMT395',
                                'TLK_DMT55',
                                'TLK_DMT20',
                                'TLK_DMT370',
                                'TLK_DMT56',
                                'TLK_DMT232',
                                'TLK_DMT167',
                                'TLK_DMT269',
                                'TLK_DMT284',
                                'TLK_DMT91',
                                'TLK_DMT352',
                                'TLK_DMT231',
                                'TLK_DMT107',
                                'TLK_DMT354',
                                'TLK_DMT111',
                                'TLK_DMT233',
                                'TLK_DMT336',
                                'TLK_DMT366',
                                'TLK_DMT59',
                                'TLK_DMT222',
                                'TLK_DMT356',
                                'TLK_DMT246',
                                'TLK_DMT339',
                                'TLK_DMT260',
                                'TLK_DMT50',
                                'TLK_DMT335',
                                'TLK_DMT7',
                                'TLK_DMT165',
                                'TLK_DMT122',
                                'TLK_DMT74',
                                'TLK_DMT126',
                                'TLK_DMT110',
                                'TLK_DMT142',
                                'TLK_DMT25',
                                'TLK_DMT172',
                                'TLK_DMT120',
                                'TLK_DMT235',
                                'TLK_DMT326',
                                'TLK_DMT41',
                                'TLK_DMT308',
                                'TLK_DMT250',
                                'TLK_DMT367',
                                'TLK_DMT1006',
                                'TLK_DMT201',
                                'TLK_DMT267',
                                'TLK_DMT45',
                                'TLK_DMT163',
                                'TLK_DMT2028',
                                'TLK_DMT119',
                                'TLK_DMT190',
                                'TLK_DMT313',
                                'TLK_DMT322',
                                'TLK_DMT404',
                                'TLK_DMT340',
                                'TLK_DMT197',
                                'TLK_DMT30',
                                'TLK_DMT69',
                                'TLK_DMT312',
                                'TLK_DMT374',
                                'TLK_DMT154',
                                'TLK_DMT410',
                                'TLK_DMT57',
                                'TLK_DMT264',
                                'TLK_DMT379',
                                'TLK_DMT34',
                                'TLK_DMT377',
                                'TLK_DMT138',
                                'TLK_DMT338',
                                'TLK_DMT61',
                                'TLK_DMT108',
                                'TLK_DMT261',
                                'TLK_DMT2008',
                                'TLK_DMT221',
                                'TLK_DMT334',
                                'TLK_DMT38',
                                'TLK_DMT228',
                                'TLK_DMT2021',
                                'fOO8zN0J',
                                'TLK_DMT2031',
                                'TLK_DMT220',
                                'TLK_DMT22',
                                'TLK_DMT2037',
                                'TLK_DMT327',
                                'TLK_DMT60',
                                'TLK_DMT178',
                                'TLK_DMT393',
                                'TLK_DMT37',
                                'TLK_DMT342',
                                'TLK_DMT195',
                                'TLK_DMT187',
                                'TLK_DMT281',
                                'TLK_DMT76',
                                'TLK_DMT211',
                                'TLK_DMT106',
                                'TLK_DMT286',
                                'TLK_DMT153',
                                'TLK_DMT331',
                                'TLK_DMT2013',
                                'TLK_DMT348',
                                'TLK_DMT147',
                                'TLK_DMT199',
                                'TLK_DMT2025',
                                'TLK_DMT182',
                                'TLK_DMT2024',
                                'TLK_DMT191',
                                'TLK_DMT92',
                                'TLK_DMT180',
                                'TLK_DMT320',
                                'TLK_DMT394',
                                'TLK_DMT309',
                                'TLK_DMT177',
                                'TLK_DMT31',
                                'TLK_DMT236',
                                'TLK_DMT408',
                                'TLK_DMT2029',
                                'TLK_DMT253',
                                'TLK_DMT196',
                                'TLK_DMT272',
                                'TLK_DMT332',
                                'TLK_DMT401',
                                'TLK_DMT161',
                                'TLK_DMT144',
                                'TLK_DMT400',
                                'TLK_DMT299',
                                'TLK_DMT383',
                                'TLK_DMT289',
                                'TLK_DMT123',
                                'TLK_DMT2007',
                                'TLK_DMT418',
                                'TLK_DMT251',
                                'TLK_DMT314',
                                'TLK_DMT219',
                                'TLK_DMT2001',
                                'TLK_DMT256',
                                'TLK_DMT184',
                                'TLK_DMT65',
                                'TLK_DMT315',
                                'TLK_DMT413',
                                'TLK_DMT371',
                                'TLK_DMT345',
                                'TLK_DMT15',
                                'TLK_DMT276',
                                'TLK_DMT302',
                                'TLK_DMT64',
                                'TLK_DMT265',
                                'TLK_DMT290',
                                'TLK_DMT2002',
                                'TLK_DMT2034',
                                'TLK_DMT155',
                                'TLK_DMT307',
                                'TLK_DMT203',
                                'TLK_DMT2009',
                                'TLK_DMT175',
                                'TLK_DMT249',
                                'TLK_DMT100',
                                'TLK_DMT271',
                                'TLK_DMT117',
                                'TLK_DMT73',
                                'TLK_DMT2027',
                                'TLK_DMT368',
                                'TLK_DMT32',
                                'TLK_DMT282',
                                'TLK_DMT70',
                                'TLK_DMT229',
                                'TLK_DMT247',
                                'TLK_DMT2033',
                                'TLK_DMT360',
                                'TLK_DMT225',
                                'TLK_DMT2032',
                                'TLK_DMT13',
                                'TLK_DMT244',
                                'TLK_DMT283',
                                'TLK_DMT412',
                                'TLK_DMT330',
                                'TLK_DMT58',
                                'TLK_DMT270',
                                'TLK_DMT403',
                                'TLK_DMT361',
                                'TLK_DMT325',
                                'TLK_DMT409',
                                'TLK_DMT2012',
                                'TLK_DMT113',
                                'TLK_DMT226',
                                'TLK_DMT2022',
                                'TLK_DMT337',
                                'TLK_DMT301',
                                'TLK_DMT234',
                                'TLK_DMT292',
                                'TLK_DMT118',
                                'TLK_DMT365',
                                'TLK_DMT139',
                                'TLK_DMT194',
                                'TLK_DMT136',
                                'TLK_DMT2039',
                                'TLK_DMT145',
                                'TLK_DMT357',
                                'TLK_DMT224',
                                'TLK_DMT2026',
                                'TLK_DMT134',
                                'TLK_DMT33',
                                'TLK_DMT179',
                                'TLK_DMT1005',
                                'TLK_DMT168',
                                'TLK_DMT166',
                                'TLK_DMT11',
                                'TLK_DMT341',
                                'TLK_DMT170',
                                'TLK_DMT347',
                                'TLK_DMT96',
                                'TLK_DMT407',
                                'TLK_DMT3',
                                'TLK_DMT358',
                                'TLK_DMT378',
                                'TLK_DMT89',
                                'TLK_DMT6',
                                'TLK_DMT323',
                                'TLK_DMT2023',
                                'TLK_DMT266',
                                'TLK_DMT173',
                                'TLK_DMT2006',
                                'TLK_DMT343',
                                'TLK_DMT2036',
                                'TLK_DMT149',
                                'TLK_DMT135',
                                'TLK_DMT216',
                                'TLK_DMT159',
                                'TLK_DMT103',
                                'TLK_DMT362',
                                'TLK_DMT373',
                                'TLK_DMT28',
                                'TLK_DMT351',
                                'TLK_DMT355',
                                'TLK_DMT202',
                                'TLK_DMT262',
                                'TLK_DMT71',
                                'TLK_DMT2011',
                                'TLK_DMT293',
                                'TLK_DMT127',
                                'TLK_DMT26',
                                'TLK_DMT375',
                                'TLK_DMT174',
                                'TLK_DMT392',
                                'TLK_DMT317',
                                'TLK_DMT12',
                                'TLK_DMT2040',
                                'TLK_DMT67',
                                'TLK_DMT88',
                                'TLK_DMT333',
                                'TLK_DMT252',
                                'TLK_DMT1',
                                'TLK_DMT137',
                                'TLK_DMT328',
                                'TLK_DMT176',
                                'TLK_DMT158',
                                'TLK_DMT109',
                                'TLK_DMT51',
                                'TLK_DMT98',
                                'TLK_DMT405',
                                'TLK_DMT99',
                                'TLK_DMT364',
                                'TLK_DMT329',
                                'TLK_DMT43',
                                'TLK_DMT1001',
                                'TLK_DMT2017',
                                'TLK_DMT350',
                                'TLK_DMT318',
                                'TLK_DMT36',
                                'TLK_DMT274',
                                'TLK_DMT44',
                                'TLK_DMT2020',
                                'TLK_DMT239',
                                'TLK_DMT304',
                                'TLK_DMT279',
                                'TLK_DMT193',
                                'TLK_DMT90',
                                'TLK_DMT300',
                                'TLK_DMT2016',
                                'TLK_DMT245',
                                'TLK_DMT54',
                                'TLK_DMT86',
                                'TLK_DMT385',
                                'TLK_DMT416',
                                'TLK_DMT63',
                                'TLK_DMT14',
                                'TLK_DMT344',
                                'TLK_DMT324',
                                'TLK_DMT380',
                                'TLK_DMT241',
                                'TLK_DMT310',
                                'TLK_DMT162',
                                'TLK_DMT152',
                                'TLK_DMT2038',
                                'TLK_DMT386',
                                'TLK_DMT399',
                                'TLK_DMT40',
                                'TLK_DMT346',
                                'TLK_DMT255',
                                'TLK_DMT148',
                                'TLK_DMT42',
                                'TLK_DMT217',
                                'TLK_DMT213',
                                'TLK_DMT396',
                                'TLK_DMT268',
                                'TLK_DMT102',
                                'TLK_DMT115',
                                'TLK_DMT2000',
                                'TLK_DMT391',
                                'TLK_DMT316',
                                'TLK_DMT93',
                                'TLK_DMT398',
                                'TLK_DMT131',
                                'TLK_DMT417',
                                'TLK_DMT140',
                                'TLK_DMT415',
                                'TLK_DMT1004',
                                'TLK_DMT23',
                                'TLK_DMT185',
                                'TLK_DMT208',
                                'TLK_DMT397',
                                'TLK_DMT81',
                                'TLK_DMT369',
                                'TLK_DMT294',
                                'TLK_DMT53',
                                'TLK_DMT164',
                                'TLK_DMT186',
                                'TLK_DMT143',
                                'TLK_DMT18',
                                'TLK_DMT359',
                                'TLK_DMT116',
                                'TLK_DMT287',
                                'TLK_DMT124',
                                'TLK_DMT156',
                                'TLK_DMT2018',
                                'TLK_DMT85',
                                'TLK_DMT128',
                                'TLK_DMT209',
                                'TLK_DMT112',
                                'TLK_DMT263',
                                'TLK_DMT200',
                                'TLK_DMT215',
                                'TLK_DMT275',
                                'TLK_DMT285',
                                'TLK_DMT24',
                                'TLK_DMT212',
                                'TLK_DMT192',
                                'TLK_DMT204',
                                'TLK_DMT189',
                                'TLK_DMT2010',
                                'TLK_DMT237',
                                'TLK_DMT258',
                                'TLK_DMT411',
                                'TLK_DMT82',
                                'TLK_DMT257',
                                'TLK_DMT298',
                                'TLK_DMT95',
                                'TLK_DMT2035',
                                'TLK_DMT10',
                                'TLK_DMT278',
                                'TLK_DMT80',
                                'TLK_DMT94',
                                'TLK_DMT133',
                                'TLK_DMT77',
                                'TLK_DMT16',
                                'TLK_DMT402',
                                'TLK_DMT243',
                                'TLK_DMT5',
                                'TLK_DMT388',
                                'TLK_DMT227',
                                'TLK_DMT305',
                                'TLK_DMT273',
                                'TLK_DMT384',
                                'TLK_DMT254',
                                'TLK_DMT372',
                                'TLK_DMT181',
                                'TLK_DMT1007',
                                'TLK_DMT259',
                                'TLK_DMT130',
                                'TLK_DMT297',
                                'TLK_DMT311',
                                'TLK_DMT414',
                                'qGOwUzBg',
                                'TLK_DMT8',
                                'TLK_DMT214',
                                'TLK_DMT84'
        )
  and `status` not in (2,3,4) and approved_information_status=1 and institutional_code not in ('0107','0108','0109')
  and id not in (select id from dispatch.rd_company_summary);