-- ============================================
-- Import Contracts from SQL Dump
-- ============================================
-- 
-- Steps:
-- 1. Run this file step by step
-- 2. In Step 2, replace the example with your actual REPLACE INTO statements
--    (change 'REPLACE INTO `tbl_contract`' to 'INSERT IGNORE INTO tmp_tbl_contract')
--
-- ============================================

-- Step 1: Create temporary table for old structure
CREATE TEMPORARY TABLE IF NOT EXISTS `tmp_tbl_contract` (
  `Id` int(10) NOT NULL PRIMARY KEY,
  `Name` varchar(50) DEFAULT NULL,
  `GroupPrefix` varchar(50) DEFAULT NULL,
  `account_type` int(10) DEFAULT 0,
  `country_id` int(10) DEFAULT 0,
  `embassy_id` int(10) DEFAULT 0,
  `address_city` varchar(30) DEFAULT NULL,
  `UO_Code` int(10) DEFAULT 0,
  `UO_Name` varchar(100) DEFAULT NULL,
  `UO_Makkah_Phone` varchar(25) DEFAULT NULL,
  `UO_Madinah_Phone` varchar(25) DEFAULT NULL,
  `UO_Jeddah_Phone` varchar(25) DEFAULT NULL,
  `UASP` int(10) DEFAULT 1,
  `validatemrz` tinyint(3) DEFAULT 0,
  `enjaz_account` tinyint(3) DEFAULT 0,
  `ExportType` tinyint(3) DEFAULT 1,
  `MOFAUser` varchar(50) DEFAULT NULL,
  `MOFAPassword` varchar(50) DEFAULT NULL,
  `TourismUser` varchar(10) DEFAULT NULL,
  `TourismPassword` varchar(50) DEFAULT NULL,
  `tasheel_email` varchar(150) DEFAULT NULL,
  `tasheel_phone` varchar(25) DEFAULT NULL,
  `res_phone_country` int(11) DEFAULT 0,
  `username` varchar(50) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  `UASP_WS_UserName` varchar(50) DEFAULT NULL,
  `UASP_WS_Password` varchar(50) DEFAULT NULL,
  `AgentId` int(10) DEFAULT NULL,
  `AgentCode` varchar(25) DEFAULT NULL,
  `AgentName` varchar(250) DEFAULT NULL,
  `AgentNameLA` varchar(250) DEFAULT NULL,
  `LogoPath` varchar(250) DEFAULT NULL,
  `EA_PersonInCharge` varchar(100) DEFAULT NULL,
  `Wallet` varchar(25) DEFAULT NULL,
  `PaymentPassword` varchar(50) DEFAULT NULL,
  `LocalId` int(10) DEFAULT NULL,
  `LocalAddress` varchar(250) DEFAULT NULL,
  `LocalPhone` varchar(25) DEFAULT NULL,
  `SaudiAddress` varchar(250) DEFAULT NULL,
  `SaudiPhone` varchar(25) DEFAULT NULL,
  `SMTPServer` varchar(100) DEFAULT NULL,
  `SMTPSenderName` varchar(100) DEFAULT NULL,
  `SMTPSenderAddress` varchar(100) DEFAULT NULL,
  `SMTPReplyTo` varchar(100) DEFAULT NULL,
  `SMTPUsername` varchar(100) DEFAULT NULL,
  `SMTPPassword` varchar(100) DEFAULT NULL,
  `SMTPPort` int(10) DEFAULT NULL,
  `TemplatePath` varchar(250) DEFAULT NULL,
  `OnlineVisaEmail` varchar(100) DEFAULT NULL,
  `OnlineVisaPhone` varchar(100) DEFAULT NULL,
  `OnlineVisaMobile` varchar(100) DEFAULT NULL,
  `OnlineVisaPoBox` varchar(100) DEFAULT NULL,
  `OnlineVisaZipCode` varchar(100) DEFAULT NULL,
  `OnlineVisaCountry` int(10) DEFAULT NULL,
  `contract_visainfo_id` int(11) DEFAULT NULL,
  `use_virtual_numbers` int(11) DEFAULT NULL,
  `UASP_Token` varchar(100) DEFAULT NULL,
  `consular` varchar(100) DEFAULT NULL,
  `is_deleted` int(11) DEFAULT 0,
  `musaned_username` varchar(50) DEFAULT NULL,
  `musaned_password` varchar(50) DEFAULT NULL,
  `WS_Token` text DEFAULT NULL,
  `WS_TokenType` varchar(50) DEFAULT NULL,
  `workonly` int(11) DEFAULT 0,
  `connection` varchar(100) DEFAULT NULL,
  `accountno` varchar(25) DEFAULT NULL,
  `is_virtual` int(11) DEFAULT NULL,
  `is_active` int(11) DEFAULT NULL,
  `agent_id` int(11) DEFAULT NULL,
  `multipleuo` bit(1) DEFAULT NULL,
  `nusuk_entity_id` int(11) DEFAULT NULL,
  `nusuk_contract_id` int(11) DEFAULT NULL,
  `nusuk_active_entity_type_id` int(11) DEFAULT NULL,
  `nusuk_active_entity_id` int(11) DEFAULT NULL
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
-- Step 2: Insert your data from the SQL dump
-- Replace the example below with your actual REPLACE INTO statements
-- Change: REPLACE INTO `tbl_contract`  ->  INSERT IGNORE INTO tmp_tbl_contract
-- ============================================
-- PASTE YOUR DATA HERE
-- ============================================
-- Example format:
-- INSERT IGNORE INTO tmp_tbl_contract (Id, Name, GroupPrefix, account_type, country_id, embassy_id, address_city, username, tasheel_email, tasheel_phone, res_phone_country, OnlineVisaPhone, connection, is_active, is_deleted) VALUES
-- (1, 'عقد العمرة', '', 1, 20, 302, 'القاهرة', '', '', '', 0, '', '', 1, 1),
-- (2, 'عقد حج', '', 2, 964, 213, '', '', '', '', 0, '', '', 1, 1);
-- ... (paste all your data here)


-- Dumping data for table virgooffline1447.tbl_contract: ~186 rows (approximately)
INSERT IGNORE INTO `tmp_tbl_contract` (`Id`, `Name`, `GroupPrefix`, `account_type`, `country_id`, `embassy_id`, `address_city`, `UO_Code`, `UO_Name`, `UO_Makkah_Phone`, `UO_Madinah_Phone`, `UO_Jeddah_Phone`, `UASP`, `validatemrz`, `enjaz_account`, `ExportType`, `MOFAUser`, `MOFAPassword`, `TourismUser`, `TourismPassword`, `tasheel_email`, `tasheel_phone`, `res_phone_country`, `username`, `password`, `UASP_WS_UserName`, `UASP_WS_Password`, `AgentId`, `AgentCode`, `AgentName`, `AgentNameLA`, `LogoPath`, `EA_PersonInCharge`, `Wallet`, `PaymentPassword`, `LocalId`, `LocalAddress`, `LocalPhone`, `SaudiAddress`, `SaudiPhone`, `SMTPServer`, `SMTPSenderName`, `SMTPSenderAddress`, `SMTPReplyTo`, `SMTPUsername`, `SMTPPassword`, `SMTPPort`, `TemplatePath`, `OnlineVisaEmail`, `OnlineVisaPhone`, `OnlineVisaMobile`, `OnlineVisaPoBox`, `OnlineVisaZipCode`, `OnlineVisaCountry`, `contract_visainfo_id`, `use_virtual_numbers`, `UASP_Token`, `consular`, `is_deleted`, `musaned_username`, `musaned_password`, `WS_Token`, `WS_TokenType`, `workonly`, `connection`, `accountno`, `is_virtual`, `is_active`, `agent_id`, `multipleuo`, `nusuk_entity_id`, `nusuk_contract_id`, `nusuk_active_entity_type_id`, `nusuk_active_entity_id`) VALUES
	(1, 'عقد العمرة', '', 1, 20, 302, 'القاهرة', 0, '', '', '', '', 6, 0, 0, 0, '', '', '', '', '', '', 0, '', '', '', '', 0, '0', 'عقد افتراضي', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', 25, '', '', '', '', '', '', 20, 1, 0, '', '', 1, '', '', '', '', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(2, 'عقد حج', '', 2, 964, 213, '', 0, '', '', '', '', 6, 0, 0, 0, '', '', '', '', '', '', 0, '', '', '', '', 0, '', '', '', '', '', '', '', 0, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', '', NULL, NULL, 0, '', '', 1, '', '', '', '', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(3, 'Tashel Contract Oman Rakb', 'Tashel', 1, 968, 215, 'عمان', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'tasheel@virgo-sy.com', '91446234', 968, 'tasheel@virgo-sy.com', 'Virgo@123456', '', '', 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 2, 0, '', '', 0, '', '', '', '', 0, '120363042539673256@g.us', '', 0, 1, 2, b'1', 714575, 218693, 52, 714575),
	(4, 'Adam USA Contract USA Rakb', 'ADAM', 1, 1, 507, 'NEW YORK', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'AMRO.ELBAZ@ADAMTRAVEL.NET', '5712347283', 1, 'AMRO.ELBAZ@ADAMTRAVEL.NET', 'Amro1983$$$$', '', '', 0, '0', '', '', '', 'Amro1983$$$$', '0', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 3, 0, '', '', 0, '', '', '', '', 0, '963966624766-1547152038@g.us', '', 0, 1, 3, NULL, 714561, 218679, 52, 714561),
	(5, 'Qwafil BAKR IRQ', '', 1, 964, 203, 'BAGHDAD', 0, 'مؤسسة بكر سالم باسنبل لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'qawafilirq@virgo-sy.com', '7704507825', 964, 'qwafil1994@gmail.com', 'Qq1241994@@@', '', '', 0, '0', '', '', '', 'Qq1241994@@@\n', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 4, 0, '', '', 0, '', '', '', '', 0, '120363374741558188@g.us', '', 1, 1, 4, NULL, NULL, NULL, NULL, NULL),
	(6, 'Rakb Senegal', 'RAKB', 1, 221, 312, 'DAKAR', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'rakb@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', 'Virgo@123456', '', '', 0, '0', '', '', '', ' Virgo@123456 rakb@virgo-sy.com //   visa@virgo-sy.com  Virgo@123456', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 5, 0, '', '', 0, '', '', '', '', 0, '120363042105049378@g.us', '', 1, 1, 5, b'0', NULL, NULL, NULL, NULL),
	(7, 'Manazel Morocco Manazel', 'MANAZEL', 1, 212, 305, 'RABAT', 0, 'شركة منازل التوحيد لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'manazel@virgo-sy.com', '563600945', 966, 'manazel@virgo-sy.com', 'Virgo@123456', '', '', 0, '0', '', '', '', 'Virgo@123456', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 6, 0, '', '', 0, '', '', '', '', 0, '120363141828621015@g.us', '', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL),
	(8, 'Rakb Contract Tourism', 'RAKB', 4, 386, 401, 'SLOVENIA', 0, '', '', '', '', 6, 0, 1, 0, 'rakb@virgo-sy.com', 'Rakb123@', '', '', 'rakb@virgo-sy.com', '693334356', 355, '', '', '', '', 0, '0', '', '', '', 'Rakb123@', '', '', 0, 'SLOVENIA', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 7, 0, '', '', 0, '', '', '', '', 0, '120363042105049378@g.us', '', 0, 1, NULL, NULL, NULL, NULL, NULL, NULL),
	(9, 'Sky Direct Contract MOFA Enjaz', '', 3, 44, 401, 'LONDON', 0, '', '', '', '', 6, 0, 0, 0, 'skydirect@virgo-sy.com', 'Sky@#$123', '', '', 'skydirect@virgo-sy.com', '7860279542', 44, '', '', '', '', 0, '0', '', '', '', 'Sky@#$1234', 'skydirect@virgo-sy.com', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 8, 0, '', '', 0, '', '', '', '', 0, '201030034119-1578928308@g.us', '', 0, 1, NULL, NULL, NULL, NULL, NULL, NULL),
	(10, 'LOUVER MARAHEB CONTRACT JORDAN', 'MARAHEB', 1, 962, 206, 'AMMAN', 0, '', '', '', '', 6, 0, 1, 0, '', '', '', '', 'maraheb@virgo-sy.com', '777726422', 962, 'maraheb@virgo-sy.com', 'Virgo@123456', '', '', 0, '0', '', '', '', 'Virgo@123456', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 9, 0, '', '', 0, '', '', '', '', 0, '120363162521918560@g.us', '', 0, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(11, 'LOUVER MARAHEB CONTRACT PALESTINE', 'MARAHEB ', 1, 970, NULL, 'AMMAN', 0, '', '', '', '', 6, 0, 1, 0, '', '', '', '', 'maraheb@virgo-sy.com', '777726422', 962, 'maraheb@virgo-sy.com', 'Virgo@123456', '', '', 0, '0', '', '', '', 'Virgo@123456', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 10, 0, '', '', 0, '', '', '', '', 0, '120363162521918560@g.us', '', 0, 1, NULL, NULL, NULL, NULL, NULL, NULL),
	(12, 'Vataksi Albania Rakb', 'VATAKSI', 1, 355, 415, 'TIRANA', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'vataksi@virgo-sy.com', '693334356', 355, 'vataksi@yahoo.com', 'Ajeti321#@!Ajeti', '', '', 0, '0', 'Vataksi Travel', '', '', 'Ajeti321#@!Ajeti', '', '', 0, 'Tirana', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 11, 0, '', '', 0, '', '', '', '', 0, '120363029114809528@g.us', '', 0, 1, NULL, NULL, NULL, NULL, NULL, NULL),
	(13, 'Virgo B2B UK Bakr', '', 1, 44, 401, 'London', 0, '', '', '', '', 6, 0, 1, 0, '', '', '', '', 'visabakr@virgo-sy.com', '1012121146', 20, 'visabakr@virgo-sy.com', 'Aa@123456789', '', '', 0, '0', '', '', '', 'Aa@123456789', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 12, 0, '', '', 0, '', '', '', '', 0, '120363091110793140@g.us', '', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL),
	(14, 'Al Masara B2B Iraq', '', 1, 964, 203, 'IRAQ', 0, 'شركة السنبلة الراقية لخدمات المعتمرين شخص واحد', '', '', '', 6, 0, 1, 0, '', '', '', '', 'almasara@virgo-sy.com', '7727764163', 964, 'bbaa25108@gmail.com', 'Aa@9876543210', '', '', 0, '0', '', '', '', 'Aa@9876543210\n Alsyedd2002$', '0', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 13, 0, '', '', 0, '', '', '', '', 0, '120363400080531892@g.us', '', 0, 1, NULL, NULL, NULL, NULL, NULL, NULL),
	(15, 'Beoot Al Shaam Teema seek Syria', 'Beoot', 1, 963, 207, 'DAMASCUS', 0, 'شركة الهباش للسياحة وخدمات المعتمرين المحدودة', '', '', '', 6, 0, 1, 0, '', '', '', '', 'biyoutalsham@virgo-sy.com', '534399977', 966, 'Tr1326q@gmail.com', 'Aa@1122334455', '', '', 17, '0', 'الهباش', '', '', 'Bbb123456789#', '120363369162214797@g.us', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 16, 0, '', '', 0, '', '', '', '', 0, '120363419114415993@g.us', '', 0, 1, 17, b'1', 726526, 220208, 52, 726526),
	(16, 'Virgo B2B Mongolia Rakb', 'VIRGO', 1, 976, 234, 'ULAANBAATAR', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'visa@virgo-sy.com', '1012121146', 20, 'visa@virgo-sy.com', 'Virgo@123456', '', '', 0, '0', '', '', '', 'Virgo@123456', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 17, 0, '', '', 0, '', '', '', '', 0, '120363027684796283@g.us', '', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL),
	(17, 'LOUVER AL AHEBA CONTRACT SYRIA', 'LOUVER', 1, 963, 207, 'DAMASCUS', 0, 'شركة مجموعة قافلة التوحيد الدولية لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'alahebasy@gmail.com', '777726422', 962, 'maraheb@virgo-sy.com', 'Moh@Mohhaff1234', '', '', 0, '0', '', '', '', 'Moh@Mohhaff1234 alahebasy@gmail.com', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 18, 0, '', '', 0, '', '', '', '', 0, '120363196015849155@g.us', '', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL),
	(18, 'Rawdat Al Molaby B2B Syria', '', 1, 963, 207, 'DAMASCUS', 0, 'مؤسسة بكر سالم باسنبل لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'rawdatalmolaby@virgo-sy.com', '932678219', 963, 'rawdatalmolabygroup@gmail.com', 'Aa@9876543210', '', '', 0, '0', '', '', '', 'Ba@123456789', '0', '', 0, 'مؤسسة بكر سالم باسنبل لخدمات المعتمرين', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 19, 0, '', '', 0, '', '', '', '', 0, '120363417841732299@g.us', '', 1, 1, NULL, b'1', NULL, NULL, NULL, NULL),
	(19, 'Beoot Al Shaam ASALAH Mahatat SYR', 'Beoot', 1, 963, 207, 'DAMASCUS', 0, 'شركة محطات العالم لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'biyoutalsham@virgo-sy.com', '534399977', 966, 'Tr1326q@gmail.com', 'Aa123456789#', '', '', 17, '0', '', '', '', 'BBb123456789#', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 20, 0, '', '', 0, '', '', '', '', 0, '120363419114415993@g.us', '', 1, 1, 17, b'0', 749792, 220784, 58, 749792),
	(20, 'Manazel B2B Netherlands Manazel', 'MANAZEL', 1, 31, 402, 'THE HAGUE', 0, 'شركة منازل التوحيد لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'manazel@virgo-sy.com', '563600945', 966, 'manazel@virgo-sy.com', 'Virgo@123456', '', '', 0, '0', '', '', '', 'Virgo@123456', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 21, 0, '', '', 0, '', '', '', '', 0, '120363141828621015@g.us', '', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL),
	(21, 'Manazel B2B Finland Manazel', '', 1, 358, 426, 'HELSINKI', 0, '', '', '', '', 6, 0, 1, 0, '', '', '', '', 'manazel@virgo-sy.com', '563600945', 966, 'manazel@virgo-sy.com', 'Virgo@123456', '', '', 0, '0', '', '', '', 'Virgo@123456', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 22, 0, '', '', 0, '', '', '', '', 0, '120363141828621015@g.us', '', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL),
	(22, 'ABRAG ALMADINA ARD EL GINAN \\ MAAD', 'ABRAG', 1, 964, 203, 'BAGHDAD', 0, 'شركة السنبلة الراقية لخدمات المعتمرين شخص واحد', '', '', '', 6, 0, 1, 0, '', '', '', '', 'ABRAG@virgo-sy.com', '7718444857', 964, '93marwa95@gmail.com', 'O1o2o3o4o5o6@', '', '', 0, '0', '', '', '', 'O1o2o3o4o5o6@                  / Aa@123456789', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 23, 0, '', '', 0, '', '', '', '', 0, '120363404082913465@g.us', '', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL),
	(23, 'Amanos Awtad SYR', 'AMANOUS', 1, 963, 207, 'DAMASCUS', 0, 'شركة اوتاد مكة لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'amanos@virgo-sy.com', '944213839', 963, 'shadi.amanous@gmail.com', 'Shadi@544633', '', '', 0, '0', '', '', '', 'Shadi@544633 amanous.sy6031@gmail.com shadi.amanous@gmail.com', '', '', 0, 'DAMASCUS', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 24, 0, '', '', 0, '', '', '', '', 0, '120363160226936106@g.us', '', 1, 1, 40, NULL, 727788, 220298, 52, 727788),
	(24, 'Mahattat Al Aalam TURKMENISTAN', 'MAHATTAT', 1, 993, 226, 'ASHGABAT', 0, 'شركة محطات العالم لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'mahtat@virgo-sy.com', '560060160', 966, 'hakzamzam2@gmail.com', 'Aa123456789#', '', '', 0, '0', '', '', '', 'Aa123456789#', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 25, 0, '', '', 0, '', '', '', '', 0, '120363027901438947@g.us', '', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL),
	(25, 'Hannoush B2B Syria Bakr', 'HANNOUSH', 1, 963, 207, 'DAMASCUS', 0, 'شركة درة المنورة لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'Bakr@virgo-sy.com', '500215680', 966, 'Bakr@virgo-sy.com', 'Aa@987654321', '', '', 0, '0', '', '', '', 'Aa@987654321', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 26, 0, '', '', 0, '', '', '', '', 0, '120363417576294925@g.us', '', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL),
	(26, 'Virgo UK Rakb', 'VIRGO', 1, 44, 401, 'LONDON', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'visa@virgo-sy.com', '1012121146', 20, 'visa@virgo-sy.com', 'Virgo@123456', '', '', 0, '0', '', '', '', 'Virgo@123456', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 27, 0, '', '', 0, '', '', '', '', 0, '120363027684796283@g.us', '', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL),
	(27, 'Virgo B2B Turkmenistan Rakb', 'ATLAS', 1, 993, 226, 'ASHGABAT', 0, '', '', '', '', 6, 0, 1, 0, '', '', '', '', 'visa@virgo-sy.com', '1012121146', 20, 'visa@virgo-sy.com', 'Virgo@123456', '', '', 0, '0', '', '', '', 'Virgo@123456', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 28, 0, '', '', 0, '', '', '', '', 0, '120363027684796283@g.us', '', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL),
	(28, 'Al Hashmy B2B Syria', 'LOUVER', 1, 963, 207, 'DAMASCUS', 0, '', '', '', '', 6, 0, 1, 0, '', '', '', '', 'alhashmi@virgo-sy.com', '777726422', 962, 'maraheb@virgo-sy.com', 'Virgo@123456', '', '', 0, '0', '', '', '', 'Ola0119927@h ola.              alhashimitravel@gmail.com    Virgo@123456', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 29, 0, '', '', 0, '', '', '', '', 0, '120363197640456615@g.us', '', 0, 1, NULL, NULL, NULL, NULL, NULL, NULL),
	(29, 'Rakb Indonesia', 'RAKB', 1, 62, 211, 'JAKARTA', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'rakb@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', 'Virgo@123456', '', '', 0, '0', '', '', '', 'Virgo@123456', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 30, 0, '', '', 0, '', '', '', '', 0, '120363042105049378@g.us', '', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL),
	(30, 'Rakb Italy', 'RAKB', 1, 39, 406, 'ROME', 0, 'شركة الركب المميز لخدمات المعتمرين', '', 'Virgo@123456', '', 6, 0, 1, 0, '', '', '', '', 'rakb@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', 'Virgo@123456', '', '', 0, '0', '', '', '', 'Virgo@123456', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 31, 0, '', '', 0, '', '', '', '', 0, '120363042105049378@g.us', '', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL),
	(31, 'Nagma Alsahel Contract Iraq', '', 1, 964, 203, 'Baghdad', 0, '', '', '', '', 6, 0, 1, 0, '', '', '', '', 'Negma@virgo-sy.com', '7800000972', 964, 'muhannaddyaa@gmail.com', 'Hussein$1999', '', '', 0, '0', '', '', '', 'Hussein$1999', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 32, 0, '', '', 0, '', '', '', '', 0, '120363402052121911@g.us', '', 0, 1, NULL, NULL, NULL, NULL, NULL, NULL),
	(32, 'Beoot Al Shaam SUNY ZOWAR SYR', 'Beoot', 1, 963, 207, 'DAMASCUS', 0, 'شركة منازل الزوار لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'biyoutalsham@virgo-sy.com', '534399977', 966, 'Tr1326q@gmail.com', 'Azowar1494@2025', '', '', 17, '0', '', 'azowar02@gmail.com Azowar1494@2025', '', 'Bbb123456789#', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 33, 0, '', '', 0, '', '', '', '', 0, '120363419114415993@g.us', '', 1, 1, 17, b'1', 751091, 220874, 52, 751091),
	(33, 'AL SHAHD B2B SUDAN', 'SHAHD', 1, 249, 307, 'AL KHARTOM', 0, 'شركة مزايا لخدمات العمرة المحدودة', '', '', '', 6, 0, 1, 0, '', '', '', '', 'alshahd@virgo-sy.com', '912133388', 249, 'soon.a0.0.7@gmail.com', 'Saif@20252025', '', '', 0, '0', '', '', '', 'Saif@20252025', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 34, 0, '', '', 0, '', '', '', '', 0, '120363154035407435@g.us', '', 1, 1, NULL, b'1', NULL, NULL, NULL, NULL),
	(34, 'Azka Albania Manazel', 'AZKA', 1, 355, 415, 'TIRANA', 0, 'شركة منازل التوحيد لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'manazel@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', 'Virgo@123456', '', '', 0, '0', '', '', '', 'Virgo@123456', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 35, 0, '', '', 0, '', '', '', '', 0, '120363404130336385@g.us', '', 1, 1, NULL, NULL, 764299, 176661, 58, 764299),
	(35, 'Amanos HORAS Al Wisam SYR', 'AMANOUS', 1, 963, 207, 'DAMASCUS', 0, 'شركة الوسام المتميزه لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'amanos@virgo-sy.com', '944213839', 963, 'shadi.amanous@gmail.com', 'Amanous@2025', '', '', 0, '0', '', '', '', 'Amanous@2025 amanoustours@gmail.com Shadi@544633', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 36, 0, '', '', 0, '', '', '', '', 0, '120363401337288060@g.us', '', 1, 1, 40, b'0', 727481, 220268, 52, 727481),
	(36, 'LOUVER Al Naqqash B2B SYRIA', 'NAQQASH', 1, 963, 207, 'DAMASCUS', 0, '', '', '', '', 6, 0, 1, 0, '', '', '', '', 'samarkachlan2014@gmail.com', '777726422', 962, 'samarkachlan2014@gmail.com', 'Ss@123456789', '', '', 0, '0', '', '', '', 'Ss@123456789', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 37, 0, '', '', 0, '', '', '', '', 0, '120363051265990774@g.us', '', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL),
	(37, 'QWAFIL MAAD AL MASIYAH IRQ', 'QWAFIL', 1, 964, 203, 'BAGHDAD', 0, 'شركة معاد الماسية المحدودة', '', '', '', 6, 0, 1, 0, '', '', '', '', 'qawafilirq@virgo-sy.com', '7704507825', 964, 'qwafil1994@gmail.com', 'uuuuuu', '', '', 0, '0', '', '', '', 'Qq1241994@@@\n', '', '', 0, 'BAGHDAD', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 38, 0, '', '', 0, '', '', '', '', 0, '120363374741558188@g.us', '', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL),
	(38, 'QWAFIL', '', 1, 964, 203, 'BAGHDAD', 0, '', '', '', '', 6, 0, 1, 0, '', '', '', '', 'TEST@VIRGO-SY.COM', '111111111111', 99, 'TEST@VIRGO-SY.COM', '555', '', '', 0, '0', '', '', '', '', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 39, 0, '', '', 0, '', '', '', '', 0, '', '', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL),
	(39, 'VIRGO B2B AUSTRALIA RAKB', 'VIRGO', 1, 61, 604, 'SYDNEY', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'visa@virgo-sy.com', '1012121146', 20, 'visa@virgo-sy.com', 'Virgo@123456', '', '', 0, '0', '', '', '', 'Virgo@123456', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 40, 0, '', '', 0, '', '', '', '', 0, '120363027684796283@g.us', '', 1, 1, NULL, b'1', NULL, NULL, NULL, NULL),
	(40, 'Qwafil SUNBULAH IRQ', 'QWAFEL', 1, 964, 203, 'BAGHDAD', 0, 'شركة السنبلة الراقية لخدمات المعتمرين شخص واحد', '', '', '', 6, 0, 1, 0, '', '', '', '', 'qawafilirq@virgo-sy.com', '7704507825', 964, 'qwafil1994@gmail.com', 'Qq1241994@@@', '', '', 0, '0', '', '', '', 'Qq1241994@@@\n', '', '', 0, 'BAGHDAD', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 41, 0, '', '', 0, '', '', '', '', 0, '120363374741558188@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(41, 'Adam USA Contract Tourism', 'ADAM', 4, 1, 401, 'USA', 0, '', '', '', '', 6, 0, 1, 0, 'adamusa@virgo-sy.com', 'Virgo@123', '', '', 'adamusa@virgo-sy.com', '5712347283', 1, '', '', '', '', 0, '0', '', '', '', 'Virgo@123', '', '', 0, 'USA', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 42, 0, '', '', 0, '', '', '', '', 0, '963966624766-1547152038@g.us', '', 0, 1, NULL, NULL, NULL, NULL, NULL, NULL),
	(42, 'Manazel B2B USA Manazel', 'MANAZEL', 1, 1, 507, 'NEW YORK', 0, 'شركة منازل التوحيد لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'manazel@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', 'Virgo@123456', '', '', 0, '0', '', '', '', 'Virgo@123456', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 43, 0, '', '', 0, '', '', '', '', 0, '120363141828621015@g.us', '', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL),
	(43, 'Manazel B2B UK Manazel', 'MANAZEL', 1, 44, 401, 'LONDON', 0, '', '', '', '', 6, 0, 1, 0, '', '', '', '', 'manazel@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', 'Virgo@123456', '', '', 0, '0', '', '', '', '', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 44, 0, '', '', 0, '', '', '', '', 0, '120363141828621015@g.us', '', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL),
	(44, 'Manazel B2B IRELAND Manazel', 'MANAZEL', 1, 353, 334, 'DUBLIN', 0, '', '', '', '', 6, 0, 1, 0, '', '', '', '', 'manazel@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', 'Virgo@123456', '', '', 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'DUBLIN', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 45, 0, '', '', 0, '', '', '', '', 0, '120363141828621015@g.us', '', 1, 1, NULL, NULL, NULL, NULL, NULL, NULL),
	(45, 'AHEBBAH Al Hashmy Syria', 'LOUVER', 1, 963, 207, 'DAMASCUS', 0, 'شركة مجموعة قافلة التوحيد الدولية لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'alhashmi@virgo-sy.com', '777726422', 962, 'maraheb@virgo-sy.com', 'Virgo@123456', '', '', 0, '0', '', '', '', 'Virgo@123456', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 46, 0, '', '', 0, '', '', '', '', 0, '120363196015849155@g.us', '', 1, 0, 9, b'1', NULL, NULL, NULL, NULL),
	(46, 'AHEBBAH Al Hashmy Syria QAFILAH', 'LOUVER', 1, 963, 207, 'DAMASCUS', 0, 'شركة مجموعة قافلة التوحيد الدولية لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'alhashmi@virgo-sy.com', '777726422', 962, 'maraheb@virgo-sy.com', 'Virgo@123456', '', '', 0, '0', '', '', '', 'Virgo@123456', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 47, 0, '', '', 0, '', '', '', '', 0, '120363196015849155@g.us', '', 1, 1, 9, b'1', NULL, NULL, NULL, NULL),
	(47, 'Manazel B2B ALGERIA Manazel', 'MANAZEL', 1, 213, 304, 'ALGERIA', 0, '', '', '', '', 6, 0, 1, 0, '', '', '', '', 'manazel@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'ALGERIA', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 48, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363141828621015@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(48, 'Amanos Syria Maather NA', 'AMANOUS', 1, 963, 207, 'DAMASCUS', 0, 'مؤسسة مآثر الضيافة لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'amanos@virgo-sy.com', '944213839', 963, 'makkahsy25@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Sy01230123##', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 49, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363419522427439@g.us', '', 1, 0, 40, b'0', NULL, NULL, NULL, NULL),
	(49, 'ABRAG ALMADINA ASFAR ALRAYA IRAQ', 'ABRAG', 1, 964, 203, 'BAGHDAD', 0, 'شركة السنبلة الراقية لخدمات المعتمرين شخص واحد', '', '', '', 6, 0, 1, 0, '', '', '', '', 'ABRAG@virgo-sy.com', '7718444857', 964, 'abragalmadina93@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Osama93@osama', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 50, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363404082913465@g.us', '', 1, 0, NULL, b'1', NULL, NULL, NULL, NULL),
	(50, 'Mahattat Al Aalam France', 'MAHATTAT', 1, 33, 403, 'PARIS', 0, 'شركة محطات العالم لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'mahtat@virgo-sy.com', '560060160', 966, 'w7daani2050@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', '12345Ismail@', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 51, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363027901438947@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(51, 'Mahattat Al Aalam Gambia', 'MAHATTAT', 1, 220, 312, 'BANJUL', 0, 'شركة محطات العالم لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'mahtat@virgo-sy.com', '560060160', 966, 'gamhajjtours@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Ab@123456789', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 52, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363027901438947@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(52, 'Manazel INDONESIA Manazel', 'MANAZEL', 1, 62, 211, 'JAKARTA', 0, 'شركة منازل التوحيد لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'manazel@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456                            manazel@virgo-sy.com', '', '', 0, ' ', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 53, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363141828621015@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(53, 'Manazel MALAYSIA Manazel', 'MANAZEL', 1, 60, 219, 'KUALA LUMPUR', 0, 'شركة منازل التوحيد لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'manazel@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'manazel@virgo-sy.com', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 54, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363141828621015@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(54, 'ABRAG ALMADINA ASFAR ALRAYA 2 IRAQ', 'ABRAG', 1, 964, 203, 'BAGHDAD', 0, 'شركة اسفار الراية لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'ABRAG@virgo-sy.com', '7718444857', 964, 'abragalmadina93@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Osama93@osama', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 55, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363404082913465@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(55, 'LOUVER AHEBBAH MULLAH QAFLAH SYR', 'LOUVER', 1, 963, 207, 'DAMASCUS', 0, 'شركة مجموعة قافلة التوحيد الدولية لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'maraheb@virgo-sy.com', '777726422', 962, 'MOH.HAFF@GMAIL.COM', NULL, NULL, NULL, 0, '0', '', '', '', 'ALmula66@888', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 56, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363196015849155@g.us', '', 1, 1, 9, b'0', NULL, NULL, NULL, NULL),
	(56, 'Amanos Makkah Maather SYR', 'AMANOUS', 1, 963, 207, 'DAMASCUS', 0, 'مؤسسة مآثر الضيافة لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'amanos@virgo-sy.com', '944213839', 963, 'shadi.amanous@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'makkahsy25@gmail.com  \\ Shadi@544633', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 57, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363419522427439@g.us', '', 1, 1, 40, b'0', 765708, 221204, 52, 765708),
	(57, 'SkyDirect Tourism', '', 4, 44, 401, 'UNITED KINGDOM', 0, '', '', '', '', 6, 0, 1, 0, 'skydirect@virgo-sy.com', 'Sky@#$123', '', '', 'skydirect@virgo-sy.com', '7860279542', 44, '', NULL, NULL, NULL, 0, '0', '', '', '', 'Sky@#$123', '', '', 0, 'UNITED KINGDOM', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 58, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '201030034119-1578928308@g.us', '', 0, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(58, 'Vataksi Bosnia and Herzegovina RAKB', 'VATAKSI', 1, 387, 236, 'Sarajevo', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'vataksi@virgo-sy.com', '693334356', 355, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 59, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363029114809528@g.us', '', 1, 1, NULL, b'0', 784634, 192988, 52, 784634),
	(59, 'AMANOUS ZAIN BAKR SYR', 'AMANOUS', 1, 963, 207, 'DAMASCUS', 0, 'مؤسسة بكر سالم باسنبل لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'amanos@virgo-sy.com', '944213839', 963, 'shadi.amanous@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Sh@@@di544633 ALZIN.SY89@GMAIL.COM \\Shadi@544633', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 60, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363403923189314@g.us', '', 1, 1, 40, b'1', 719606, 219722, 52, 719606),
	(60, 'IdealGate BAKR Germany', 'IDEALGATE', 1, 49, 405, 'BERLIN', 0, 'مؤسسة بكر سالم باسنبل لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'ideal@virgo-sy.com', '1605777522', 49, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 61, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363230454824349@g.us', '', 0, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(61, 'Al Safy Midan Mawakeb SYR', 'ALSAFY', 1, 963, 207, 'DAMASCUS', 0, 'مؤسسة مواكب لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'alsafi@virgo-sy.com', '940743910', 963, 'asad0940743910@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'm0940@743910M', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 62, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363419428550647@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(62, 'Beoot Al Shaam QADRY OLYYAN IRQ', 'Beoot', 1, 964, 203, 'BAGHDAD', 0, 'شركة سليمان بن موسى العليان التجارية', '', '', '', 6, 0, 1, 0, '', '', '', '', 'biyoutalsham@virgo-sy.com', '534399977', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 17, '0', '', '', '', 'Virgo@123456', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 63, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363419114415993@g.us', '', 1, 1, 17, b'0', NULL, NULL, NULL, NULL),
	(63, 'NOOR ALMAARIF SUNBULAH IRQ', 'NOOR', 1, 964, 203, 'BAGHDAD', 0, 'شركة السنبلة الراقية لخدمات المعتمرين شخص واحد', '', '', '', 6, 0, 1, 0, '', '', '', '', 'nour_almaaref@virgo-sy.com', '7830066390', 964, 'hxnx17hxnx17hxnx17hxnx+1@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Hh959@h959h995', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 64, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363403363400126@g.us', '', 0, 1, 46, b'1', 885109, 227764, 58, 885109),
	(64, 'Virgo Contract Tourism', 'VIRGO', 4, 1112, 401, 'CANADA', 0, '', '', '', '', 6, 0, 1, 0, 'tourism@virgo-sy.com', 'Virgo@123', '', '', 'tourism@virgo-sy.com', '12121146', 20, '', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123', '', '', 0, 'CANADA', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 65, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363150850593347@g.us', '', 0, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(65, 'Mahattat Al Aalam USA', 'MAHATTAT', 1, 1, 507, 'NEW YORK', 0, 'شركة محطات العالم لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'mahtat@virgo-sy.com', '560060160', 966, 'w7daani2050@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', '12345Ismail@', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 66, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363027901438947@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(66, 'Caravan Tours Contract UK', '', 1, 44, 401, 'london', 0, 'اثراء النسك لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'abdul@caravantourtravel.com', '7859830611', 44, 'abdul@caravantourtravel.com', NULL, NULL, NULL, 0, '0', '', '', '', '', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 67, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '963966624766-1570887396@g.us', '', 0, 0, NULL, b'0', NULL, NULL, NULL, NULL),
	(67, 'VIRGO Bosnia and Herzegovina RAKB', 'VIRGO', 1, 381, 236, 'SARAJEVO', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'visa@virgo-sy.com', '1557356352', 20, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'SARAJEVO', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 68, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363027684796283@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(68, 'Rakb MYANMAR Rakb', 'RAKB', 1, 95, 334, 'NAYPYIDAW', 0, '', '', '', '', 6, 0, 1, 0, '', '', '', '', 'rakb@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'NAYPYIDAW', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 69, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363042105049378@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(69, 'AMANOS TSHRYN MNHAJ SYR', 'AMANOUS', 1, 963, 207, 'DAMASCUS', 0, 'شركة المنهاج لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'amanos@virgo-sy.com', '944213839', 963, 'shadi.amanous@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Sh@@@di544633 tishreen.sy2025@gmail.com Shadi@544633', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 70, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363403628649400@g.us', '', 1, 1, 40, b'0', 799608, 222531, 52, 799608),
	(70, 'Vataksi SWEDEN Rakb', 'VATAKSI', 1, 46, 412, 'STOCKHOLM', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'vataksi@virgo-sy.com', '693334356', 355, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', '', '', '', 0, 'STOCKHOLM', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 71, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363029114809528@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(71, 'Virgo B2B USA Rakb', 'VIRGO', 1, 1, 507, 'NEW YORK', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'visa@virgo-sy.com', '1012121146', 20, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 72, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363027684796283@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(72, 'Virgo B2B MOROCCO Rakb', 'VIRGO', 1, 212, 305, 'MOROCCO', 0, '', '', '', '', 6, 0, 1, 0, '', '', '', '', 'visa@virgo-sy.com', '1012121146', 20, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'MOROCCO', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 73, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363027684796283@g.us', '', 0, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(73, 'AMANOUS AJYAD SYR', 'AMANOUS', 1, 963, 207, 'DAMASCUS', 0, 'مؤسسة قوافل الراحة لنقل الحجاج والمعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'amanos@virgo-sy.com', '944213839', 963, 'shadi.amanous@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Shadi@544633', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 74, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363402954057626@g.us', '', 1, 1, 40, b'0', 800469, 222488, 58, 800469),
	(74, 'AMANOS ALKHATM HASOOB SYR', 'AMANOUS', 1, 963, 207, 'DAMASCUS', 0, 'شركة حاسوب التقنية التجارية', '', '', '', 6, 0, 1, 0, '', '', '', '', 'amanos@virgo-sy.com', '944213839', 963, 'shadi.amanous@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Shadi@544633', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 75, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363420007286497@g.us', '', 1, 1, 40, b'0', 799514, 222508, 52, 799514),
	(75, 'Virgo B2B Kazakhstan Rakb', 'VIRGO', 1, 7001, 334, 'ASTANA', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'visa@virgo-sy.com', '1012121146', 10, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 76, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363027684796283@g.us', '', 1, 1, NULL, b'0', 800643, 150025, 52, 800643),
	(76, 'Rakb ALGERIA Rakb', 'RAKB', 1, 213, 304, 'ALGERIA', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'rakb@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 77, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363042105049378@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(77, 'Virgo SPAIN Rakb', 'VIRGO', 1, 34, 407, 'MADRID', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'visa@virgo-sy.com', '1012121146', 20, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 78, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363027684796283@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(78, 'VIRGO B2B IRELAND RAKB', 'VIRGO', 1, 353, 334, 'IRELAND', 0, '', '', '', '', 6, 0, 1, 0, '', '', '', '', 'visa@virgo-sy.com', '1012121146', 20, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', 'VIRGO BUSSNIES SOLUTION', '', '', 'Virgo@123456', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 79, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363027684796283@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(79, 'Mahattat Al Aalam Mali', 'MAHATTAT', 1, 223, 316, 'bamako', 0, 'شركة محطات العالم لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'mahtat@virgo-sy.com', '560060160', 966, 'sfryatalmutheda2025@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Mm@123456789', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 80, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363027901438947@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(80, 'Galata Tours Contract Tourism', 'GALATA', 4, 90, 401, 'TURKEY', 0, 'شركة افاق المتميزة لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, 'galatatours@virgo-sy.com', 'Virgo2024@', '', '', 'galatatours@virgo-sy.com', '5050744095', 90, '', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo2024@', '', '', 0, 'TURKEY', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 81, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363047540561795@g.us', '', 0, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(81, 'AZKA Bosnia and Herzegovina Manazel', '', 1, 381, 236, 'SARAJEVO', 0, 'شركة منازل التوحيد لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'manazel@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', '', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 82, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363404130336385@g.us', '', 0, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(82, 'Virgo B2B INDIA Rakb', 'VIRGO', 1, 91, 232, 'BOMBAY', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'visa@virgo-sy.com', '1012121146', 20, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'BOMBAY', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 83, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363027684796283@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(83, 'Virgo Sri Lanka Rakb', 'VIRGO', 1, 94, 237, 'COLOMBO', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'visa@virgo-sy.com', '1012121146', 20, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'COLOMBO', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 84, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363027684796283@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(84, 'Beoot Al Shaam EBLA DREAM SYR', 'Beoot', 1, 963, 207, 'DAMASCUS', 0, 'شركة النادي العالمي لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'biyoutalsham@virgo-sy.com', '534399977', 966, 'Tr1326q@gmail.com', NULL, NULL, NULL, 17, '0', '', '', '', 'BBb123456789#', '', '', 0, 'DAMASCUS', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 85, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363419114415993@g.us', '', 1, 1, 17, b'0', 818779, 224504, 52, 818779),
	(85, 'Virgo B2B Bangladesh Rakb', '', 1, 880, 218, 'Dhaka', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'visa@virgo-sy.com', '1012121146', 20, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', '', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 86, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363027684796283@g.us', '', 0, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(86, 'LOUVER QAFLAH SYR', '', 1, 963, 207, 'دمشق', 0, 'Qafilat Altawhid International Group', '', '', '', 6, 0, 1, 0, '', '', '', '', 'visa@virgo-sy.com', '1012121146', 20, 'nouser', NULL, NULL, NULL, 0, '0', '', '', '', '', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 87, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '', '', 0, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(87, 'Amanos Syria Al BAZ AL NAADY', 'AMANOUS', 1, 963, 207, 'DAMASCUS', 0, 'شركة النادي العالمي لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'amanos@virgo-sy.com', '944213839', 963, 'shadi.amanous@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Aa@123456789 ALBAZ.SY2025@GMAIL.COM \\  Shadi@544633', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 88, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363423456853469@g.us', '', 0, 1, 40, b'0', 818247, 224380, 52, 818247),
	(88, 'qwafil print visa', '', 1, 964, 203, 'baghdad', 0, 'شركة نجم العاصمة لتشغيل الفنادق', '', '', '', 6, 0, 1, 0, '', '', '', '', 'visa@virgo-sy.com', '0', 0, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', '', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 89, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '', '', 1, 1, NULL, b'1', NULL, NULL, NULL, NULL),
	(89, 'Virgo ALGERIA Rakb', 'VIRGO', 1, 213, 304, 'ALGERIA', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'visa@virgo-sy.com', '1012121146', 20, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'ALGERIA', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 90, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363027684796283@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(90, 'Vataksi - Serbia Rakb', 'VATAKSI', 1, 381, 236, 'Serbia', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'visa@virgo-sy.com', '1012121146', 20, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', '', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 91, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363029114809528@g.us', '', 1, 1, 16, b'0', NULL, NULL, NULL, NULL),
	(91, 'Manazel SWEDEN', 'MANAZEL', 1, 46, 412, 'STOCKHOLM', 0, 'شركة منازل التوحيد لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'manazel@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'STOCKHOLM', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 92, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363141828621015@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(92, 'Rakb SWEDEN', 'RAKB', 1, 46, 412, 'STOCKHOLM', 0, '', '', '', '', 6, 0, 1, 0, '', '', '', '', 'rakb@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'STOCKHOLM', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 93, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363042105049378@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(93, 'Amanos WARKAA SHABAA SYR', 'AMANOUS', 1, 963, 207, 'DAMASCUS', 0, 'شركة شبا لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'amanos@virgo-sy.com', '944213839', 963, 'shadi.amanous@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Shadi@544633', '', '', 0, 'DAMASCUS', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 94, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363419641509911@g.us', '', 1, 1, 40, b'0', 722006, 220065, 52, 722006),
	(94, 'Beoot Al Shaam alharamoun WATANYA SYR', 'BEOOT', 1, 963, 207, 'DAMASCUS', 0, 'الشركة الوطنية لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'biyoutalsham@virgo-sy.com', '534399977', 966, 'Tr1326q@gmail.com', NULL, NULL, NULL, 17, '0', '', '', '', 'TrB123456789#', '', '', 0, 'DAMASCUS', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 95, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363419114415993@g.us', '', 1, 1, 17, b'1', 820816, 224884, 52, 820816),
	(95, 'Virgo B2B Canada Rakb', '', 1, 1112, 502, 'otawa', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'visa@virgo-sy.com', '1012121146', 20, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 96, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363027684796283@g.us', '', 0, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(96, 'Amanos ALBOSTAN TAAEF SYR', 'AMANOUS', 1, 963, 207, 'DAMASCUS', 0, 'شركة الطائف لخدمات المعتمرين التجارية', '', '', '', 6, 0, 1, 0, '', '', '', '', 'amanos@virgo-sy.com', '944213839', 963, 'shadi.amanous@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Shadi@544633', '', '', 0, 'DAMASCUS', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 97, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363419560016168@g.us', '', 1, 1, 40, b'1', 820809, 224882, 52, 820809),
	(97, 'Vataksi Switzerland Rakb', '', 1, 41, 404, 'BERN', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'vataksi@virgo-sy.com', '693334356', 355, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', '', '', '', 0, 'BERN', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 98, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363029114809528@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(98, 'Virgo TURKEY Rakb', 'VIRGO', 1, 90, 233, 'ISTANBUL', 0, '', '', '', '', 6, 0, 1, 0, '', '', '', '', 'visa@virgo-sy.com', '1012121146', 20, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'ISTANBUL', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 99, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363027684796283@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(99, 'Virgo SWITZERLAND Rakb', 'VIRGO', 1, 41, 404, 'BERN', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'visa@virgo-sy.com', '1012121146', 20, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'BERN', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 100, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363027684796283@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(100, 'Mahattat Al Aalam NAJM MAR', 'MAHATTAT', 1, 212, 305, 'REBAT', 0, 'شركة محطات العالم لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'mahtat@virgo-sy.com', '560060160', 966, 'mcdcahmad@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Aa@1314151617', '', '', 0, 'REBAT', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 101, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363027901438947@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(101, 'Manazel GERMANY', 'MANAZEL', 1, 49, 405, 'BERLIN', 0, 'شركة منازل التوحيد لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'manazel@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'BERLIN', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 102, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363141828621015@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(102, 'Manazel SWITZERLAND', 'MANAZEL', 1, 41, 404, 'BERN', 0, 'شركة منازل التوحيد لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'manazel@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'BERN', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 103, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363141828621015@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(103, 'Manazel ITALY', '', 1, 39, 406, 'ROME', 0, 'شركة منازل التوحيد لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'manazel@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'ROME', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 104, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363141828621015@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(104, 'Manazel NORWAY', 'MANAZEL', 1, 47, 428, 'OSLO', 0, 'شركة منازل التوحيد لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'manazel@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'OSLO', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 105, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363141828621015@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(105, 'Manazel ROMANIA', 'MANAZEL', 1, 40, 420, 'BUCHAREST', 0, 'شركة منازل التوحيد لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'manazel@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'BUCHAREST', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 106, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363141828621015@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(106, 'Manazel RUSSIA', 'MANAZEL', 1, 7002, 235, 'MOSCOW', 0, 'شركة منازل التوحيد لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'manazel@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'MOSCOW', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 107, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363141828621015@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(107, 'VIRGO B2B FRANCE RAKB', '', 1, 33, 403, 'Paris', 0, '', '', '', '', 6, 0, 1, 0, '', '', '', '', 'visa@virgo-sy.com', '0', 0, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 108, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363027684796283@g.us', '', 0, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(108, 'Rakb GERMANY Rakb', '', 1, 49, 405, 'BERLIN', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'rakb@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 109, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363042105049378@g.us', '', 0, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(109, 'Vataksi GERMANY Rakb', 'VATAKSI', 1, 49, 405, 'BERLIN', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'vataksi@virgo-sy.com', '693334356', 355, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'BERLIN', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 110, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363029114809528@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(110, 'Vataksi Belgium Rakb', 'VATAKSI', 1, 32, 410, 'BRUSSELS', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'visa@virgo-sy.com', '693334356', 355, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'BRUSSELS', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 111, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363029114809528@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(111, 'Virgo DANMARK Rakb', '', 1, 45, 411, 'COPENHAGEN', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'visa@virgo-sy.com', '1012121146', 20, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 112, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363027684796283@g.us', '', 0, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(112, 'IdealGate ALMNHAJ Germany', 'IDEALGATE', 1, 49, 405, 'BERLIN', 0, 'شركة المنهاج لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'ideal@virgo-sy.com', '1605777522', 49, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'شركة المنهاج لخدمات المعتمرين', '', '', 0, 'BERLIN', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 113, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363403334587690@g.us', '', 0, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(113, 'Rakb INDIA', 'RAKB', 1, 91, 232, 'BOMBAY', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'rakb@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', '', '', '', 0, 'BOMBAY', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 114, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363042105049378@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(114, 'Azka Germany Manazel', 'AZKA', 1, 49, 405, 'BERLIN', 0, 'شركة منازل التوحيد لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'manazel@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'BERLIN', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 115, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363404130336385@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(115, 'Vataksi ITALY Rakb', 'VATAKSI', 1, 39, 406, 'ROME', 0, 'مؤسسة الدور الحديثة للتطوير العقاري', '', '', '', 6, 0, 1, 0, '', '', '', '', 'vataksi@virgo-sy.com', '693334356', 355, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'ROME', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 116, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363029114809528@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(116, 'Rakb UAE', 'RAKB', 1, 971, 230, 'DUBAI', 0, '', '', '', '', 6, 0, 1, 0, '', '', '', '', 'rakb@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'DUBAI', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 117, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363042105049378@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(117, 'Manazel FRANCE', 'MANAZEL', 1, 33, 403, 'PARIS', 0, 'شركة منازل التوحيد لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'manazel@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'PARIS', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 118, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363141828621015@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(118, 'RAKB Slovenia', 'RAKB', 1, 386, 408, 'LJUBLJANA', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'rakb@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'LJUBLJANA', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 119, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363042105049378@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(119, 'RAKB AUSTRIA', 'RAKB', 1, 43, 408, 'VIENNA', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'rakb@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'VIENNA', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 120, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363042105049378@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(120, 'RAKB CROATIA', 'RAKB', 1, 385, 236, 'ZAGREB', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'rakb@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', '', '', '', 0, 'ZAGREB', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 121, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363042105049378@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(121, 'VIRGO INDONESIA RAKB', 'VIRGO', 1, 62, 211, 'JAKARTA', 0, '', '', '', '', 6, 0, 1, 0, '', '', '', '', 'visa@virgo-sy.com', '1012121146', 20, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'JAKARTA', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 122, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363027684796283@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(122, 'AZKA BELGIUM Manazel', 'AZKA', 1, 32, 410, 'BRUSSELS', 0, 'شركة منازل التوحيد لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'manazel@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'BRUSSELS', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 123, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363404130336385@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(123, 'Manazel SENEGAL', '', 1, 221, 312, 'DAKAR', 0, 'شركة منازل التوحيد لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'manazel@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', '', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 124, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363141828621015@g.us', '', 0, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(124, 'Virgo TANZANIA Rakb', 'VIRGO', 1, 2551, 333, 'DODOMA', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'visa@virgo-sy.com', '1012121146', 20, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'DODOMA', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 125, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363027684796283@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(125, 'Bosnia and Herzegovina RAKB', 'RAKB', 1, 3811, 236, 'SARAJEVO', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'rakb@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'SARAJEVO', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 126, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363042105049378@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(126, 'Rakb ALBANIA', 'RAKB', 1, 355, 415, 'TIRANA', 0, '', '', '', '', 6, 0, 1, 0, '', '', '', '', 'rakb@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'TIRANA', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 127, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363042105049378@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(127, 'RAKB LUXEMBOURG', 'RAKB', 1, 352, 410, 'LUXEMBOURG', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'rakb@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'LUXEMBOURG', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 128, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363042105049378@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(128, 'Amanos MOISHA DYAFAH SYR', 'AMANOUS', 1, 963, 207, 'DAMASCUS', 0, 'شركة الضيافة الجديدة لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'amanos@virgo-sy.com', '944213839', 963, 'shadi.amanous@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', '', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 129, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363402945300262@g.us', '', 0, 1, 40, b'0', 828515, 226169, 52, 828515),
	(129, 'Adam USA UK Rakb', 'ADAM', 1, 44, 401, 'LONDON', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'AMRO.ELBAZ@ADAMTRAVEL.NET', '5712347283', 1, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'LONDON', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 130, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '963966624766-1547152038@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(130, 'Adam USA AUSTRALIA Rakb', 'ADAM', 1, 61, 604, 'SYDNEY', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'AMRO.ELBAZ@ADAMTRAVEL.NET', '5712347283', 1, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'SYDNEY', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 131, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '963966624766-1547152038@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(131, 'Adam USA ALBANIA Rakb', 'ADAM', 1, 355, 415, 'TIRANA', 0, '', '', '', '', 6, 0, 1, 0, '', '', '', '', 'AMRO.ELBAZ@ADAMTRAVEL.NET', '5712347283', 1, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'TIRANA', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 132, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '963966624766-1547152038@g.us', '', 1, 1, 3, b'0', NULL, NULL, NULL, NULL),
	(132, 'Mahattat Al Aalam ASALAH SYR', 'MAHATTAT', 1, 963, 207, 'DAMASCUS', 0, 'شركة محطات العالم لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'mahtat@virgo-sy.com', '560060160', 966, 'mcdcahmad@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Aa@1314151617', '', '', 0, 'DAMASCUS', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 133, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363027901438947@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(133, 'Amanos CHARAF Z  SYR', 'AMANOUS', 1, 963, 207, 'DAMASCUS', 0, 'شركة اوتاد مكة لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'amanos@virgo-sy.com', '944213839', 963, 'shadi.amanous@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Shadi@544633', '', '', 0, 'DAMASCUS', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 134, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363403188089170@g.us', '', 1, 1, 40, b'0', 819435, 224735, 52, 819435),
	(134, 'Rakb AUSTRALIA', 'RAKB', 1, 61, 604, 'SYDNEY', 0, '', '', '', '', 6, 0, 1, 0, '', '', '', '', 'rakb@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'SYDNEY', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 135, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363042105049378@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(135, 'Adam USA DENMARK Rakb', 'ADAM', 1, 45, 411, 'COPENHAGEN', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'AMRO.ELBAZ@ADAMTRAVEL.NET', '5712347283', 1, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', '', '', '', 0, 'COPENHAGEN', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 136, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '963966624766-1547152038@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(136, 'MANAZEL TANZANIA ', 'MAAZEL', 1, 2551, 334, 'DODOMA', 0, '', '', '', '', 6, 0, 1, 0, '', '', '', '', 'manazel@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'DODOMA', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 137, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363141828621015@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(137, 'MOBARAK AUSTRIA', 'RAKB', 1, 43, 408, 'VIENNA', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'rakb@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', '', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 138, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363042105049378@g.us', '', 0, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(138, 'AMANOS AL MASAR SYR ', 'AMANOUS', 1, 963, 207, 'DAMASCUS', 0, 'شركة المسار الفندقي المحدودة', '', '', '', 6, 0, 1, 0, '', '', '', '', 'amanos@virgo-sy.com', '944213839', 963, 'shadi.amanous@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Shadi@544633', '', '', 0, 'DAMASCUS', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 139, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363421462079367@g.us', '', 1, 1, 40, b'0', 832814, 226184, 58, 832814),
	(139, 'Azka SLOVINA Manazel', 'AZKA', 1, 386, 408, 'LJUBLJANA', 0, 'شركة منازل التوحيد لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'manazel@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'LJUBLJANA', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 140, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363404130336385@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(140, 'Beoot Al Shaam AL FARES MAIDAA SYR', 'BEOOT', 1, 963, 207, 'DAMASCUS', 0, 'مؤسسة مكارم السلام لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'biyoutalsham@virgo-sy.com', '534399977', 966, 'Tr1326q@gmail.com', NULL, NULL, NULL, 17, '0', '', '', '', '', '', '', 0, 'DAMASCUS', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 141, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363419114415993@g.us', '', 1, 1, 17, b'0', 831534, 226672, 52, 831534),
	(141, 'Beoot Al Shaam AL EHSAN Athar SYR', 'BEOOT', 1, 963, 207, 'DAMASCUS', 0, 'شركة اثار الصور لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'biyoutalsham@virgo-sy.com', '534399977', 966, 'Tr1326q@gmail.com', NULL, NULL, NULL, 17, '0', '', '', '', 'Tr123456789#', '', '', 0, 'DAMASCUS', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 142, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363419114415993@g.us', '', 1, 1, 17, b'0', 831548, 226673, 52, 831548),
	(142, 'Azka SWEDEN Manazel', 'AZKA', 1, 46, 412, 'STOCKHOLM', 0, 'شركة منازل التوحيد لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'manazel@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'STOCKHOLM', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 143, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363404130336385@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(143, 'VIRGO PAKISTAN', 'VIRGO', 1, 92, 231, 'KARACHI', 0, 'شركة إطلالة مكة لتنظيم خدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'visa@virgo-sy.com', '1012121146', 20, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'KARACHI', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 144, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '', '', 1, 1, NULL, b'1', NULL, NULL, NULL, NULL),
	(144, 'Mahattat Al Aalam INDONESIA', '', 1, 971, 214, 'JAKARTA', 0, 'شركة محطات العالم لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'mahtat@virgo-sy.com', '560060160', 966, 'mcdcahmad@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Aa@1314151617', '', '', 0, 'JAKARTA', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 145, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363027901438947@g.us', '', 1, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(145, 'AMANOS SAHL HORAAN ALDEWANYA', 'AMANOUS', 1, 963, 207, 'DAMASCUS', 0, 'شركة الديوانية لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'amanos@virgo-sy.com', '944213839', 963, 'shadi.amanous@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Shadi@544633', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 146, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363406750249647@g.us', '', 0, 1, 40, b'0', 840252, 227307, 52, 840252),
	(146, 'AMANOUS Amanos AL SHARI ALSHARIAH SYR', 'AMANOUS', 1, 963, 207, 'DAMASCUS', 0, 'شركة الشريعة لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'amanos@virgo-sy.com', '944213839', 963, 'shadi.amanous@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Shadi@544633', '', '', 0, 'DAMASCUS', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 147, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363402959248322@g.us', '', 1, 1, 40, b'0', 840251, 227306, 52, 840251),
	(147, 'Amanos AL SHARI ALSHARIAH SYR', 'AMANOUS', 1, 963, 207, 'DAMASCUS', 0, 'شركة الشريعة لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'amanos@virgo-sy.com', '944213839', 963, 'shadi.amanous@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Shadi@544633', '', '', 0, 'DAMASCUS', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 148, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363402959248322@g.us', '', 1, 0, 40, b'0', 840251, 227306, 52, 840251),
	(148, 'LOUVER \\  MARITTA \\ ALEMAN SYR', 'LOUVER', 1, 963, 207, 'DAMASCUS', 0, 'شركة اسفار الايمان المتميزة لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'maraheb@virgo-sy.com', '777726422', 962, 'marina.agency.umrah@gmail.com', NULL, NULL, NULL, 0, '0', '', 'مؤسسة مواكب لخدمات المعتمرين', '', 'MArina66@888', '', '', 0, 'DAMASCUS', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 149, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363404962272839@g.us', '', 1, 1, 9, b'0', 840250, 227305, 52, 840250),
	(149, 'Adam USA CAN Rakb', 'ADAM', 1, 1112, 502, 'OTTAWA', 0, '', '', '', '', 6, 0, 1, 0, '', '', '', '', 'AMRO.ELBAZ@ADAMTRAVEL.NET', '5712347283', 1, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'OTTAWA', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 150, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '963966624766-1547152038@g.us', '', 1, 1, 3, b'0', NULL, NULL, NULL, NULL),
	(150, 'Virgo DENMARK Rakb', 'VIRGO', 1, 45, 411, 'COPENHAGEN', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'visa@virgo-sy.com', '1012121146', 20, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'COPENHAGEN', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 151, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363027684796283@g.us', '', 1, 1, 12, b'0', NULL, NULL, NULL, NULL),
	(151, 'AMANOUS SHAM AL MAJD \\ ROAYA SYR', 'AMANOUS', 1, 963, 207, 'DAMASCUS', 0, 'شركة رؤيا فيجن لتشغيل الفنادق', '', '', '', 6, 0, 1, 0, '', '', '', '', 'amanos@virgo-sy.com', '944213839', 963, 'shadi.amanous@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Shadi@544633', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 152, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363425096503213@g.us', '', 1, 1, 40, b'0', 840261, 227315, 52, 840261),
	(152, 'MANZEL ALBANIA', 'MANAZEL', 1, 355, 415, 'TIRANA', 0, 'شركة منازل التوحيد لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'manazel@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'TIRANA', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 153, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363141828621015@g.us', '', 0, 1, NULL, b'0', NULL, NULL, NULL, NULL),
	(153, 'Amanos GOLDIN HOLIDAYS SYR', 'AMANOUS', 1, 963, 207, 'DAMASCUS', 0, '', '', '', '', 6, 0, 1, 0, '', '', '', '', 'amanos@virgo-sy.com', '944213839', 963, 'shadi.amanous@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Shadi@544633', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 154, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363406986593908@g.us', '', 0, 1, 40, b'0', NULL, NULL, NULL, NULL),
	(154, 'Beoot Al Shaam NOOR ELYAQEEN', 'BEOOT', 1, 963, 207, 'DAMASCUS', 0, 'شركة مصطفى فريد حافظ لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'biyoutalsham@virgo-sy.com', '534399977', 966, 'Tr1326q@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'BBb123456789#', '', '', 0, 'DAMASCUS', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 155, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363419114415993@g.us', '', 1, 1, 17, b'0', 835085, 227154, 52, 835085),
	(155, 'Beoot Al Shaam ZINO', 'BEOOT', 1, 963, 207, 'DAMASCUS', 0, 'شركة تالا السعودية للصيانة والنظافة المحدودة', '', '', '', 6, 0, 1, 0, '', '', '', '', 'biyoutalsham@virgo-sy.com', '534399977', 966, 'Tr1326q@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Bbb123456789#', '', '', 0, 'BEOOT', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 156, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363419114415993@g.us', '', 1, 1, 17, b'0', 840805, 227329, 52, 840805),
	(156, 'Amanos ITLALT MAKAH NAWA SYR', 'AMANOUS', 1, 963, 207, 'DAMASCUS', 0, 'شركة إطلالة مكة لتنظيم خدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'amanos@virgo-sy.com', '944213839', 963, 'shadi.amanous@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Shadi@544633', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 157, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363422667346628@g.us', '', 1, 1, 40, b'0', 844537, 228146, 52, 844537),
	(157, 'AMANOUS RAWAFI ALAHLAM ALGIZA SYR', 'AMANOUS', 1, 963, 207, 'DAMASCUS', 0, 'شركة روافي الاحلام للسفر والسياحة', '', '', '', 6, 0, 1, 0, '', '', '', '', 'amanos@virgo-sy.com', '944213839', 963, 'shadi.amanous@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', '', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 158, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363402743665242@g.us', '', 0, 1, 40, b'0', 844536, 227521, 52, 844536),
	(158, 'SHAHAD AL HARAMEN \\ AWTAD SYR', '', 1, 963, 207, 'DAMASCUS', 0, 'شركة اوتاد مكة لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'shahed_alharamen@virgo-sy.com', '933263725', 963, 'Shahed_alharamen@hotmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'S933263725s@', '', '', 0, 'DAMASCUS', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 159, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363422053495324@g.us', '', 1, 1, 73, b'0', 0, 0, 0, 0),
	(159, 'Beoot Al Shaam Madain Gate', 'BEOOT', 1, 963, 207, 'DAMASCUS', 0, 'شركة مكة للانشاء والتعمير لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'biyoutalsham@virgo-sy.com', '534399977', 966, 'Tr1326q@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'BBb123456789#', '', '', 0, 'DAMASCUS', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 160, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363419114415993@g.us', '', 1, 1, 17, b'0', 845591, 227612, 52, 845591),
	(160, 'RAWAHEL\\ ROKN \\ ALDERAYEH  SYR', 'RAWAHEL AL MASHAER', 1, 963, 207, 'DAMASCUS', 0, 'شركة السنبلة الراقية لخدمات المعتمرين شخص واحد', '', '', '', 6, 0, 1, 0, '', '', '', '', 'alroqnalkhames1986@outlook.com', '556697380', 971, 'alroqnalkhames1986@outlook.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Abcd@5622663', '', '', 0, 'DAMASCUS', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 161, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363421134642852@g.us', '', 1, 1, 74, b'0', 840193, 227310, 52, 840193),
	(161, 'RAKB IVORY COAST', 'RAKB', 1, 225, 334, 'ABIDJAN', 0, '', '', '', '', 6, 0, 1, 0, '', '', '', '', 'rakb@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'ABIDJAN', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 162, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363042105049378@g.us', '', 1, 1, 5, b'0', 0, 0, 0, 0),
	(162, 'RAWAHEL ALMASHAIR', 'RAWAHEL AL MASHAER', 1, 963, 207, 'DAMASCUS', 0, 'شركة رواحل المشاعر المحدودة', '', '', '', 6, 0, 1, 0, '', '', '', '', 'rawhil-sy@hotmail.com', '556697380', 971, 'rawhil-sy@hotmail.com', NULL, NULL, NULL, 0, '0', '', '', '', '1234567Aa@1234567', '', '', 0, 'DAMASCUS', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 163, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363421134642852@g.us', '', 1, 1, 74, b'0', 714095, 218225, 52, 714095),
	(163, 'RAWAHEL ALNAJJAR', 'RAWAHEL AL MASHAER', 1, 963, 207, 'DAMASCUS', 0, 'شركة نوران لخدمات المعتمرين التجارية', '', '', '', 6, 0, 1, 0, '', '', '', '', 'alnajartravel@hotmail.com', '556697380', 971, 'alnajartravel@hotmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Abcd@5622663', '', '', 0, 'DAMASCUS', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 164, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363421134642852@g.us', '', 1, 1, 74, b'0', 749286, 220787, 52, 749286),
	(164, 'LOUVER AHEBBAH RAKB SYR', 'LOUVER', 1, 963, 207, 'DAMASCUS', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'maraheb@virgo-sy.com', '777726422', 962, 'alaheba.agency@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'ALaheba66@88', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 165, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363145118638217@g.us', '', 1, 1, 9, b'0', 848549, 227715, 52, 848549),
	(165, 'RAKB FRANCE', 'RAKB', 1, 33, 403, 'PARIS', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'rakb@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'PARIS', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 166, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363042105049378@g.us', '', 1, 1, 5, b'0', 0, 0, 0, 0),
	(166, 'RAKB BULGARIA', 'RAKB', 1, 359, 707, 'SOFIA', 0, '', '', '', '', 6, 0, 1, 0, '', '', '', '', 'rakb@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'SOFIA', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 167, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363042105049378@g.us', '', 1, 1, 5, b'0', 0, 0, 0, 0),
	(167, 'ASSALAM REISEN GERMANY', 'ASSALAM REISEN', 1, 49, 405, 'BERLIN', 0, 'مؤسسة حسين محمد حجازي لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'Khadijaazzaoui@yahoo.de', '17646065906', 49, 'Khadijaazzaoui@yahoo.de', NULL, NULL, NULL, 0, '0', '', '', '', 'Saudi-12345!', '', '', 0, 'BERLIN', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 168, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363043821635040@g.us', '', 1, 1, 76, b'0', 0, 0, 0, 0),
	(168, 'ASSALAM REISEN FRANCE', 'ASSALAM REISEN', 1, 33, 403, 'PARIS', 0, 'مؤسسة حسين محمد حجازي لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'Khadijaazzaoui@yahoo.de', '17646065906', 49, 'Khadijaazzaoui@yahoo.de', NULL, NULL, NULL, 0, '0', '', '', '', 'Saudi-12345!', '', '', 0, 'PARIS', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 169, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363043821635040@g.us', '', 1, 1, 76, b'0', 0, 0, 0, 0),
	(169, 'NOOR ALMAARIF TOURISM', '', 4, 1, 401, 'USA', 0, 'شركة السنبلة الراقية لخدمات المعتمرين شخص واحد', '', '', '', 6, 0, 1, 0, 'nour_almaaref@virgo-sy.com', 'Hh959@h959h995', '', '', 'nour_almaaref@virgo-sy.com', '7830066390', 964, '', NULL, NULL, NULL, 0, '0', '', '', '', '', '', '', 0, 'USA', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 170, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363403363400126@g.us', '', 0, 1, NULL, b'0', 0, 0, 0, 0),
	(170, 'Mahattat Al Aalam UAE', '', 1, 971, 230, 'Dubai', 0, 'شركة محطات العالم لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'mcdcahmad@gmail.com', '560060160', 966, 'mcdcahmad@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', '', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 171, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363027901438947@g.us', '', 0, 1, 23, b'0', 0, 0, 0, 0),
	(171, 'Rakb Contract MOFA Enjaz', '', 3, 1, 507, 'NEW YORK', 0, '', '', '', '', 6, 0, 1, 0, 'rakb@virgo-sy.com', 'Rakb@1234', '', '', 'rakb@virgo-sy.com', '563600945', 966, '', NULL, NULL, NULL, 0, '0', '', '', '', 'Rakb@1234', 'rakb@virgo-sy.com', '', 0, 'NEW YORK', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 172, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363042105049378@g.us', '', 0, 1, NULL, b'0', 0, 0, 0, 0),
	(172, 'ADAM SPAIN', 'ADAM', 1, 34, 407, 'MADRID', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'AMRO.ELBAZ@ADAMTRAVEL.NET', '5712347283', 1, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'MADRID', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 173, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '963966624766-1547152038@g.us', '', 1, 1, 3, b'0', 0, 0, 0, 0),
	(173, 'VIRGO ENJAZ', '', 3, 34, 407, 'MADRID', 0, '', '', '', '', 6, 0, 1, 0, 'visa@virgo-sy.com', 'Visa#123', '', '', 'visa@virgo-sy.com', '1012121146', 20, '', NULL, NULL, NULL, 0, '0', '', '', '', '', 'T', 'T', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 174, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '', '', 0, 1, NULL, b'0', 0, 0, 0, 0),
	(174, 'Amanos JAWHARAH \\ ALMAMORA SYR', '', 1, 963, 207, 'DAMASCUS', 0, 'شركة مجموعة المعمورة الدولية للتجارة', '', '', '', 6, 0, 1, 0, '', '', '', '', 'amanos@virgo-sy.com', '944213839', 963, 'shadi.amanous@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Shadi@544633', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 175, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363425886931429@g.us', '', 0, 1, 40, b'0', 869754, 228111, 52, 869754),
	(175, 'Amanos BAWABET MUSAFIR SYR', '', 1, 963, 207, 'DAMASCUS', 0, 'مؤسسة بوابة السفر لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'amanos@virgo-sy.com', '944213839', 963, 'shadi.amanous@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Shadi@544633', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 176, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363423407397498@g.us', '', 0, 1, NULL, b'0', 0, 0, 0, 0),
	(176, 'Rakb SERBIA', 'RAKB', 1, 381, 236, 'SARAJEVO', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'rakb@virgo-sy.com', '563600945', 966, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Virgo@123456', '', '', 0, 'SARAJEVO', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 177, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363042105049378@g.us', '', 1, 1, 5, b'0', 0, 0, 0, 0),
	(177, 'Beoot Al Shaam WALID ALZAID', 'BEOOT', 1, 963, 207, 'DAMASCUS', 0, 'شركة ديار المدينة لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'biyoutalsham@virgo-sy.com', '534399977', 966, 'Tr1326q@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'TrB123456789#', '', '', 0, 'DAMASCUS', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 178, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363419114415993@g.us', '', 0, 1, 17, b'1', 870092, 228125, 52, 870092),
	(178, 'Beoot Al Shaam Special ticket / Bright SYR', 'BEOOT', 1, 963, 207, 'DAMASCUS', 0, '', '', '', '', 6, 0, 1, 0, '', '', '', '', 'biyoutalsham@virgo-sy.com', '534399977', 966, 'Tr1326q@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Tr123456789#', '', '', 0, 'DAMASCUS', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 179, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363419114415993@g.us', '', 0, 1, 17, b'0', 0, 0, 0, 0),
	(179, 'VATAKSI KAZAKHSTAN RAKB', 'VATAKSI', 1, 7001, 334, 'KAZAKHSTAN', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'vataksi@virgo-sy.com', '693334356', 355, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', '', '', '', 0, 'KAZAKHSTAN', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 180, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363029114809528@g.us', '', 1, 1, 16, b'0', 0, 0, 0, 0),
	(180, 'AMANOUS \\ ALTALBIA \\ RAWABI SYR', 'AMANOUS', 1, 963, 207, 'DAMASCUS', 0, '', '', '', '', 6, 0, 1, 0, '', '', '', '', 'amanos@virgo-sy.com', '944213839', 963, 'shadi.amanous@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Shadi@544633', '', '', 0, 'DAMASCUS', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 181, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363425947494674@g.us', '', 0, 1, 40, b'0', 0, 0, 0, 0),
	(181, 'NOOR ALMAARIF BAKR IRQ', 'NOOR', 1, 964, 203, 'BAGHDAD', 0, 'مؤسسة بكر سالم باسنبل لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'nour_almaaref@virgo-sy.com', '7830066390', 964, 'hxnx17hxnx17hxnx17hxnx@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Hh959@h959h995', '', '', 0, 'BAGHDAD', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 182, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363403363400126@g.us', '', 0, 1, 46, b'0', 0, 0, 0, 0),
	(182, 'Beoot Al Sham Al-Azem Mahatat', 'Beoot', 1, 963, 207, 'DAMASCUS', 0, 'شركة محطات العالم لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'biyoutalsham@virgo-sy.com', '534399977', 966, 'Tr1326q@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Tr123456789#\n', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 183, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363419114415993@g.us', '', 1, 1, 17, b'0', 876446, 228290, 52, 876446),
	(183, 'Beoot Al Shaam BASIM QADRY IRQ', 'Beoot', 1, 964, 203, 'BAGHDAD', 0, 'شركة المسار الفندقي المحدودة', '', '', '', 6, 0, 1, 0, '', '', '', '', 'biyoutalsham@virgo-sy.com', '534399977', 966, 'Tr1326q@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', '', '', '', 0, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 184, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363419114415993@g.us', '', 1, 1, 17, b'0', 887926, 225377, 58, 887926),
	(184, 'AMANOUS FADI / AWTAD SYR', 'AMANOUS', 1, 963, 207, 'DAMASCUS', 0, '', '', '', '', 6, 0, 1, 0, '', '', '', '', 'amanos@virgo-sy.com', '944213839', 963, 'shadi.amanous@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Shadi@544633', '', '', 0, 'DAMASCUS', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 185, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363403561906646@g.us', '', 0, 1, 40, b'0', 0, 0, 0, 0),
	(185, 'VATAKSI USA', 'VATAKSI', 1, 1, 507, 'USA', 0, 'شركة الركب المميز لخدمات المعتمرين', '', '', '', 6, 0, 1, 0, '', '', '', '', 'vataksi@virgo-sy.com', '693334356', 355, 'visa@virgo-sy.com', NULL, NULL, NULL, 0, '0', '', '', '', '', '', '', 0, 'USA', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 186, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363029114809528@g.us', '', 1, 1, 16, b'0', 0, 0, 0, 0),
	(186, 'Amanos Kiwan / Nigm Al Asema SYR', 'AMANOUS', 1, 963, 207, 'DAMASCUS', 0, 'شركة نجم العاصمة لتشغيل الفنادق', '', '', '', 6, 0, 1, 0, '', '', '', '', 'amanos@virgo-sy.com', '944213839', 963, 'shadi.amanous@gmail.com', NULL, NULL, NULL, 0, '0', '', '', '', 'Shadi@544633', '', '', 0, 'DAMASCUS', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '', '', 44, 187, NULL, NULL, '', 0, '', '', NULL, NULL, 0, '120363424668855284@g.us', '', 1, 1, 40, b'1', 888090, 228891, 52, 888090);


-- Step 3: Map and insert into new contracts table
INSERT INTO contracts (
    id, contract_name, username, contract_type, is_active, status,
    embassy_id, group_name_prefix, whatsapp_group_id, email,
    country_code, phone_number, city, primary_client_id,
    umrah_company_id, tourism_company_id, created_at, updated_at
)
SELECT 
    o.Id,
    COALESCE(NULLIF(o.Name, ''), 'Unnamed Contract') AS contract_name,
    COALESCE(NULLIF(o.username, ''), CONCAT('user_', o.Id)) AS username,
    CASE o.account_type
        WHEN 1 THEN 'umrah'
        WHEN 2 THEN 'hajj'
        WHEN 3 THEN 'external'
        WHEN 4 THEN 'tourism'
        ELSE 'umrah'
    END AS contract_type,
    COALESCE(o.is_active, 1) = 1 AS is_active,
    'pending' AS status,
    NULLIF(o.embassy_id, 0) AS embassy_id,
    NULLIF(o.GroupPrefix, '') AS group_name_prefix,
    COALESCE(
        (SELECT id FROM whatsapp_groups WHERE group_id = o.connection LIMIT 1),
        1
    ) AS whatsapp_group_id,
    COALESCE(
        NULLIF(o.tasheel_email, ''),
        NULLIF(o.username, ''),
        CONCAT('contract', o.Id, '@example.com')
    ) AS email,
    CASE
        WHEN o.res_phone_country > 0 THEN CONCAT('+', o.res_phone_country)
        ELSE '+966'
    END AS country_code,
    COALESCE(
        NULLIF(o.tasheel_phone, ''),
        NULLIF(o.OnlineVisaPhone, ''),
        '0'
    ) AS phone_number,
    NULLIF(o.address_city, '') AS city,
    1 AS primary_client_id,
    NULL AS umrah_company_id,
    NULL AS tourism_company_id,
    NOW() AS created_at,
    NOW() AS updated_at
FROM tmp_tbl_contract o
WHERE (o.is_deleted = 0 OR o.is_deleted IS NULL)
ON DUPLICATE KEY UPDATE
    contract_name = VALUES(contract_name),
    username = VALUES(username),
    contract_type = VALUES(contract_type),
    is_active = VALUES(is_active),
    embassy_id = VALUES(embassy_id),
    group_name_prefix = VALUES(group_name_prefix),
    whatsapp_group_id = VALUES(whatsapp_group_id),
    email = VALUES(email),
    country_code = VALUES(country_code),
    phone_number = VALUES(phone_number),
    city = VALUES(city),
    updated_at = NOW();

-- Step 4: Clean up temporary table (optional - it's temporary so will be dropped automatically when session ends)
DROP TEMPORARY TABLE IF EXISTS tmp_tbl_contract;
