SELECT p.iPostID, p.iPostType, p.iAdType, p.iUserType, p.strTitle, p.iSubType, p.iItemType, p.iPrice, p.iPriceUnit, json_unquote(p.jsonLocation->"$.city") AS city, p.jsonExtra, p.tmPosted, p.iShowImg, p.strImages, p.strVideos, p.strPostURL FROM posts p WHERE p.iActive=1 AND iSubType=105 AND p.iAdType='2' AND p.iItemType='20' AND iCityID IN (8244,8279,8370,8228,6857,8339,8135,8074,8085,8138,8262,8209,8204,16176,8384,8105,8295,16177,8355,8298,8210,8208,8387,8125,8289,8265,8375,6861,8349,8259,8090,8133,16167,8037,8234,8070,8056,8179,8089,8374,8129,8309,8401,8376,8400,8277,8245,8320,8247,8109,8219,8143,8165,8369,16178,8278,8316,8251,8120,8182,8110,8049,13018,16182,8154,8117,8063,8310,8162,8134,8161,8111,16170,8078,8285,16169,8338,8079,8337,8122,12439,8261,8206,8284,16184,8118,8246,8366,8157,8365,12436,12406,8158,8264,8093,8389,12424,12441,8207,8287,12425,8126,8243,16173,8281,8035,12404,8361,8081,8256,8231,8257,8290,16183,8128,12429,8344,8300,8301,8053,12422,8051,8250,16175,12415,8168,8249,8202,12442,8330,8283,8100,12435,12437,16181,8385,12411,12414,16168,12407,8139,8166,12440,8302,12430,8276,8087,12426,12427,12431,16639,8282,8399,12443,8352,16644,12412,8226,16174,8178,12416,12423,8258,16590,8238,12413,8108) ORDER BY FIELD(iCityID, 8244,8279,8370,8228,6857,8339,8135,8074,8085,8138,8262,8209,8204,16176,8384,8105,8295,16177,8355,8298,8210,8208,8387,8125,8289,8265,8375,6861,8349,8259,8090,8133,16167,8037,8234,8070,8056,8179,8089,8374,8129,8309,8401,8376,8400,8277,8245,8320,8247,8109,8219,8143,8165,8369,16178,8278,8316,8251,8120,8182,8110,8049,13018,16182,8154,8117,8063,8310,8162,8134,8161,8111,16170,8078,8285,16169,8338,8079,8337,8122,12439,8261,8206,8284,16184,8118,8246,8366,8157,8365,12436,12406,8158,8264,8093,8389,12424,12441,8207,8287,12425,8126,8243,16173,8281,8035,12404,8361,8081,8256,8231,8257,8290,16183,8128,12429,8344,8300,8301,8053,12422,8051,8250,16175,12415,8168,8249,8202,12442,8330,8283,8100,12435,12437,16181,8385,12411,12414,16168,12407,8139,8166,12440,8302,12430,8276,8087,12426,12427,12431,16639,8282,8399,12443,8352,16644,12412,8226,16174,8178,12416,12423,8258,16590,8238,12413,8108) ASC, p.tmPosted DESC LIMIT 24
For Rent/Lease in North Falmouth
