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=302 AND iCityID IN (3763,4104,3877,3977,4024,3896,3751,3901,3761,4047,3925,3890,3853,4071,3739,3950,3749,3932,3758,3983,3895,4048,3688,3784,3753,3812,4074,4044,3936,3693,3737,3843,4052,3862,3735,3880,4031,3893,3738,3833,3845,3695,3953,3869,3747,3987,4063,3854,3821,4106,5026,3748,4953,4007,3967,4014,3922,3804,4012,4023,3822,4077,3910,3852,3934,5115,3997,3770,4039,3721,3765,4045,5008,3923,3917,4981,3839,3855,5058,3878,4094,3791,3891,3885,5142,3908,4011,4925,3810,3928,4046,3926,3703,4098,4075,5086,4076,4109,3952,4036,3816,5036,3957,3666,4091,3755,3921,4966,3924,4123,3789,3919,3692,4984,4938,3887,3668,3799,3741,3938,3837) ORDER BY FIELD(iCityID, 3763,4104,3877,3977,4024,3896,3751,3901,3761,4047,3925,3890,3853,4071,3739,3950,3749,3932,3758,3983,3895,4048,3688,3784,3753,3812,4074,4044,3936,3693,3737,3843,4052,3862,3735,3880,4031,3893,3738,3833,3845,3695,3953,3869,3747,3987,4063,3854,3821,4106,5026,3748,4953,4007,3967,4014,3922,3804,4012,4023,3822,4077,3910,3852,3934,5115,3997,3770,4039,3721,3765,4045,5008,3923,3917,4981,3839,3855,5058,3878,4094,3791,3891,3885,5142,3908,4011,4925,3810,3928,4046,3926,3703,4098,4075,5086,4076,4109,3952,4036,3816,5036,3957,3666,4091,3755,3921,4966,3924,4123,3789,3919,3692,4984,4938,3887,3668,3799,3741,3938,3837) ASC, p.tmPosted DESC LIMIT 24 Mobiles & Accessories for Sale in Denver