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=110 AND p.iAdType='2' AND p.iItemType='16' AND iCityID IN (12982,12980,12978,12818,12734,12733,12912,12702,12736,12674,12926,12837,12638,12988,12644,12726,12935,12716,12849,12641,12715,12831,12904,12615,12972,12785,12810,12812,12646,12624,12951,12870,12954,12993,12724,12956,12717,12994,12814,12654,12739,12898,12966,12829,12970,12729,12889,12683,12947,12832,12848,12692,16597,12906,12963,12881,12755,12854,12689,12916,12642,12933,12878,12694,12691,12932,12851,12643,12843,12738,12981,12761,12864,12630,12614,12636,12719,12874,12667,12914,12865,12754,12768,12929,12649,12617,12590,12882,12961,12700,12891,12774,12763,7313,7833,7555,7372,12666,12868,12751,12653,7842,12723,12971,12990,7797,12758,7712,7326,7558,7768,12992,7578,12757,12953,7458,7793,7487,12684,12858,12650,7695,7457,12805,7507,12713,12712,7781,7738,12900,12602,7494,12816,12685,7737,12745,7584,12607,7808,7739,7466,7535,12759,7736,12967,7681,7490,7495,12789,12678,7834,7607,12777,7652,12776,7796,7562,7608) ORDER BY FIELD(iCityID, 12982,12980,12978,12818,12734,12733,12912,12702,12736,12674,12926,12837,12638,12988,12644,12726,12935,12716,12849,12641,12715,12831,12904,12615,12972,12785,12810,12812,12646,12624,12951,12870,12954,12993,12724,12956,12717,12994,12814,12654,12739,12898,12966,12829,12970,12729,12889,12683,12947,12832,12848,12692,16597,12906,12963,12881,12755,12854,12689,12916,12642,12933,12878,12694,12691,12932,12851,12643,12843,12738,12981,12761,12864,12630,12614,12636,12719,12874,12667,12914,12865,12754,12768,12929,12649,12617,12590,12882,12961,12700,12891,12774,12763,7313,7833,7555,7372,12666,12868,12751,12653,7842,12723,12971,12990,7797,12758,7712,7326,7558,7768,12992,7578,12757,12953,7458,7793,7487,12684,12858,12650,7695,7457,12805,7507,12713,12712,7781,7738,12900,12602,7494,12816,12685,7737,12745,7584,12607,7808,7739,7466,7535,12759,7736,12967,7681,7490,7495,12789,12678,7834,7607,12777,7652,12776,7796,7562,7608) ASC, p.tmPosted DESC LIMIT 24
Fasteners Wanted to Buy in West Milwaukee
