apartment with room

select * from Mls where ID in (220224,227631,224905,230315,230320,223709,78985,123795,203261,203260,203719,203750,175565,121259,138783,147297,172076,157960,155076,122896,154134,154121,152150,78836,121037,143791,143787,133930,133936,132206,130570,126224,125523,124878,124813,121024,103247,113902,113801,112865,81232,101085,90953,91136,86349,85168,75507,72114,13298,26303,33901,36198,36768,37900,37901,14929,229172,230093,220094,230860,229847,230983,229217,227240,206442,229178,218572,229969,230424,230652,225234,230939,230670,226981,224653,229866,225697,211058,225539,70919,208247,230505,230617,211064,228808,230076,211697,221188,216432,229041,221812,230539,228937,230484,229660,229164,230833,230623,230407,230732,55861,107986,230537,229083,202932,229957,230781,223268,163358,225915,208799,229015,225307,203001,223645,201849,229924,230651,213193,148272,171260,39212,229797,96949,230606,229262,222722,229701,178013,228651,223440,187370,186533,230829,42585,225720,171182,203485,228109,64221,219907,181127,229329,159843,178159,207266,223626,230915,86651,221929,208827,222283,220468,203125,212313,153700,207304,139062,200702,221267,226979,163830,64541,105064,184840,155247,225796,218708,151573,216980,209305,203879,173959,115350,87346,94618,190371,220017,224794,222505,170402,207450,225050,229162,228689,226973,228815,225715,225252,221166,223048,229139,222276,204389,133375,201221,104861,173935,229149,217870) ORDER BY FIELD(ID, 220224,227631,224905,230315,230320,223709,78985,123795,203261,203260,203719,203750,175565,121259,138783,147297,172076,157960,155076,122896,154134,154121,152150,78836,121037,143791,143787,133930,133936,132206,130570,126224,125523,124878,124813,121024,103247,113902,113801,112865,81232,101085,90953,91136,86349,85168,75507,72114,13298,26303,33901,36198,36768,37900,37901,14929,229172,230093,220094,230860,229847,230983,229217,227240,206442,229178,218572,229969,230424,230652,225234,230939,230670,226981,224653,229866,225697,211058,225539,70919,208247,230505,230617,211064,228808,230076,211697,221188,216432,229041,221812,230539,228937,230484,229660,229164,230833,230623,230407,230732,55861,107986,230537,229083,202932,229957,230781,223268,163358,225915,208799,229015,225307,203001,223645,201849,229924,230651,213193,148272,171260,39212,229797,96949,230606,229262,222722,229701,178013,228651,223440,187370,186533,230829,42585,225720,171182,203485,228109,64221,219907,181127,229329,159843,178159,207266,223626,230915,86651,221929,208827,222283,220468,203125,212313,153700,207304,139062,200702,221267,226979,163830,64541,105064,184840,155247,225796,218708,151573,216980,209305,203879,173959,115350,87346,94618,190371,220017,224794,222505,170402,207450,225050,229162,228689,226973,228815,225715,225252,221166,223048,229139,222276,204389,133375,201221,104861,173935,229149,217870) LIMIT 0,20
Table 'Mls' is marked as crashed and should be repaired