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

Other Services in Annandale

Show more results

By Using this website, you agree to Terms of Use & Privacy Policy. Got it