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);