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 p.iPostType=12 AND iPostID IN (SELECT t.iPostID FROM posttext t WHERE t.iDomID=1 AND MATCH (t.strSearch) AGAINST ('+grocery +stores +ads' IN BOOLEAN MODE)) AND iCityID IN (4220,4253,4197,4202,4217,4263,4233,4131,4244,4127,4173,4277,4234,4134,4145,4204,4251,4236,4168,4151,4211,4171,4272,16257,4216,4273,4240,4191,4235,4149,4274,4261,4265,4206,4138,4175,4172,4255,4161,4214,4186,4267,4215,4152,4213,4270,4264,4139,4241,4248,4200,4258,4174,4157,4219,4275,4222,6816,4146,4249,4245,4189,4135,4130,4159,4170,4143,4268,4179,4230,4205,4262,4160,4195,4232,4176,4237,4177,4194,4196,4239,4257,4144,4167,4252,4163,542,4203,4266,4128,4129,4198,4199,554,4269,4180,4210,4193,4183,4154,4243,4225,4164,4280,6817,4256,4136,4148,4224,4209,4279,4231,4184,4137,4185,4238,4187,4142,4278,4169,4190,4207,16207,4254,16236,4132) ORDER BY FIELD(iCityID, 4220,4253,4197,4202,4217,4263,4233,4131,4244,4127,4173,4277,4234,4134,4145,4204,4251,4236,4168,4151,4211,4171,4272,16257,4216,4273,4240,4191,4235,4149,4274,4261,4265,4206,4138,4175,4172,4255,4161,4214,4186,4267,4215,4152,4213,4270,4264,4139,4241,4248,4200,4258,4174,4157,4219,4275,4222,6816,4146,4249,4245,4189,4135,4130,4159,4170,4143,4268,4179,4230,4205,4262,4160,4195,4232,4176,4237,4177,4194,4196,4239,4257,4144,4167,4252,4163,542,4203,4266,4128,4129,4198,4199,554,4269,4180,4210,4193,4183,4154,4243,4225,4164,4280,6817,4256,4136,4148,4224,4209,4279,4231,4184,4137,4185,4238,4187,4142,4278,4169,4190,4207,16207,4254,16236,4132) ASC, p.tmPosted DESC LIMIT 24
grocery stores ads, Community Classifieds, Local Events, Friends, Activities in Ocean City
