apartments with roof for rent

select * from Mls where ID in (232448,231014,9350,228110,225612,115638,221507,221266,218147,218064,174272,216267,216268,216069,216070,215953,110961,215473,215280,215281,215282,161102,165500,199094,199977,72048,213750,155990,167618,167617,203653,213341,211668,209923,207694,209508,99615,206736,206124,205935,203325,203321,203437,203323,203320,201317,201314,201241,199896,199900,199090,199093,199016,165938,197838,55066,197108,195231,194837,193030,179657,190519,187427,185417,185244,185245,185246,185253,182484,182485,180936,180232,180123,180144,180038,178279,176019,79697,86062,174273,173283,172655,170683,75322,99007,99707,105846,107201,164428,164426,156305,155127,92325,146411,147421,146793,165443,155108,157618,165446,114965,163407,162450,37742,161520,161161,161164,160717,154707,153648,157441,157953,157950,32405,151850,100594,101198,105878,143690,143219,143025,141695,141517,141316,140774,140778,140403,140343,140334,137361,137319,137321,134949,134870,134871,89734,132264,132265,73029,127586,127525,126587,127211,126167,20880,120818,117485,118989,118372,115910,115681,118183,113425,113474,105258,113036,112984,112933,111815,110734,111189,111174,110861,110578,110265,105166,93633,103104,102820,32372,101763,100535,100214,100063,89866,89867,99568,99569,99570,98168,87325,97402,62318,62288,92498,60196,71634,41972,61706,8797,43804,38815,66791,19337,36073,53592,73410,72059,71686,71197) ORDER BY FIELD(ID, 232448,231014,9350,228110,225612,115638,221507,221266,218147,218064,174272,216267,216268,216069,216070,215953,110961,215473,215280,215281,215282,161102,165500,199094,199977,72048,213750,155990,167618,167617,203653,213341,211668,209923,207694,209508,99615,206736,206124,205935,203325,203321,203437,203323,203320,201317,201314,201241,199896,199900,199090,199093,199016,165938,197838,55066,197108,195231,194837,193030,179657,190519,187427,185417,185244,185245,185246,185253,182484,182485,180936,180232,180123,180144,180038,178279,176019,79697,86062,174273,173283,172655,170683,75322,99007,99707,105846,107201,164428,164426,156305,155127,92325,146411,147421,146793,165443,155108,157618,165446,114965,163407,162450,37742,161520,161161,161164,160717,154707,153648,157441,157953,157950,32405,151850,100594,101198,105878,143690,143219,143025,141695,141517,141316,140774,140778,140403,140343,140334,137361,137319,137321,134949,134870,134871,89734,132264,132265,73029,127586,127525,126587,127211,126167,20880,120818,117485,118989,118372,115910,115681,118183,113425,113474,105258,113036,112984,112933,111815,110734,111189,111174,110861,110578,110265,105166,93633,103104,102820,32372,101763,100535,100214,100063,89866,89867,99568,99569,99570,98168,87325,97402,62318,62288,92498,60196,71634,41972,61706,8797,43804,38815,66791,19337,36073,53592,73410,72059,71686,71197) LIMIT 0,20
Table 'Mls' is marked as crashed and should be repaired