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 +online +advertising +for +websites' IN BOOLEAN MODE)) AND iCityID IN (7639,7800,7579,7830,7837,7823,7418,7340,7810,7481,7363,7821,7318,7405,7649,7325,7582,6854,7384,7731,7664,7472,7568,7795,7518,7626,7826,7341,7696,7660,7354,7742,7337,7809,7529,7675,7820,7306,7434,7394,16611,7448,7516,7733,7580,7819,7547,7610,7334,7588,7323,7500,7400,7534,7519,7835,7548,7825,7330,7778,7349,7484,7659,7333,7775,7348,7395,7537,7763,7445,16122,7776,7522,7802,7611,7606,7718,7589,7512,7656,7779,7748,7433,7462,7346,7520,7679,7431,7680,7536,7454,7841,7749,7674,7753,7432,7716,7335,7715,7772,7530,7839,7352,7725,7436,7734,7678,7381,7663,7572,7648,7706,7336,7383,7662,7673,7644,7759,7503,7523,7729,7812,7697,7412,7815,7331,7683,7636,7621,7814,7423,7310,7314,7315,7811,7653,7765,7757,7703,7396,7531,7677,7347,7380,7465,7442,7634,7620,7785,7425,7694,7364,7646,7710,7613,7532,7661,7609,7598,7813,7615,7322,7319,7478,7721,7581,7371,7307,7586,7460,7643,7818,7321,7517,7461,7628,16587,7339,7632,7345,7438,7378,7408,7577,7704,7744,7595,7437,7358,7393,7651,7600,7824,7482,7575,7350,7542,7414,7309,7756,16585,7642,7574,7486,7417,16586,7641,7402,7817,7506,7373,7583,7836,7791,7645,7429,7540,7528,7717,7502,7559,7657,7658,7459,7560,7693,7728,7650,7451,7497,7719,7392,7767,7441,7524,7828,7758,7553,7453,16610,7416,7605,7426,7367,7527,7505,7444,7539,7576,7764,7832,7761,7788,7409,7668,7714,7780,7794,7485,7783,7320,7701,7682,7353,7666,7805,7563,7407,7399,7513,7752,7807,7379,7483,7629,7624,7829,7514,16554,7762,7638,7533,7357,7770,8026,7705,7452,7413,7564,7566,7387,7473,7397,7571,7344,7964,7587,7916,7556,7745,7689,7491,7545,7887,7796,7562,7554,7594,7885,7543,7608,7351,7369,7495,7827,7490,7736,7920,7739,7838,7599,7466,7584,7597,7652,7737,7750,7607,7328,7738,7681,7781,7535,7913,7997,7544,7996,7422,7457,7494,7470,7793,7834,7487,7603,7808,7458,7695,7903,7578,7558,7768,7342,7488,7797,16582,7326,7866,7343,7950,7676,7967,7875,7313,7372,7555,7538,7712,7722,7842,7515,7332,7938,7921,7507,7623,7421) ORDER BY FIELD(iCityID, 7639,7800,7579,7830,7837,7823,7418,7340,7810,7481,7363,7821,7318,7405,7649,7325,7582,6854,7384,7731,7664,7472,7568,7795,7518,7626,7826,7341,7696,7660,7354,7742,7337,7809,7529,7675,7820,7306,7434,7394,16611,7448,7516,7733,7580,7819,7547,7610,7334,7588,7323,7500,7400,7534,7519,7835,7548,7825,7330,7778,7349,7484,7659,7333,7775,7348,7395,7537,7763,7445,16122,7776,7522,7802,7611,7606,7718,7589,7512,7656,7779,7748,7433,7462,7346,7520,7679,7431,7680,7536,7454,7841,7749,7674,7753,7432,7716,7335,7715,7772,7530,7839,7352,7725,7436,7734,7678,7381,7663,7572,7648,7706,7336,7383,7662,7673,7644,7759,7503,7523,7729,7812,7697,7412,7815,7331,7683,7636,7621,7814,7423,7310,7314,7315,7811,7653,7765,7757,7703,7396,7531,7677,7347,7380,7465,7442,7634,7620,7785,7425,7694,7364,7646,7710,7613,7532,7661,7609,7598,7813,7615,7322,7319,7478,7721,7581,7371,7307,7586,7460,7643,7818,7321,7517,7461,7628,16587,7339,7632,7345,7438,7378,7408,7577,7704,7744,7595,7437,7358,7393,7651,7600,7824,7482,7575,7350,7542,7414,7309,7756,16585,7642,7574,7486,7417,16586,7641,7402,7817,7506,7373,7583,7836,7791,7645,7429,7540,7528,7717,7502,7559,7657,7658,7459,7560,7693,7728,7650,7451,7497,7719,7392,7767,7441,7524,7828,7758,7553,7453,16610,7416,7605,7426,7367,7527,7505,7444,7539,7576,7764,7832,7761,7788,7409,7668,7714,7780,7794,7485,7783,7320,7701,7682,7353,7666,7805,7563,7407,7399,7513,7752,7807,7379,7483,7629,7624,7829,7514,16554,7762,7638,7533,7357,7770,8026,7705,7452,7413,7564,7566,7387,7473,7397,7571,7344,7964,7587,7916,7556,7745,7689,7491,7545,7887,7796,7562,7554,7594,7885,7543,7608,7351,7369,7495,7827,7490,7736,7920,7739,7838,7599,7466,7584,7597,7652,7737,7750,7607,7328,7738,7681,7781,7535,7913,7997,7544,7996,7422,7457,7494,7470,7793,7834,7487,7603,7808,7458,7695,7903,7578,7558,7768,7342,7488,7797,16582,7326,7866,7343,7950,7676,7967,7875,7313,7372,7555,7538,7712,7722,7842,7515,7332,7938,7921,7507,7623,7421) ASC, p.tmPosted DESC LIMIT 24
free online advertising for websites, Community Classifieds, Local Events, Friends, Activities in Naperville
