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=8 AND p.iItemType='2' AND iCityID IN (15479,15474,15427,15522,15452,15513,15537,15472,15425,15437,15531,15505,15432,14789,15477,15459,15534,15506,15504,15535,15511,15446,15510,15487,15434,15501,15467,15422,15484,15450,15540,15423,15519,15529,15418,15428,15451,15509,15426,15461,15489,15947,15518,16531,15441,15507,15440,15493,15523,15464,15473,15436,15444,15458,15944,15449,15488,15460,15476,15433,15447,15521,15431,15485,16645,15429,15457,15443,15514,15496,15533,15525,15478,15520,15430,15503,15527,15500,15454,15512,15517,15530,15486,15516,15420,15469,15470,15532,15448,15490,14790,15442,15483,15492,15494,15463,15538,14723,15438,15539,14750,15515) ORDER BY FIELD(iCityID, 15479,15474,15427,15522,15452,15513,15537,15472,15425,15437,15531,15505,15432,14789,15477,15459,15534,15506,15504,15535,15511,15446,15510,15487,15434,15501,15467,15422,15484,15450,15540,15423,15519,15529,15418,15428,15451,15509,15426,15461,15489,15947,15518,16531,15441,15507,15440,15493,15523,15464,15473,15436,15444,15458,15944,15449,15488,15460,15476,15433,15447,15521,15431,15485,16645,15429,15457,15443,15514,15496,15533,15525,15478,15520,15430,15503,15527,15500,15454,15512,15517,15530,15486,15516,15420,15469,15470,15532,15448,15490,14790,15442,15483,15492,15494,15463,15538,14723,15438,15539,14750,15515) ASC, p.tmPosted DESC LIMIT 24
Bed & Breakfast Vacation Rental in Murray
