chalets for sale sea view

select * from Mls where ID in (63197,106901,136537,130368,113730,112339,108502,200324,97581,191984,200396,197840,200251,199195,189180,191681,200478,166005,178009,76647,192417,84951,130952,193320,35361,135192,172653,197255,106434,82393,132564,183819,176083,126628,161846,197883,146896,157931,113782,159766,119765,123705,155216,64019,201041,201044,201065,201076,201085,201087,200429,200451,200328,200528,200530,200553,200551,200554,200064,200047,199971,199842,199843,199854,199856,199535,199472,199137,198947,198884,198896,198906,198908,198918,198919,198920,198341,198426,197857,197864,197860,197861,197863,197865,197871,197887,197804,197806,197719,197720,197721,197727,197703,197708,197715,197716,197700,197696,197626,197631,197665,197667,197668,197308,197309,197312,197247,197314,197586,197180,197684,197685,197590,197596,197598,197142,197690,196691,196985,196988,196694,196971,196853,196523,196526,196527,195961,196325,196164,196244,196107,196249,196190,196191,196194,195942,196195,195958,195960,195863,195869,195919,196283,195813,195700,195558,196263,195571,195707,195708,195711,195229,195043,194949,195802,195660,194886,194890,195673,195672,195675,195677,194893,194897,194900,194901,195807,193318,193270,193271,193279,113697,193283,192955,194517,194512,192960,192517,192523,192527,191981,192014,192031,192033,192038,192040,192289,192290,191206,191373,191380,191382,191234,189233,190849,194529,190609,190663,194433,190333) ORDER BY FIELD(ID, 63197,106901,136537,130368,113730,112339,108502,200324,97581,191984,200396,197840,200251,199195,189180,191681,200478,166005,178009,76647,192417,84951,130952,193320,35361,135192,172653,197255,106434,82393,132564,183819,176083,126628,161846,197883,146896,157931,113782,159766,119765,123705,155216,64019,201041,201044,201065,201076,201085,201087,200429,200451,200328,200528,200530,200553,200551,200554,200064,200047,199971,199842,199843,199854,199856,199535,199472,199137,198947,198884,198896,198906,198908,198918,198919,198920,198341,198426,197857,197864,197860,197861,197863,197865,197871,197887,197804,197806,197719,197720,197721,197727,197703,197708,197715,197716,197700,197696,197626,197631,197665,197667,197668,197308,197309,197312,197247,197314,197586,197180,197684,197685,197590,197596,197598,197142,197690,196691,196985,196988,196694,196971,196853,196523,196526,196527,195961,196325,196164,196244,196107,196249,196190,196191,196194,195942,196195,195958,195960,195863,195869,195919,196283,195813,195700,195558,196263,195571,195707,195708,195711,195229,195043,194949,195802,195660,194886,194890,195673,195672,195675,195677,194893,194897,194900,194901,195807,193318,193270,193271,193279,113697,193283,192955,194517,194512,192960,192517,192523,192527,191981,192014,192031,192033,192038,192040,192289,192290,191206,191373,191380,191382,191234,189233,190849,194529,190609,190663,194433,190333) LIMIT 0,20
Table 'Mls' is marked as crashed and should be repaired