﻿-- select count(*) as total_all
-- from ho_hotel_master;
-- 
-- select count(*) as total_direct
-- from ho_hotel_master hm
-- inner join (
--     select distinct hm.hotel_code
--     from ho_hotel_master hm
--     where 1 = 1
--       and exists (
--         select 1
--         from vd_vendor_hotel_contract vvhc
--         where vvhc.hotel_code = hm.hotel_code
--     )
-- ) d_hotel on hm.hotel_code = d_hotel.hotel_code
--          inner join bs_country_code cc on hm.country_code = cc.country_code
--          left join bs_region_code region on hm.region_code = region.region_code
-- where 1 = 1
-- ;
-- 877853 / 5228

SELECT DISTINCT HM.HOTEL_CODE AS ELLISHOTELCODE,
    LEGACY.VENDOR_HOTEL_CODE AS LEGACYHOTELCODE,
    LEGACY.VENDOR_HOTEL_CODE AS ELLISCOMPCODE,
    HM.HOTEL_NAME_EN AS ALICEHOTELNAME,
    EXPEDIA.VENDOR_HOTEL_CODE AS EXPEDIACODE,
    HOTELBED.VENDOR_HOTEL_CODE AS HOTELBEDCODE,
    AGODA.VENDOR_HOTEL_CODE AS AGODACODE,
    DOTW.VENDOR_HOTEL_CODE AS DOTWCODE,
    FITRUUMS.VENDOR_HOTEL_CODE AS FITRUUMSCODE,
    DIDA.VENDOR_HOTEL_CODE AS DIDACODE,
    RAKUTEN.VENDOR_HOTEL_CODE AS RAKUTENCODE,
    CC.COUNTRY_CODE AS COUNTRYCODE,
    CC.COUNTRY_NAME_EN AS COUNTRYNAME,
    REGION.REGION_CODE AS CITYCODE,
    REGION.REGION_NAME_EN AS CITYNAME,
    HM.ADDRESS_EN AS HOTELADDRESSEN,
    CONCAT(
            HM.STAR_RATING,
            ' ',
            CASE
                WHEN HM.STAR_RATING <> '0.0'
                    AND HM.STAR_RATING <> '1.0' THEN 'STARS'
                ELSE 'STAR'
            END
    ) AS STARRATING,
    HM.LONGITUDE AS LONGITUDE,
    HM.LATITUDE AS LATITUDE
FROM HO_HOTEL_MASTER HM
INNER JOIN (
    SELECT DISTINCT HM.HOTEL_CODE
    FROM HO_HOTEL_MASTER HM
    WHERE 1 = 1
      AND EXISTS (
        SELECT 1
        FROM VD_VENDOR_HOTEL_CONTRACT VVHC
        WHERE VVHC.HOTEL_CODE = HM.HOTEL_CODE
    )
) D_HOTEL ON HM.HOTEL_CODE = D_HOTEL.HOTEL_CODE
INNER JOIN BS_COUNTRY_CODE CC ON HM.COUNTRY_CODE = CC.COUNTRY_CODE
LEFT JOIN BS_REGION_CODE REGION ON HM.REGION_CODE = REGION.REGION_CODE
LEFT JOIN LATERAL (
  SELECT VHM.VENDOR_HOTEL_CODE, VHM.VENDOR_COMP_CODE
  FROM VD_VENDOR_HOTEL_MAPPING VHM
  INNER JOIN VD_VENDOR_HOTEL_MASTER VVHM ON VVHM.VENDOR_HOTEL_CODE = VVHM.VENDOR_HOTEL_CODE
      AND VVHM.VENDOR_COMP_CODE = VHM.VENDOR_COMP_CODE
      AND VVHM.DELETE_YN = 'N'
  INNER JOIN US_COMP_MASTER CM ON VHM.VENDOR_COMP_CODE = CM.COMP_CODE
  WHERE 1 = 1
    AND VHM.HOTEL_CODE = HM.HOTEL_CODE
    AND VHM.VENDOR_COMP_CODE = 110000
  LIMIT 1
) LEGACY ON TRUE
LEFT JOIN LATERAL (
  SELECT VHM.VENDOR_HOTEL_CODE
  FROM VD_VENDOR_HOTEL_MAPPING VHM
           INNER JOIN VD_VENDOR_HOTEL_MASTER VVHM ON VVHM.VENDOR_HOTEL_CODE = VVHM.VENDOR_HOTEL_CODE
      AND VVHM.VENDOR_COMP_CODE = VHM.VENDOR_COMP_CODE
      AND VVHM.DELETE_YN = 'N'
           INNER JOIN US_COMP_MASTER CM ON VHM.VENDOR_COMP_CODE = CM.COMP_CODE
  WHERE 1 = 1
    AND VHM.HOTEL_CODE = HM.HOTEL_CODE
    AND VHM.VENDOR_COMP_CODE != 110000
    AND VHM.VENDOR_COMP_CODE = 910001
  LIMIT 1
) EXPEDIA ON TRUE
LEFT JOIN LATERAL (
  SELECT VHM.VENDOR_HOTEL_CODE
  FROM VD_VENDOR_HOTEL_MAPPING VHM
           INNER JOIN VD_VENDOR_HOTEL_MASTER VVHM ON VVHM.VENDOR_HOTEL_CODE = VVHM.VENDOR_HOTEL_CODE
      AND VVHM.VENDOR_COMP_CODE = VHM.VENDOR_COMP_CODE
      AND VVHM.DELETE_YN = 'N'
           INNER JOIN US_COMP_MASTER CM ON VHM.VENDOR_COMP_CODE = CM.COMP_CODE
  WHERE 1 = 1
    AND VHM.HOTEL_CODE = HM.HOTEL_CODE
    AND VHM.VENDOR_COMP_CODE != 110000
    AND VHM.VENDOR_COMP_CODE = 910002
  LIMIT 1
) HOTELBED ON TRUE
LEFT JOIN LATERAL (
  SELECT VHM.VENDOR_HOTEL_CODE
  FROM VD_VENDOR_HOTEL_MAPPING VHM
  INNER JOIN VD_VENDOR_HOTEL_MASTER VVHM ON VVHM.VENDOR_HOTEL_CODE = VVHM.VENDOR_HOTEL_CODE
      AND VVHM.VENDOR_COMP_CODE = VHM.VENDOR_COMP_CODE
      AND VVHM.DELETE_YN = 'N'
  INNER JOIN US_COMP_MASTER CM ON VHM.VENDOR_COMP_CODE = CM.COMP_CODE
  WHERE 1 = 1
    AND VHM.HOTEL_CODE = HM.HOTEL_CODE
    AND VHM.VENDOR_COMP_CODE != 110000
    AND VHM.VENDOR_COMP_CODE = 910003
  LIMIT 1
) AGODA ON TRUE
LEFT JOIN LATERAL (
  SELECT VHM.VENDOR_HOTEL_CODE
  FROM VD_VENDOR_HOTEL_MAPPING VHM
  INNER JOIN VD_VENDOR_HOTEL_MASTER VVHM ON VVHM.VENDOR_HOTEL_CODE = VVHM.VENDOR_HOTEL_CODE
      AND VVHM.VENDOR_COMP_CODE = VHM.VENDOR_COMP_CODE
      AND VVHM.DELETE_YN = 'N'
  INNER JOIN US_COMP_MASTER CM ON VHM.VENDOR_COMP_CODE = CM.COMP_CODE
  WHERE 1 = 1
    AND VHM.HOTEL_CODE = HM.HOTEL_CODE
    AND VHM.VENDOR_COMP_CODE != 110000
    AND VHM.VENDOR_COMP_CODE = 910004
  LIMIT 1
) DOTW ON TRUE
LEFT JOIN LATERAL (
  SELECT VHM.VENDOR_HOTEL_CODE
  FROM VD_VENDOR_HOTEL_MAPPING VHM
           INNER JOIN VD_VENDOR_HOTEL_MASTER VVHM ON VVHM.VENDOR_HOTEL_CODE = VVHM.VENDOR_HOTEL_CODE
      AND VVHM.VENDOR_COMP_CODE = VHM.VENDOR_COMP_CODE
      AND VVHM.DELETE_YN = 'N'
           INNER JOIN US_COMP_MASTER CM ON VHM.VENDOR_COMP_CODE = CM.COMP_CODE
  WHERE 1 = 1
    AND VHM.HOTEL_CODE = HM.HOTEL_CODE
    AND VHM.VENDOR_COMP_CODE != 110000
    AND VHM.VENDOR_COMP_CODE = 910005
  LIMIT 1
) FITRUUMS ON TRUE
LEFT JOIN LATERAL (
  SELECT VHM.VENDOR_HOTEL_CODE
  FROM VD_VENDOR_HOTEL_MAPPING VHM
           INNER JOIN VD_VENDOR_HOTEL_MASTER VVHM ON VVHM.VENDOR_HOTEL_CODE = VVHM.VENDOR_HOTEL_CODE
      AND VVHM.VENDOR_COMP_CODE = VHM.VENDOR_COMP_CODE
      AND VVHM.DELETE_YN = 'N'
           INNER JOIN US_COMP_MASTER CM ON VHM.VENDOR_COMP_CODE = CM.COMP_CODE
  WHERE 1 = 1
    AND VHM.HOTEL_CODE = HM.HOTEL_CODE
    AND VHM.VENDOR_COMP_CODE != 110000
    AND VHM.VENDOR_COMP_CODE = 910016
  LIMIT 1
) DIDA ON TRUE
LEFT JOIN LATERAL (
  SELECT VHM.VENDOR_HOTEL_CODE
  FROM VD_VENDOR_HOTEL_MAPPING VHM
           INNER JOIN VD_VENDOR_HOTEL_MASTER VVHM ON VVHM.VENDOR_HOTEL_CODE = VVHM.VENDOR_HOTEL_CODE
      AND VVHM.VENDOR_COMP_CODE = VHM.VENDOR_COMP_CODE
      AND VVHM.DELETE_YN = 'N'
           INNER JOIN US_COMP_MASTER CM ON VHM.VENDOR_COMP_CODE = CM.COMP_CODE
  WHERE 1 = 1
    AND VHM.HOTEL_CODE = HM.HOTEL_CODE
    AND VHM.VENDOR_COMP_CODE != 110000
    AND VHM.VENDOR_COMP_CODE = 910023
  LIMIT 1
) RAKUTEN ON TRUE
WHERE 1 = 1
ORDER BY HM.COUNTRY_CODE;


-- Without direct
SELECT distinct HM.HOTEL_CODE AS EllisHotelCode,
    Legacy.VENDOR_HOTEL_CODE AS LegacyHotelCode,
    Legacy.VENDOR_HOTEL_CODE AS EllisCompCode,
    HM.HOTEL_NAME_EN AS AliceHotelName,
    Expedia.VENDOR_HOTEL_CODE AS ExpediaCode,
    HotelBed.VENDOR_HOTEL_CODE AS HotelbedCode,
    Agoda.VENDOR_HOTEL_CODE AS AgodaCode,
    Dotw.VENDOR_HOTEL_CODE AS DOTWCode,
    Fitruums.VENDOR_HOTEL_CODE AS FitruumsCode,
    Dida.VENDOR_HOTEL_CODE AS DidaCode,
    Rakuten.VENDOR_HOTEL_CODE AS RakutenCode,
    CC.COUNTRY_CODE AS CountryCode,
    CC.COUNTRY_NAME_EN AS CountryName,
    REGION.REGION_CODE AS CityCode,
    REGION.REGION_NAME_EN AS CityName,
    HM.ADDRESS_EN AS HotelAddressEn,
    CONCAT(
            HM.STAR_RATING,
            ' ',
            CASE
                WHEN HM.STAR_RATING <> '0.0'
                    AND HM.STAR_RATING <> '1.0' THEN 'Stars'
                ELSE 'Star'
            END
    ) AS StarRating,
    HM.LONGITUDE AS Longitude,
    HM.LATITUDE AS Latitude
FROM HO_HOTEL_MASTER HM
INNER JOIN BS_COUNTRY_CODE CC ON HM.COUNTRY_CODE = CC.COUNTRY_CODE
LEFT JOIN BS_REGION_CODE REGION ON HM.REGION_CODE = REGION.REGION_CODE
LEFT JOIN LATERAL (
  SELECT VHM.VENDOR_HOTEL_CODE, VHM.VENDOR_COMP_CODE
  FROM VD_VENDOR_HOTEL_MAPPING VHM
  INNER JOIN VD_VENDOR_HOTEL_MASTER VVHM ON VVHM.VENDOR_HOTEL_CODE = VVHM.VENDOR_HOTEL_CODE
      AND VVHM.VENDOR_COMP_CODE = VHM.VENDOR_COMP_CODE
      AND VVHM.DELETE_YN = 'N'
  INNER JOIN US_COMP_MASTER CM ON VHM.VENDOR_COMP_CODE = CM.COMP_CODE
  WHERE 1 = 1
    AND VHM.HOTEL_CODE = HM.HOTEL_CODE
    AND VHM.VENDOR_COMP_CODE = 110000
  LIMIT 1
) Legacy ON TRUE
LEFT JOIN LATERAL (
  SELECT VHM.VENDOR_HOTEL_CODE
  FROM VD_VENDOR_HOTEL_MAPPING VHM
           INNER JOIN VD_VENDOR_HOTEL_MASTER VVHM ON VVHM.VENDOR_HOTEL_CODE = VVHM.VENDOR_HOTEL_CODE
      AND VVHM.VENDOR_COMP_CODE = VHM.VENDOR_COMP_CODE
      AND VVHM.DELETE_YN = 'N'
           INNER JOIN US_COMP_MASTER CM ON VHM.VENDOR_COMP_CODE = CM.COMP_CODE
  WHERE 1 = 1
    AND VHM.HOTEL_CODE = HM.HOTEL_CODE
    AND VHM.VENDOR_COMP_CODE != 110000
    AND VHM.VENDOR_COMP_CODE = 910001
  LIMIT 1
) Expedia ON TRUE
LEFT JOIN LATERAL (
  SELECT VHM.VENDOR_HOTEL_CODE
  FROM VD_VENDOR_HOTEL_MAPPING VHM
           INNER JOIN VD_VENDOR_HOTEL_MASTER VVHM ON VVHM.VENDOR_HOTEL_CODE = VVHM.VENDOR_HOTEL_CODE
      AND VVHM.VENDOR_COMP_CODE = VHM.VENDOR_COMP_CODE
      AND VVHM.DELETE_YN = 'N'
           INNER JOIN US_COMP_MASTER CM ON VHM.VENDOR_COMP_CODE = CM.COMP_CODE
  WHERE 1 = 1
    AND VHM.HOTEL_CODE = HM.HOTEL_CODE
    AND VHM.VENDOR_COMP_CODE != 110000
    AND VHM.VENDOR_COMP_CODE = 910002
  LIMIT 1
) HotelBed ON TRUE
LEFT JOIN LATERAL (
  SELECT VHM.VENDOR_HOTEL_CODE
  FROM VD_VENDOR_HOTEL_MAPPING VHM
  INNER JOIN VD_VENDOR_HOTEL_MASTER VVHM ON VVHM.VENDOR_HOTEL_CODE = VVHM.VENDOR_HOTEL_CODE
      AND VVHM.VENDOR_COMP_CODE = VHM.VENDOR_COMP_CODE
      AND VVHM.DELETE_YN = 'N'
  INNER JOIN US_COMP_MASTER CM ON VHM.VENDOR_COMP_CODE = CM.COMP_CODE
  WHERE 1 = 1
    AND VHM.HOTEL_CODE = HM.HOTEL_CODE
    AND VHM.VENDOR_COMP_CODE != 110000
    AND VHM.VENDOR_COMP_CODE = 910003
  LIMIT 1
) Agoda ON TRUE
LEFT JOIN LATERAL (
  SELECT VHM.VENDOR_HOTEL_CODE
  FROM VD_VENDOR_HOTEL_MAPPING VHM
  INNER JOIN VD_VENDOR_HOTEL_MASTER VVHM ON VVHM.VENDOR_HOTEL_CODE = VVHM.VENDOR_HOTEL_CODE
      AND VVHM.VENDOR_COMP_CODE = VHM.VENDOR_COMP_CODE
      AND VVHM.DELETE_YN = 'N'
  INNER JOIN US_COMP_MASTER CM ON VHM.VENDOR_COMP_CODE = CM.COMP_CODE
  WHERE 1 = 1
    AND VHM.HOTEL_CODE = HM.HOTEL_CODE
    AND VHM.VENDOR_COMP_CODE != 110000
    AND VHM.VENDOR_COMP_CODE = 910004
  LIMIT 1
) Dotw ON TRUE
LEFT JOIN LATERAL (
  SELECT VHM.VENDOR_HOTEL_CODE
  FROM VD_VENDOR_HOTEL_MAPPING VHM
           INNER JOIN VD_VENDOR_HOTEL_MASTER VVHM ON VVHM.VENDOR_HOTEL_CODE = VVHM.VENDOR_HOTEL_CODE
      AND VVHM.VENDOR_COMP_CODE = VHM.VENDOR_COMP_CODE
      AND VVHM.DELETE_YN = 'N'
           INNER JOIN US_COMP_MASTER CM ON VHM.VENDOR_COMP_CODE = CM.COMP_CODE
  WHERE 1 = 1
    AND VHM.HOTEL_CODE = HM.HOTEL_CODE
    AND VHM.VENDOR_COMP_CODE != 110000
    AND VHM.VENDOR_COMP_CODE = 910005
  LIMIT 1
) Fitruums ON TRUE
LEFT JOIN LATERAL (
  SELECT VHM.VENDOR_HOTEL_CODE
  FROM VD_VENDOR_HOTEL_MAPPING VHM
           INNER JOIN VD_VENDOR_HOTEL_MASTER VVHM ON VVHM.VENDOR_HOTEL_CODE = VVHM.VENDOR_HOTEL_CODE
      AND VVHM.VENDOR_COMP_CODE = VHM.VENDOR_COMP_CODE
      AND VVHM.DELETE_YN = 'N'
           INNER JOIN US_COMP_MASTER CM ON VHM.VENDOR_COMP_CODE = CM.COMP_CODE
  WHERE 1 = 1
    AND VHM.HOTEL_CODE = HM.HOTEL_CODE
    AND VHM.VENDOR_COMP_CODE != 110000
    AND VHM.VENDOR_COMP_CODE = 910016
  LIMIT 1
) Dida ON TRUE
LEFT JOIN LATERAL (
  SELECT VHM.VENDOR_HOTEL_CODE
  FROM VD_VENDOR_HOTEL_MAPPING VHM
           INNER JOIN VD_VENDOR_HOTEL_MASTER VVHM ON VVHM.VENDOR_HOTEL_CODE = VVHM.VENDOR_HOTEL_CODE
      AND VVHM.VENDOR_COMP_CODE = VHM.VENDOR_COMP_CODE
      AND VVHM.DELETE_YN = 'N'
           INNER JOIN US_COMP_MASTER CM ON VHM.VENDOR_COMP_CODE = CM.COMP_CODE
  WHERE 1 = 1
    AND VHM.HOTEL_CODE = HM.HOTEL_CODE
    AND VHM.VENDOR_COMP_CODE != 110000
    AND VHM.VENDOR_COMP_CODE = 910023
  LIMIT 1
) Rakuten ON TRUE
WHERE 1 = 1
  AND HM.HOTEL_CODE NOT IN (100140,100301,100321,100628,100741,101336,101393,101658,101781,101842,101864,102416,102862,102887,102977,103124,103137,103332,103503,103521,103770,103784,103785,103809,103913,103972,103973,103984,104009,104022,104153,104233,104269,104444,104920,105021,105294,105433,105508,105671,105948,105978,106442,106503,106580,106620,106697,106718,106772,107553,107697,107742,107793,107922,107989,107993,108098,108111,108267,108367,108522,108620,108690,108692,108712,108718,108739,108838,108844,108878,109032,109056,109310,109429,109431,109567,109801,109838,110031,110144,110444,110592,110653,110699,110745,110945,111110,111430,111689,112108,112222,112405,112558,112587,113186,113300,113460,113687,113786,114080,114638,114974,114996,115003,115346,115411,115538,116388,116630,116633,116762,116889,116929,117326,117389,117699,117703,117776,117852,117983,118063,118382,118555,118685,118691,118712,118725,118836,119040,119087,119178,119381,119394,119613,119638,119842,119845,119846,119848,120015,120047,120049,120081,120168,120317,120318,120319,120378,120526,120535,120853,120915,120959,121053,121186,121566,121575,121855,122998,123205,123207,123217,123220,123230,123379,123477,123489,123628,123671,123722,123831,123834,123855,123969,124162,124176,124181,124357,124416,124556,124615,124621,124746,124873,125107,125194,125892,126034,126141,126163,126251,126417,126418,126745,126868,126875,126997,127729,128038,128211,128245,128309,128320,128336,128459,128479,128738,128743,128860,128870,129022,129066,129220,129322,129339,129423,129798,130073,130088,130092,130281,130321,130438,130443,130592,130692,130728,130730,130820,130959,131154,131351,131463,131688,131745,131809,132077,132079,132246,132349,132380,132744,132958,132992,133137,133355,133428,133430,133602,133730,133794,133850,133990,133995,134017,134035,134043,134158,134164,134165,134332,134440,134680,135056,135307,135413,135654,135685,135755,135790,135813,135814,135972,136213,136598,136687,136823,136884,137004,137031,137537,137564,137673,138179,138187,138589,138678,138681,138953,138995,139022,139237,139441,139605,139723,139857,139868,139874,139962,140072,140152,140164,140216,140482,140590,140598,141043,141069,141139,141246,141441,141458,141613,141666,141826,141841,142032,142040,142178,142206,142226,142240,142346,142500,142730,142900,143171,143269,143373,143569,143642,143921,144346,144992,144994,145288,145392,145408,145467,145471,145472,145473,145503,145543,145737,145750,145867,146130,146184,146252,146309,146418,146455,146531,146620,146709,147098,147102,147885,147890,148117,148139,148276,148319,148336,148742,148755,148762,148779,148783,148809,148899,148917,148926,149207,150005,150021,150312,150477,150589,150747,150794,150920,150921,150928,150950,151154,151204,151221,151282,151318,151526,151539,152029,152032,152047,152335,152356,152461,152599,152636,152644,152931,153009,153016,153173,153244,153342,153381,153383,153537,153681,153696,154088,154098,154135,154145,154286,154326,154352,154391,154402,154454,154588,154599,154922,155204,155227,155234,155549,155613,155693,155719,155806,155808,155844,155916,156049,156227,156245,156286,156355,156459,156476,156586,156954,156956,156959,156968,157142,157395,157425,157889,158046,158050,158060,158197,158310,158387,158581,158724,158743,158753,158761,158776,158883,159090,159091,159571,159612,159635,159877,160024,160126,160145,160315,160450,160465,160467,160579,160823,161134,161220,161249,161250,161253,161458,161624,161758,161954,162082,162091,162253,162279,162376,162579,162673,162705,163030,163405,163408,163522,163705,163775,164172,164192,164194,164276,164418,164419,164568,164665,164884,165002,165005,165251,165280,165510,165524,165753,166251,166831,166915,166921,166923,166968,167034,167121,167170,167185,167327,167349,167365,167371,167495,167501,167529,167534,167970,168043,168085,168187,168438,168447,168469,168556,168607,168617,168622,168751,168766,168770,168777,168780,168934,168971,169115,169324,169327,169330,169331,169332,169333,169424,169432,169449,169455,169585,169592,169628,170079,170139,170289,170311,170579,170799,170902,171101,171108,171127,171255,171539,171693,171840,172122,172795,173045,173096,174106,174145,174218,174246,174276,174427,174642,174722,174754,174813,175167,175525,175549,176015,176165,176187,176338,176344,176494,176496,176653,176688,176895,176923,177037,177103,177110,177159,177240,177280,177301,177327,177485,177660,177689,177735,177763,177766,177954,177974,178422,178651,178788,178803,178898,178907,178910,178912,179004,179015,179156,179157,179294,179620,179741,179743,179835,180137,180627,180819,181225,181491,181914,181933,182082,182089,182092,182397,182429,182488,182492,182502,182504,182506,182712,182868,182883,183181,183330,183499,183542,183629,183775,183784,183899,183901,184497,184640,184649,184655,184757,184870,184883,185472,185624,185813,185815,185924,185928,185936,185954,185962,185984,185987,185988,185992,186018,186024,186028,186037,186040,186043,186044,186048,186050,186051,186052,186054,186055,186088,186093,186098,186102,186110,186112,186113,186123,186124,186136,186139,186146,186149,186162,186163,186164,186192,186204,186207,186240,186329,186529,186530,186669,186786,186794,186814,186892,186983,187040,187233,187261,187289,187431,187477,187583,187586,187644,187664,187697,187722,187756,187881,188088,188104,188121,188139,188147,188213,188300,188336,188346,188350,188358,188474,188670,189357,189410,189411,189555,189626,189699,189788,189789,189791,189830,189906,189937,190570,190599,190838,191013,191137,191202,191216,191581,191625,191632,192069,192303,192506,192578,192751,192826,192950,193147,193198,193206,193320,193440,194029,194090,194167,194205,194383,194538,194540,194617,194665,194712,194789,194836,194872,195040,195231,195242,195247,195422,195430,195441,195462,195615,195626,195909,195938,195984,196372,196474,196478,196504,196724,197065,197242,197290,197472,197952,198024,198204,198284,198506,198664,198749,198976,199018,199222,199223,199349,199639,200346,200395,200411,200593,200653,200805,201208,201356,201367,201394,201508,201511,201623,201673,201716,201735,201855,201902,202080,202270,202293,202415,202825,202884,203074,203206,203592,203609,203612,203617,203618,203644,203877,204439,204529,204734,204892,204895,204903,204960,204965,205021,205117,205128,205172,205305,205389,205491,205521,205575,205765,206238,206390,206571,206592,206752,206762,206836,206900,207063,207104,207113,207461,207929,208126,208292,208498,208576,208582,208759,208855,209006,209069,209213,209291,209458,209463,209529,209716,209759,209775,209927,209933,210089,210097,210290,210331,210450,210490,210667,210758,210759,210896,211021,211147,211193,211196,211197,211449,211619,211632,211854,211857,211863,211970,211971,211973,212208,212319,212838,212882,212889,212912,212968,213116,213121,213124,213135,213141,213156,213170,213310,213319,213349,213396,213522,213561,213579,213583,213786,214057,214105,214266,214359,214717,214867,214896,215370,215377,215404,215678,215829,215859,216412,216859,217192,217527,217546,217842,218013,218035,218054,218057,218487,218557,219304,219464,219606,219622,219670,220362,220370,220405,220413,220477,220639,220641,220644,220645,220651,220656,220660,221033,221097,221119,221185,221219,221234,221250,221273,221292,221832,221841,221924,222113,222117,222119,222345,222639,222715,222923,223036,223265,223406,223444,223753,224011,224125,224422,224688,224985,225364,225650,225658,225664,225942,226461,226668,226803,226872,227005,227022,227059,227252,227260,227282,227315,227343,227348,227374,228017,228075,228203,228291,228339,228350,228488,228624,228950,229136,229424,229432,229439,229505,229506,229742,229754,230210,230241,230267,230461,230637,230685,230967,231026,231083,231465,231679,232020,232233,232409,232481,232780,233320,233349,233508,233567,233996,234437,234704,234743,234774,234815,234816,234826,234830,235093,235094,235199,235485,235796,235806,235852,236459,237000,237348,237572,237729,237774,237798,238052,238236,238321,238496,238504,238893,239030,239224,239590,239626,239677,239682,239683,239871,240275,240460,240714,240797,241059,241092,241590,241800,242515,242713,242839,243310,244109,244349,244473,244978,244993,245025,245306,245322,245359,245563,245631,245636,245922,246225,246233,246234,246896,247257,247600,247930,248357,248385,248535,248577,249038,249179,249334,249494,249661,249704,249745,249769,249954,249986,250361,250368,250438,250520,251289,251294,251296,251324,251345,251392,251396,251435,251468,251471,251475,251667,251794,251940,252178,252179,252180,252203,252225,252317,252708,252711,252745,252780,252838,252839,253211,253451,253653,254053,254100,254116,254516,255001,255454,255496,255898,256315,256791,256805,257717,257719,257865,258816,259832,261231,261233,261437,262421,262574,262604,262620,262946,263017,263044,263079,263562,263586,263607,263619,264114,264249,264330,264561,264582,265026,265265,265574,267496,267600,268105,268648,268692,268990,270205,270238,270333,270383,270502,270784,270966,271462,271463,271869,271969,272367,272821,273085,273157,273852,273869,273886,275010,275511,275515,275522,275773,275779,275805,275825,276134,276216,276961,277038,277092,277427,277456,277469,277521,277587,277839,278351,278356,279046,279200,279205,279206,279393,279909,280059,281160,281171,281621,281952,282012,282016,282018,282250,282738,283138,283894,284132,284632,284695,285019,285030,285737,285743,285887,285936,285954,286433,286440,286455,286524,286836,287839,287865,287908,288294,289389,289398,289649,290000,290001,290041,290050,290054,290509,290571,291053,291425,291604,291718,291726,292076,292115,292135,292150,292710,293012,293686,293893,293897,293904,293908,293937,294391,294499,294644,294898,294899,295858,295965,296228,297078,297152,297173,297187,297890,297918,297925,297971,298579,298621,298712,298993,299239,299497,300364,300834,301473,301517,301540,301648,302081,302179,302253,302265,302274,302861,303014,303089,303538,304459,304517,305277,305287,306035,306043,306406,306587,306762,306950,307637,307652,307825,308675,308694,309261,309683,310129,310741,311268,311373,312495,312715,312718,312720,313384,313408,313413,313663,313736,313741,313742,313743,313745,313747,313748,313749,313751,313752,313896,313956,314298,314384,314477,314567,314663,314719,314853,314996,315004,315259,315269,315278,316279,316797,316914,317112,317354,317724,318394,318514,318986,319299,319950,320024,320149,320740,320766,321443,322063,322070,322836,322935,322999,323044,323299,323357,323484,323875,323998,324001,324074,325120,325411,325517,325522,325530,325652,325741,325767,326028,326032,326327,326335,326338,326360,326362,326576,326590,326591,326596,326608,326695,327163,327376,327464,327688,327758,327807,328180,328219,328291,328336,328353,328762,328853,329003,329182,329648,329740,329837,330121,330252,330266,330287,330369,330376,330668,330994,331055,331235,331264,331379,331383,331627,332116,332635,332764,332909,333151,333184,333319,333712,333933,333936,334016,334150,334343,334704,335268,335351,335818,336847,336891,336918,336955,338046,338137,338206,338701,339342,339818,340339,340732,340734,340818,341434,341836,342534,342565,342573,342580,342701,342851,342931,342965,343053,343060,343061,343062,343262,343468,343476,343478,343584,344038,344064,344114,344132,344271,344353,344354,344355,344368,344374,344378,344379,344428,344433,344907,345022,345933,346069,346141,346482,346934,346945,347051,347422,348186,348226,348402,348407,348745,349142,349367,349804,349893,350569,350682,350684,350700,350702,350847,351162,351183,351216,351721,352043,352081,352505,352556,352666,353293,353408,353411,353431,353542,353707,353821,353829,353957,354224,354250,354423,354771,355677,355803,355840,356449,356529,356680,356779,357405,357547,357548,357640,357641,357872,358121,358193,358199,358526,359638,359780,359863,359879,360206,360214,360216,360256,360260,360265,360272,360274,360277,360281,360415,360900,361092,361097,361430,361432,361438,361664,361752,362201,362210,363840,364714,365564,365917,365955,366306,366845,366933,367381,367464,367732,368042,368130,368134,368165,368219,369431,370286,370379,370496,370634,371685,371799,372421,372426,372455,372590,373032,373056,373514,373529,373586,374179,374753,375333,375385,375397,376997,377380,378125,378127,378357,378585,378722,379839,379991,380027,381550,382019,382428,382609,383149,383151,383622,384165,385033,385557,385576,386435,386497,387146,387150,387541,387558,387561,387949,388003,388082,388183,388184,388544,389337,389343,389347,389409,389454,389744,389883,389987,390164,390362,390798,391201,391251,391286,391490,391757,392098,392168,392229,392230,392255,392257,392278,393335,393354,393568,394871,395218,395714,396043,396280,396766,396775,396823,396841,396843,396844,396874,397267,397706,397853,398300,399549,399985,399992,399995,400688,401118,401242,401320,401573,401833,402167,402187,402312,402583,402602,402621,402627,402632,402696,403836,403837,403838,403845,404223,404232,404246,404283,404336,404749,404804,404828,405497,405520,406232,406470,407210,407219,407908,407978,407986,407989,408830,408940,408951,408988,409102,409119,409897,410063,410100,410625,410632,410680,410686,411051,411053,411099,411872,412356,412372,412375,412428,412519,412746,412951,412995,413723,413724,413756,414432,414951,415170,416089,416111,416182,416600,416704,417502,418944,418946,418947,418950,418953,418957,418958,418960,418962,419416,419511,419874,419923,419931,420551,420655,420874,420882,421150,421151,421154,421156,421157,421197,421727,421808,422748,423328,423329,423335,423357,423381,423757,424001,424144,424683,424714,424719,425378,426465,426822,426823,427468,427520,427869,428467,428606,428611,429051,429057,429060,429061,429062,429065,429066,429067,429069,429071,429077,429083,429084,429085,429087,429088,429091,429094,429111,429112,429115,429118,429119,429120,429507,429605,429661,430279,430289,430294,430596,430600,430820,431206,431339,431433,432509,433310,434359,434955,435030,435069,435294,435815,436126,436506,436517,436522,436572,436809,437182,437305,437493,437824,437833,437834,437838,437846,437860,438138,438199,438410,438417,439389,440324,440638,440673,440683,440696,441346,441369,442044,442536,443247,443914,444681,444713,444730,445166,445254,445257,445266,445282,445473,445935,445968,445993,446570,446676,447021,447131,447469,447479,447483,447486,447495,447548,447791,447916,447996,448023,448116,448640,448771,449217,449303,449411,449593,449715,449914,450433,450577,451125,451684,452660,453378,453535,453536,454036,455262,455920,455941,455970,456043,456084,456198,456453,456492,456612,456692,456788,456912,457653,457951,457980,459062,459348,459431,459763,459819,459827,459830,460431,460453,460628,460658,460759,460955,461240,461992,462768,462790,463001,463009,463591,463623,464255,464310,464470,465070,465740,465797,465943,466430,467054,467145,467736,467873,467880,467882,468442,468444,468615,469053,469093,469629,469743,469767,469892,469959,470259,471157,471327,471576,471951,471966,471970,471974,472647,472848,472850,472881,473238,473348,473476,473483,473501,473503,473506,473516,473542,474040,474054,474697,474711,475008,475246,476288,476306,476376,477339,477559,477560,478140,478764,478795,479750,480127,480327,480449,480899,480925,481471,481557,481981,482162,482588,483977,484129,485551,485609,485674,486495,486635,486741,487486,488974,490101,490129,490800,490870,490959,491061,491068,491170,491201,491204,491209,491224,491318,493408,494015,494808,494876,495055,495836,495849,495856,496425,496470,496472,496986,497015,497098,497131,497438,497700,497875,498209,498266,498861,499180,499226,499234,499236,499250,499257,499265,499278,499296,499401,500160,500680,500746,500756,500760,500813,501207,501270,501280,501283,501284,501285,501438,501454,501701,501961,502114,502349,502381,502383,502390,502576,502665,502870,502971,503223,503613,503724,503729,503730,503742,504134,504257,504303,504308,504315,504648,504649,504688,505625,505644,506256,506308,506309,506400,506408,506820,508153,508493,508628,508650,508720,509069,509080,509759,509950,510007,510767,511252,511392,511425,512550,512837,512936,513076,513115,513253,513420,513723,513837,513856,514286,514372,514381,514454,514621,514735,515486,516190,516220,517161,517329,517761,517878,518624,518666,518739,518743,519120,519255,519279,519308,519310,519365,519368,519922,519929,519935,519945,519962,519967,520032,520509,520510,520511,520512,520518,520614,520706,520730,521035,521558,521616,521626,522136,522562,523027,523050,523268,523396,523400,523414,523453,523806,523841,523968,524305,524322,524344,524637,525291,525542,525607,525619,526307,526764,526922,526924,527191,527237,527244,527246,527248,527264,527630,527633,527641,527657,527758,528092,528098,528108,528109,528117,528122,528124,528131,528132,528134,528135,528136,528152,528153,528390,528403,528586,528681,528713,528725,528726,528727,528734,528770,528919,528935,529160,529805,529809,529997,530592,530612,530633,530641,530646,530748,530749,530751,530816,530818,530829,530840,531806,531807,531809,531834,532412,532424,532534,532604,532716,533544,534188,534247,534282,535099,535196,535283,535395,535415,536243,536337,536499,537057,537112,537387,537405,537623,537839,537895,538301,538559,538755,538797,539198,539403,539429,539483,540340,541165,541894,542529,542953,542981,543549,543732,543772,543900,544387,545466,546278,546336,547236,547360,547470,547554,547587,548576,548975,549005,549020,549025,549140,549300,549332,549540,549541,549596,549962,549993,550216,550522,550552,550615,551205,551293,551296,551299,551303,551305,551313,551424,551425,551436,551440,551528,551630,551693,551715,551716,551722,551726,551813,552124,552170,552207,552755,552889,552933,553607,553608,553609,553616,553618,553642,553644,553645,553647,553649,553668,554158,554160,554161,554162,554171,554175,554180,554181,554182,554235,554255,554268,554535,554553,554747,554765,555081,555101,555248,555540,555874,556176,556243,556271,556613,557191,557812,558012,558281,558508,558517,559223,559441,559450,559493,559811,559837,560394,560397,560411,560442,560495,560692,560787,560796,560804,560808,560809,560814,560817,560840,560917,560918,560919,560921,560953,561062,561102,561146,561161,561162,561163,561177,561736,562318,563020,564280,564282,565157,565333,566162,566163,566165,566735,566737,566741,567179,567245,567304,567573,567760,567782,567784,568671,569239,569251,569253,569258,569892,570012,570827,571157,572261,573438,573526,574042,574653,574693,574695,574784,574852,574859,574860,575069,575070,575071,575072,575252,575259,575272,575273,575336,575338,575339,575340,575390,575925,576406,576534,576578,576650,576948,577004,577219,577257,577261,577262,577265,577270,577276,577277,577279,577281,577324,577631,577632,577834,577974,578565,578772,578822,578836,578884,579204,580015,580023,580133,580384,580446,580498,580499,580508,580988,580991,580993,581029,581030,581241,581245,581258,581361,581365,581367,581375,581656,581659,581660,581662,581695,581728,582443,582592,582898,582934,583253,583291,583393,583807,584172,584277,584344,584450,584461,585033,585080,585259,586541,586543,586685,586690,586865,587819,588002,588032,588877,589295,589791,590053,591012,591019,591036,591458,591690,591696,592349,598271,598273,598278,598288,598296,598301,598401,599328,599412,600311,600624,600635,600750,600885,600986,601042,601152,601154,601230,601512,602095,602100,602173,602976,603362,603629,603634,603667,603701,603709,603766,604229,604325,604358,604362,604402,604432,604433,604478,604601,604760,604766,604775,604927,604962,604987,605359,605499,605518,605599,605762,605766,605837,605978,606106,606109,606110,606113,606114,606209,607761,607901,607907,609301,609368,609938,609940,609951,610764,610896,611442,611568,612242,613057,613721,614653,614825,614972,616579,617016,617024,617078,618002,618139,619502,620350,620397,620477,621521,621522,621535,621562,621839,622960,622969,622974,624620,625904,627755,627776,627801,627821,628224,628346,628463,628469,628472,628473,628609,628632,628733,628784,629123,629343,629467,629507,629565,629843,630008,630061,630109,630128,630130,630132,630562,631042,631106,631117,631120,631121,631145,632044,633334,633769,633937,633945,634384,634506,634704,636119,636222,636467,636468,636469,636892,636918,638241,638314,638797,638812,640151,640638,640640,641717,641726,642814,642827,643919,645725,645816,645826,645889,645897,645898,646439,646615,646971,647877,647975,648819,649152,649378,649716,649842,649878,649913,649980,650121,650522,650982,650995,651064,651328,651342,651446,651568,652226,652230,652346,652439,652567,652986,653072,653594,653599,653603,653987,654178,654185,654455,654465,654986,655320,655329,655880,656401,656414,656424,656745,656748,656750,657034,657040,657050,657112,657202,657323,657358,657814,657845,657855,657862,657901,658173,658174,658187,658207,658258,658665,658861,658915,659011,659023,659027,659030,659082,659200,659257,659422,659432,659436,659541,659548,659629,660031,660110,660267,660428,660653,660891,661030,661170,661318,661324,661481,661489,662122,662130,662162,662313,662338,662366,662371,662525,662532,662751,662842,662930,662977,663111,663227,663228,663277,663510,663530,664368,664422,664484,664486,664496,664502,664615,665050,665068,665121,665136,665138,665143,665175,665197,665430,665707,665798,665814,665816,665910,665938,665977,666273,666437,666473,666588,666604,666671,666719,666762,666858,666864,667092,667093,667095,667096,667097,667129,667130,667135,667204,667271,667590,667714,667756,668286,668467,668474,668798,668883,668955,669132,669230,669994,670101,670235,670322,670609,670738,670848,670941,671018,671078,671084,671098,671101,671109,671165,671191,671194,671396,671519,671602,671651,671688,671728,671763,671881,672042,672134,672210,672232,672608,672798,673081,673161,673162,673163,673164,674035,674046,674598,674611,674749,674753,674941,675008,675033,675046,675050,675061,675271,675278,675297,675385,675463,675729,676002,676138,676463,676732,677173,678107,678328,678367,678402,678429,678537,678552,678661,678724,678756,678806,678934,678951,678962,678968,678973,678979,678981,679025,679081,679106,679297,679348,679349,679351,679352,679353,679501,679642,679785,679786,680538,680600,680785,680801,680891,681047,681112,681255,681577,681582,681648,682144,682145,682147,682156,682157,682161,682226,682358,682378,682597,682598,682655,682770,682771,682794,682810,682967,683585,683601,683661,683757,683784,683977,683988,684027,684070,684336,684379,684383,684426,684427,684802,684813,684898,685113,685120,685129,685166,685169,685210,685349,685364,685548,685675,685690,685781,685832,685849,685853,686787,687052,687083,687199,687215,687229,687238,687260,687271,687288,687481,687595,687645,687671,687899,688014,688257,688650,688726,688848,689011,689014,689016,689020,689039,689337,689339,689665,689695,689746,690000,690021,690185,690215,690216,690220,690222,690356,690873,690902,691119,691720,692132,692203,692274,692359,692577,692763,692868,692882,692974,693092,693132,693293,693299,693300,693301,693393,693395,693397,693407,693419,693460,693461,693640,693641,693797,693932,693996,693998,693999,694000,694029,694030,694031,694080,694373,694498,694507,694513,694580,694725,695409,695740,695883,696398,696427,696467,696469,696600,696609,696707,696817,696913,697228,697633,697800,697879,698354,698376,698551,698750,698758,698877,698882,698913,698987,699000,699110,699116,699239,699240,699414,699476,699961,699970,700008,700117,700118,700132,700322,700609,700996,701109,701118,701244,701520,702932,702960,702984,702996,703002,703029,703078,703088,703093,703108,703313,703315,703316,703318,703319,703441,703444,703707,703729,703806,704067,704218,704264,704544,704614,704697,704779,704817,705080,705084,705258,705264,705460,705555,705669,705733,705750,705877,706539,706687,706948,707037,707110,707238,707518,707579,707633,707724,708016,708117,708470,708544,708548,708562,708640,709121,709523,709542,710138,710233,710258,710260,710546,710647,710790,710936,711340,711343,711472,711699,711778,711820,711876,711980,712350,712479,712551,712837,712868,713257,713369,713373,713510,713750,714102,714410,714457,714509,714793,714906,714965,714999,715891,717581,717671,717685,717688,717690,717783,717796,717812,717930,718119,718219,718220,718262,718398,718561,718566,718614,718651,718661,718973,719446,719454,719457,719460,719655,719775,719822,720107,720436,720469,720569,720612,720646,720667,720754,720794,720834,720964,721141,721144,721224,721404,721492,721671,721740,721746,721827,722532,722848,722934,723080,723141,723247,723355,723371,723471,724121,724195,724236,724245,724249,724351,724366,724447,724674,724707,724759,724765,724766,724768,724769,724770,725141,725146,725152,725156,725158,725217,725331,725610,725669,725676,725686,725692,725693,726209,727374,727434,727532,727749,727896,728013,728878,728887,728958,728998,729011,729045,729647,729652,729675,730283,730289,730886,730925,731026,731036,731054,731117,731199,731365,731811,731827,731844,731902,731926,731963,732120,732161,732162,732164,732266,732316,732374,732447,732463,733100,733187,733188,733189,733645,733705,733770,734087,734430,734680,735052,735442,735572,735584,735676,735687,736175,736316,736508,736681,736775,736864,737165,737238,737946,737948,738569,738625,738637,738638,738639,738640,738641,738661,738667,738972,739073,739197,739324,739348,739498,739504,739600,739778,739791,739826,739866,740280,740559,740581,740979,741441,741450,741474,741824,742119,742162,742776,743932,744337,745635,745711,746261,746262,746325,746964,747818,747994,748079,748544,748654,748760,748774,748972,749031,749044,749271,749362,749379,749412,749441,749483,749754,749871,749903,749945,750081,750083,750097,750103,751255,751454,751524,751525,751526,751527,752114,752162,752163,752257,752333,752558,753136,753232,753644,753753,753884,754031,754056,754183,754193,754489,754548,754644,754870,755093,755136,755649,755934,757185,757463,761280,761405,763082,763368,763545,763552,763554,763901,764010,764066,764173,764481,764608,764831,765178,765185,765423,765522,765549,766082,766214,766498,766503,766985,767009,768123,768379,768401,768491,768527,768541,769284,769520,770017,770234,770847,771029,771061,771064,771066,771072,771079,772156,772250,772390,772655,773339,773940,774181,774284,774492,774957,775121,775483,776717,776961,777083,777206,777329,777354,777726,778213,778219,778342,778369,778445,778495,778643,778882,778975,779057,779281,779282,779322,779836,779989,780057,780384,780385,780401,780444,780481,780884,781097,781143,781269,781288,781306,781347,781352,781634,781786,781789,781847,782079,782423,782858,783020,783148,783234,784936,784941,784943,785325,785328,785448,785450,785597,785732,785885,786082,786114,786342,786361,786523,786650,786669,786674,786769,787632,787650,787700,787759,787951,788177,788230,788426,788446,788458,788854,789044,789066,789173,789361,789364,789705,790132,790372,790470,790969,790971,791116,791165,791678,792361,793071,793233,793334,793509,794051,794080,794192,794203,794600,795186,795664,796075,796662,797360,797808,797850,798579,798697,798710,798724,798746,798863,799131,799169,799290,799401,799522,799524,799679,799689,799708,799934,800156,800353,800385,800389,800769,801890,802516,802618,802698,803104,803157,803227,803306,803313,803344,803552,803556,803644,803715,804172,804180,804445,804721,804749,804763,804863,805285,805287,805289,805467,805524,806067,807150,807239,807240,807450,807588,807595,807665,807766,808062,808064,808077,808143,808145,808464,809241,809360,809430,809883,809933,810062,810310,810334,810520,810532,810554,810741,810775,811517,811623,811722,811727,811773,811972,812006,812154,812713,812953,813147,813172,813477,813517,813840,814564,815186,815755,815890,815935,821065,822278,822342,822535,822540,823142,823211,823510,823536,823547,824063,824419,825631,827093,827213,827642,827858,827865,828584,828977,829047,829061,829556,829557,829576,829579,829629,829725,829753,829797,830164,830168,830192,830275,830287,830297,830322,830414,830427,830434,830448,830457,830673,830884,831083,831451,831709,831931,831971,831975,832060,832208,832592,832853,833435,834072,834236,834245,834452,834458,834462,834463,834717,834721,835050,835055,835551,837258,837273,837662,837670,838102,838105,838296,838351,838438,838772,838775,838798,838932,839120,839176,839743,840322,840674,840678,842837,842879,844045,844267,845586,845809,845857,846010,846536,846894,847566,847644,847723,847841,847888,847898,848217,848249,848267,848498,848745,848936,849289,849443,849447,849646,849781,849784,850460,850535,850536,850641,850701,850709,850744,850759,850760,850800,850813,850884,850904,850989,850992,851015,851552,851607,851681,851688,851770,851973,852082,852202,852238,852301,852302,852364,852474,852475,852536,852675,852740,852748,852760,852801,852946,852990,853024,853137,853202,853380,853486,853564,853847,853931,853934,854051,854053,854069,854153,854167,854168,854197,854247,854268,854281,854483,855398,856565,856615,856763,856809,856815,856939,857037,857046,857139,857165,857204,857254,857326,857341,857411,857560,857634,857756,857808,857921,857930,857970,858031,858135,858137,858248,858373,858386,858406,858521,858522,858581,858622,858846,858928,859098,859332,859413,859473,859480,859499,859506,859617,859618,859624,859858,859887,860037,860124,860129,860363,860521,860531,860537,860678,860832,860842,861008,861010,861066,861081,861133,861138,861166,861216,861217,861230,861286,861301,861321,861482,861728,862436,862591,862782,862798,886424,886426,886427,886428,886429,886430,886431,886432,886433,886434,886435,886436,886437,886438,886439,886440,886441,886442,886443,886444,886445,886446,886447,886448,886449,886450,886451,886452,886453,886454,886455,886456,886457,886458,886459,886460,886461,886462,886463,886464,886465,886466,886467,886468,886469,886470,886471,886472,886473,886474,886475,886476,886477,886478,886479,886480,886481,886482,886483,886484,886485,886486,886487,886488,886489,886490,886491,886492,886493,886494,886495,886496,886497,886498,886499,886500,886501,886502,886503,886504,886505,886506,886507,886508,886509,886510,886511,886552,886553,886554,886555,886556,886557,886558,886559,886560,886561,886562,886563,886564,886565,886566,886567,886568,886569,886570,886583,886584,886585,886586,886587,886588,886589,886590,886591,886592,886593,886594,886595,886596,886597,886598,886599,886600,886601,886602,886603,886604,886605,886606,886607,886608,886609,886610,886611,886612,886613,886614,886615,886616,886617,886618,886619,886620,886621,886622,886623,886624,886625,886626,886627,886648,886649,886650,886651,886652,886653,886654,886655,886656,886657,886658,886659,886660,886661,886662,886663,886665,886675,887520,888319,889356,889790,889847,890757,891190,891506,891835,892028,892162,892185,892342,892379,892477,892998,893016,894000,894865,895866,896292,896330,896487,897580,897734,898221,898871,899193,899305,899333,900167,900856,901975,902197,903033,903471,903501,903669,904173,904201,904700,905282,905345,905769,905840,905906,905968,906024,906169,906279,906917,907596,907625,907731,907898,908119,908247,908868,908875,908993,913420,913516,913981,915564,916009,922560,922643,922955,931048,931429,931585,931843,932954,933034,933502,934403,944183,944589,944880,945516,945851,945879,945906,947519,947576,948072,948560,949099,949510,949752,950041,950409,950476,951542,952058,952616,952668,952963,953402,953517,953646,953661,953810,954719,955045,955146,955301,955303,955469,955512,955674,955750,956297,956597,956887,957064,958373,959446,959965,960064,960243,960244,960245,960246,960247,960248,960249,960250,960251,960252,960253,960254,960255,960256,960451,960486,960577,961490,961494,961769,961807,961902,962278,962658,962663,963252,963273,963279,963521,963663,964849,965612,965691,966727,966805,966909,967926,968721,968817,969348,969554,969876,970001,970334,970517,971516,971517,971518,971519,971520,971521,971826,971827,971828,972368,972401,972911,973319,973649,974437,974687,974801,975082,975393,975630,975902,975962,976560,977208,977968,978481,978987,979162,980041,981847,982747,982748,982749,982750,982751,982752,982753,982755,982756,982757,982758,982759,982760,982761,982762,982763,982764,982765,982766,982767,982768,982769,982770,982771,982772,982773,982774,982775,982776,982777,982778,982779,982780,982781,982782,982783,982784,982785,982786,982787,982788,982789,982790,982791,982792,982793,982808,982816,983087,983114,983115,983116,983117,983118,983119,983120,983121,983122,983123,983124,983125,983126,983127,983128,983129,983130,983131,983132,983133,983134,983182,983681,983921,983955,984723,985004,985233,985234,985235,985236,985237,985238,985239,985422,987241,987627,988125,992943,993644,993666,994000,994048,994225,994913,995620,995713,995714,995715,995716,995717,995718,995719,995720,995721,995722,995723,995724,995725,995726,995727,995728,995729,995730,995731,995732,995733,995744,995745,995746,995747,995748,995749,995750,995961,995967,996179,996462,996903,997034,997147,997148,997816,998230,998568,998961,999166,1000101,1000102,1000103,1000104,1000105,1000106,1000107,1000108,1000109,1000110,1000111,1000112,1000113,1000114,1000115,1000253,1000427,1000476,1000706,1000755,1000766,1001022,1001023,1001024,1001026,1001027,1001028,1001029,1001030,1001031,1001033,1001035,1001040,1001041,1001042,1001044,1001045,1001046,1001047,1001048,1001049,1001053,1001054,1001055,1001056,1001057,1001058,1001059,1001060,1001061,1001062,1001063,1001064,1001065,1001066,1001067,1001068,1001069,1001070,1001071,1001072,1001075,1001076,1001077,1001078,1001079,1001080,1001081,1001082,1001083,1001084,1001085,1001086,1001087,1001088,1001090,1001091,1001092,1001093,1001094,1001095,1001096,1001097,1001098,1001099,1001100,1001101,1001102,1001103,1001105,1001106,1001107,1001108,1001177,1001184,1001185,1001186,1001187,1001188,1001189,1001190,1001191,1001192,1001193,1001194,1001195,1001196,1001197,1001198,1001199,1001200,1001201,1001202,1001203,1001204,1001205,1001206,1001207,1001209,1001210,1001211,1001212,1001213,1001215,1001216,1001217,1001218,1001219,1001220,1001221,1001222,1001223,1001225,1001227,1001228,1001229,1001230,1001231,1001232,1001233,1001234,1001235,1001236,1001237,1001238,1001239,1001241,1001242,1001243,1001244,1001245,1001246,1001247,1001248,1001249,1001252,1001253,1001255,1001256,1001257,1001258,1001259,1001260,1001261,1001263,1001265,1001266,1001268,1001271,1001274,1001276,1001277,1001278,1001279,1001280,1001281,1001282,1001283,1001284,1001285,1001286,1001288,1001289,1001290,1001291,1001292,1001293,1001294,1001295,1001296,1001297,1001298,1001299,1001300,1001301,1001302,1001305,1001306,1001308,1001309,1001310,1001311,1001312,1001313,1001314,1001315,1001316,1001317,1001318,1001319,1001320,1001321,1001322,1001323,1001324,1001325,1001326,1001327,1001328,1001329,1001330,1001331,1001332,1001333,1001334,1001335,1001336,1001337,1001338,1001339,1001340,1001341,1001344,1001345,1001346,1001347,1001348,1001349,1001350,1001352,1001353,1001354,1001355,1001356,1001357,1001358,1001359,1001360,1001361,1001362,1001363,1001364,1001365,1001366,1001367,1001368,1001369,1001370,1001371,1001372,1001373,1001374,1001375,1001376,1001377,1001379,1001380,1001381,1001382,1001383,1001384,1001385,1001386,1001389,1001390,1001391,1001392,1001393,1001394,1001395,1001396,1001397,1001398,1001399,1001400,1001401,1001402,1001403,1001404,1001405,1001406,1001407,1001408,1001409,1001410,1001411,1001412,1001413,1001414,1001415,1001416,1001417,1001418,1001419,1001420,1001421,1001422,1001423,1001424,1001425,1001428,1001429,1001431,1001432,1001433,1001434,1001435,1001436,1001439,1001440,1001441,1001442,1001443,1001444,1001445,1001446,1001447,1001448,1001449,1001450,1001451,1001452,1001453,1001454,1001455,1001456,1001457,1001458,1001459,1001460,1001461,1001462,1001463,1001464,1001465,1001466,1001467,1001468,1001469,1001470,1001471,1001472,1001473,1001474,1001475,1001476,1001477,1001478,1001480,1001482,1001483,1001484,1001485,1001487,1001488,1001489,1001490,1001491,1001492,1001493,1001494,1001495,1001496,1001497,1001498,1001499,1001500,1001501,1001502,1001503,1001504,1001505,1001506,1001507,1001508,1001509,1001510,1001511,1001513,1001514,1001515,1001516,1001517,1001518,1001519,1001520,1001521,1001522,1001523,1001524,1001525,1001526,1001527,1001528,1001529,1001530,1001531,1001532,1001533,1001534,1001535,1001536,1001537,1001538,1001539,1001540,1001541,1001542,1001543,1001544,1001545,1001546,1001547,1001548,1001549,1001550,1001552,1001553,1001554,1001555,1001556,1001557,1001558,1001559,1001560,1001561,1001562,1001563,1001564,1001565,1001566,1001567,1001568,1001569,1001570,1001571,1001572,1001573,1001574,1001575,1001576,1001577,1001578,1001579,1001580,1001581,1001582,1001583,1001584,1001585,1001586,1001587,1001588,1001589,1001590,1001591,1001593,1001594,1001595,1001596,1001597,1001598,1001599,1001600,1001601,1001602,1001603,1001604,1001605,1001606,1001607,1001608,1001609,1001610,1001611,1001612,1001613,1001614,1001616,1001617,1001618,1001619,1001620,1001621,1001622,1001623,1001624,1001625,1001626,1001627,1001628,1001629,1001630,1001631,1001632,1001633,1001634,1001635,1001636,1001637,1001638,1001639,1001640,1001641,1001642,1001643,1001644,1001646,1001647,1001648,1001649,1001650,1001651,1001652,1001653,1001654,1001655,1001656,1001657,1001658,1001659,1001660,1001661,1001662,1001663,1001664,1001665,1001666,1001667,1001668,1001669,1001670,1001671,1001672,1001673,1001675,1001676,1001677,1001678,1001679,1001680,1001681,1001682,1001683,1001684,1001685,1001686,1001687,1001688,1001690,1001691,1001692)
ORDER BY HM.COUNTRY_CODE;