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=105 AND p.iAdType='1' AND p.iItemType='8' AND iCityID IN (4872,4794,4787,4883,4854,4887,11735,4779,16521,4792,11887,11974,4884,4823,4895,4780,4812,11798,4894,11780,11676,4813,539,11754,4853,11624,551,11906,12131,12085,11986,12296,553,535,552,11629,12130,11811,4863,4791,4880,12147,11556,531,11615,12263,11924,11677,12254,549,4828,12274,11608,12167,12201,11961,550,11563,11727,561,11815,11977,522,518,12210,4826,16254,11550,4784,12284,525,12166,12178,530,3014,11575,12034,11857,4837,11646,4829,11855,12339,562,11790,11969,4885,11926,4833,11551,12308,12181,11923,4899,11909,4785,12238,11696,11726,12206,4786,4855,12042,4888,12053,12173,11971,11795,4226,12314,11749,12142,517,4882,2860,548,12182,12177,12358,12394,12360,12272,12363,534,12199,4153,4790,11938,12353,12219,11842,12245,4806,12395,4901,11630,4875,2979,4846,11640,12371,4810,4866,12221,16635,12095,4228,12345,11651,12075,16636,12266,4862,4793,4797,4800,12246,4851,12342,12265,4843,11703,11568,11898,4778,11689,4816,12119,11975,4857,4141,2814,4811,11947,4795,12061,4827,4868,11757,4803,12070,12255,12192,4799,4904,527,16146,4842,12160,4178,4796,12389,12295,11639,12195,11933,11586,11862,4259,11931,2997,11625,11588,4223,11939,11619,12060,4881,2906,12179,12384,12103,12143,11988,11812,12209,12089,11814,4242,11955,12141,11942,11561,12392,11755,11819,4280,12264,11868,4860,4212,12252,16658,12189,4897,12294,12122,4898,4210,4858,12040,11738,11847,11699,12391,4278,12180,11992,544,6817,4279,2763,12303,4271,12243,11709,4150,12050,4128,11932,12067,4147,4269,11912,4181,12390,12225,12262,16201,4276,16195,11554,4239,11673,12377,4207,12144,4142,4133,11995,11888,4218,12197,16243,11579,11871,4162,6815,11984,4132,11638,4232,11867,11953,4227,2996,12078,4184,560,4180,4900,4243,12348,12004,12172,3046,11860,12187,3017,4136,12313,12288,11649,12155,2779,16199,2977,11564,4182,11858,12332,4144,4185,12211,4155,16200,4864,10033,4179,4199,4193,11784,11740,11908,10069,11692,4156,4262,4169,11775,4252,11736,12190,2923,12343,4170,11706,4902,4879,4878,4798,4905,4129,4158,4257,4201,11565,4190,4159,4194,11733,4167,11807,2867,4196,11684,11672,16211,4256,11659,11584,12158,2925,11828,4245,4160,12312,4230,3000,4805,12188,2857,4876,4222,11597,4183,11921,9858,4177,4238,11710,4889,11936,11765,12128,11557,12057,4822,12329,4831,12125,4870,4203,11987,559,4275,4903,9819,11783,4817,2931,526,4850,4249,11822,11873,11876,4143,11834,4146,12220,9870,11716,11715,4209,12123,12140,4896,11940,4848,11941,12218,12148,12092,12299,4815,12091) ORDER BY FIELD(iCityID, 4872,4794,4787,4883,4854,4887,11735,4779,16521,4792,11887,11974,4884,4823,4895,4780,4812,11798,4894,11780,11676,4813,539,11754,4853,11624,551,11906,12131,12085,11986,12296,553,535,552,11629,12130,11811,4863,4791,4880,12147,11556,531,11615,12263,11924,11677,12254,549,4828,12274,11608,12167,12201,11961,550,11563,11727,561,11815,11977,522,518,12210,4826,16254,11550,4784,12284,525,12166,12178,530,3014,11575,12034,11857,4837,11646,4829,11855,12339,562,11790,11969,4885,11926,4833,11551,12308,12181,11923,4899,11909,4785,12238,11696,11726,12206,4786,4855,12042,4888,12053,12173,11971,11795,4226,12314,11749,12142,517,4882,2860,548,12182,12177,12358,12394,12360,12272,12363,534,12199,4153,4790,11938,12353,12219,11842,12245,4806,12395,4901,11630,4875,2979,4846,11640,12371,4810,4866,12221,16635,12095,4228,12345,11651,12075,16636,12266,4862,4793,4797,4800,12246,4851,12342,12265,4843,11703,11568,11898,4778,11689,4816,12119,11975,4857,4141,2814,4811,11947,4795,12061,4827,4868,11757,4803,12070,12255,12192,4799,4904,527,16146,4842,12160,4178,4796,12389,12295,11639,12195,11933,11586,11862,4259,11931,2997,11625,11588,4223,11939,11619,12060,4881,2906,12179,12384,12103,12143,11988,11812,12209,12089,11814,4242,11955,12141,11942,11561,12392,11755,11819,4280,12264,11868,4860,4212,12252,16658,12189,4897,12294,12122,4898,4210,4858,12040,11738,11847,11699,12391,4278,12180,11992,544,6817,4279,2763,12303,4271,12243,11709,4150,12050,4128,11932,12067,4147,4269,11912,4181,12390,12225,12262,16201,4276,16195,11554,4239,11673,12377,4207,12144,4142,4133,11995,11888,4218,12197,16243,11579,11871,4162,6815,11984,4132,11638,4232,11867,11953,4227,2996,12078,4184,560,4180,4900,4243,12348,12004,12172,3046,11860,12187,3017,4136,12313,12288,11649,12155,2779,16199,2977,11564,4182,11858,12332,4144,4185,12211,4155,16200,4864,10033,4179,4199,4193,11784,11740,11908,10069,11692,4156,4262,4169,11775,4252,11736,12190,2923,12343,4170,11706,4902,4879,4878,4798,4905,4129,4158,4257,4201,11565,4190,4159,4194,11733,4167,11807,2867,4196,11684,11672,16211,4256,11659,11584,12158,2925,11828,4245,4160,12312,4230,3000,4805,12188,2857,4876,4222,11597,4183,11921,9858,4177,4238,11710,4889,11936,11765,12128,11557,12057,4822,12329,4831,12125,4870,4203,11987,559,4275,4903,9819,11783,4817,2931,526,4850,4249,11822,11873,11876,4143,11834,4146,12220,9870,11716,11715,4209,12123,12140,4896,11940,4848,11941,12218,12148,12092,12299,4815,12091) ASC, p.tmPosted DESC LIMIT 24
Aircrafts Wanted Rent & Lease in South Coatesville
