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=8 AND iPostID IN (SELECT t.iPostID FROM posttext t WHERE t.iDomID=1 AND MATCH (t.strSearch) AGAINST ('+exemption +for +service +tax' IN BOOLEAN MODE)) AND iCityID IN (5243,5389,5264,5431,5251,5335,5369,5296,5327,5298,5247,5262,5429,5204,5375,5380,5253,2302,5340,5290,5405,5426,5288,5352,5393,2437,5178,5200,5397,5158,5168,5169,5240,5248,5349,5368,2418,5373,5151,2219,5339,5362,5241,2431,2235,5286,5291,2312,5242,5438,5392,5187,5234,2456,5430,5156,5411,2287) ORDER BY FIELD(iCityID, 5243,5389,5264,5431,5251,5335,5369,5296,5327,5298,5247,5262,5429,5204,5375,5380,5253,2302,5340,5290,5405,5426,5288,5352,5393,2437,5178,5200,5397,5158,5168,5169,5240,5248,5349,5368,2418,5373,5151,2219,5339,5362,5241,2431,2235,5286,5291,2312,5242,5438,5392,5187,5234,2456,5430,5156,5411,2287) ASC, p.tmPosted DESC LIMIT 24
exemption for service tax, Service Classifieds, Local Service Providers in Gallatin