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=5 AND p.iItemType='4' AND iCityID IN (7880,7993,7919,7932,7946,7937,7939,8031,7866,7843,7875,7989,16556,8013,7950,7960,7971,8019,7996,7488,7921,7997,7328,8002,7623,7827,7967,7913,7938,7984,7885,7745,7920,7956,7397,8025,7903,7587,7741,7868,7975,7770,7452,7985,7864,7988,7762,7908,7964,16554,7933,7856,7566,7916,7379,7483,7689,7928,7682,7624,8028,7929,7714,7668,7597,7783,7887,7357,7605,7343,7524,7451,7538,7426,7751,7764,7353,7342,7693,7506,8026,7502,7416,7393,7600,7717,7934,16593,7958,7461,7414,7951,8009,7704,7375,7460,7661,7785,7931,7615,7358,16582,7806,7876,7897,7339,7721,7945,8017,7761,7396,7628,7894,7385,7621,7613,7673,7310,7373,7634,7595,7767,7863,16587,16586,7442,7678,7674,7836,7644,7662,7381,7839,7528,7680,7972,7523,7315,7438,7979,7617,7813,7540,7679,7983,7522,8928,7380,7352,7510,7906,7486,7815,7484,7643,7465,7512,7978,7417,7530,7922,7564,7812,7346,7437,7829,7966) ORDER BY FIELD(iCityID, 7880,7993,7919,7932,7946,7937,7939,8031,7866,7843,7875,7989,16556,8013,7950,7960,7971,8019,7996,7488,7921,7997,7328,8002,7623,7827,7967,7913,7938,7984,7885,7745,7920,7956,7397,8025,7903,7587,7741,7868,7975,7770,7452,7985,7864,7988,7762,7908,7964,16554,7933,7856,7566,7916,7379,7483,7689,7928,7682,7624,8028,7929,7714,7668,7597,7783,7887,7357,7605,7343,7524,7451,7538,7426,7751,7764,7353,7342,7693,7506,8026,7502,7416,7393,7600,7717,7934,16593,7958,7461,7414,7951,8009,7704,7375,7460,7661,7785,7931,7615,7358,16582,7806,7876,7897,7339,7721,7945,8017,7761,7396,7628,7894,7385,7621,7613,7673,7310,7373,7634,7595,7767,7863,16587,16586,7442,7678,7674,7836,7644,7662,7381,7839,7528,7680,7972,7523,7315,7438,7979,7617,7813,7540,7679,7983,7522,8928,7380,7352,7510,7906,7486,7815,7484,7643,7465,7512,7978,7417,7530,7922,7564,7812,7346,7437,7829,7966) ASC, p.tmPosted DESC LIMIT 24
Industrial for Sale in DeMotte
