duplex ground floor with first floor

select * from Mls where ID in (183983,95816,225813,222457,107642,217059,217062,217064,213048,168758,206645,206766,206762,206697,206703,201315,201026,112592,197262,105757,108544,194944,189412,189415,188091,188092,188093,188094,188095,182831,176743,176746,174550,170451,170457,170016,169729,152914,169100,155111,169531,149433,169223,169101,168940,168193,168192,168064,165263,159305,161581,161586,36340,161123,158412,157232,159212,119335,156707,156205,144475,152741,149454,147744,146776,146982,146780,146783,183845,142412,140396,112487,137269,134229,86885,62708,62707,41108,121611,112589,108230,46628,60188,33773,35899,35741,112205,110904,111355,111238,111067,109350,108381,108878,63793,105649,105638,103212,103173,69088,150387,89731,59926,89233,6554,48580,60905,76358,76837,52288,71249,68810,70400,68393,63795,61379,61247,60207,53856,58971,58542,49364,47242,35887,36206,36773,36772,32636,31519,31827,29829,25445,25704,25713,25969,26215,26234,26328,27415,27416,27563,28025,28245,29563,29699,29728,29742,29748,29774,29782,29951,30146,30606,30616,30781,30919,31123,31451,31823,31720,31972,32107,32483,33581,33629,33635,33809,33826,33832,33869,33965,36207,3138,6643,7066,224550,230693,226956,193922,208799,208827,224526,105064,184840,201221,214562,42323,195350,122557,106121,70568,183769,98120,183818,115967,204533,121327,221553,33468,125466) ORDER BY FIELD(ID, 183983,95816,225813,222457,107642,217059,217062,217064,213048,168758,206645,206766,206762,206697,206703,201315,201026,112592,197262,105757,108544,194944,189412,189415,188091,188092,188093,188094,188095,182831,176743,176746,174550,170451,170457,170016,169729,152914,169100,155111,169531,149433,169223,169101,168940,168193,168192,168064,165263,159305,161581,161586,36340,161123,158412,157232,159212,119335,156707,156205,144475,152741,149454,147744,146776,146982,146780,146783,183845,142412,140396,112487,137269,134229,86885,62708,62707,41108,121611,112589,108230,46628,60188,33773,35899,35741,112205,110904,111355,111238,111067,109350,108381,108878,63793,105649,105638,103212,103173,69088,150387,89731,59926,89233,6554,48580,60905,76358,76837,52288,71249,68810,70400,68393,63795,61379,61247,60207,53856,58971,58542,49364,47242,35887,36206,36773,36772,32636,31519,31827,29829,25445,25704,25713,25969,26215,26234,26328,27415,27416,27563,28025,28245,29563,29699,29728,29742,29748,29774,29782,29951,30146,30606,30616,30781,30919,31123,31451,31823,31720,31972,32107,32483,33581,33629,33635,33809,33826,33832,33869,33965,36207,3138,6643,7066,224550,230693,226956,193922,208799,208827,224526,105064,184840,201221,214562,42323,195350,122557,106121,70568,183769,98120,183818,115967,204533,121327,221553,33468,125466) LIMIT 0,20
Table 'Mls' is marked as crashed and should be repaired