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