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=1 AND iPostID IN (SELECT t.iPostID FROM posttext t WHERE t.iDomID=1 AND MATCH (t.strSearch) AGAINST ('+online +real +estate +sales' IN BOOLEAN MODE)) AND iCityID IN (15469,15517,15516,14790,15496,15420,15539,15438,15490,15532,15488,15944,14750,15464,14723,15493,15947,15426,15507,15461,15451,15418,15433,15436,13052,15473,15449,15434,15422,14741,15446,15501,15535,15506,14722,15511,14789,14719,15505,15450,15510,15489,15432,15443,15472,15531,15457,15509,15452,15477,15479,14740,15437,15474,15522,14739,15425,15487,15537,15427,16531,15519,15459,15485,15513,15534,14751,15504,15523,15467,14725) ORDER BY FIELD(iCityID, 15469,15517,15516,14790,15496,15420,15539,15438,15490,15532,15488,15944,14750,15464,14723,15493,15947,15426,15507,15461,15451,15418,15433,15436,13052,15473,15449,15434,15422,14741,15446,15501,15535,15506,14722,15511,14789,14719,15505,15450,15510,15489,15432,15443,15472,15531,15457,15509,15452,15477,15479,14740,15437,15474,15522,14739,15425,15487,15537,15427,16531,15519,15459,15485,15513,15534,14751,15504,15523,15467,14725) ASC, p.tmPosted DESC LIMIT 24
online real estate sales, Real Estate Classifieds, Apartments for Rent, Houses for Sale, Properties for Sale in Mapleton
