ground floor chalets overlooking swimming pool

select * from Mls where ID in (106107,188095,126737,165068,164754,163617,156707,154412,36946,142984,62708,62707,104324,74982,32245,110999,35741,26019,25968,111238,151505,76875,75198,63364,51464,36206,36773,36772,30546,31625,26206,27223,27224,27358,27859,29894,30465,30548,30919,31121,31542,32043,32140,32271,32562,33575,33623,33825,33965,36207,231577,225813,231404,115454,223096,110998,220546,187164,216853,216858,107642,215627,106104,209470,209468,206276,153612,155119,166821,168758,183717,211799,212044,212045,212046,212047,212049,206645,206766,206762,204008,204103,204533,204295,204104,204102,203881,203780,210014,77154,198787,150342,113092,190756,189416,189072,105412,188566,188568,188574,194248,188227,188091,188092,188093,188094,186478,185949,185950,185951,185091,182606,93403,126736,177586,176743,176746,89559,178050,18573,171986,170451,170457,152914,155684,155446,168103,169661,168645,168643,168644,168445,119890,168107,168105,164766,163396,161437,148563,85975,160174,159983,159299,149347,149345,159165,156205,154662,154400,152843,127603,149812,127481,38295,37286,149348,96868,148566,147647,145899,10852,143294,143291,143487,142891,142412,142453,140571,140932,139694,139564,137615,100827,234795,136288,134929,134663,132085,131549,131281,131139,116544,129624,129489,128675,127945,33650,41108,124724,124096,32472,122981,121577,41560,121396,121012,111592,119891,119862,119820) ORDER BY FIELD(ID, 106107,188095,126737,165068,164754,163617,156707,154412,36946,142984,62708,62707,104324,74982,32245,110999,35741,26019,25968,111238,151505,76875,75198,63364,51464,36206,36773,36772,30546,31625,26206,27223,27224,27358,27859,29894,30465,30548,30919,31121,31542,32043,32140,32271,32562,33575,33623,33825,33965,36207,231577,225813,231404,115454,223096,110998,220546,187164,216853,216858,107642,215627,106104,209470,209468,206276,153612,155119,166821,168758,183717,211799,212044,212045,212046,212047,212049,206645,206766,206762,204008,204103,204533,204295,204104,204102,203881,203780,210014,77154,198787,150342,113092,190756,189416,189072,105412,188566,188568,188574,194248,188227,188091,188092,188093,188094,186478,185949,185950,185951,185091,182606,93403,126736,177586,176743,176746,89559,178050,18573,171986,170451,170457,152914,155684,155446,168103,169661,168645,168643,168644,168445,119890,168107,168105,164766,163396,161437,148563,85975,160174,159983,159299,149347,149345,159165,156205,154662,154400,152843,127603,149812,127481,38295,37286,149348,96868,148566,147647,145899,10852,143294,143291,143487,142891,142412,142453,140571,140932,139694,139564,137615,100827,234795,136288,134929,134663,132085,131549,131281,131139,116544,129624,129489,128675,127945,33650,41108,124724,124096,32472,122981,121577,41560,121396,121012,111592,119891,119862,119820) LIMIT 0,20
Table 'Mls' is marked as crashed and should be repaired