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 ('+for +sale +local +ads' IN BOOLEAN MODE)) AND iCityID IN (6520,6560,2802,6624,2796,6474,6424,6408,6588,16240,3045,6522,2878,6629,2785,6312,2823,6649,3004,6485,6579,514,6316,16626,6512,6307,512,6448,2822,6548,3048,516,6496,2978,2928,2884,515,2870,2980,513,3041,6545,6573,6420,6572,6484,3056,3076,6601,6402,2824,3063,3023,16533,6578,6434,2875,2890,6350,2927,2938,2982,6471,6303,6644,2971,6463,2773,2793,6321,2766,16574,6421,3078,2835,2832,2887,2919,6452,6547,2911,6430,2847,6449,6503,6615,6459,3064,2871,16228,3026,2943,2786,2843,2858,2831,3016,6540,2991,2830,16460,2912,6473,2853,6361,2956,3040,2821,2866,6609,2808,2834,16220,2882,6405,6386,3011,3035,16253,3054,2784,3058,6359,2936,6652,7,2865,2937,16654,2827,3081,16191,2804,16213,16129,3068,2781,6499,2974,2987,2848,3050,2877,6626,16507,2968,2897,2889,2969,2939,2806,2886,2872,6656,16197,6597,16242,2874,2892,6549,3034,2800,16534,3052,6487,6313,16196,2934,2941,6511,3071,2828,6498,6341,3003,6650,2891,6345,6336,6613,2929,3049,6323,2764,6641,3082,2881,6510,2910,3075,3033,2963,6564,2942,6348,16504,2981,2825,6395,2798,2958,3005,16506,3018,16505,2921,2794,3024,2967,2957,3032,6526,2788,16232,2782,2792,6494,3065,2842,6497,2873,6475,3067,6438,2839,6368,2955,6460,6349,21,16194,3028,16252,6406,2896,2837,2905,6542,2986,2833,6622,3066,2774,2883,3037,16224,2844,2932,2904,2765,3002,2970,3070,2862,2799,2920,16532,2861,2851,2852,2840,6537,6569,3015,3055,3047,2778,2777,2810,2770,2869,2888,3051,2908,2950,2856,2947,2769,6501,2813,2989,6311,2859,2994,2993,2914,3009,2946,2940,2924,2845,3038,3036,2876,2776,3020,2797,2922,2960,2966,3080,3010,2795,3039,6633,2895,2913,2772,6514,2768,2917,2948,16214,6603,2916,2791,2815,2976,2826,2817,2998,2771,6776,2775,2935,3069,3019,2885,2990,2801,2807,6319,2965,2816,2893,6672,2962,3012,2850,3007,3083,2975,6394,6681,6766,16535,3025,2855,2961,2973,6554,3061,2953,6425,3074,2864,6325,3060,2992,6481,2988,6436,16246,2902,3053,3027,2787,2926,2809,2829,2819,6777,2964,6592,6383,2915,3059,2901,6309,3057) ORDER BY FIELD(iCityID, 6520,6560,2802,6624,2796,6474,6424,6408,6588,16240,3045,6522,2878,6629,2785,6312,2823,6649,3004,6485,6579,514,6316,16626,6512,6307,512,6448,2822,6548,3048,516,6496,2978,2928,2884,515,2870,2980,513,3041,6545,6573,6420,6572,6484,3056,3076,6601,6402,2824,3063,3023,16533,6578,6434,2875,2890,6350,2927,2938,2982,6471,6303,6644,2971,6463,2773,2793,6321,2766,16574,6421,3078,2835,2832,2887,2919,6452,6547,2911,6430,2847,6449,6503,6615,6459,3064,2871,16228,3026,2943,2786,2843,2858,2831,3016,6540,2991,2830,16460,2912,6473,2853,6361,2956,3040,2821,2866,6609,2808,2834,16220,2882,6405,6386,3011,3035,16253,3054,2784,3058,6359,2936,6652,7,2865,2937,16654,2827,3081,16191,2804,16213,16129,3068,2781,6499,2974,2987,2848,3050,2877,6626,16507,2968,2897,2889,2969,2939,2806,2886,2872,6656,16197,6597,16242,2874,2892,6549,3034,2800,16534,3052,6487,6313,16196,2934,2941,6511,3071,2828,6498,6341,3003,6650,2891,6345,6336,6613,2929,3049,6323,2764,6641,3082,2881,6510,2910,3075,3033,2963,6564,2942,6348,16504,2981,2825,6395,2798,2958,3005,16506,3018,16505,2921,2794,3024,2967,2957,3032,6526,2788,16232,2782,2792,6494,3065,2842,6497,2873,6475,3067,6438,2839,6368,2955,6460,6349,21,16194,3028,16252,6406,2896,2837,2905,6542,2986,2833,6622,3066,2774,2883,3037,16224,2844,2932,2904,2765,3002,2970,3070,2862,2799,2920,16532,2861,2851,2852,2840,6537,6569,3015,3055,3047,2778,2777,2810,2770,2869,2888,3051,2908,2950,2856,2947,2769,6501,2813,2989,6311,2859,2994,2993,2914,3009,2946,2940,2924,2845,3038,3036,2876,2776,3020,2797,2922,2960,2966,3080,3010,2795,3039,6633,2895,2913,2772,6514,2768,2917,2948,16214,6603,2916,2791,2815,2976,2826,2817,2998,2771,6776,2775,2935,3069,3019,2885,2990,2801,2807,6319,2965,2816,2893,6672,2962,3012,2850,3007,3083,2975,6394,6681,6766,16535,3025,2855,2961,2973,6554,3061,2953,6425,3074,2864,6325,3060,2992,6481,2988,6436,16246,2902,3053,3027,2787,2926,2809,2829,2819,6777,2964,6592,6383,2915,3059,2901,6309,3057) ASC, p.tmPosted DESC LIMIT 24
for sale local ads, Community Classifieds, Local Events, Friends, Activities in McLean
