SQL Error: BIGINT UNSIGNED value is out of range in '((`db_sld_29`.`g`.`sklad` + `db_sld_29`.`g`.`in_list`) - `db_sld_29`.`g`.`noshow`)' at /var/www/sld/data/www/site12/public_html/lib/php/cms_sql/class.php line 1984
Array
(
    [code] => 1690
    [message] => BIGINT UNSIGNED value is out of range in '((`db_sld_29`.`g`.`sklad` + `db_sld_29`.`g`.`in_list`) - `db_sld_29`.`g`.`noshow`)'
    [query] => SELECT count(*) FROM
				(
				SELECT g.id
				FROM cms_good g
				LEFT JOIN cms_ref_vendor v	ON v.id=g.vendor_id
				LEFT JOIN cms_good_alias a	ON g.id=a.good_id
				     JOIN cms_good_tree gt	ON gt.id=g.pid
				LEFT JOIN cms_good_markup m	ON m.good_tree_id=gt.id AND m.distributor_id=1
				LEFT JOIN cms_prop_field pf	ON pf.prop_id=gt.prop_id
				LEFT JOIN cms_field f		ON f.id=pf.field_id
				
				WHERE TRUE  AND ((sklad+in_list-noshow) > 0 AND (g.pid IN (97,98,99,100,101,102,104,105,108,109,118,89) or (g.id in (39271,46177,46187,46181,39575,41421,41443,24447,24425,28073,25109,45739,24449,45738,21347,24429,24443,40212,24541,54047,54982,54993,54994,54983,37557,36978,37115,36975,36977,36979,40645,55530,55524,30549,56532,56599,55529,45277,55521,55526,56542,56598,46262,46259,46260,42408,46258,46257,41157,43677,43678,43673,55820,46091,46386,44304,44831,44832,48506,47699,47700,35310,44301,34108,34109,47701,46085,46086,34107,46087,47697,47698,46083,46084,44225,42313,39875,41924,41477,39874,35963,49076,56742,44710,47368,42311,44313,44712,44709,47829,49842,42310,39600,41183,41184,41923,44315,44347,55913,55917,56739,41473,49175,49176,49178,49522,55919,55912,31511,42309,56738,56744,56745,31525,34660,35961,39614,38679,40474,41185,41925,44223,44859,44714,46780,41475,42982,31522,35958,45365,42981,42307,43470,34161,58265,36332,58263,58264,58657,58262,58261,58139,57601,57853,57854,57855,57856,57816,57817,57818,57857,42273,48981,48978,57178,57177,46178,28218,46261,14887,14850,7692,7691,12425,15118,5230,6308,6309,7694,9705,9706,10367,10414,10415,10636,10902,11613,11626,11886,11887,11889,11892,11893,11896,11897,12378,12379,12395,12397,12407,12408,13736,12432,12461,12462,12628,12632,12650,12651,12869,12925,12926,12940,12941,13119,13126,13128,13129,13130,14462,13710,13711,13712,13714,13715,13717,13718,13719,13721,13722,13723,13724,13725,13737,13852,13887,13889,13894,13895,14234,14235,14238,14241,14268,14302,14307,14308,14488,14463,14461,14467,14512,14523,14524,14525,14526,14527,14533,14590,14589,14583,14659,14657,14658,14675,15160,10300,7825,325,11567,549,11566,12374,12392,8072,2273,5352,12358,4856,2275,13111,10388,10389,12639,12640,13116,12904,4164,12905,8882,10016,7214,12645,10335,4136,1883,13704,4109,10364,10365,12422,12424,9707,9708,5736,7434,10663,12447,945,12433,6000,7807,7808,7815,7812,14239,14237,11901,11900,7154,13621,7155,7153,11895,11906,12930,11894,12388,12376,13127,13125,13716,14508,13845,7844,10030,12535,12530,12884,12877,12881,13134,15152,16028,16102,16253,16277,17130,17131,17150,16435,17157,17160,16446,16602,763,940,941,942,1202,2596,4534,4867,7835,11883,11884,11905,13460,12451,12548,12886,12924,12927,13037,13459,13466,13469,13745,13746,13839,13848,14279,14664,14865,12602,15158,12429,12430,14464,2275,14493,8868,13109,10366,11899,4547,12363,12360,12520,8886,13849,10402,10029,12879,15149,10059,15187,15190,15191,16123,16100,16176,16178,17014,16313,16315,16316,16320,16322,16323,16247,16254,16255,16256,16257,16258,16260,16262,16263,16264,16361,16362,16364,16370,16266,16267,16272,16275,16276,16278,17129,17132,17134,17135,17136,17137,17152,17154,17155,17156,16327,16328,16334,16335,16336,16337,16338,16339,16340,16341,16342,16344,16345,16346,16347,16352,16353,16354,16356,16357,16433,16434,16437,16438,16440,16441,16469,17158,16406,16407,16408,16409,16410,16411,16412,16418,16419,16421,16522,16523,16544,16596,16597,16621,16623,16624,16631,16636,16769,16688,16689,16804,17044,17026,813,17641,17640,16676,16386,16388,16390,16393,16394,17380,17381,16392,17629,17729,17730,17731,17732,17733,17734,17735,17736,16306,16292,16293,16295,16298,16299,16310,16311,16312,16381,16395,16397,765,11868,11876,13418,13422,13423,13421,13419,10501,12719,10731,11357,12709,12713,11335,12710,4412,3592,3726,3600,2970,3598,3637,15260,15269,9518,9193,9102,15624,5391,15671,12587,3599,4371,13139,13138,3593,11510,14917,15268,15261,9101,9100,11213,15618,15631,15623,15634,13090,13088,13081,16093,12284,13864,12277,7390,13029,7388,13027,12283,13863,8006,7389,13030,13031,13028,17081,17616,17077,17176,16706,16708,16669,16709,7410,8679,17080,17078,16989,16705,16707,16668,16670,12028,10679,11602,8470,15774,13171,12034,12134,14440,10711,11596,12036,15422,15771,14254,14257,15426,11588,15776,6052,7632,10715,11150,11606,12169,13084,11751,8465,11750,11765,11592,11605,10680,14251,12135,11590,12137,13478,11589,11595,11604,12047,15424,11598,14255,14283,15421,15770,15777,8468,11144,12026,12139,11600,6050,12268,11586,13739,4137,7689,10578,11880,12359,12361,12362,12377,12393,12394,12396,12399,12426,13420,12449,12460,12539,12540,12541,12542,12543,12557,16245,16124,16246,14223,10901,4110,16431,16432,17169,17171,16439,17164,17639,17637,12546,13706,13720,14222,16447,16448,13728,13824,13825,13888,14236,6053,17180,17163,15670,16369,16396,14454,14455,14468,14470,14472,14474,16387,16436,17638,16296,16297,16265,863,718,14674,15159,15184,15396,15397,13036,13865,13862,14591,15151,15189,16620,17219,13035,17013,13861,16333,12889,20407,11878,14672,11597,15116,17627,14484,14482,14483,14485,16325,14791,16259,12280,19549,14960,14790,16398,16324,16300,17079,16358,11575,14582,14584,15188))) AND status=1) GROUP BY g.id) as foo
    [context] => /var/www/sld/data/www/site12/public_html/lib/php/cms_sql/class.php line 1984
)