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=101 AND MATCH (t.strSearch) AGAINST ('+free +dating +websites +for +singles' IN BOOLEAN MODE)) AND iCityID IN (68072,68050,67474,70111,68725,67586,70032,69299,70392,68075,69059,68190,68523,69167,69997,67404,70022,69293,68484,66956,68206,69730,68856,70177,68739,69214,68187,68415) ORDER BY FIELD(iCityID, 68072,68050,67474,70111,68725,67586,70032,69299,70392,68075,69059,68190,68523,69167,69997,67404,70022,69293,68484,66956,68206,69730,68856,70177,68739,69214,68187,68415) ASC, p.tmPosted DESC LIMIT 24
free dating websites for singles, Community Classifieds, Local Events, Friends, Activities in Nargund
