An Error Was Encountered

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-48' at line 37

SELECT a.id , a.clientID , a.url , a.width , a.height , a.name , a.targetURL , a.opacity , at.adtype FROM ads a INNER JOIN client c ON c.id = a.clientID INNER JOIN adlocation l ON l.id = a.adlocationID INNER JOIN adtype at ON at.id = a.adtypeID INNER JOIN adpriority ap ON ap.id = a.adpriorityID WHERE a.active = 1 AND c.active = 1 AND ( SELECT COUNT(s.id) FROM adstatistics s INNER JOIN adimpressiontype it ON it.id = s.adimpressiontypeID WHERE it.impressiontype = "impression" ) < a.maximpressions AND c.zip IN (60677,60606,60679,60661,60695,60663,60675,60678,60694,60690,60674,60699,60681,60669,60603,60654,60668,60607,60602,60685,60673,60604,60687,60601,60664,60670,60680,60605,60693,60691,60697,60610,60611,60684,60686,60688,60689,60696,60622,60612,60616,60608,60614,60682,60647,60624,60657,60653,60623,60609,60613,60651,60618,60615,60644,60632,60640,60639,60804,60641,60625,60621,60637,60636,60303,60304,60302,60660,60629,60659,60403,60301,60402,60630,60130,60649,60626,60305,60645,60499,60707,60619,60638,60620,60634,60141,60712,60652,60546,60646,60534,60153,60202,60706,60171,60501,60155,60165,60456,60805,60513,60631,60459,60160,60656,60161,60068,60076,60209,60617,60104,60077,60203,60208,60526,60643,60201,60204,60131,60154,60453,60455,60628,60176,60164,60162,60701,60458,60525,60655,60714,60053,60570,60163,60290,60415,60091,60558,60457,60454,60029,60666,60043,60482,60522,60803,60126,46394,60018,60406,60827,60633,60523,60480,60025,60399,60105,60093,60106,60472,60017,60019,60521,60463,60016,60026,60181,60445,60469,60419,60514,60082,60559,60191,60464,46327,60022,60426,60428,60409,60101,46312,60148,46325,60473,46320,60561,60452,60056,60062,60009,60515,60143,60007,60462,60516,60476,60429,46324,60070,60137,60005,60157,60092,60138,60438,46323,60035,60478,60430,60139,60487,60477,60078,60425,60090,60108,60172,60532,60004,60517,46406,60117,60491,60015,60422,60467,46321,60199,60128,60132,60040,60008,60095,60038,60037,60187,46404,60196,46322,46402,60193,60159,60173,60461,60189,60490,60439,60440,60412,60116,60197,60411,60069,60188,46407,60125,60443,60089,60067,60190,60065,60133,46319,60194,60566,60565,60567,60448,60074,60540,46408,60168,60169,60045,60192,46403,60563,60195,60471,60094,46311,60055,60555,46375,46409,60475,60049,46405,60423,60185,60107,60466,60186,60006,60103,60441,60446,60061,60044,60417,46392,60451,60047,46373,60184,60564,46411,46368,60088,60519,60432,46342,60504,60598,60502,60568,60597,60086,60048,60449,60434,46410,60064,60179,60585,60433,60435,60010,60503,60544,60174,46401,60060,60134,60510,60177,60121,60120,46393,60505,60170,46307,46308,60122,60085,60507,60542,60442,60079,60572,60539,60124,60401,46303,60123,60110,46304,60431,60011,60586,60175,60021,60084,46301,60030,60118,60031,60436,60506,60538,60599,60087,60543,60404,60468,60013,60421,60183,46361,46383,60136,60073,60042,60102,46384,46355,60147,60083,60099,46385,60156,46360,60512,60410,60096,60041,60046,46356,60014,60554,60039,60012,60119,46341,60447,46391,60940,60560,60075,60020,46302,60144,60050,60142,49117,60051,60950,60109,60511,60002,53143,60140,60481,60545,53102,53158,60081,60151,46376,49129,46390,53140,53141,60954,53142,60072,46377,49116,53104,46347,46350,46379,53179,60097,60914,60180,46381,60098,60536,46352,60541,49115,60408,60915,53109,53194,60520,46382,53192,60071,46349,49128,60416,46310,60548,53170,46372,49125,60450,53199,60901,60112,53171,60537,60178,46345,53181,53144,53168,60407,46371,53101,46340,60135,60913,46348,60944,60552,60910,49106,49119,46346,60152,60935,53128,60034,53401,53152,60115,53159,53403,53177,49113,46380,60474,49127,53157,53405,53407,60556,60444,53408,60969,60964,46365,53406,49101,60001,47943,53404,60424,53182,46552,46374,60551,49085,53195,60145,61038,60531,60941,60033,60922,53139,49023,60961,60111,60150,61360,60956,49107,60550,53105,53147,60917,46366,60479,53402,53126,46532,60912,53148,60549,47963,49022,53176,60557,53125,49126,49103,60146,46534,53191,47964,53167,53184,60951,46574,49104,61341,60437,60927,53108,60129,61008,60518,61012,47957,46554,49084,60420,60113,46620,60920,60530,60931,53138,53185,46531,46619,49111,60919,46628,47978,49102,53585,49039,61065,53154,60911,49038,61353,46626,49120,60553,46624,49121,46572,47922,46513,53115,61052,61016,46616,61049,53132,53121,53172,60946,60470,46637,60945,46601,61068,46699,61112,46501,46613,60934,47946,46556,61011,46634,46680,46617,46614,53114,53150,49098,61350,46968,46536,46660,61325,46635,53110,53244,61125,46537,53237,53103,46604,46615,53120,60930,61126,53129,53221,61318,61108,60460,49043,61371,61109,53235,53130,61130,61107,60970,61114,60929,61313,60966,61132,61131,53149,47951,46563,53220,53207,60928,61111,46960,53228,61106,46511,61373,61364,46996,61104,53525,61110,61073,61769,53215,60938,49090,61115,47948,53151,53219,53234,53227,61080,61372,53204,53146,47959,53295,60974,53201,53119,53214,53290,53278,53274,53268,53203,53259,47977,53288,46922,53293,53233,53267,53202,53505,60955,53208,53205,60959,53213,47925,53226,53212,53186,46945,53512,47995,47942,53187,53153,61348,53189,53210,61319,53122,53206,53127,53211,53156,61332,49416,53188,60921,53008,53005,53216,53190,53263,53222,60953,53045,46985,61764,53183,60968,53218,46935,53118,53209,60967,53007,61741,47980,53225,61311,53546,53072,61743,53501,61333,53217,47944,46939,53548,49406,53547,53223,61334,47960,53018,61739,53224,53051,60939,60918,60926,53545,53563,53046,60924,60962,53178,46978,53029,60973,53089,61321,53052,61377,46975,47929,61775,53058,61740,53056,53092,53069,53066,46950,53538,61358,53097,47921,49434,47984,60952,46942,53064,46931,47971,47997,53022,60948,61726,53017,47986,47923,61773,53137,53549,60942,53534,47917,47926,53033,46947,60960,53036,61760,61731) AND ap.priorityorder = 1 AND l.location = "inventory" ORDER BY RAND() LIMIT -48