duplex with roof mountain view

select * from Mls where ID in (231246,213514,169654,179432,171566,170419,168290,162756,160615,156887,129520,38944,141073,136809,128496,123841,108821,64804,88463,87064,62648,33188,42296,40120,116970,203620,232285,232245,231754,230975,230977,230787,230619,230616,230453,230253,230254,225420,231449,228700,228621,197922,228461,226093,227176,227175,227173,228392,169116,228311,92890,92888,227836,228076,176655,196767,196763,196644,196643,186827,219797,219889,219794,219320,228030,228020,228019,225773,231368,227792,227791,174415,227724,227703,227489,229208,225289,225153,111686,224917,73506,224808,224800,224678,224605,224606,224378,224379,224307,223778,223784,223696,210626,223649,136060,223443,213941,223324,223223,223225,222920,222922,222923,222629,222715,222679,222688,217379,218898,222101,222103,221965,221634,107218,107013,221495,221496,229042,221393,204715,221349,221155,221157,221094,221096,220507,220829,220751,220758,228992,220117,219916,219920,219627,219699,219640,219619,219159,219161,218920,218922,218896,218451,218435,218436,217902,217876,217881,217607,216952,227476,216659,216296,216278,215142,215741,215747,215510,215177,215178,215160,215143,214761,21076,137816,142590,214452,214042,213986,213746,213200,213474,213355,213202,213153,213022,212911,212089,202771,211555,211557,211748,210364,210372,210354,209848,209508,209485,209043,208613,207650,207468,207471,197836,197833,197839,197799,197805,197807,207391) ORDER BY FIELD(ID, 231246,213514,169654,179432,171566,170419,168290,162756,160615,156887,129520,38944,141073,136809,128496,123841,108821,64804,88463,87064,62648,33188,42296,40120,116970,203620,232285,232245,231754,230975,230977,230787,230619,230616,230453,230253,230254,225420,231449,228700,228621,197922,228461,226093,227176,227175,227173,228392,169116,228311,92890,92888,227836,228076,176655,196767,196763,196644,196643,186827,219797,219889,219794,219320,228030,228020,228019,225773,231368,227792,227791,174415,227724,227703,227489,229208,225289,225153,111686,224917,73506,224808,224800,224678,224605,224606,224378,224379,224307,223778,223784,223696,210626,223649,136060,223443,213941,223324,223223,223225,222920,222922,222923,222629,222715,222679,222688,217379,218898,222101,222103,221965,221634,107218,107013,221495,221496,229042,221393,204715,221349,221155,221157,221094,221096,220507,220829,220751,220758,228992,220117,219916,219920,219627,219699,219640,219619,219159,219161,218920,218922,218896,218451,218435,218436,217902,217876,217881,217607,216952,227476,216659,216296,216278,215142,215741,215747,215510,215177,215178,215160,215143,214761,21076,137816,142590,214452,214042,213986,213746,213200,213474,213355,213202,213153,213022,212911,212089,202771,211555,211557,211748,210364,210372,210354,209848,209508,209485,209043,208613,207650,207468,207471,197836,197833,197839,197799,197805,197807,207391) LIMIT 0,20
Table 'Mls' is marked as crashed and should be repaired