MDB2_Error Object ( [error_message_prefix] => [mode] => 1 [level] => 1024 [code] => -1 [message] => MDB2 Error: unknown error [userinfo] => _doQuery: [Error message: Could not execute statement] [Last executed query: select SQL_CALC_FOUND_ROWS i.*, sc.name, sc.alias4url, ip_price.value_int price, v_avail.value_varchar avail , group_concat(sale_sc.name) sale_names, group_concat(sale_sc.alias4url) sale_alias4urls, group_concat(sale_i.id) sale_ids , ip_avail.prop_value_id avail_id , ip_cat.prop_value_id cat_id , v_type.value_varchar cat , v_brand.value_varchar brand , group_concat(distinct p.id order by p.id) mands , REPLACE(sc.name, '&', '&') name4xml , max(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE((concat(ii.static_img_id, '_', si.orig_filename)), ' ', '%20'), '\#', '%23'), '&', '&'), '+', '%2B'), ',', '-')) prim_img_fn , IF(ubd.id is not null and bd.discount>12, round(ip_price.value_int*(bd.discount-12)/400),0) as basic_bonus , v_cat.alias4url cat_alias4url , ip_cat.prop_value_id category_id , ip_brand.prop_value_id brand_id , IF(ubd.id is not null, round(IF(bd.discount>12,ip_price.value_int*(bd.discount-12)/800,0) + ip_price.value_int*bd.bonus/1000),0) as expert_bonus , REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( sc.html, ' ', ''), '—', '-'), '–', '-'), '«', '"'), '»', '"'), '®', '') , '°', 'o'), '•', '-'), '“', '"'), '”', '"') description , max(ig.item_gift_id) item_gift_id , max(gsc.name) gift_name , IFNULL(ima.articul, iua.articul) articul, IFNULL(ima.name, iua.name) articul_name from item i join static_content sc on sc.id=i.static_id join static_img si on si.static_id=i.static_id and si.prim join item_img ii on si.id=ii.static_img_id join item_prop_value ip_price on ip_price.prop_id=1 and ip_price.item_id=i.id join item_prop_value ip_brand on ip_brand.prop_id=4 and ip_brand.item_id=i.id join item_prop_value ip_cat on ip_cat.prop_id=3 and ip_cat.item_id=i.id join item_prop_value ip_type on ip_type.prop_id=35 and ip_type.item_id=i.id join prop_value v_type on v_type.id=ip_type.prop_value_id join prop_value v_brand on v_brand.id=ip_brand.prop_value_id join prop_value v_cat on v_cat.id=ip_cat.prop_value_id left join item_gift ig on ig.item_id=i.id left join item igi on igi.id=ig.item_gift_id left join static_content gsc on gsc.id=igi.static_id left join item_prop_value ip_avail on ip_avail.prop_id=2 and ip_avail.item_id=i.id left join prop_value v_avail on v_avail.id=ip_avail.prop_value_id left join item_prop_value pv on pv.item_id=i.id left join prop p on p.id=pv.prop_id and p.mand left join prop_value v on v.id=pv.prop_value_id left join bonus_disco bd on IF(bd.category_id=0, ip_cat.prop_value_id, bd.category_id)=ip_cat.prop_value_id and IF(bd.brand_id=0, ip_brand.prop_value_id, bd.brand_id)=ip_brand.prop_value_id left join users ubd on ubd.id=bd.user_id left join `item_manuf_articul` ima on i.id=ima.item_id left join `item_user_avail` iua on i.id=iua.item_id left join item sale_i on sale_i.sale_id=i.id left join static_content sale_sc on sale_sc.id=sale_i.static_id left join item_prop_value pv4 on pv4.prop_id=4 and pv4.item_id=i.id left join prop_value v4 on v4.id=pv4.prop_value_id where 1 and (IFNULL(pv4.prop_value_id,'') in ('165') or v4.alias4url in ('165') ) and i.id in (18903,18906,18907,18929,18932,18946,18947,18994,18995,19036,19037,19038,19058,19059,19060,19061,19062,19063,19064,19065,19066,19067,19068,19069,19070,19071,19072,19073,19074,19075,19076,19077,19078,19079,19080,19081,19082,19084,19091,19092,19094,19095,19096,19104,19112,19145,19146,19147,19148,19149,19150,19151,19152,19153,19155,19182,19203,19204,19205,19227,19228,19254,19305,19334,19335,19396,19471,19477,20783,20784,20785,20786,20787,20788,20789,20790,20792,20793,20794,20795,20796,20797,20798,20799,20800,20801,20802,20803,20805,20806,20807,20808,20809,20810,20811,20813,20814,20815,20816,20817,20818,20819,20820,20821,20822,20823,20824,20825,20826,20827,20828,20829,20830,20831,20833,20835,20836,20837,20838,20839,20840,20841,20842,20843,20844,20845,20846,20847,20848,20849,20850,20851,20852,20853,20854,20855,20856,20857,20858,20859,20860,20861,20862,20863,20864,20865,20866,20867,20868,20869,20870,20871,20872,20873,20874,20875,20876,20877,20878,20879,20880,20881,20883,20884,20886,20887,20888,20889,20890,20891,20892,20893,20894,20895,20896,20897,20898,20899,20900,20901,20902,20903,20904,20905,20906,20907,20908,20909,20910,20911,20912,20913,20914,20915,20916,20917,20918,20919,20920,20921,20922,20923,20924,20925,20926,20927,20928,20929,20930,20931,20932,20933,20934,20936,20937,20938,20940,20941,20942,20943,20944,20946,20948,20949,20950,20951,20952,20954,20955,20956,20957,20958,20959,20960,20961,20962,20963,20964,20965,20966,20967,20968,20969,20970,20971,20972,20973,20974,20975,20976,20977,20978,20979,20980,20981,20982,20983,20984,20985,20986,20987,20988,20989,20990,20991,20992,20993,20994,20995,20996,20997,20998,20999,21000,21001,21002,21003,21004,21005,21006,21007,21008,21009,21010,21011,21012,21013,21014,21015,21016,21017,21018,21019,21020,21021,21022,21023,21024,21025,21026,21027,21028,21029,21030,21031,21032,21033,21034,21035,21036,21037,21038,21039,21040,21041,21042,21043,21044,21045,21046,21047,21048,21049,21050,21052,21053,21054) and i.black=0 group by i.id having group_concat(distinct p.id order by p.id) = '1,3,4,35' and prim_img_fn and prim_img_fn is not null and price>0 ] [Native code: 1030] [Native message: Got error 28 from storage engine] [backtrace] => Array ( [0] => Array ( [file] => /home/admin/web/logistock.ru/public_html/MDB2.php [line] => 979 [function] => PEAR_Error [class] => PEAR_Error [type] => -> [args] => Array ( [0] => MDB2 Error: unknown error [1] => -1 [2] => 1 [3] => 1024 [4] => _doQuery: [Error message: Could not execute statement] [Last executed query: select SQL_CALC_FOUND_ROWS i.*, sc.name, sc.alias4url, ip_price.value_int price, v_avail.value_varchar avail , group_concat(sale_sc.name) sale_names, group_concat(sale_sc.alias4url) sale_alias4urls, group_concat(sale_i.id) sale_ids , ip_avail.prop_value_id avail_id , ip_cat.prop_value_id cat_id , v_type.value_varchar cat , v_brand.value_varchar brand , group_concat(distinct p.id order by p.id) mands , REPLACE(sc.name, '&', '&') name4xml , max(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE((concat(ii.static_img_id, '_', si.orig_filename)), ' ', '%20'), '\#', '%23'), '&', '&'), '+', '%2B'), ',', '-')) prim_img_fn , IF(ubd.id is not null and bd.discount>12, round(ip_price.value_int*(bd.discount-12)/400),0) as basic_bonus , v_cat.alias4url cat_alias4url , ip_cat.prop_value_id category_id , ip_brand.prop_value_id brand_id , IF(ubd.id is not null, round(IF(bd.discount>12,ip_price.value_int*(bd.discount-12)/800,0) + ip_price.value_int*bd.bonus/1000),0) as expert_bonus , REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( sc.html, ' ', ''), '—', '-'), '–', '-'), '«', '"'), '»', '"'), '®', '') , '°', 'o'), '•', '-'), '“', '"'), '”', '"') description , max(ig.item_gift_id) item_gift_id , max(gsc.name) gift_name , IFNULL(ima.articul, iua.articul) articul, IFNULL(ima.name, iua.name) articul_name from item i join static_content sc on sc.id=i.static_id join static_img si on si.static_id=i.static_id and si.prim join item_img ii on si.id=ii.static_img_id join item_prop_value ip_price on ip_price.prop_id=1 and ip_price.item_id=i.id join item_prop_value ip_brand on ip_brand.prop_id=4 and ip_brand.item_id=i.id join item_prop_value ip_cat on ip_cat.prop_id=3 and ip_cat.item_id=i.id join item_prop_value ip_type on ip_type.prop_id=35 and ip_type.item_id=i.id join prop_value v_type on v_type.id=ip_type.prop_value_id join prop_value v_brand on v_brand.id=ip_brand.prop_value_id join prop_value v_cat on v_cat.id=ip_cat.prop_value_id left join item_gift ig on ig.item_id=i.id left join item igi on igi.id=ig.item_gift_id left join static_content gsc on gsc.id=igi.static_id left join item_prop_value ip_avail on ip_avail.prop_id=2 and ip_avail.item_id=i.id left join prop_value v_avail on v_avail.id=ip_avail.prop_value_id left join item_prop_value pv on pv.item_id=i.id left join prop p on p.id=pv.prop_id and p.mand left join prop_value v on v.id=pv.prop_value_id left join bonus_disco bd on IF(bd.category_id=0, ip_cat.prop_value_id, bd.category_id)=ip_cat.prop_value_id and IF(bd.brand_id=0, ip_brand.prop_value_id, bd.brand_id)=ip_brand.prop_value_id left join users ubd on ubd.id=bd.user_id left join `item_manuf_articul` ima on i.id=ima.item_id left join `item_user_avail` iua on i.id=iua.item_id left join item sale_i on sale_i.sale_id=i.id left join static_content sale_sc on sale_sc.id=sale_i.static_id left join item_prop_value pv4 on pv4.prop_id=4 and pv4.item_id=i.id left join prop_value v4 on v4.id=pv4.prop_value_id where 1 and (IFNULL(pv4.prop_value_id,'') in ('165') or v4.alias4url in ('165') ) and i.id in (18903,18906,18907,18929,18932,18946,18947,18994,18995,19036,19037,19038,19058,19059,19060,19061,19062,19063,19064,19065,19066,19067,19068,19069,19070,19071,19072,19073,19074,19075,19076,19077,19078,19079,19080,19081,19082,19084,19091,19092,19094,19095,19096,19104,19112,19145,19146,19147,19148,19149,19150,19151,19152,19153,19155,19182,19203,19204,19205,19227,19228,19254,19305,19334,19335,19396,19471,19477,20783,20784,20785,20786,20787,20788,20789,20790,20792,20793,20794,20795,20796,20797,20798,20799,20800,20801,20802,20803,20805,20806,20807,20808,20809,20810,20811,20813,20814,20815,20816,20817,20818,20819,20820,20821,20822,20823,20824,20825,20826,20827,20828,20829,20830,20831,20833,20835,20836,20837,20838,20839,20840,20841,20842,20843,20844,20845,20846,20847,20848,20849,20850,20851,20852,20853,20854,20855,20856,20857,20858,20859,20860,20861,20862,20863,20864,20865,20866,20867,20868,20869,20870,20871,20872,20873,20874,20875,20876,20877,20878,20879,20880,20881,20883,20884,20886,20887,20888,20889,20890,20891,20892,20893,20894,20895,20896,20897,20898,20899,20900,20901,20902,20903,20904,20905,20906,20907,20908,20909,20910,20911,20912,20913,20914,20915,20916,20917,20918,20919,20920,20921,20922,20923,20924,20925,20926,20927,20928,20929,20930,20931,20932,20933,20934,20936,20937,20938,20940,20941,20942,20943,20944,20946,20948,20949,20950,20951,20952,20954,20955,20956,20957,20958,20959,20960,20961,20962,20963,20964,20965,20966,20967,20968,20969,20970,20971,20972,20973,20974,20975,20976,20977,20978,20979,20980,20981,20982,20983,20984,20985,20986,20987,20988,20989,20990,20991,20992,20993,20994,20995,20996,20997,20998,20999,21000,21001,21002,21003,21004,21005,21006,21007,21008,21009,21010,21011,21012,21013,21014,21015,21016,21017,21018,21019,21020,21021,21022,21023,21024,21025,21026,21027,21028,21029,21030,21031,21032,21033,21034,21035,21036,21037,21038,21039,21040,21041,21042,21043,21044,21045,21046,21047,21048,21049,21050,21052,21053,21054) and i.black=0 group by i.id having group_concat(distinct p.id order by p.id) = '1,3,4,35' and prim_img_fn and prim_img_fn is not null and price>0 ] [Native code: 1030] [Native message: Got error 28 from storage engine] ) ) [1] => Array ( [file] => /home/admin/web/logistock.ru/public_html/PEAR.php [line] => 531 [function] => __construct [class] => MDB2_Error [object] => MDB2_Error Object *RECURSION* [type] => -> [args] => Array ( [0] => [1] => 1 [2] => 1024 [3] => _doQuery: [Error message: Could not execute statement] [Last executed query: select SQL_CALC_FOUND_ROWS i.*, sc.name, sc.alias4url, ip_price.value_int price, v_avail.value_varchar avail , group_concat(sale_sc.name) sale_names, group_concat(sale_sc.alias4url) sale_alias4urls, group_concat(sale_i.id) sale_ids , ip_avail.prop_value_id avail_id , ip_cat.prop_value_id cat_id , v_type.value_varchar cat , v_brand.value_varchar brand , group_concat(distinct p.id order by p.id) mands , REPLACE(sc.name, '&', '&') name4xml , max(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE((concat(ii.static_img_id, '_', si.orig_filename)), ' ', '%20'), '\#', '%23'), '&', '&'), '+', '%2B'), ',', '-')) prim_img_fn , IF(ubd.id is not null and bd.discount>12, round(ip_price.value_int*(bd.discount-12)/400),0) as basic_bonus , v_cat.alias4url cat_alias4url , ip_cat.prop_value_id category_id , ip_brand.prop_value_id brand_id , IF(ubd.id is not null, round(IF(bd.discount>12,ip_price.value_int*(bd.discount-12)/800,0) + ip_price.value_int*bd.bonus/1000),0) as expert_bonus , REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( sc.html, ' ', ''), '—', '-'), '–', '-'), '«', '"'), '»', '"'), '®', '') , '°', 'o'), '•', '-'), '“', '"'), '”', '"') description , max(ig.item_gift_id) item_gift_id , max(gsc.name) gift_name , IFNULL(ima.articul, iua.articul) articul, IFNULL(ima.name, iua.name) articul_name from item i join static_content sc on sc.id=i.static_id join static_img si on si.static_id=i.static_id and si.prim join item_img ii on si.id=ii.static_img_id join item_prop_value ip_price on ip_price.prop_id=1 and ip_price.item_id=i.id join item_prop_value ip_brand on ip_brand.prop_id=4 and ip_brand.item_id=i.id join item_prop_value ip_cat on ip_cat.prop_id=3 and ip_cat.item_id=i.id join item_prop_value ip_type on ip_type.prop_id=35 and ip_type.item_id=i.id join prop_value v_type on v_type.id=ip_type.prop_value_id join prop_value v_brand on v_brand.id=ip_brand.prop_value_id join prop_value v_cat on v_cat.id=ip_cat.prop_value_id left join item_gift ig on ig.item_id=i.id left join item igi on igi.id=ig.item_gift_id left join static_content gsc on gsc.id=igi.static_id left join item_prop_value ip_avail on ip_avail.prop_id=2 and ip_avail.item_id=i.id left join prop_value v_avail on v_avail.id=ip_avail.prop_value_id left join item_prop_value pv on pv.item_id=i.id left join prop p on p.id=pv.prop_id and p.mand left join prop_value v on v.id=pv.prop_value_id left join bonus_disco bd on IF(bd.category_id=0, ip_cat.prop_value_id, bd.category_id)=ip_cat.prop_value_id and IF(bd.brand_id=0, ip_brand.prop_value_id, bd.brand_id)=ip_brand.prop_value_id left join users ubd on ubd.id=bd.user_id left join `item_manuf_articul` ima on i.id=ima.item_id left join `item_user_avail` iua on i.id=iua.item_id left join item sale_i on sale_i.sale_id=i.id left join static_content sale_sc on sale_sc.id=sale_i.static_id left join item_prop_value pv4 on pv4.prop_id=4 and pv4.item_id=i.id left join prop_value v4 on v4.id=pv4.prop_value_id where 1 and (IFNULL(pv4.prop_value_id,'') in ('165') or v4.alias4url in ('165') ) and i.id in (18903,18906,18907,18929,18932,18946,18947,18994,18995,19036,19037,19038,19058,19059,19060,19061,19062,19063,19064,19065,19066,19067,19068,19069,19070,19071,19072,19073,19074,19075,19076,19077,19078,19079,19080,19081,19082,19084,19091,19092,19094,19095,19096,19104,19112,19145,19146,19147,19148,19149,19150,19151,19152,19153,19155,19182,19203,19204,19205,19227,19228,19254,19305,19334,19335,19396,19471,19477,20783,20784,20785,20786,20787,20788,20789,20790,20792,20793,20794,20795,20796,20797,20798,20799,20800,20801,20802,20803,20805,20806,20807,20808,20809,20810,20811,20813,20814,20815,20816,20817,20818,20819,20820,20821,20822,20823,20824,20825,20826,20827,20828,20829,20830,20831,20833,20835,20836,20837,20838,20839,20840,20841,20842,20843,20844,20845,20846,20847,20848,20849,20850,20851,20852,20853,20854,20855,20856,20857,20858,20859,20860,20861,20862,20863,20864,20865,20866,20867,20868,20869,20870,20871,20872,20873,20874,20875,20876,20877,20878,20879,20880,20881,20883,20884,20886,20887,20888,20889,20890,20891,20892,20893,20894,20895,20896,20897,20898,20899,20900,20901,20902,20903,20904,20905,20906,20907,20908,20909,20910,20911,20912,20913,20914,20915,20916,20917,20918,20919,20920,20921,20922,20923,20924,20925,20926,20927,20928,20929,20930,20931,20932,20933,20934,20936,20937,20938,20940,20941,20942,20943,20944,20946,20948,20949,20950,20951,20952,20954,20955,20956,20957,20958,20959,20960,20961,20962,20963,20964,20965,20966,20967,20968,20969,20970,20971,20972,20973,20974,20975,20976,20977,20978,20979,20980,20981,20982,20983,20984,20985,20986,20987,20988,20989,20990,20991,20992,20993,20994,20995,20996,20997,20998,20999,21000,21001,21002,21003,21004,21005,21006,21007,21008,21009,21010,21011,21012,21013,21014,21015,21016,21017,21018,21019,21020,21021,21022,21023,21024,21025,21026,21027,21028,21029,21030,21031,21032,21033,21034,21035,21036,21037,21038,21039,21040,21041,21042,21043,21044,21045,21046,21047,21048,21049,21050,21052,21053,21054) and i.black=0 group by i.id having group_concat(distinct p.id order by p.id) = '1,3,4,35' and prim_img_fn and prim_img_fn is not null and price>0 ] [Native code: 1030] [Native message: Got error 28 from storage engine] ) ) [2] => Array ( [file] => /home/admin/web/logistock.ru/public_html/MDB2.php [line] => 1500 [function] => raiseError [class] => PEAR [type] => :: [args] => Array ( [0] => [1] => [2] => [3] => [4] => _doQuery: [Error message: Could not execute statement] [Last executed query: select SQL_CALC_FOUND_ROWS i.*, sc.name, sc.alias4url, ip_price.value_int price, v_avail.value_varchar avail , group_concat(sale_sc.name) sale_names, group_concat(sale_sc.alias4url) sale_alias4urls, group_concat(sale_i.id) sale_ids , ip_avail.prop_value_id avail_id , ip_cat.prop_value_id cat_id , v_type.value_varchar cat , v_brand.value_varchar brand , group_concat(distinct p.id order by p.id) mands , REPLACE(sc.name, '&', '&') name4xml , max(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE((concat(ii.static_img_id, '_', si.orig_filename)), ' ', '%20'), '\#', '%23'), '&', '&'), '+', '%2B'), ',', '-')) prim_img_fn , IF(ubd.id is not null and bd.discount>12, round(ip_price.value_int*(bd.discount-12)/400),0) as basic_bonus , v_cat.alias4url cat_alias4url , ip_cat.prop_value_id category_id , ip_brand.prop_value_id brand_id , IF(ubd.id is not null, round(IF(bd.discount>12,ip_price.value_int*(bd.discount-12)/800,0) + ip_price.value_int*bd.bonus/1000),0) as expert_bonus , REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( sc.html, ' ', ''), '—', '-'), '–', '-'), '«', '"'), '»', '"'), '®', '') , '°', 'o'), '•', '-'), '“', '"'), '”', '"') description , max(ig.item_gift_id) item_gift_id , max(gsc.name) gift_name , IFNULL(ima.articul, iua.articul) articul, IFNULL(ima.name, iua.name) articul_name from item i join static_content sc on sc.id=i.static_id join static_img si on si.static_id=i.static_id and si.prim join item_img ii on si.id=ii.static_img_id join item_prop_value ip_price on ip_price.prop_id=1 and ip_price.item_id=i.id join item_prop_value ip_brand on ip_brand.prop_id=4 and ip_brand.item_id=i.id join item_prop_value ip_cat on ip_cat.prop_id=3 and ip_cat.item_id=i.id join item_prop_value ip_type on ip_type.prop_id=35 and ip_type.item_id=i.id join prop_value v_type on v_type.id=ip_type.prop_value_id join prop_value v_brand on v_brand.id=ip_brand.prop_value_id join prop_value v_cat on v_cat.id=ip_cat.prop_value_id left join item_gift ig on ig.item_id=i.id left join item igi on igi.id=ig.item_gift_id left join static_content gsc on gsc.id=igi.static_id left join item_prop_value ip_avail on ip_avail.prop_id=2 and ip_avail.item_id=i.id left join prop_value v_avail on v_avail.id=ip_avail.prop_value_id left join item_prop_value pv on pv.item_id=i.id left join prop p on p.id=pv.prop_id and p.mand left join prop_value v on v.id=pv.prop_value_id left join bonus_disco bd on IF(bd.category_id=0, ip_cat.prop_value_id, bd.category_id)=ip_cat.prop_value_id and IF(bd.brand_id=0, ip_brand.prop_value_id, bd.brand_id)=ip_brand.prop_value_id left join users ubd on ubd.id=bd.user_id left join `item_manuf_articul` ima on i.id=ima.item_id left join `item_user_avail` iua on i.id=iua.item_id left join item sale_i on sale_i.sale_id=i.id left join static_content sale_sc on sale_sc.id=sale_i.static_id left join item_prop_value pv4 on pv4.prop_id=4 and pv4.item_id=i.id left join prop_value v4 on v4.id=pv4.prop_value_id where 1 and (IFNULL(pv4.prop_value_id,'') in ('165') or v4.alias4url in ('165') ) and i.id in (18903,18906,18907,18929,18932,18946,18947,18994,18995,19036,19037,19038,19058,19059,19060,19061,19062,19063,19064,19065,19066,19067,19068,19069,19070,19071,19072,19073,19074,19075,19076,19077,19078,19079,19080,19081,19082,19084,19091,19092,19094,19095,19096,19104,19112,19145,19146,19147,19148,19149,19150,19151,19152,19153,19155,19182,19203,19204,19205,19227,19228,19254,19305,19334,19335,19396,19471,19477,20783,20784,20785,20786,20787,20788,20789,20790,20792,20793,20794,20795,20796,20797,20798,20799,20800,20801,20802,20803,20805,20806,20807,20808,20809,20810,20811,20813,20814,20815,20816,20817,20818,20819,20820,20821,20822,20823,20824,20825,20826,20827,20828,20829,20830,20831,20833,20835,20836,20837,20838,20839,20840,20841,20842,20843,20844,20845,20846,20847,20848,20849,20850,20851,20852,20853,20854,20855,20856,20857,20858,20859,20860,20861,20862,20863,20864,20865,20866,20867,20868,20869,20870,20871,20872,20873,20874,20875,20876,20877,20878,20879,20880,20881,20883,20884,20886,20887,20888,20889,20890,20891,20892,20893,20894,20895,20896,20897,20898,20899,20900,20901,20902,20903,20904,20905,20906,20907,20908,20909,20910,20911,20912,20913,20914,20915,20916,20917,20918,20919,20920,20921,20922,20923,20924,20925,20926,20927,20928,20929,20930,20931,20932,20933,20934,20936,20937,20938,20940,20941,20942,20943,20944,20946,20948,20949,20950,20951,20952,20954,20955,20956,20957,20958,20959,20960,20961,20962,20963,20964,20965,20966,20967,20968,20969,20970,20971,20972,20973,20974,20975,20976,20977,20978,20979,20980,20981,20982,20983,20984,20985,20986,20987,20988,20989,20990,20991,20992,20993,20994,20995,20996,20997,20998,20999,21000,21001,21002,21003,21004,21005,21006,21007,21008,21009,21010,21011,21012,21013,21014,21015,21016,21017,21018,21019,21020,21021,21022,21023,21024,21025,21026,21027,21028,21029,21030,21031,21032,21033,21034,21035,21036,21037,21038,21039,21040,21041,21042,21043,21044,21045,21046,21047,21048,21049,21050,21052,21053,21054) and i.black=0 group by i.id having group_concat(distinct p.id order by p.id) = '1,3,4,35' and prim_img_fn and prim_img_fn is not null and price>0 ] [Native code: 1030] [Native message: Got error 28 from storage engine] [5] => MDB2_Error [6] => 1 ) ) [3] => Array ( [file] => /home/admin/web/logistock.ru/public_html/MDB2/Driver/mysql.php [line] => 811 [function] => raiseError [class] => MDB2_Driver_Common [object] => MDB2_Driver_mysql Object ( [string_quoting] => Array ( [start] => ' [end] => ' [escape] => \ [escape_pattern] => \ ) [identifier_quoting] => Array ( [start] => ` [end] => ` [escape] => ` ) [sql_comments] => Array ( [0] => Array ( [start] => -- [end] => [escape] => ) [1] => Array ( [start] => # [end] => [escape] => ) [2] => Array ( [start] => /* [end] => */ [escape] => ) ) [server_capabilities_checked:protected] => 1 [start_transaction:protected] => 1 [varchar_max_length] => 65532 [datatype] => [extended] => MDB2_Extended Object ( [db_index:protected] => 1 ) [function] => [manager] => [native] => [reverse] => [db_index] => 1 [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => admin_logistock [password] => xpdmdZJfAO [protocol] => [hostspec] => localhost [port] => [socket] => [database] => [mode] => ) [connected_dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => admin_logistock [password] => xpdmdZJfAO [protocol] => [hostspec] => localhost [port] => [socket] => [database] => [mode] => ) [connection] => Resource id #1 [opened_persistent] => [database_name] => admin_logistock [connected_database_name] => admin_logistock [connected_server_info] => 5.5.49 [supported] => Array ( [sequences] => emulated [indexes] => 1 [affected_rows] => 1 [summary_functions] => 1 [order_by_text] => 1 [transactions] => 1 [savepoints] => 1 [current_id] => emulated [limit_queries] => 1 [LOBs] => 1 [replace] => 1 [sub_selects] => 1 [triggers] => 1 [auto_increment] => 1 [primary_key] => 1 [result_introspection] => 1 [prepared_statements] => 1 [identifier_quoting] => 1 [pattern_escaping] => 1 [new_link] => 1 ) [options] => Array ( [ssl] => [field_case] => 0 [disable_query] => [result_class] => MDB2_Result_%s [buffered_result_class] => MDB2_BufferedResult_%s [result_wrap_class] => [result_buffering] => 1 [fetch_class] => stdClass [persistent] => [debug] => 0 [debug_handler] => MDB2_defaultDebugOutput [debug_expanded_output] => [default_text_field_length] => 4096 [lob_buffer_length] => 8192 [log_line_break] => [idxname_format] => %s_idx [seqname_format] => %s_seq [savepoint_format] => MDB2_SAVEPOINT_%s [statement_format] => MDB2_STATEMENT_%1$s_%2$s [seqcol_name] => sequence [quote_identifier] => [use_transactions] => 1 [decimal_places] => 2 [portability] => 0 [modules] => Array ( [ex] => Extended [dt] => Datatype [mg] => Manager [rv] => Reverse [na] => Native [fc] => Function ) [emulate_prepared] => [datatype_map] => Array ( ) [datatype_map_callback] => Array ( ) [nativetype_map_callback] => Array ( ) [lob_allow_url_include] => [bindname_format] => (?:\d+)|(?:[a-zA-Z][a-zA-Z0-9_]*) [max_identifiers_length] => 64 [default_fk_action_onupdate] => RESTRICT [default_fk_action_ondelete] => RESTRICT [DBA_username] => [DBA_password] => [default_table_type] => ) [wildcards:protected] => Array ( [0] => % [1] => _ ) [as_keyword] => AS [warnings] => Array ( ) [debug_output] => [in_transaction] => [nested_transaction_counter] => [has_transaction_error:protected] => [offset] => 0 [limit] => 0 [phptype] => mysql [dbsyntax] => mysql [last_query] => select SQL_CALC_FOUND_ROWS i.*, sc.name, sc.alias4url, ip_price.value_int price, v_avail.value_varchar avail , group_concat(sale_sc.name) sale_names, group_concat(sale_sc.alias4url) sale_alias4urls, group_concat(sale_i.id) sale_ids , ip_avail.prop_value_id avail_id , ip_cat.prop_value_id cat_id , v_type.value_varchar cat , v_brand.value_varchar brand , group_concat(distinct p.id order by p.id) mands , REPLACE(sc.name, '&', '&') name4xml , max(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE((concat(ii.static_img_id, '_', si.orig_filename)), ' ', '%20'), '\#', '%23'), '&', '&'), '+', '%2B'), ',', '-')) prim_img_fn , IF(ubd.id is not null and bd.discount>12, round(ip_price.value_int*(bd.discount-12)/400),0) as basic_bonus , v_cat.alias4url cat_alias4url , ip_cat.prop_value_id category_id , ip_brand.prop_value_id brand_id , IF(ubd.id is not null, round(IF(bd.discount>12,ip_price.value_int*(bd.discount-12)/800,0) + ip_price.value_int*bd.bonus/1000),0) as expert_bonus , REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( sc.html, ' ', ''), '—', '-'), '–', '-'), '«', '"'), '»', '"'), '®', '') , '°', 'o'), '•', '-'), '“', '"'), '”', '"') description , max(ig.item_gift_id) item_gift_id , max(gsc.name) gift_name , IFNULL(ima.articul, iua.articul) articul, IFNULL(ima.name, iua.name) articul_name from item i join static_content sc on sc.id=i.static_id join static_img si on si.static_id=i.static_id and si.prim join item_img ii on si.id=ii.static_img_id join item_prop_value ip_price on ip_price.prop_id=1 and ip_price.item_id=i.id join item_prop_value ip_brand on ip_brand.prop_id=4 and ip_brand.item_id=i.id join item_prop_value ip_cat on ip_cat.prop_id=3 and ip_cat.item_id=i.id join item_prop_value ip_type on ip_type.prop_id=35 and ip_type.item_id=i.id join prop_value v_type on v_type.id=ip_type.prop_value_id join prop_value v_brand on v_brand.id=ip_brand.prop_value_id join prop_value v_cat on v_cat.id=ip_cat.prop_value_id left join item_gift ig on ig.item_id=i.id left join item igi on igi.id=ig.item_gift_id left join static_content gsc on gsc.id=igi.static_id left join item_prop_value ip_avail on ip_avail.prop_id=2 and ip_avail.item_id=i.id left join prop_value v_avail on v_avail.id=ip_avail.prop_value_id left join item_prop_value pv on pv.item_id=i.id left join prop p on p.id=pv.prop_id and p.mand left join prop_value v on v.id=pv.prop_value_id left join bonus_disco bd on IF(bd.category_id=0, ip_cat.prop_value_id, bd.category_id)=ip_cat.prop_value_id and IF(bd.brand_id=0, ip_brand.prop_value_id, bd.brand_id)=ip_brand.prop_value_id left join users ubd on ubd.id=bd.user_id left join `item_manuf_articul` ima on i.id=ima.item_id left join `item_user_avail` iua on i.id=iua.item_id left join item sale_i on sale_i.sale_id=i.id left join static_content sale_sc on sale_sc.id=sale_i.static_id left join item_prop_value pv4 on pv4.prop_id=4 and pv4.item_id=i.id left join prop_value v4 on v4.id=pv4.prop_value_id where 1 and (IFNULL(pv4.prop_value_id,'') in ('165') or v4.alias4url in ('165') ) and i.id in (18903,18906,18907,18929,18932,18946,18947,18994,18995,19036,19037,19038,19058,19059,19060,19061,19062,19063,19064,19065,19066,19067,19068,19069,19070,19071,19072,19073,19074,19075,19076,19077,19078,19079,19080,19081,19082,19084,19091,19092,19094,19095,19096,19104,19112,19145,19146,19147,19148,19149,19150,19151,19152,19153,19155,19182,19203,19204,19205,19227,19228,19254,19305,19334,19335,19396,19471,19477,20783,20784,20785,20786,20787,20788,20789,20790,20792,20793,20794,20795,20796,20797,20798,20799,20800,20801,20802,20803,20805,20806,20807,20808,20809,20810,20811,20813,20814,20815,20816,20817,20818,20819,20820,20821,20822,20823,20824,20825,20826,20827,20828,20829,20830,20831,20833,20835,20836,20837,20838,20839,20840,20841,20842,20843,20844,20845,20846,20847,20848,20849,20850,20851,20852,20853,20854,20855,20856,20857,20858,20859,20860,20861,20862,20863,20864,20865,20866,20867,20868,20869,20870,20871,20872,20873,20874,20875,20876,20877,20878,20879,20880,20881,20883,20884,20886,20887,20888,20889,20890,20891,20892,20893,20894,20895,20896,20897,20898,20899,20900,20901,20902,20903,20904,20905,20906,20907,20908,20909,20910,20911,20912,20913,20914,20915,20916,20917,20918,20919,20920,20921,20922,20923,20924,20925,20926,20927,20928,20929,20930,20931,20932,20933,20934,20936,20937,20938,20940,20941,20942,20943,20944,20946,20948,20949,20950,20951,20952,20954,20955,20956,20957,20958,20959,20960,20961,20962,20963,20964,20965,20966,20967,20968,20969,20970,20971,20972,20973,20974,20975,20976,20977,20978,20979,20980,20981,20982,20983,20984,20985,20986,20987,20988,20989,20990,20991,20992,20993,20994,20995,20996,20997,20998,20999,21000,21001,21002,21003,21004,21005,21006,21007,21008,21009,21010,21011,21012,21013,21014,21015,21016,21017,21018,21019,21020,21021,21022,21023,21024,21025,21026,21027,21028,21029,21030,21031,21032,21033,21034,21035,21036,21037,21038,21039,21040,21041,21042,21043,21044,21045,21046,21047,21048,21049,21050,21052,21053,21054) and i.black=0 group by i.id having group_concat(distinct p.id order by p.id) = '1,3,4,35' and prim_img_fn and prim_img_fn is not null and price>0 [fetchmode] => 3 [modules:protected] => Array ( [Extended] => MDB2_Extended Object ( [db_index:protected] => 1 ) ) [destructor_registered:protected] => 1 [pear:protected] => PEAR Object ( [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => PEAR_Error [_expected_errors] => Array ( ) ) ) [type] => -> [args] => Array ( [0] => [1] => [2] => [3] => Could not execute statement [4] => _doQuery ) ) [4] => Array ( [file] => /home/admin/web/logistock.ru/public_html/MDB2.php [line] => 2629 [function] => _doQuery [class] => MDB2_Driver_mysql [object] => MDB2_Driver_mysql Object ( [string_quoting] => Array ( [start] => ' [end] => ' [escape] => \ [escape_pattern] => \ ) [identifier_quoting] => Array ( [start] => ` [end] => ` [escape] => ` ) [sql_comments] => Array ( [0] => Array ( [start] => -- [end] => [escape] => ) [1] => Array ( [start] => # [end] => [escape] => ) [2] => Array ( [start] => /* [end] => */ [escape] => ) ) [server_capabilities_checked:protected] => 1 [start_transaction:protected] => 1 [varchar_max_length] => 65532 [datatype] => [extended] => MDB2_Extended Object ( [db_index:protected] => 1 ) [function] => [manager] => [native] => [reverse] => [db_index] => 1 [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => admin_logistock [password] => xpdmdZJfAO [protocol] => [hostspec] => localhost [port] => [socket] => [database] => [mode] => ) [connected_dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => admin_logistock [password] => xpdmdZJfAO [protocol] => [hostspec] => localhost [port] => [socket] => [database] => [mode] => ) [connection] => Resource id #1 [opened_persistent] => [database_name] => admin_logistock [connected_database_name] => admin_logistock [connected_server_info] => 5.5.49 [supported] => Array ( [sequences] => emulated [indexes] => 1 [affected_rows] => 1 [summary_functions] => 1 [order_by_text] => 1 [transactions] => 1 [savepoints] => 1 [current_id] => emulated [limit_queries] => 1 [LOBs] => 1 [replace] => 1 [sub_selects] => 1 [triggers] => 1 [auto_increment] => 1 [primary_key] => 1 [result_introspection] => 1 [prepared_statements] => 1 [identifier_quoting] => 1 [pattern_escaping] => 1 [new_link] => 1 ) [options] => Array ( [ssl] => [field_case] => 0 [disable_query] => [result_class] => MDB2_Result_%s [buffered_result_class] => MDB2_BufferedResult_%s [result_wrap_class] => [result_buffering] => 1 [fetch_class] => stdClass [persistent] => [debug] => 0 [debug_handler] => MDB2_defaultDebugOutput [debug_expanded_output] => [default_text_field_length] => 4096 [lob_buffer_length] => 8192 [log_line_break] => [idxname_format] => %s_idx [seqname_format] => %s_seq [savepoint_format] => MDB2_SAVEPOINT_%s [statement_format] => MDB2_STATEMENT_%1$s_%2$s [seqcol_name] => sequence [quote_identifier] => [use_transactions] => 1 [decimal_places] => 2 [portability] => 0 [modules] => Array ( [ex] => Extended [dt] => Datatype [mg] => Manager [rv] => Reverse [na] => Native [fc] => Function ) [emulate_prepared] => [datatype_map] => Array ( ) [datatype_map_callback] => Array ( ) [nativetype_map_callback] => Array ( ) [lob_allow_url_include] => [bindname_format] => (?:\d+)|(?:[a-zA-Z][a-zA-Z0-9_]*) [max_identifiers_length] => 64 [default_fk_action_onupdate] => RESTRICT [default_fk_action_ondelete] => RESTRICT [DBA_username] => [DBA_password] => [default_table_type] => ) [wildcards:protected] => Array ( [0] => % [1] => _ ) [as_keyword] => AS [warnings] => Array ( ) [debug_output] => [in_transaction] => [nested_transaction_counter] => [has_transaction_error:protected] => [offset] => 0 [limit] => 0 [phptype] => mysql [dbsyntax] => mysql [last_query] => select SQL_CALC_FOUND_ROWS i.*, sc.name, sc.alias4url, ip_price.value_int price, v_avail.value_varchar avail , group_concat(sale_sc.name) sale_names, group_concat(sale_sc.alias4url) sale_alias4urls, group_concat(sale_i.id) sale_ids , ip_avail.prop_value_id avail_id , ip_cat.prop_value_id cat_id , v_type.value_varchar cat , v_brand.value_varchar brand , group_concat(distinct p.id order by p.id) mands , REPLACE(sc.name, '&', '&') name4xml , max(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE((concat(ii.static_img_id, '_', si.orig_filename)), ' ', '%20'), '\#', '%23'), '&', '&'), '+', '%2B'), ',', '-')) prim_img_fn , IF(ubd.id is not null and bd.discount>12, round(ip_price.value_int*(bd.discount-12)/400),0) as basic_bonus , v_cat.alias4url cat_alias4url , ip_cat.prop_value_id category_id , ip_brand.prop_value_id brand_id , IF(ubd.id is not null, round(IF(bd.discount>12,ip_price.value_int*(bd.discount-12)/800,0) + ip_price.value_int*bd.bonus/1000),0) as expert_bonus , REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( sc.html, ' ', ''), '—', '-'), '–', '-'), '«', '"'), '»', '"'), '®', '') , '°', 'o'), '•', '-'), '“', '"'), '”', '"') description , max(ig.item_gift_id) item_gift_id , max(gsc.name) gift_name , IFNULL(ima.articul, iua.articul) articul, IFNULL(ima.name, iua.name) articul_name from item i join static_content sc on sc.id=i.static_id join static_img si on si.static_id=i.static_id and si.prim join item_img ii on si.id=ii.static_img_id join item_prop_value ip_price on ip_price.prop_id=1 and ip_price.item_id=i.id join item_prop_value ip_brand on ip_brand.prop_id=4 and ip_brand.item_id=i.id join item_prop_value ip_cat on ip_cat.prop_id=3 and ip_cat.item_id=i.id join item_prop_value ip_type on ip_type.prop_id=35 and ip_type.item_id=i.id join prop_value v_type on v_type.id=ip_type.prop_value_id join prop_value v_brand on v_brand.id=ip_brand.prop_value_id join prop_value v_cat on v_cat.id=ip_cat.prop_value_id left join item_gift ig on ig.item_id=i.id left join item igi on igi.id=ig.item_gift_id left join static_content gsc on gsc.id=igi.static_id left join item_prop_value ip_avail on ip_avail.prop_id=2 and ip_avail.item_id=i.id left join prop_value v_avail on v_avail.id=ip_avail.prop_value_id left join item_prop_value pv on pv.item_id=i.id left join prop p on p.id=pv.prop_id and p.mand left join prop_value v on v.id=pv.prop_value_id left join bonus_disco bd on IF(bd.category_id=0, ip_cat.prop_value_id, bd.category_id)=ip_cat.prop_value_id and IF(bd.brand_id=0, ip_brand.prop_value_id, bd.brand_id)=ip_brand.prop_value_id left join users ubd on ubd.id=bd.user_id left join `item_manuf_articul` ima on i.id=ima.item_id left join `item_user_avail` iua on i.id=iua.item_id left join item sale_i on sale_i.sale_id=i.id left join static_content sale_sc on sale_sc.id=sale_i.static_id left join item_prop_value pv4 on pv4.prop_id=4 and pv4.item_id=i.id left join prop_value v4 on v4.id=pv4.prop_value_id where 1 and (IFNULL(pv4.prop_value_id,'') in ('165') or v4.alias4url in ('165') ) and i.id in (18903,18906,18907,18929,18932,18946,18947,18994,18995,19036,19037,19038,19058,19059,19060,19061,19062,19063,19064,19065,19066,19067,19068,19069,19070,19071,19072,19073,19074,19075,19076,19077,19078,19079,19080,19081,19082,19084,19091,19092,19094,19095,19096,19104,19112,19145,19146,19147,19148,19149,19150,19151,19152,19153,19155,19182,19203,19204,19205,19227,19228,19254,19305,19334,19335,19396,19471,19477,20783,20784,20785,20786,20787,20788,20789,20790,20792,20793,20794,20795,20796,20797,20798,20799,20800,20801,20802,20803,20805,20806,20807,20808,20809,20810,20811,20813,20814,20815,20816,20817,20818,20819,20820,20821,20822,20823,20824,20825,20826,20827,20828,20829,20830,20831,20833,20835,20836,20837,20838,20839,20840,20841,20842,20843,20844,20845,20846,20847,20848,20849,20850,20851,20852,20853,20854,20855,20856,20857,20858,20859,20860,20861,20862,20863,20864,20865,20866,20867,20868,20869,20870,20871,20872,20873,20874,20875,20876,20877,20878,20879,20880,20881,20883,20884,20886,20887,20888,20889,20890,20891,20892,20893,20894,20895,20896,20897,20898,20899,20900,20901,20902,20903,20904,20905,20906,20907,20908,20909,20910,20911,20912,20913,20914,20915,20916,20917,20918,20919,20920,20921,20922,20923,20924,20925,20926,20927,20928,20929,20930,20931,20932,20933,20934,20936,20937,20938,20940,20941,20942,20943,20944,20946,20948,20949,20950,20951,20952,20954,20955,20956,20957,20958,20959,20960,20961,20962,20963,20964,20965,20966,20967,20968,20969,20970,20971,20972,20973,20974,20975,20976,20977,20978,20979,20980,20981,20982,20983,20984,20985,20986,20987,20988,20989,20990,20991,20992,20993,20994,20995,20996,20997,20998,20999,21000,21001,21002,21003,21004,21005,21006,21007,21008,21009,21010,21011,21012,21013,21014,21015,21016,21017,21018,21019,21020,21021,21022,21023,21024,21025,21026,21027,21028,21029,21030,21031,21032,21033,21034,21035,21036,21037,21038,21039,21040,21041,21042,21043,21044,21045,21046,21047,21048,21049,21050,21052,21053,21054) and i.black=0 group by i.id having group_concat(distinct p.id order by p.id) = '1,3,4,35' and prim_img_fn and prim_img_fn is not null and price>0 [fetchmode] => 3 [modules:protected] => Array ( [Extended] => MDB2_Extended Object ( [db_index:protected] => 1 ) ) [destructor_registered:protected] => 1 [pear:protected] => PEAR Object ( [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => PEAR_Error [_expected_errors] => Array ( ) ) ) [type] => -> [args] => Array ( [0] => select SQL_CALC_FOUND_ROWS i.*, sc.name, sc.alias4url, ip_price.value_int price, v_avail.value_varchar avail , group_concat(sale_sc.name) sale_names, group_concat(sale_sc.alias4url) sale_alias4urls, group_concat(sale_i.id) sale_ids , ip_avail.prop_value_id avail_id , ip_cat.prop_value_id cat_id , v_type.value_varchar cat , v_brand.value_varchar brand , group_concat(distinct p.id order by p.id) mands , REPLACE(sc.name, '&', '&') name4xml , max(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE((concat(ii.static_img_id, '_', si.orig_filename)), ' ', '%20'), '\#', '%23'), '&', '&'), '+', '%2B'), ',', '-')) prim_img_fn , IF(ubd.id is not null and bd.discount>12, round(ip_price.value_int*(bd.discount-12)/400),0) as basic_bonus , v_cat.alias4url cat_alias4url , ip_cat.prop_value_id category_id , ip_brand.prop_value_id brand_id , IF(ubd.id is not null, round(IF(bd.discount>12,ip_price.value_int*(bd.discount-12)/800,0) + ip_price.value_int*bd.bonus/1000),0) as expert_bonus , REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( sc.html, ' ', ''), '—', '-'), '–', '-'), '«', '"'), '»', '"'), '®', '') , '°', 'o'), '•', '-'), '“', '"'), '”', '"') description , max(ig.item_gift_id) item_gift_id , max(gsc.name) gift_name , IFNULL(ima.articul, iua.articul) articul, IFNULL(ima.name, iua.name) articul_name from item i join static_content sc on sc.id=i.static_id join static_img si on si.static_id=i.static_id and si.prim join item_img ii on si.id=ii.static_img_id join item_prop_value ip_price on ip_price.prop_id=1 and ip_price.item_id=i.id join item_prop_value ip_brand on ip_brand.prop_id=4 and ip_brand.item_id=i.id join item_prop_value ip_cat on ip_cat.prop_id=3 and ip_cat.item_id=i.id join item_prop_value ip_type on ip_type.prop_id=35 and ip_type.item_id=i.id join prop_value v_type on v_type.id=ip_type.prop_value_id join prop_value v_brand on v_brand.id=ip_brand.prop_value_id join prop_value v_cat on v_cat.id=ip_cat.prop_value_id left join item_gift ig on ig.item_id=i.id left join item igi on igi.id=ig.item_gift_id left join static_content gsc on gsc.id=igi.static_id left join item_prop_value ip_avail on ip_avail.prop_id=2 and ip_avail.item_id=i.id left join prop_value v_avail on v_avail.id=ip_avail.prop_value_id left join item_prop_value pv on pv.item_id=i.id left join prop p on p.id=pv.prop_id and p.mand left join prop_value v on v.id=pv.prop_value_id left join bonus_disco bd on IF(bd.category_id=0, ip_cat.prop_value_id, bd.category_id)=ip_cat.prop_value_id and IF(bd.brand_id=0, ip_brand.prop_value_id, bd.brand_id)=ip_brand.prop_value_id left join users ubd on ubd.id=bd.user_id left join `item_manuf_articul` ima on i.id=ima.item_id left join `item_user_avail` iua on i.id=iua.item_id left join item sale_i on sale_i.sale_id=i.id left join static_content sale_sc on sale_sc.id=sale_i.static_id left join item_prop_value pv4 on pv4.prop_id=4 and pv4.item_id=i.id left join prop_value v4 on v4.id=pv4.prop_value_id where 1 and (IFNULL(pv4.prop_value_id,'') in ('165') or v4.alias4url in ('165') ) and i.id in (18903,18906,18907,18929,18932,18946,18947,18994,18995,19036,19037,19038,19058,19059,19060,19061,19062,19063,19064,19065,19066,19067,19068,19069,19070,19071,19072,19073,19074,19075,19076,19077,19078,19079,19080,19081,19082,19084,19091,19092,19094,19095,19096,19104,19112,19145,19146,19147,19148,19149,19150,19151,19152,19153,19155,19182,19203,19204,19205,19227,19228,19254,19305,19334,19335,19396,19471,19477,20783,20784,20785,20786,20787,20788,20789,20790,20792,20793,20794,20795,20796,20797,20798,20799,20800,20801,20802,20803,20805,20806,20807,20808,20809,20810,20811,20813,20814,20815,20816,20817,20818,20819,20820,20821,20822,20823,20824,20825,20826,20827,20828,20829,20830,20831,20833,20835,20836,20837,20838,20839,20840,20841,20842,20843,20844,20845,20846,20847,20848,20849,20850,20851,20852,20853,20854,20855,20856,20857,20858,20859,20860,20861,20862,20863,20864,20865,20866,20867,20868,20869,20870,20871,20872,20873,20874,20875,20876,20877,20878,20879,20880,20881,20883,20884,20886,20887,20888,20889,20890,20891,20892,20893,20894,20895,20896,20897,20898,20899,20900,20901,20902,20903,20904,20905,20906,20907,20908,20909,20910,20911,20912,20913,20914,20915,20916,20917,20918,20919,20920,20921,20922,20923,20924,20925,20926,20927,20928,20929,20930,20931,20932,20933,20934,20936,20937,20938,20940,20941,20942,20943,20944,20946,20948,20949,20950,20951,20952,20954,20955,20956,20957,20958,20959,20960,20961,20962,20963,20964,20965,20966,20967,20968,20969,20970,20971,20972,20973,20974,20975,20976,20977,20978,20979,20980,20981,20982,20983,20984,20985,20986,20987,20988,20989,20990,20991,20992,20993,20994,20995,20996,20997,20998,20999,21000,21001,21002,21003,21004,21005,21006,21007,21008,21009,21010,21011,21012,21013,21014,21015,21016,21017,21018,21019,21020,21021,21022,21023,21024,21025,21026,21027,21028,21029,21030,21031,21032,21033,21034,21035,21036,21037,21038,21039,21040,21041,21042,21043,21044,21045,21046,21047,21048,21049,21050,21052,21053,21054) and i.black=0 group by i.id having group_concat(distinct p.id order by p.id) = '1,3,4,35' and prim_img_fn and prim_img_fn is not null and price>0 [1] => [2] => Resource id #1 [3] => admin_logistock ) ) [5] => Array ( [file] => /home/admin/web/logistock.ru/public_html/MDB2.php [line] => 3442 [function] => query [class] => MDB2_Driver_Common [object] => MDB2_Driver_mysql Object ( [string_quoting] => Array ( [start] => ' [end] => ' [escape] => \ [escape_pattern] => \ ) [identifier_quoting] => Array ( [start] => ` [end] => ` [escape] => ` ) [sql_comments] => Array ( [0] => Array ( [start] => -- [end] => [escape] => ) [1] => Array ( [start] => # [end] => [escape] => ) [2] => Array ( [start] => /* [end] => */ [escape] => ) ) [server_capabilities_checked:protected] => 1 [start_transaction:protected] => 1 [varchar_max_length] => 65532 [datatype] => [extended] => MDB2_Extended Object ( [db_index:protected] => 1 ) [function] => [manager] => [native] => [reverse] => [db_index] => 1 [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => admin_logistock [password] => xpdmdZJfAO [protocol] => [hostspec] => localhost [port] => [socket] => [database] => [mode] => ) [connected_dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => admin_logistock [password] => xpdmdZJfAO [protocol] => [hostspec] => localhost [port] => [socket] => [database] => [mode] => ) [connection] => Resource id #1 [opened_persistent] => [database_name] => admin_logistock [connected_database_name] => admin_logistock [connected_server_info] => 5.5.49 [supported] => Array ( [sequences] => emulated [indexes] => 1 [affected_rows] => 1 [summary_functions] => 1 [order_by_text] => 1 [transactions] => 1 [savepoints] => 1 [current_id] => emulated [limit_queries] => 1 [LOBs] => 1 [replace] => 1 [sub_selects] => 1 [triggers] => 1 [auto_increment] => 1 [primary_key] => 1 [result_introspection] => 1 [prepared_statements] => 1 [identifier_quoting] => 1 [pattern_escaping] => 1 [new_link] => 1 ) [options] => Array ( [ssl] => [field_case] => 0 [disable_query] => [result_class] => MDB2_Result_%s [buffered_result_class] => MDB2_BufferedResult_%s [result_wrap_class] => [result_buffering] => 1 [fetch_class] => stdClass [persistent] => [debug] => 0 [debug_handler] => MDB2_defaultDebugOutput [debug_expanded_output] => [default_text_field_length] => 4096 [lob_buffer_length] => 8192 [log_line_break] => [idxname_format] => %s_idx [seqname_format] => %s_seq [savepoint_format] => MDB2_SAVEPOINT_%s [statement_format] => MDB2_STATEMENT_%1$s_%2$s [seqcol_name] => sequence [quote_identifier] => [use_transactions] => 1 [decimal_places] => 2 [portability] => 0 [modules] => Array ( [ex] => Extended [dt] => Datatype [mg] => Manager [rv] => Reverse [na] => Native [fc] => Function ) [emulate_prepared] => [datatype_map] => Array ( ) [datatype_map_callback] => Array ( ) [nativetype_map_callback] => Array ( ) [lob_allow_url_include] => [bindname_format] => (?:\d+)|(?:[a-zA-Z][a-zA-Z0-9_]*) [max_identifiers_length] => 64 [default_fk_action_onupdate] => RESTRICT [default_fk_action_ondelete] => RESTRICT [DBA_username] => [DBA_password] => [default_table_type] => ) [wildcards:protected] => Array ( [0] => % [1] => _ ) [as_keyword] => AS [warnings] => Array ( ) [debug_output] => [in_transaction] => [nested_transaction_counter] => [has_transaction_error:protected] => [offset] => 0 [limit] => 0 [phptype] => mysql [dbsyntax] => mysql [last_query] => select SQL_CALC_FOUND_ROWS i.*, sc.name, sc.alias4url, ip_price.value_int price, v_avail.value_varchar avail , group_concat(sale_sc.name) sale_names, group_concat(sale_sc.alias4url) sale_alias4urls, group_concat(sale_i.id) sale_ids , ip_avail.prop_value_id avail_id , ip_cat.prop_value_id cat_id , v_type.value_varchar cat , v_brand.value_varchar brand , group_concat(distinct p.id order by p.id) mands , REPLACE(sc.name, '&', '&') name4xml , max(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE((concat(ii.static_img_id, '_', si.orig_filename)), ' ', '%20'), '\#', '%23'), '&', '&'), '+', '%2B'), ',', '-')) prim_img_fn , IF(ubd.id is not null and bd.discount>12, round(ip_price.value_int*(bd.discount-12)/400),0) as basic_bonus , v_cat.alias4url cat_alias4url , ip_cat.prop_value_id category_id , ip_brand.prop_value_id brand_id , IF(ubd.id is not null, round(IF(bd.discount>12,ip_price.value_int*(bd.discount-12)/800,0) + ip_price.value_int*bd.bonus/1000),0) as expert_bonus , REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( sc.html, ' ', ''), '—', '-'), '–', '-'), '«', '"'), '»', '"'), '®', '') , '°', 'o'), '•', '-'), '“', '"'), '”', '"') description , max(ig.item_gift_id) item_gift_id , max(gsc.name) gift_name , IFNULL(ima.articul, iua.articul) articul, IFNULL(ima.name, iua.name) articul_name from item i join static_content sc on sc.id=i.static_id join static_img si on si.static_id=i.static_id and si.prim join item_img ii on si.id=ii.static_img_id join item_prop_value ip_price on ip_price.prop_id=1 and ip_price.item_id=i.id join item_prop_value ip_brand on ip_brand.prop_id=4 and ip_brand.item_id=i.id join item_prop_value ip_cat on ip_cat.prop_id=3 and ip_cat.item_id=i.id join item_prop_value ip_type on ip_type.prop_id=35 and ip_type.item_id=i.id join prop_value v_type on v_type.id=ip_type.prop_value_id join prop_value v_brand on v_brand.id=ip_brand.prop_value_id join prop_value v_cat on v_cat.id=ip_cat.prop_value_id left join item_gift ig on ig.item_id=i.id left join item igi on igi.id=ig.item_gift_id left join static_content gsc on gsc.id=igi.static_id left join item_prop_value ip_avail on ip_avail.prop_id=2 and ip_avail.item_id=i.id left join prop_value v_avail on v_avail.id=ip_avail.prop_value_id left join item_prop_value pv on pv.item_id=i.id left join prop p on p.id=pv.prop_id and p.mand left join prop_value v on v.id=pv.prop_value_id left join bonus_disco bd on IF(bd.category_id=0, ip_cat.prop_value_id, bd.category_id)=ip_cat.prop_value_id and IF(bd.brand_id=0, ip_brand.prop_value_id, bd.brand_id)=ip_brand.prop_value_id left join users ubd on ubd.id=bd.user_id left join `item_manuf_articul` ima on i.id=ima.item_id left join `item_user_avail` iua on i.id=iua.item_id left join item sale_i on sale_i.sale_id=i.id left join static_content sale_sc on sale_sc.id=sale_i.static_id left join item_prop_value pv4 on pv4.prop_id=4 and pv4.item_id=i.id left join prop_value v4 on v4.id=pv4.prop_value_id where 1 and (IFNULL(pv4.prop_value_id,'') in ('165') or v4.alias4url in ('165') ) and i.id in (18903,18906,18907,18929,18932,18946,18947,18994,18995,19036,19037,19038,19058,19059,19060,19061,19062,19063,19064,19065,19066,19067,19068,19069,19070,19071,19072,19073,19074,19075,19076,19077,19078,19079,19080,19081,19082,19084,19091,19092,19094,19095,19096,19104,19112,19145,19146,19147,19148,19149,19150,19151,19152,19153,19155,19182,19203,19204,19205,19227,19228,19254,19305,19334,19335,19396,19471,19477,20783,20784,20785,20786,20787,20788,20789,20790,20792,20793,20794,20795,20796,20797,20798,20799,20800,20801,20802,20803,20805,20806,20807,20808,20809,20810,20811,20813,20814,20815,20816,20817,20818,20819,20820,20821,20822,20823,20824,20825,20826,20827,20828,20829,20830,20831,20833,20835,20836,20837,20838,20839,20840,20841,20842,20843,20844,20845,20846,20847,20848,20849,20850,20851,20852,20853,20854,20855,20856,20857,20858,20859,20860,20861,20862,20863,20864,20865,20866,20867,20868,20869,20870,20871,20872,20873,20874,20875,20876,20877,20878,20879,20880,20881,20883,20884,20886,20887,20888,20889,20890,20891,20892,20893,20894,20895,20896,20897,20898,20899,20900,20901,20902,20903,20904,20905,20906,20907,20908,20909,20910,20911,20912,20913,20914,20915,20916,20917,20918,20919,20920,20921,20922,20923,20924,20925,20926,20927,20928,20929,20930,20931,20932,20933,20934,20936,20937,20938,20940,20941,20942,20943,20944,20946,20948,20949,20950,20951,20952,20954,20955,20956,20957,20958,20959,20960,20961,20962,20963,20964,20965,20966,20967,20968,20969,20970,20971,20972,20973,20974,20975,20976,20977,20978,20979,20980,20981,20982,20983,20984,20985,20986,20987,20988,20989,20990,20991,20992,20993,20994,20995,20996,20997,20998,20999,21000,21001,21002,21003,21004,21005,21006,21007,21008,21009,21010,21011,21012,21013,21014,21015,21016,21017,21018,21019,21020,21021,21022,21023,21024,21025,21026,21027,21028,21029,21030,21031,21032,21033,21034,21035,21036,21037,21038,21039,21040,21041,21042,21043,21044,21045,21046,21047,21048,21049,21050,21052,21053,21054) and i.black=0 group by i.id having group_concat(distinct p.id order by p.id) = '1,3,4,35' and prim_img_fn and prim_img_fn is not null and price>0 [fetchmode] => 3 [modules:protected] => Array ( [Extended] => MDB2_Extended Object ( [db_index:protected] => 1 ) ) [destructor_registered:protected] => 1 [pear:protected] => PEAR Object ( [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => PEAR_Error [_expected_errors] => Array ( ) ) ) [type] => -> [args] => Array ( [0] => select SQL_CALC_FOUND_ROWS i.*, sc.name, sc.alias4url, ip_price.value_int price, v_avail.value_varchar avail , group_concat(sale_sc.name) sale_names, group_concat(sale_sc.alias4url) sale_alias4urls, group_concat(sale_i.id) sale_ids , ip_avail.prop_value_id avail_id , ip_cat.prop_value_id cat_id , v_type.value_varchar cat , v_brand.value_varchar brand , group_concat(distinct p.id order by p.id) mands , REPLACE(sc.name, '&', '&') name4xml , max(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE((concat(ii.static_img_id, '_', si.orig_filename)), ' ', '%20'), '\#', '%23'), '&', '&'), '+', '%2B'), ',', '-')) prim_img_fn , IF(ubd.id is not null and bd.discount>12, round(ip_price.value_int*(bd.discount-12)/400),0) as basic_bonus , v_cat.alias4url cat_alias4url , ip_cat.prop_value_id category_id , ip_brand.prop_value_id brand_id , IF(ubd.id is not null, round(IF(bd.discount>12,ip_price.value_int*(bd.discount-12)/800,0) + ip_price.value_int*bd.bonus/1000),0) as expert_bonus , REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( sc.html, ' ', ''), '—', '-'), '–', '-'), '«', '"'), '»', '"'), '®', '') , '°', 'o'), '•', '-'), '“', '"'), '”', '"') description , max(ig.item_gift_id) item_gift_id , max(gsc.name) gift_name , IFNULL(ima.articul, iua.articul) articul, IFNULL(ima.name, iua.name) articul_name from item i join static_content sc on sc.id=i.static_id join static_img si on si.static_id=i.static_id and si.prim join item_img ii on si.id=ii.static_img_id join item_prop_value ip_price on ip_price.prop_id=1 and ip_price.item_id=i.id join item_prop_value ip_brand on ip_brand.prop_id=4 and ip_brand.item_id=i.id join item_prop_value ip_cat on ip_cat.prop_id=3 and ip_cat.item_id=i.id join item_prop_value ip_type on ip_type.prop_id=35 and ip_type.item_id=i.id join prop_value v_type on v_type.id=ip_type.prop_value_id join prop_value v_brand on v_brand.id=ip_brand.prop_value_id join prop_value v_cat on v_cat.id=ip_cat.prop_value_id left join item_gift ig on ig.item_id=i.id left join item igi on igi.id=ig.item_gift_id left join static_content gsc on gsc.id=igi.static_id left join item_prop_value ip_avail on ip_avail.prop_id=2 and ip_avail.item_id=i.id left join prop_value v_avail on v_avail.id=ip_avail.prop_value_id left join item_prop_value pv on pv.item_id=i.id left join prop p on p.id=pv.prop_id and p.mand left join prop_value v on v.id=pv.prop_value_id left join bonus_disco bd on IF(bd.category_id=0, ip_cat.prop_value_id, bd.category_id)=ip_cat.prop_value_id and IF(bd.brand_id=0, ip_brand.prop_value_id, bd.brand_id)=ip_brand.prop_value_id left join users ubd on ubd.id=bd.user_id left join `item_manuf_articul` ima on i.id=ima.item_id left join `item_user_avail` iua on i.id=iua.item_id left join item sale_i on sale_i.sale_id=i.id left join static_content sale_sc on sale_sc.id=sale_i.static_id left join item_prop_value pv4 on pv4.prop_id=4 and pv4.item_id=i.id left join prop_value v4 on v4.id=pv4.prop_value_id where 1 and (IFNULL(pv4.prop_value_id,'') in ('165') or v4.alias4url in ('165') ) and i.id in (18903,18906,18907,18929,18932,18946,18947,18994,18995,19036,19037,19038,19058,19059,19060,19061,19062,19063,19064,19065,19066,19067,19068,19069,19070,19071,19072,19073,19074,19075,19076,19077,19078,19079,19080,19081,19082,19084,19091,19092,19094,19095,19096,19104,19112,19145,19146,19147,19148,19149,19150,19151,19152,19153,19155,19182,19203,19204,19205,19227,19228,19254,19305,19334,19335,19396,19471,19477,20783,20784,20785,20786,20787,20788,20789,20790,20792,20793,20794,20795,20796,20797,20798,20799,20800,20801,20802,20803,20805,20806,20807,20808,20809,20810,20811,20813,20814,20815,20816,20817,20818,20819,20820,20821,20822,20823,20824,20825,20826,20827,20828,20829,20830,20831,20833,20835,20836,20837,20838,20839,20840,20841,20842,20843,20844,20845,20846,20847,20848,20849,20850,20851,20852,20853,20854,20855,20856,20857,20858,20859,20860,20861,20862,20863,20864,20865,20866,20867,20868,20869,20870,20871,20872,20873,20874,20875,20876,20877,20878,20879,20880,20881,20883,20884,20886,20887,20888,20889,20890,20891,20892,20893,20894,20895,20896,20897,20898,20899,20900,20901,20902,20903,20904,20905,20906,20907,20908,20909,20910,20911,20912,20913,20914,20915,20916,20917,20918,20919,20920,20921,20922,20923,20924,20925,20926,20927,20928,20929,20930,20931,20932,20933,20934,20936,20937,20938,20940,20941,20942,20943,20944,20946,20948,20949,20950,20951,20952,20954,20955,20956,20957,20958,20959,20960,20961,20962,20963,20964,20965,20966,20967,20968,20969,20970,20971,20972,20973,20974,20975,20976,20977,20978,20979,20980,20981,20982,20983,20984,20985,20986,20987,20988,20989,20990,20991,20992,20993,20994,20995,20996,20997,20998,20999,21000,21001,21002,21003,21004,21005,21006,21007,21008,21009,21010,21011,21012,21013,21014,21015,21016,21017,21018,21019,21020,21021,21022,21023,21024,21025,21026,21027,21028,21029,21030,21031,21032,21033,21034,21035,21036,21037,21038,21039,21040,21041,21042,21043,21044,21045,21046,21047,21048,21049,21050,21052,21053,21054) and i.black=0 group by i.id having group_concat(distinct p.id order by p.id) = '1,3,4,35' and prim_img_fn and prim_img_fn is not null and price>0 [1] => ) ) [6] => Array ( [file] => /home/admin/web/logistock.ru/public_html/MDB2/Extended.php [line] => 504 [function] => queryAll [class] => MDB2_Driver_Common [object] => MDB2_Driver_mysql Object ( [string_quoting] => Array ( [start] => ' [end] => ' [escape] => \ [escape_pattern] => \ ) [identifier_quoting] => Array ( [start] => ` [end] => ` [escape] => ` ) [sql_comments] => Array ( [0] => Array ( [start] => -- [end] => [escape] => ) [1] => Array ( [start] => # [end] => [escape] => ) [2] => Array ( [start] => /* [end] => */ [escape] => ) ) [server_capabilities_checked:protected] => 1 [start_transaction:protected] => 1 [varchar_max_length] => 65532 [datatype] => [extended] => MDB2_Extended Object ( [db_index:protected] => 1 ) [function] => [manager] => [native] => [reverse] => [db_index] => 1 [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => admin_logistock [password] => xpdmdZJfAO [protocol] => [hostspec] => localhost [port] => [socket] => [database] => [mode] => ) [connected_dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => admin_logistock [password] => xpdmdZJfAO [protocol] => [hostspec] => localhost [port] => [socket] => [database] => [mode] => ) [connection] => Resource id #1 [opened_persistent] => [database_name] => admin_logistock [connected_database_name] => admin_logistock [connected_server_info] => 5.5.49 [supported] => Array ( [sequences] => emulated [indexes] => 1 [affected_rows] => 1 [summary_functions] => 1 [order_by_text] => 1 [transactions] => 1 [savepoints] => 1 [current_id] => emulated [limit_queries] => 1 [LOBs] => 1 [replace] => 1 [sub_selects] => 1 [triggers] => 1 [auto_increment] => 1 [primary_key] => 1 [result_introspection] => 1 [prepared_statements] => 1 [identifier_quoting] => 1 [pattern_escaping] => 1 [new_link] => 1 ) [options] => Array ( [ssl] => [field_case] => 0 [disable_query] => [result_class] => MDB2_Result_%s [buffered_result_class] => MDB2_BufferedResult_%s [result_wrap_class] => [result_buffering] => 1 [fetch_class] => stdClass [persistent] => [debug] => 0 [debug_handler] => MDB2_defaultDebugOutput [debug_expanded_output] => [default_text_field_length] => 4096 [lob_buffer_length] => 8192 [log_line_break] => [idxname_format] => %s_idx [seqname_format] => %s_seq [savepoint_format] => MDB2_SAVEPOINT_%s [statement_format] => MDB2_STATEMENT_%1$s_%2$s [seqcol_name] => sequence [quote_identifier] => [use_transactions] => 1 [decimal_places] => 2 [portability] => 0 [modules] => Array ( [ex] => Extended [dt] => Datatype [mg] => Manager [rv] => Reverse [na] => Native [fc] => Function ) [emulate_prepared] => [datatype_map] => Array ( ) [datatype_map_callback] => Array ( ) [nativetype_map_callback] => Array ( ) [lob_allow_url_include] => [bindname_format] => (?:\d+)|(?:[a-zA-Z][a-zA-Z0-9_]*) [max_identifiers_length] => 64 [default_fk_action_onupdate] => RESTRICT [default_fk_action_ondelete] => RESTRICT [DBA_username] => [DBA_password] => [default_table_type] => ) [wildcards:protected] => Array ( [0] => % [1] => _ ) [as_keyword] => AS [warnings] => Array ( ) [debug_output] => [in_transaction] => [nested_transaction_counter] => [has_transaction_error:protected] => [offset] => 0 [limit] => 0 [phptype] => mysql [dbsyntax] => mysql [last_query] => select SQL_CALC_FOUND_ROWS i.*, sc.name, sc.alias4url, ip_price.value_int price, v_avail.value_varchar avail , group_concat(sale_sc.name) sale_names, group_concat(sale_sc.alias4url) sale_alias4urls, group_concat(sale_i.id) sale_ids , ip_avail.prop_value_id avail_id , ip_cat.prop_value_id cat_id , v_type.value_varchar cat , v_brand.value_varchar brand , group_concat(distinct p.id order by p.id) mands , REPLACE(sc.name, '&', '&') name4xml , max(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE((concat(ii.static_img_id, '_', si.orig_filename)), ' ', '%20'), '\#', '%23'), '&', '&'), '+', '%2B'), ',', '-')) prim_img_fn , IF(ubd.id is not null and bd.discount>12, round(ip_price.value_int*(bd.discount-12)/400),0) as basic_bonus , v_cat.alias4url cat_alias4url , ip_cat.prop_value_id category_id , ip_brand.prop_value_id brand_id , IF(ubd.id is not null, round(IF(bd.discount>12,ip_price.value_int*(bd.discount-12)/800,0) + ip_price.value_int*bd.bonus/1000),0) as expert_bonus , REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( sc.html, ' ', ''), '—', '-'), '–', '-'), '«', '"'), '»', '"'), '®', '') , '°', 'o'), '•', '-'), '“', '"'), '”', '"') description , max(ig.item_gift_id) item_gift_id , max(gsc.name) gift_name , IFNULL(ima.articul, iua.articul) articul, IFNULL(ima.name, iua.name) articul_name from item i join static_content sc on sc.id=i.static_id join static_img si on si.static_id=i.static_id and si.prim join item_img ii on si.id=ii.static_img_id join item_prop_value ip_price on ip_price.prop_id=1 and ip_price.item_id=i.id join item_prop_value ip_brand on ip_brand.prop_id=4 and ip_brand.item_id=i.id join item_prop_value ip_cat on ip_cat.prop_id=3 and ip_cat.item_id=i.id join item_prop_value ip_type on ip_type.prop_id=35 and ip_type.item_id=i.id join prop_value v_type on v_type.id=ip_type.prop_value_id join prop_value v_brand on v_brand.id=ip_brand.prop_value_id join prop_value v_cat on v_cat.id=ip_cat.prop_value_id left join item_gift ig on ig.item_id=i.id left join item igi on igi.id=ig.item_gift_id left join static_content gsc on gsc.id=igi.static_id left join item_prop_value ip_avail on ip_avail.prop_id=2 and ip_avail.item_id=i.id left join prop_value v_avail on v_avail.id=ip_avail.prop_value_id left join item_prop_value pv on pv.item_id=i.id left join prop p on p.id=pv.prop_id and p.mand left join prop_value v on v.id=pv.prop_value_id left join bonus_disco bd on IF(bd.category_id=0, ip_cat.prop_value_id, bd.category_id)=ip_cat.prop_value_id and IF(bd.brand_id=0, ip_brand.prop_value_id, bd.brand_id)=ip_brand.prop_value_id left join users ubd on ubd.id=bd.user_id left join `item_manuf_articul` ima on i.id=ima.item_id left join `item_user_avail` iua on i.id=iua.item_id left join item sale_i on sale_i.sale_id=i.id left join static_content sale_sc on sale_sc.id=sale_i.static_id left join item_prop_value pv4 on pv4.prop_id=4 and pv4.item_id=i.id left join prop_value v4 on v4.id=pv4.prop_value_id where 1 and (IFNULL(pv4.prop_value_id,'') in ('165') or v4.alias4url in ('165') ) and i.id in (18903,18906,18907,18929,18932,18946,18947,18994,18995,19036,19037,19038,19058,19059,19060,19061,19062,19063,19064,19065,19066,19067,19068,19069,19070,19071,19072,19073,19074,19075,19076,19077,19078,19079,19080,19081,19082,19084,19091,19092,19094,19095,19096,19104,19112,19145,19146,19147,19148,19149,19150,19151,19152,19153,19155,19182,19203,19204,19205,19227,19228,19254,19305,19334,19335,19396,19471,19477,20783,20784,20785,20786,20787,20788,20789,20790,20792,20793,20794,20795,20796,20797,20798,20799,20800,20801,20802,20803,20805,20806,20807,20808,20809,20810,20811,20813,20814,20815,20816,20817,20818,20819,20820,20821,20822,20823,20824,20825,20826,20827,20828,20829,20830,20831,20833,20835,20836,20837,20838,20839,20840,20841,20842,20843,20844,20845,20846,20847,20848,20849,20850,20851,20852,20853,20854,20855,20856,20857,20858,20859,20860,20861,20862,20863,20864,20865,20866,20867,20868,20869,20870,20871,20872,20873,20874,20875,20876,20877,20878,20879,20880,20881,20883,20884,20886,20887,20888,20889,20890,20891,20892,20893,20894,20895,20896,20897,20898,20899,20900,20901,20902,20903,20904,20905,20906,20907,20908,20909,20910,20911,20912,20913,20914,20915,20916,20917,20918,20919,20920,20921,20922,20923,20924,20925,20926,20927,20928,20929,20930,20931,20932,20933,20934,20936,20937,20938,20940,20941,20942,20943,20944,20946,20948,20949,20950,20951,20952,20954,20955,20956,20957,20958,20959,20960,20961,20962,20963,20964,20965,20966,20967,20968,20969,20970,20971,20972,20973,20974,20975,20976,20977,20978,20979,20980,20981,20982,20983,20984,20985,20986,20987,20988,20989,20990,20991,20992,20993,20994,20995,20996,20997,20998,20999,21000,21001,21002,21003,21004,21005,21006,21007,21008,21009,21010,21011,21012,21013,21014,21015,21016,21017,21018,21019,21020,21021,21022,21023,21024,21025,21026,21027,21028,21029,21030,21031,21032,21033,21034,21035,21036,21037,21038,21039,21040,21041,21042,21043,21044,21045,21046,21047,21048,21049,21050,21052,21053,21054) and i.black=0 group by i.id having group_concat(distinct p.id order by p.id) = '1,3,4,35' and prim_img_fn and prim_img_fn is not null and price>0 [fetchmode] => 3 [modules:protected] => Array ( [Extended] => MDB2_Extended Object ( [db_index:protected] => 1 ) ) [destructor_registered:protected] => 1 [pear:protected] => PEAR Object ( [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => PEAR_Error [_expected_errors] => Array ( ) ) ) [type] => -> [args] => Array ( [0] => select SQL_CALC_FOUND_ROWS i.*, sc.name, sc.alias4url, ip_price.value_int price, v_avail.value_varchar avail , group_concat(sale_sc.name) sale_names, group_concat(sale_sc.alias4url) sale_alias4urls, group_concat(sale_i.id) sale_ids , ip_avail.prop_value_id avail_id , ip_cat.prop_value_id cat_id , v_type.value_varchar cat , v_brand.value_varchar brand , group_concat(distinct p.id order by p.id) mands , REPLACE(sc.name, '&', '&') name4xml , max(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE((concat(ii.static_img_id, '_', si.orig_filename)), ' ', '%20'), '\#', '%23'), '&', '&'), '+', '%2B'), ',', '-')) prim_img_fn , IF(ubd.id is not null and bd.discount>12, round(ip_price.value_int*(bd.discount-12)/400),0) as basic_bonus , v_cat.alias4url cat_alias4url , ip_cat.prop_value_id category_id , ip_brand.prop_value_id brand_id , IF(ubd.id is not null, round(IF(bd.discount>12,ip_price.value_int*(bd.discount-12)/800,0) + ip_price.value_int*bd.bonus/1000),0) as expert_bonus , REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( sc.html, ' ', ''), '—', '-'), '–', '-'), '«', '"'), '»', '"'), '®', '') , '°', 'o'), '•', '-'), '“', '"'), '”', '"') description , max(ig.item_gift_id) item_gift_id , max(gsc.name) gift_name , IFNULL(ima.articul, iua.articul) articul, IFNULL(ima.name, iua.name) articul_name from item i join static_content sc on sc.id=i.static_id join static_img si on si.static_id=i.static_id and si.prim join item_img ii on si.id=ii.static_img_id join item_prop_value ip_price on ip_price.prop_id=1 and ip_price.item_id=i.id join item_prop_value ip_brand on ip_brand.prop_id=4 and ip_brand.item_id=i.id join item_prop_value ip_cat on ip_cat.prop_id=3 and ip_cat.item_id=i.id join item_prop_value ip_type on ip_type.prop_id=35 and ip_type.item_id=i.id join prop_value v_type on v_type.id=ip_type.prop_value_id join prop_value v_brand on v_brand.id=ip_brand.prop_value_id join prop_value v_cat on v_cat.id=ip_cat.prop_value_id left join item_gift ig on ig.item_id=i.id left join item igi on igi.id=ig.item_gift_id left join static_content gsc on gsc.id=igi.static_id left join item_prop_value ip_avail on ip_avail.prop_id=2 and ip_avail.item_id=i.id left join prop_value v_avail on v_avail.id=ip_avail.prop_value_id left join item_prop_value pv on pv.item_id=i.id left join prop p on p.id=pv.prop_id and p.mand left join prop_value v on v.id=pv.prop_value_id left join bonus_disco bd on IF(bd.category_id=0, ip_cat.prop_value_id, bd.category_id)=ip_cat.prop_value_id and IF(bd.brand_id=0, ip_brand.prop_value_id, bd.brand_id)=ip_brand.prop_value_id left join users ubd on ubd.id=bd.user_id left join `item_manuf_articul` ima on i.id=ima.item_id left join `item_user_avail` iua on i.id=iua.item_id left join item sale_i on sale_i.sale_id=i.id left join static_content sale_sc on sale_sc.id=sale_i.static_id left join item_prop_value pv4 on pv4.prop_id=4 and pv4.item_id=i.id left join prop_value v4 on v4.id=pv4.prop_value_id where 1 and (IFNULL(pv4.prop_value_id,'') in ('165') or v4.alias4url in ('165') ) and i.id in (18903,18906,18907,18929,18932,18946,18947,18994,18995,19036,19037,19038,19058,19059,19060,19061,19062,19063,19064,19065,19066,19067,19068,19069,19070,19071,19072,19073,19074,19075,19076,19077,19078,19079,19080,19081,19082,19084,19091,19092,19094,19095,19096,19104,19112,19145,19146,19147,19148,19149,19150,19151,19152,19153,19155,19182,19203,19204,19205,19227,19228,19254,19305,19334,19335,19396,19471,19477,20783,20784,20785,20786,20787,20788,20789,20790,20792,20793,20794,20795,20796,20797,20798,20799,20800,20801,20802,20803,20805,20806,20807,20808,20809,20810,20811,20813,20814,20815,20816,20817,20818,20819,20820,20821,20822,20823,20824,20825,20826,20827,20828,20829,20830,20831,20833,20835,20836,20837,20838,20839,20840,20841,20842,20843,20844,20845,20846,20847,20848,20849,20850,20851,20852,20853,20854,20855,20856,20857,20858,20859,20860,20861,20862,20863,20864,20865,20866,20867,20868,20869,20870,20871,20872,20873,20874,20875,20876,20877,20878,20879,20880,20881,20883,20884,20886,20887,20888,20889,20890,20891,20892,20893,20894,20895,20896,20897,20898,20899,20900,20901,20902,20903,20904,20905,20906,20907,20908,20909,20910,20911,20912,20913,20914,20915,20916,20917,20918,20919,20920,20921,20922,20923,20924,20925,20926,20927,20928,20929,20930,20931,20932,20933,20934,20936,20937,20938,20940,20941,20942,20943,20944,20946,20948,20949,20950,20951,20952,20954,20955,20956,20957,20958,20959,20960,20961,20962,20963,20964,20965,20966,20967,20968,20969,20970,20971,20972,20973,20974,20975,20976,20977,20978,20979,20980,20981,20982,20983,20984,20985,20986,20987,20988,20989,20990,20991,20992,20993,20994,20995,20996,20997,20998,20999,21000,21001,21002,21003,21004,21005,21006,21007,21008,21009,21010,21011,21012,21013,21014,21015,21016,21017,21018,21019,21020,21021,21022,21023,21024,21025,21026,21027,21028,21029,21030,21031,21032,21033,21034,21035,21036,21037,21038,21039,21040,21041,21042,21043,21044,21045,21046,21047,21048,21049,21050,21052,21053,21054) and i.black=0 group by i.id having group_concat(distinct p.id order by p.id) = '1,3,4,35' and prim_img_fn and prim_img_fn is not null and price>0 [1] => [2] => 0 [3] => [4] => [5] => ) ) [7] => Array ( [function] => getAll [class] => MDB2_Extended [object] => MDB2_Extended Object ( [db_index:protected] => 1 ) [type] => -> [args] => Array ( [0] => select SQL_CALC_FOUND_ROWS i.*, sc.name, sc.alias4url, ip_price.value_int price, v_avail.value_varchar avail , group_concat(sale_sc.name) sale_names, group_concat(sale_sc.alias4url) sale_alias4urls, group_concat(sale_i.id) sale_ids , ip_avail.prop_value_id avail_id , ip_cat.prop_value_id cat_id , v_type.value_varchar cat , v_brand.value_varchar brand , group_concat(distinct p.id order by p.id) mands , REPLACE(sc.name, '&', '&') name4xml , max(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE((concat(ii.static_img_id, '_', si.orig_filename)), ' ', '%20'), '\#', '%23'), '&', '&'), '+', '%2B'), ',', '-')) prim_img_fn , IF(ubd.id is not null and bd.discount>12, round(ip_price.value_int*(bd.discount-12)/400),0) as basic_bonus , v_cat.alias4url cat_alias4url , ip_cat.prop_value_id category_id , ip_brand.prop_value_id brand_id , IF(ubd.id is not null, round(IF(bd.discount>12,ip_price.value_int*(bd.discount-12)/800,0) + ip_price.value_int*bd.bonus/1000),0) as expert_bonus , REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( sc.html, ' ', ''), '—', '-'), '–', '-'), '«', '"'), '»', '"'), '®', '') , '°', 'o'), '•', '-'), '“', '"'), '”', '"') description , max(ig.item_gift_id) item_gift_id , max(gsc.name) gift_name , IFNULL(ima.articul, iua.articul) articul, IFNULL(ima.name, iua.name) articul_name from item i join static_content sc on sc.id=i.static_id join static_img si on si.static_id=i.static_id and si.prim join item_img ii on si.id=ii.static_img_id join item_prop_value ip_price on ip_price.prop_id=1 and ip_price.item_id=i.id join item_prop_value ip_brand on ip_brand.prop_id=4 and ip_brand.item_id=i.id join item_prop_value ip_cat on ip_cat.prop_id=3 and ip_cat.item_id=i.id join item_prop_value ip_type on ip_type.prop_id=35 and ip_type.item_id=i.id join prop_value v_type on v_type.id=ip_type.prop_value_id join prop_value v_brand on v_brand.id=ip_brand.prop_value_id join prop_value v_cat on v_cat.id=ip_cat.prop_value_id left join item_gift ig on ig.item_id=i.id left join item igi on igi.id=ig.item_gift_id left join static_content gsc on gsc.id=igi.static_id left join item_prop_value ip_avail on ip_avail.prop_id=2 and ip_avail.item_id=i.id left join prop_value v_avail on v_avail.id=ip_avail.prop_value_id left join item_prop_value pv on pv.item_id=i.id left join prop p on p.id=pv.prop_id and p.mand left join prop_value v on v.id=pv.prop_value_id left join bonus_disco bd on IF(bd.category_id=0, ip_cat.prop_value_id, bd.category_id)=ip_cat.prop_value_id and IF(bd.brand_id=0, ip_brand.prop_value_id, bd.brand_id)=ip_brand.prop_value_id left join users ubd on ubd.id=bd.user_id left join `item_manuf_articul` ima on i.id=ima.item_id left join `item_user_avail` iua on i.id=iua.item_id left join item sale_i on sale_i.sale_id=i.id left join static_content sale_sc on sale_sc.id=sale_i.static_id left join item_prop_value pv4 on pv4.prop_id=4 and pv4.item_id=i.id left join prop_value v4 on v4.id=pv4.prop_value_id where 1 and (IFNULL(pv4.prop_value_id,'') in ('165') or v4.alias4url in ('165') ) and i.id in (18903,18906,18907,18929,18932,18946,18947,18994,18995,19036,19037,19038,19058,19059,19060,19061,19062,19063,19064,19065,19066,19067,19068,19069,19070,19071,19072,19073,19074,19075,19076,19077,19078,19079,19080,19081,19082,19084,19091,19092,19094,19095,19096,19104,19112,19145,19146,19147,19148,19149,19150,19151,19152,19153,19155,19182,19203,19204,19205,19227,19228,19254,19305,19334,19335,19396,19471,19477,20783,20784,20785,20786,20787,20788,20789,20790,20792,20793,20794,20795,20796,20797,20798,20799,20800,20801,20802,20803,20805,20806,20807,20808,20809,20810,20811,20813,20814,20815,20816,20817,20818,20819,20820,20821,20822,20823,20824,20825,20826,20827,20828,20829,20830,20831,20833,20835,20836,20837,20838,20839,20840,20841,20842,20843,20844,20845,20846,20847,20848,20849,20850,20851,20852,20853,20854,20855,20856,20857,20858,20859,20860,20861,20862,20863,20864,20865,20866,20867,20868,20869,20870,20871,20872,20873,20874,20875,20876,20877,20878,20879,20880,20881,20883,20884,20886,20887,20888,20889,20890,20891,20892,20893,20894,20895,20896,20897,20898,20899,20900,20901,20902,20903,20904,20905,20906,20907,20908,20909,20910,20911,20912,20913,20914,20915,20916,20917,20918,20919,20920,20921,20922,20923,20924,20925,20926,20927,20928,20929,20930,20931,20932,20933,20934,20936,20937,20938,20940,20941,20942,20943,20944,20946,20948,20949,20950,20951,20952,20954,20955,20956,20957,20958,20959,20960,20961,20962,20963,20964,20965,20966,20967,20968,20969,20970,20971,20972,20973,20974,20975,20976,20977,20978,20979,20980,20981,20982,20983,20984,20985,20986,20987,20988,20989,20990,20991,20992,20993,20994,20995,20996,20997,20998,20999,21000,21001,21002,21003,21004,21005,21006,21007,21008,21009,21010,21011,21012,21013,21014,21015,21016,21017,21018,21019,21020,21021,21022,21023,21024,21025,21026,21027,21028,21029,21030,21031,21032,21033,21034,21035,21036,21037,21038,21039,21040,21041,21042,21043,21044,21045,21046,21047,21048,21049,21050,21052,21053,21054) and i.black=0 group by i.id having group_concat(distinct p.id order by p.id) = '1,3,4,35' and prim_img_fn and prim_img_fn is not null and price>0 ) ) [8] => Array ( [file] => /home/admin/web/logistock.ru/public_html/MDB2.php [line] => 1994 [function] => call_user_func_array [args] => Array ( [0] => Array ( [0] => MDB2_Extended Object ( [db_index:protected] => 1 ) [1] => getAll ) [1] => Array ( [0] => select SQL_CALC_FOUND_ROWS i.*, sc.name, sc.alias4url, ip_price.value_int price, v_avail.value_varchar avail , group_concat(sale_sc.name) sale_names, group_concat(sale_sc.alias4url) sale_alias4urls, group_concat(sale_i.id) sale_ids , ip_avail.prop_value_id avail_id , ip_cat.prop_value_id cat_id , v_type.value_varchar cat , v_brand.value_varchar brand , group_concat(distinct p.id order by p.id) mands , REPLACE(sc.name, '&', '&') name4xml , max(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE((concat(ii.static_img_id, '_', si.orig_filename)), ' ', '%20'), '\#', '%23'), '&', '&'), '+', '%2B'), ',', '-')) prim_img_fn , IF(ubd.id is not null and bd.discount>12, round(ip_price.value_int*(bd.discount-12)/400),0) as basic_bonus , v_cat.alias4url cat_alias4url , ip_cat.prop_value_id category_id , ip_brand.prop_value_id brand_id , IF(ubd.id is not null, round(IF(bd.discount>12,ip_price.value_int*(bd.discount-12)/800,0) + ip_price.value_int*bd.bonus/1000),0) as expert_bonus , REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( sc.html, ' ', ''), '—', '-'), '–', '-'), '«', '"'), '»', '"'), '®', '') , '°', 'o'), '•', '-'), '“', '"'), '”', '"') description , max(ig.item_gift_id) item_gift_id , max(gsc.name) gift_name , IFNULL(ima.articul, iua.articul) articul, IFNULL(ima.name, iua.name) articul_name from item i join static_content sc on sc.id=i.static_id join static_img si on si.static_id=i.static_id and si.prim join item_img ii on si.id=ii.static_img_id join item_prop_value ip_price on ip_price.prop_id=1 and ip_price.item_id=i.id join item_prop_value ip_brand on ip_brand.prop_id=4 and ip_brand.item_id=i.id join item_prop_value ip_cat on ip_cat.prop_id=3 and ip_cat.item_id=i.id join item_prop_value ip_type on ip_type.prop_id=35 and ip_type.item_id=i.id join prop_value v_type on v_type.id=ip_type.prop_value_id join prop_value v_brand on v_brand.id=ip_brand.prop_value_id join prop_value v_cat on v_cat.id=ip_cat.prop_value_id left join item_gift ig on ig.item_id=i.id left join item igi on igi.id=ig.item_gift_id left join static_content gsc on gsc.id=igi.static_id left join item_prop_value ip_avail on ip_avail.prop_id=2 and ip_avail.item_id=i.id left join prop_value v_avail on v_avail.id=ip_avail.prop_value_id left join item_prop_value pv on pv.item_id=i.id left join prop p on p.id=pv.prop_id and p.mand left join prop_value v on v.id=pv.prop_value_id left join bonus_disco bd on IF(bd.category_id=0, ip_cat.prop_value_id, bd.category_id)=ip_cat.prop_value_id and IF(bd.brand_id=0, ip_brand.prop_value_id, bd.brand_id)=ip_brand.prop_value_id left join users ubd on ubd.id=bd.user_id left join `item_manuf_articul` ima on i.id=ima.item_id left join `item_user_avail` iua on i.id=iua.item_id left join item sale_i on sale_i.sale_id=i.id left join static_content sale_sc on sale_sc.id=sale_i.static_id left join item_prop_value pv4 on pv4.prop_id=4 and pv4.item_id=i.id left join prop_value v4 on v4.id=pv4.prop_value_id where 1 and (IFNULL(pv4.prop_value_id,'') in ('165') or v4.alias4url in ('165') ) and i.id in (18903,18906,18907,18929,18932,18946,18947,18994,18995,19036,19037,19038,19058,19059,19060,19061,19062,19063,19064,19065,19066,19067,19068,19069,19070,19071,19072,19073,19074,19075,19076,19077,19078,19079,19080,19081,19082,19084,19091,19092,19094,19095,19096,19104,19112,19145,19146,19147,19148,19149,19150,19151,19152,19153,19155,19182,19203,19204,19205,19227,19228,19254,19305,19334,19335,19396,19471,19477,20783,20784,20785,20786,20787,20788,20789,20790,20792,20793,20794,20795,20796,20797,20798,20799,20800,20801,20802,20803,20805,20806,20807,20808,20809,20810,20811,20813,20814,20815,20816,20817,20818,20819,20820,20821,20822,20823,20824,20825,20826,20827,20828,20829,20830,20831,20833,20835,20836,20837,20838,20839,20840,20841,20842,20843,20844,20845,20846,20847,20848,20849,20850,20851,20852,20853,20854,20855,20856,20857,20858,20859,20860,20861,20862,20863,20864,20865,20866,20867,20868,20869,20870,20871,20872,20873,20874,20875,20876,20877,20878,20879,20880,20881,20883,20884,20886,20887,20888,20889,20890,20891,20892,20893,20894,20895,20896,20897,20898,20899,20900,20901,20902,20903,20904,20905,20906,20907,20908,20909,20910,20911,20912,20913,20914,20915,20916,20917,20918,20919,20920,20921,20922,20923,20924,20925,20926,20927,20928,20929,20930,20931,20932,20933,20934,20936,20937,20938,20940,20941,20942,20943,20944,20946,20948,20949,20950,20951,20952,20954,20955,20956,20957,20958,20959,20960,20961,20962,20963,20964,20965,20966,20967,20968,20969,20970,20971,20972,20973,20974,20975,20976,20977,20978,20979,20980,20981,20982,20983,20984,20985,20986,20987,20988,20989,20990,20991,20992,20993,20994,20995,20996,20997,20998,20999,21000,21001,21002,21003,21004,21005,21006,21007,21008,21009,21010,21011,21012,21013,21014,21015,21016,21017,21018,21019,21020,21021,21022,21023,21024,21025,21026,21027,21028,21029,21030,21031,21032,21033,21034,21035,21036,21037,21038,21039,21040,21041,21042,21043,21044,21045,21046,21047,21048,21049,21050,21052,21053,21054) and i.black=0 group by i.id having group_concat(distinct p.id order by p.id) = '1,3,4,35' and prim_img_fn and prim_img_fn is not null and price>0 ) ) ) [9] => Array ( [file] => /home/admin/web/logistock.ru/public_html/lib/Item.php [line] => 963 [function] => __call [class] => MDB2_Driver_Common [object] => MDB2_Driver_mysql Object ( [string_quoting] => Array ( [start] => ' [end] => ' [escape] => \ [escape_pattern] => \ ) [identifier_quoting] => Array ( [start] => ` [end] => ` [escape] => ` ) [sql_comments] => Array ( [0] => Array ( [start] => -- [end] => [escape] => ) [1] => Array ( [start] => # [end] => [escape] => ) [2] => Array ( [start] => /* [end] => */ [escape] => ) ) [server_capabilities_checked:protected] => 1 [start_transaction:protected] => 1 [varchar_max_length] => 65532 [datatype] => [extended] => MDB2_Extended Object ( [db_index:protected] => 1 ) [function] => [manager] => [native] => [reverse] => [db_index] => 1 [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => admin_logistock [password] => xpdmdZJfAO [protocol] => [hostspec] => localhost [port] => [socket] => [database] => [mode] => ) [connected_dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => admin_logistock [password] => xpdmdZJfAO [protocol] => [hostspec] => localhost [port] => [socket] => [database] => [mode] => ) [connection] => Resource id #1 [opened_persistent] => [database_name] => admin_logistock [connected_database_name] => admin_logistock [connected_server_info] => 5.5.49 [supported] => Array ( [sequences] => emulated [indexes] => 1 [affected_rows] => 1 [summary_functions] => 1 [order_by_text] => 1 [transactions] => 1 [savepoints] => 1 [current_id] => emulated [limit_queries] => 1 [LOBs] => 1 [replace] => 1 [sub_selects] => 1 [triggers] => 1 [auto_increment] => 1 [primary_key] => 1 [result_introspection] => 1 [prepared_statements] => 1 [identifier_quoting] => 1 [pattern_escaping] => 1 [new_link] => 1 ) [options] => Array ( [ssl] => [field_case] => 0 [disable_query] => [result_class] => MDB2_Result_%s [buffered_result_class] => MDB2_BufferedResult_%s [result_wrap_class] => [result_buffering] => 1 [fetch_class] => stdClass [persistent] => [debug] => 0 [debug_handler] => MDB2_defaultDebugOutput [debug_expanded_output] => [default_text_field_length] => 4096 [lob_buffer_length] => 8192 [log_line_break] => [idxname_format] => %s_idx [seqname_format] => %s_seq [savepoint_format] => MDB2_SAVEPOINT_%s [statement_format] => MDB2_STATEMENT_%1$s_%2$s [seqcol_name] => sequence [quote_identifier] => [use_transactions] => 1 [decimal_places] => 2 [portability] => 0 [modules] => Array ( [ex] => Extended [dt] => Datatype [mg] => Manager [rv] => Reverse [na] => Native [fc] => Function ) [emulate_prepared] => [datatype_map] => Array ( ) [datatype_map_callback] => Array ( ) [nativetype_map_callback] => Array ( ) [lob_allow_url_include] => [bindname_format] => (?:\d+)|(?:[a-zA-Z][a-zA-Z0-9_]*) [max_identifiers_length] => 64 [default_fk_action_onupdate] => RESTRICT [default_fk_action_ondelete] => RESTRICT [DBA_username] => [DBA_password] => [default_table_type] => ) [wildcards:protected] => Array ( [0] => % [1] => _ ) [as_keyword] => AS [warnings] => Array ( ) [debug_output] => [in_transaction] => [nested_transaction_counter] => [has_transaction_error:protected] => [offset] => 0 [limit] => 0 [phptype] => mysql [dbsyntax] => mysql [last_query] => select SQL_CALC_FOUND_ROWS i.*, sc.name, sc.alias4url, ip_price.value_int price, v_avail.value_varchar avail , group_concat(sale_sc.name) sale_names, group_concat(sale_sc.alias4url) sale_alias4urls, group_concat(sale_i.id) sale_ids , ip_avail.prop_value_id avail_id , ip_cat.prop_value_id cat_id , v_type.value_varchar cat , v_brand.value_varchar brand , group_concat(distinct p.id order by p.id) mands , REPLACE(sc.name, '&', '&') name4xml , max(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE((concat(ii.static_img_id, '_', si.orig_filename)), ' ', '%20'), '\#', '%23'), '&', '&'), '+', '%2B'), ',', '-')) prim_img_fn , IF(ubd.id is not null and bd.discount>12, round(ip_price.value_int*(bd.discount-12)/400),0) as basic_bonus , v_cat.alias4url cat_alias4url , ip_cat.prop_value_id category_id , ip_brand.prop_value_id brand_id , IF(ubd.id is not null, round(IF(bd.discount>12,ip_price.value_int*(bd.discount-12)/800,0) + ip_price.value_int*bd.bonus/1000),0) as expert_bonus , REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( sc.html, ' ', ''), '—', '-'), '–', '-'), '«', '"'), '»', '"'), '®', '') , '°', 'o'), '•', '-'), '“', '"'), '”', '"') description , max(ig.item_gift_id) item_gift_id , max(gsc.name) gift_name , IFNULL(ima.articul, iua.articul) articul, IFNULL(ima.name, iua.name) articul_name from item i join static_content sc on sc.id=i.static_id join static_img si on si.static_id=i.static_id and si.prim join item_img ii on si.id=ii.static_img_id join item_prop_value ip_price on ip_price.prop_id=1 and ip_price.item_id=i.id join item_prop_value ip_brand on ip_brand.prop_id=4 and ip_brand.item_id=i.id join item_prop_value ip_cat on ip_cat.prop_id=3 and ip_cat.item_id=i.id join item_prop_value ip_type on ip_type.prop_id=35 and ip_type.item_id=i.id join prop_value v_type on v_type.id=ip_type.prop_value_id join prop_value v_brand on v_brand.id=ip_brand.prop_value_id join prop_value v_cat on v_cat.id=ip_cat.prop_value_id left join item_gift ig on ig.item_id=i.id left join item igi on igi.id=ig.item_gift_id left join static_content gsc on gsc.id=igi.static_id left join item_prop_value ip_avail on ip_avail.prop_id=2 and ip_avail.item_id=i.id left join prop_value v_avail on v_avail.id=ip_avail.prop_value_id left join item_prop_value pv on pv.item_id=i.id left join prop p on p.id=pv.prop_id and p.mand left join prop_value v on v.id=pv.prop_value_id left join bonus_disco bd on IF(bd.category_id=0, ip_cat.prop_value_id, bd.category_id)=ip_cat.prop_value_id and IF(bd.brand_id=0, ip_brand.prop_value_id, bd.brand_id)=ip_brand.prop_value_id left join users ubd on ubd.id=bd.user_id left join `item_manuf_articul` ima on i.id=ima.item_id left join `item_user_avail` iua on i.id=iua.item_id left join item sale_i on sale_i.sale_id=i.id left join static_content sale_sc on sale_sc.id=sale_i.static_id left join item_prop_value pv4 on pv4.prop_id=4 and pv4.item_id=i.id left join prop_value v4 on v4.id=pv4.prop_value_id where 1 and (IFNULL(pv4.prop_value_id,'') in ('165') or v4.alias4url in ('165') ) and i.id in (18903,18906,18907,18929,18932,18946,18947,18994,18995,19036,19037,19038,19058,19059,19060,19061,19062,19063,19064,19065,19066,19067,19068,19069,19070,19071,19072,19073,19074,19075,19076,19077,19078,19079,19080,19081,19082,19084,19091,19092,19094,19095,19096,19104,19112,19145,19146,19147,19148,19149,19150,19151,19152,19153,19155,19182,19203,19204,19205,19227,19228,19254,19305,19334,19335,19396,19471,19477,20783,20784,20785,20786,20787,20788,20789,20790,20792,20793,20794,20795,20796,20797,20798,20799,20800,20801,20802,20803,20805,20806,20807,20808,20809,20810,20811,20813,20814,20815,20816,20817,20818,20819,20820,20821,20822,20823,20824,20825,20826,20827,20828,20829,20830,20831,20833,20835,20836,20837,20838,20839,20840,20841,20842,20843,20844,20845,20846,20847,20848,20849,20850,20851,20852,20853,20854,20855,20856,20857,20858,20859,20860,20861,20862,20863,20864,20865,20866,20867,20868,20869,20870,20871,20872,20873,20874,20875,20876,20877,20878,20879,20880,20881,20883,20884,20886,20887,20888,20889,20890,20891,20892,20893,20894,20895,20896,20897,20898,20899,20900,20901,20902,20903,20904,20905,20906,20907,20908,20909,20910,20911,20912,20913,20914,20915,20916,20917,20918,20919,20920,20921,20922,20923,20924,20925,20926,20927,20928,20929,20930,20931,20932,20933,20934,20936,20937,20938,20940,20941,20942,20943,20944,20946,20948,20949,20950,20951,20952,20954,20955,20956,20957,20958,20959,20960,20961,20962,20963,20964,20965,20966,20967,20968,20969,20970,20971,20972,20973,20974,20975,20976,20977,20978,20979,20980,20981,20982,20983,20984,20985,20986,20987,20988,20989,20990,20991,20992,20993,20994,20995,20996,20997,20998,20999,21000,21001,21002,21003,21004,21005,21006,21007,21008,21009,21010,21011,21012,21013,21014,21015,21016,21017,21018,21019,21020,21021,21022,21023,21024,21025,21026,21027,21028,21029,21030,21031,21032,21033,21034,21035,21036,21037,21038,21039,21040,21041,21042,21043,21044,21045,21046,21047,21048,21049,21050,21052,21053,21054) and i.black=0 group by i.id having group_concat(distinct p.id order by p.id) = '1,3,4,35' and prim_img_fn and prim_img_fn is not null and price>0 [fetchmode] => 3 [modules:protected] => Array ( [Extended] => MDB2_Extended Object ( [db_index:protected] => 1 ) ) [destructor_registered:protected] => 1 [pear:protected] => PEAR Object ( [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => PEAR_Error [_expected_errors] => Array ( ) ) ) [type] => -> [args] => Array ( [0] => getAll [1] => Array ( [0] => select SQL_CALC_FOUND_ROWS i.*, sc.name, sc.alias4url, ip_price.value_int price, v_avail.value_varchar avail , group_concat(sale_sc.name) sale_names, group_concat(sale_sc.alias4url) sale_alias4urls, group_concat(sale_i.id) sale_ids , ip_avail.prop_value_id avail_id , ip_cat.prop_value_id cat_id , v_type.value_varchar cat , v_brand.value_varchar brand , group_concat(distinct p.id order by p.id) mands , REPLACE(sc.name, '&', '&') name4xml , max(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE((concat(ii.static_img_id, '_', si.orig_filename)), ' ', '%20'), '\#', '%23'), '&', '&'), '+', '%2B'), ',', '-')) prim_img_fn , IF(ubd.id is not null and bd.discount>12, round(ip_price.value_int*(bd.discount-12)/400),0) as basic_bonus , v_cat.alias4url cat_alias4url , ip_cat.prop_value_id category_id , ip_brand.prop_value_id brand_id , IF(ubd.id is not null, round(IF(bd.discount>12,ip_price.value_int*(bd.discount-12)/800,0) + ip_price.value_int*bd.bonus/1000),0) as expert_bonus , REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( sc.html, ' ', ''), '—', '-'), '–', '-'), '«', '"'), '»', '"'), '®', '') , '°', 'o'), '•', '-'), '“', '"'), '”', '"') description , max(ig.item_gift_id) item_gift_id , max(gsc.name) gift_name , IFNULL(ima.articul, iua.articul) articul, IFNULL(ima.name, iua.name) articul_name from item i join static_content sc on sc.id=i.static_id join static_img si on si.static_id=i.static_id and si.prim join item_img ii on si.id=ii.static_img_id join item_prop_value ip_price on ip_price.prop_id=1 and ip_price.item_id=i.id join item_prop_value ip_brand on ip_brand.prop_id=4 and ip_brand.item_id=i.id join item_prop_value ip_cat on ip_cat.prop_id=3 and ip_cat.item_id=i.id join item_prop_value ip_type on ip_type.prop_id=35 and ip_type.item_id=i.id join prop_value v_type on v_type.id=ip_type.prop_value_id join prop_value v_brand on v_brand.id=ip_brand.prop_value_id join prop_value v_cat on v_cat.id=ip_cat.prop_value_id left join item_gift ig on ig.item_id=i.id left join item igi on igi.id=ig.item_gift_id left join static_content gsc on gsc.id=igi.static_id left join item_prop_value ip_avail on ip_avail.prop_id=2 and ip_avail.item_id=i.id left join prop_value v_avail on v_avail.id=ip_avail.prop_value_id left join item_prop_value pv on pv.item_id=i.id left join prop p on p.id=pv.prop_id and p.mand left join prop_value v on v.id=pv.prop_value_id left join bonus_disco bd on IF(bd.category_id=0, ip_cat.prop_value_id, bd.category_id)=ip_cat.prop_value_id and IF(bd.brand_id=0, ip_brand.prop_value_id, bd.brand_id)=ip_brand.prop_value_id left join users ubd on ubd.id=bd.user_id left join `item_manuf_articul` ima on i.id=ima.item_id left join `item_user_avail` iua on i.id=iua.item_id left join item sale_i on sale_i.sale_id=i.id left join static_content sale_sc on sale_sc.id=sale_i.static_id left join item_prop_value pv4 on pv4.prop_id=4 and pv4.item_id=i.id left join prop_value v4 on v4.id=pv4.prop_value_id where 1 and (IFNULL(pv4.prop_value_id,'') in ('165') or v4.alias4url in ('165') ) and i.id in (18903,18906,18907,18929,18932,18946,18947,18994,18995,19036,19037,19038,19058,19059,19060,19061,19062,19063,19064,19065,19066,19067,19068,19069,19070,19071,19072,19073,19074,19075,19076,19077,19078,19079,19080,19081,19082,19084,19091,19092,19094,19095,19096,19104,19112,19145,19146,19147,19148,19149,19150,19151,19152,19153,19155,19182,19203,19204,19205,19227,19228,19254,19305,19334,19335,19396,19471,19477,20783,20784,20785,20786,20787,20788,20789,20790,20792,20793,20794,20795,20796,20797,20798,20799,20800,20801,20802,20803,20805,20806,20807,20808,20809,20810,20811,20813,20814,20815,20816,20817,20818,20819,20820,20821,20822,20823,20824,20825,20826,20827,20828,20829,20830,20831,20833,20835,20836,20837,20838,20839,20840,20841,20842,20843,20844,20845,20846,20847,20848,20849,20850,20851,20852,20853,20854,20855,20856,20857,20858,20859,20860,20861,20862,20863,20864,20865,20866,20867,20868,20869,20870,20871,20872,20873,20874,20875,20876,20877,20878,20879,20880,20881,20883,20884,20886,20887,20888,20889,20890,20891,20892,20893,20894,20895,20896,20897,20898,20899,20900,20901,20902,20903,20904,20905,20906,20907,20908,20909,20910,20911,20912,20913,20914,20915,20916,20917,20918,20919,20920,20921,20922,20923,20924,20925,20926,20927,20928,20929,20930,20931,20932,20933,20934,20936,20937,20938,20940,20941,20942,20943,20944,20946,20948,20949,20950,20951,20952,20954,20955,20956,20957,20958,20959,20960,20961,20962,20963,20964,20965,20966,20967,20968,20969,20970,20971,20972,20973,20974,20975,20976,20977,20978,20979,20980,20981,20982,20983,20984,20985,20986,20987,20988,20989,20990,20991,20992,20993,20994,20995,20996,20997,20998,20999,21000,21001,21002,21003,21004,21005,21006,21007,21008,21009,21010,21011,21012,21013,21014,21015,21016,21017,21018,21019,21020,21021,21022,21023,21024,21025,21026,21027,21028,21029,21030,21031,21032,21033,21034,21035,21036,21037,21038,21039,21040,21041,21042,21043,21044,21045,21046,21047,21048,21049,21050,21052,21053,21054) and i.black=0 group by i.id having group_concat(distinct p.id order by p.id) = '1,3,4,35' and prim_img_fn and prim_img_fn is not null and price>0 ) ) ) [10] => Array ( [file] => /home/admin/web/logistock.ru/public_html/lib/Item.php [line] => 963 [function] => getAll [class] => MDB2_Driver_mysql [object] => MDB2_Driver_mysql Object ( [string_quoting] => Array ( [start] => ' [end] => ' [escape] => \ [escape_pattern] => \ ) [identifier_quoting] => Array ( [start] => ` [end] => ` [escape] => ` ) [sql_comments] => Array ( [0] => Array ( [start] => -- [end] => [escape] => ) [1] => Array ( [start] => # [end] => [escape] => ) [2] => Array ( [start] => /* [end] => */ [escape] => ) ) [server_capabilities_checked:protected] => 1 [start_transaction:protected] => 1 [varchar_max_length] => 65532 [datatype] => [extended] => MDB2_Extended Object ( [db_index:protected] => 1 ) [function] => [manager] => [native] => [reverse] => [db_index] => 1 [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => admin_logistock [password] => xpdmdZJfAO [protocol] => [hostspec] => localhost [port] => [socket] => [database] => [mode] => ) [connected_dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => admin_logistock [password] => xpdmdZJfAO [protocol] => [hostspec] => localhost [port] => [socket] => [database] => [mode] => ) [connection] => Resource id #1 [opened_persistent] => [database_name] => admin_logistock [connected_database_name] => admin_logistock [connected_server_info] => 5.5.49 [supported] => Array ( [sequences] => emulated [indexes] => 1 [affected_rows] => 1 [summary_functions] => 1 [order_by_text] => 1 [transactions] => 1 [savepoints] => 1 [current_id] => emulated [limit_queries] => 1 [LOBs] => 1 [replace] => 1 [sub_selects] => 1 [triggers] => 1 [auto_increment] => 1 [primary_key] => 1 [result_introspection] => 1 [prepared_statements] => 1 [identifier_quoting] => 1 [pattern_escaping] => 1 [new_link] => 1 ) [options] => Array ( [ssl] => [field_case] => 0 [disable_query] => [result_class] => MDB2_Result_%s [buffered_result_class] => MDB2_BufferedResult_%s [result_wrap_class] => [result_buffering] => 1 [fetch_class] => stdClass [persistent] => [debug] => 0 [debug_handler] => MDB2_defaultDebugOutput [debug_expanded_output] => [default_text_field_length] => 4096 [lob_buffer_length] => 8192 [log_line_break] => [idxname_format] => %s_idx [seqname_format] => %s_seq [savepoint_format] => MDB2_SAVEPOINT_%s [statement_format] => MDB2_STATEMENT_%1$s_%2$s [seqcol_name] => sequence [quote_identifier] => [use_transactions] => 1 [decimal_places] => 2 [portability] => 0 [modules] => Array ( [ex] => Extended [dt] => Datatype [mg] => Manager [rv] => Reverse [na] => Native [fc] => Function ) [emulate_prepared] => [datatype_map] => Array ( ) [datatype_map_callback] => Array ( ) [nativetype_map_callback] => Array ( ) [lob_allow_url_include] => [bindname_format] => (?:\d+)|(?:[a-zA-Z][a-zA-Z0-9_]*) [max_identifiers_length] => 64 [default_fk_action_onupdate] => RESTRICT [default_fk_action_ondelete] => RESTRICT [DBA_username] => [DBA_password] => [default_table_type] => ) [wildcards:protected] => Array ( [0] => % [1] => _ ) [as_keyword] => AS [warnings] => Array ( ) [debug_output] => [in_transaction] => [nested_transaction_counter] => [has_transaction_error:protected] => [offset] => 0 [limit] => 0 [phptype] => mysql [dbsyntax] => mysql [last_query] => select SQL_CALC_FOUND_ROWS i.*, sc.name, sc.alias4url, ip_price.value_int price, v_avail.value_varchar avail , group_concat(sale_sc.name) sale_names, group_concat(sale_sc.alias4url) sale_alias4urls, group_concat(sale_i.id) sale_ids , ip_avail.prop_value_id avail_id , ip_cat.prop_value_id cat_id , v_type.value_varchar cat , v_brand.value_varchar brand , group_concat(distinct p.id order by p.id) mands , REPLACE(sc.name, '&', '&') name4xml , max(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE((concat(ii.static_img_id, '_', si.orig_filename)), ' ', '%20'), '\#', '%23'), '&', '&'), '+', '%2B'), ',', '-')) prim_img_fn , IF(ubd.id is not null and bd.discount>12, round(ip_price.value_int*(bd.discount-12)/400),0) as basic_bonus , v_cat.alias4url cat_alias4url , ip_cat.prop_value_id category_id , ip_brand.prop_value_id brand_id , IF(ubd.id is not null, round(IF(bd.discount>12,ip_price.value_int*(bd.discount-12)/800,0) + ip_price.value_int*bd.bonus/1000),0) as expert_bonus , REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( sc.html, ' ', ''), '—', '-'), '–', '-'), '«', '"'), '»', '"'), '®', '') , '°', 'o'), '•', '-'), '“', '"'), '”', '"') description , max(ig.item_gift_id) item_gift_id , max(gsc.name) gift_name , IFNULL(ima.articul, iua.articul) articul, IFNULL(ima.name, iua.name) articul_name from item i join static_content sc on sc.id=i.static_id join static_img si on si.static_id=i.static_id and si.prim join item_img ii on si.id=ii.static_img_id join item_prop_value ip_price on ip_price.prop_id=1 and ip_price.item_id=i.id join item_prop_value ip_brand on ip_brand.prop_id=4 and ip_brand.item_id=i.id join item_prop_value ip_cat on ip_cat.prop_id=3 and ip_cat.item_id=i.id join item_prop_value ip_type on ip_type.prop_id=35 and ip_type.item_id=i.id join prop_value v_type on v_type.id=ip_type.prop_value_id join prop_value v_brand on v_brand.id=ip_brand.prop_value_id join prop_value v_cat on v_cat.id=ip_cat.prop_value_id left join item_gift ig on ig.item_id=i.id left join item igi on igi.id=ig.item_gift_id left join static_content gsc on gsc.id=igi.static_id left join item_prop_value ip_avail on ip_avail.prop_id=2 and ip_avail.item_id=i.id left join prop_value v_avail on v_avail.id=ip_avail.prop_value_id left join item_prop_value pv on pv.item_id=i.id left join prop p on p.id=pv.prop_id and p.mand left join prop_value v on v.id=pv.prop_value_id left join bonus_disco bd on IF(bd.category_id=0, ip_cat.prop_value_id, bd.category_id)=ip_cat.prop_value_id and IF(bd.brand_id=0, ip_brand.prop_value_id, bd.brand_id)=ip_brand.prop_value_id left join users ubd on ubd.id=bd.user_id left join `item_manuf_articul` ima on i.id=ima.item_id left join `item_user_avail` iua on i.id=iua.item_id left join item sale_i on sale_i.sale_id=i.id left join static_content sale_sc on sale_sc.id=sale_i.static_id left join item_prop_value pv4 on pv4.prop_id=4 and pv4.item_id=i.id left join prop_value v4 on v4.id=pv4.prop_value_id where 1 and (IFNULL(pv4.prop_value_id,'') in ('165') or v4.alias4url in ('165') ) and i.id in (18903,18906,18907,18929,18932,18946,18947,18994,18995,19036,19037,19038,19058,19059,19060,19061,19062,19063,19064,19065,19066,19067,19068,19069,19070,19071,19072,19073,19074,19075,19076,19077,19078,19079,19080,19081,19082,19084,19091,19092,19094,19095,19096,19104,19112,19145,19146,19147,19148,19149,19150,19151,19152,19153,19155,19182,19203,19204,19205,19227,19228,19254,19305,19334,19335,19396,19471,19477,20783,20784,20785,20786,20787,20788,20789,20790,20792,20793,20794,20795,20796,20797,20798,20799,20800,20801,20802,20803,20805,20806,20807,20808,20809,20810,20811,20813,20814,20815,20816,20817,20818,20819,20820,20821,20822,20823,20824,20825,20826,20827,20828,20829,20830,20831,20833,20835,20836,20837,20838,20839,20840,20841,20842,20843,20844,20845,20846,20847,20848,20849,20850,20851,20852,20853,20854,20855,20856,20857,20858,20859,20860,20861,20862,20863,20864,20865,20866,20867,20868,20869,20870,20871,20872,20873,20874,20875,20876,20877,20878,20879,20880,20881,20883,20884,20886,20887,20888,20889,20890,20891,20892,20893,20894,20895,20896,20897,20898,20899,20900,20901,20902,20903,20904,20905,20906,20907,20908,20909,20910,20911,20912,20913,20914,20915,20916,20917,20918,20919,20920,20921,20922,20923,20924,20925,20926,20927,20928,20929,20930,20931,20932,20933,20934,20936,20937,20938,20940,20941,20942,20943,20944,20946,20948,20949,20950,20951,20952,20954,20955,20956,20957,20958,20959,20960,20961,20962,20963,20964,20965,20966,20967,20968,20969,20970,20971,20972,20973,20974,20975,20976,20977,20978,20979,20980,20981,20982,20983,20984,20985,20986,20987,20988,20989,20990,20991,20992,20993,20994,20995,20996,20997,20998,20999,21000,21001,21002,21003,21004,21005,21006,21007,21008,21009,21010,21011,21012,21013,21014,21015,21016,21017,21018,21019,21020,21021,21022,21023,21024,21025,21026,21027,21028,21029,21030,21031,21032,21033,21034,21035,21036,21037,21038,21039,21040,21041,21042,21043,21044,21045,21046,21047,21048,21049,21050,21052,21053,21054) and i.black=0 group by i.id having group_concat(distinct p.id order by p.id) = '1,3,4,35' and prim_img_fn and prim_img_fn is not null and price>0 [fetchmode] => 3 [modules:protected] => Array ( [Extended] => MDB2_Extended Object ( [db_index:protected] => 1 ) ) [destructor_registered:protected] => 1 [pear:protected] => PEAR Object ( [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => PEAR_Error [_expected_errors] => Array ( ) ) ) [type] => -> [args] => Array ( [0] => select SQL_CALC_FOUND_ROWS i.*, sc.name, sc.alias4url, ip_price.value_int price, v_avail.value_varchar avail , group_concat(sale_sc.name) sale_names, group_concat(sale_sc.alias4url) sale_alias4urls, group_concat(sale_i.id) sale_ids , ip_avail.prop_value_id avail_id , ip_cat.prop_value_id cat_id , v_type.value_varchar cat , v_brand.value_varchar brand , group_concat(distinct p.id order by p.id) mands , REPLACE(sc.name, '&', '&') name4xml , max(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE((concat(ii.static_img_id, '_', si.orig_filename)), ' ', '%20'), '\#', '%23'), '&', '&'), '+', '%2B'), ',', '-')) prim_img_fn , IF(ubd.id is not null and bd.discount>12, round(ip_price.value_int*(bd.discount-12)/400),0) as basic_bonus , v_cat.alias4url cat_alias4url , ip_cat.prop_value_id category_id , ip_brand.prop_value_id brand_id , IF(ubd.id is not null, round(IF(bd.discount>12,ip_price.value_int*(bd.discount-12)/800,0) + ip_price.value_int*bd.bonus/1000),0) as expert_bonus , REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( sc.html, ' ', ''), '—', '-'), '–', '-'), '«', '"'), '»', '"'), '®', '') , '°', 'o'), '•', '-'), '“', '"'), '”', '"') description , max(ig.item_gift_id) item_gift_id , max(gsc.name) gift_name , IFNULL(ima.articul, iua.articul) articul, IFNULL(ima.name, iua.name) articul_name from item i join static_content sc on sc.id=i.static_id join static_img si on si.static_id=i.static_id and si.prim join item_img ii on si.id=ii.static_img_id join item_prop_value ip_price on ip_price.prop_id=1 and ip_price.item_id=i.id join item_prop_value ip_brand on ip_brand.prop_id=4 and ip_brand.item_id=i.id join item_prop_value ip_cat on ip_cat.prop_id=3 and ip_cat.item_id=i.id join item_prop_value ip_type on ip_type.prop_id=35 and ip_type.item_id=i.id join prop_value v_type on v_type.id=ip_type.prop_value_id join prop_value v_brand on v_brand.id=ip_brand.prop_value_id join prop_value v_cat on v_cat.id=ip_cat.prop_value_id left join item_gift ig on ig.item_id=i.id left join item igi on igi.id=ig.item_gift_id left join static_content gsc on gsc.id=igi.static_id left join item_prop_value ip_avail on ip_avail.prop_id=2 and ip_avail.item_id=i.id left join prop_value v_avail on v_avail.id=ip_avail.prop_value_id left join item_prop_value pv on pv.item_id=i.id left join prop p on p.id=pv.prop_id and p.mand left join prop_value v on v.id=pv.prop_value_id left join bonus_disco bd on IF(bd.category_id=0, ip_cat.prop_value_id, bd.category_id)=ip_cat.prop_value_id and IF(bd.brand_id=0, ip_brand.prop_value_id, bd.brand_id)=ip_brand.prop_value_id left join users ubd on ubd.id=bd.user_id left join `item_manuf_articul` ima on i.id=ima.item_id left join `item_user_avail` iua on i.id=iua.item_id left join item sale_i on sale_i.sale_id=i.id left join static_content sale_sc on sale_sc.id=sale_i.static_id left join item_prop_value pv4 on pv4.prop_id=4 and pv4.item_id=i.id left join prop_value v4 on v4.id=pv4.prop_value_id where 1 and (IFNULL(pv4.prop_value_id,'') in ('165') or v4.alias4url in ('165') ) and i.id in (18903,18906,18907,18929,18932,18946,18947,18994,18995,19036,19037,19038,19058,19059,19060,19061,19062,19063,19064,19065,19066,19067,19068,19069,19070,19071,19072,19073,19074,19075,19076,19077,19078,19079,19080,19081,19082,19084,19091,19092,19094,19095,19096,19104,19112,19145,19146,19147,19148,19149,19150,19151,19152,19153,19155,19182,19203,19204,19205,19227,19228,19254,19305,19334,19335,19396,19471,19477,20783,20784,20785,20786,20787,20788,20789,20790,20792,20793,20794,20795,20796,20797,20798,20799,20800,20801,20802,20803,20805,20806,20807,20808,20809,20810,20811,20813,20814,20815,20816,20817,20818,20819,20820,20821,20822,20823,20824,20825,20826,20827,20828,20829,20830,20831,20833,20835,20836,20837,20838,20839,20840,20841,20842,20843,20844,20845,20846,20847,20848,20849,20850,20851,20852,20853,20854,20855,20856,20857,20858,20859,20860,20861,20862,20863,20864,20865,20866,20867,20868,20869,20870,20871,20872,20873,20874,20875,20876,20877,20878,20879,20880,20881,20883,20884,20886,20887,20888,20889,20890,20891,20892,20893,20894,20895,20896,20897,20898,20899,20900,20901,20902,20903,20904,20905,20906,20907,20908,20909,20910,20911,20912,20913,20914,20915,20916,20917,20918,20919,20920,20921,20922,20923,20924,20925,20926,20927,20928,20929,20930,20931,20932,20933,20934,20936,20937,20938,20940,20941,20942,20943,20944,20946,20948,20949,20950,20951,20952,20954,20955,20956,20957,20958,20959,20960,20961,20962,20963,20964,20965,20966,20967,20968,20969,20970,20971,20972,20973,20974,20975,20976,20977,20978,20979,20980,20981,20982,20983,20984,20985,20986,20987,20988,20989,20990,20991,20992,20993,20994,20995,20996,20997,20998,20999,21000,21001,21002,21003,21004,21005,21006,21007,21008,21009,21010,21011,21012,21013,21014,21015,21016,21017,21018,21019,21020,21021,21022,21023,21024,21025,21026,21027,21028,21029,21030,21031,21032,21033,21034,21035,21036,21037,21038,21039,21040,21041,21042,21043,21044,21045,21046,21047,21048,21049,21050,21052,21053,21054) and i.black=0 group by i.id having group_concat(distinct p.id order by p.id) = '1,3,4,35' and prim_img_fn and prim_img_fn is not null and price>0 ) ) [11] => Array ( [file] => /home/admin/web/logistock.ru/public_html/index.php [line] => 760 [function] => listAllParams [class] => Item [type] => :: [args] => Array ( [0] => MDB2_Driver_mysql Object ( [string_quoting] => Array ( [start] => ' [end] => ' [escape] => \ [escape_pattern] => \ ) [identifier_quoting] => Array ( [start] => ` [end] => ` [escape] => ` ) [sql_comments] => Array ( [0] => Array ( [start] => -- [end] => [escape] => ) [1] => Array ( [start] => # [end] => [escape] => ) [2] => Array ( [start] => /* [end] => */ [escape] => ) ) [server_capabilities_checked:protected] => 1 [start_transaction:protected] => 1 [varchar_max_length] => 65532 [datatype] => [extended] => MDB2_Extended Object ( [db_index:protected] => 1 ) [function] => [manager] => [native] => [reverse] => [db_index] => 1 [dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => admin_logistock [password] => xpdmdZJfAO [protocol] => [hostspec] => localhost [port] => [socket] => [database] => [mode] => ) [connected_dsn] => Array ( [phptype] => mysql [dbsyntax] => mysql [username] => admin_logistock [password] => xpdmdZJfAO [protocol] => [hostspec] => localhost [port] => [socket] => [database] => [mode] => ) [connection] => Resource id #1 [opened_persistent] => [database_name] => admin_logistock [connected_database_name] => admin_logistock [connected_server_info] => 5.5.49 [supported] => Array ( [sequences] => emulated [indexes] => 1 [affected_rows] => 1 [summary_functions] => 1 [order_by_text] => 1 [transactions] => 1 [savepoints] => 1 [current_id] => emulated [limit_queries] => 1 [LOBs] => 1 [replace] => 1 [sub_selects] => 1 [triggers] => 1 [auto_increment] => 1 [primary_key] => 1 [result_introspection] => 1 [prepared_statements] => 1 [identifier_quoting] => 1 [pattern_escaping] => 1 [new_link] => 1 ) [options] => Array ( [ssl] => [field_case] => 0 [disable_query] => [result_class] => MDB2_Result_%s [buffered_result_class] => MDB2_BufferedResult_%s [result_wrap_class] => [result_buffering] => 1 [fetch_class] => stdClass [persistent] => [debug] => 0 [debug_handler] => MDB2_defaultDebugOutput [debug_expanded_output] => [default_text_field_length] => 4096 [lob_buffer_length] => 8192 [log_line_break] => [idxname_format] => %s_idx [seqname_format] => %s_seq [savepoint_format] => MDB2_SAVEPOINT_%s [statement_format] => MDB2_STATEMENT_%1$s_%2$s [seqcol_name] => sequence [quote_identifier] => [use_transactions] => 1 [decimal_places] => 2 [portability] => 0 [modules] => Array ( [ex] => Extended [dt] => Datatype [mg] => Manager [rv] => Reverse [na] => Native [fc] => Function ) [emulate_prepared] => [datatype_map] => Array ( ) [datatype_map_callback] => Array ( ) [nativetype_map_callback] => Array ( ) [lob_allow_url_include] => [bindname_format] => (?:\d+)|(?:[a-zA-Z][a-zA-Z0-9_]*) [max_identifiers_length] => 64 [default_fk_action_onupdate] => RESTRICT [default_fk_action_ondelete] => RESTRICT [DBA_username] => [DBA_password] => [default_table_type] => ) [wildcards:protected] => Array ( [0] => % [1] => _ ) [as_keyword] => AS [warnings] => Array ( ) [debug_output] => [in_transaction] => [nested_transaction_counter] => [has_transaction_error:protected] => [offset] => 0 [limit] => 0 [phptype] => mysql [dbsyntax] => mysql [last_query] => select SQL_CALC_FOUND_ROWS i.*, sc.name, sc.alias4url, ip_price.value_int price, v_avail.value_varchar avail , group_concat(sale_sc.name) sale_names, group_concat(sale_sc.alias4url) sale_alias4urls, group_concat(sale_i.id) sale_ids , ip_avail.prop_value_id avail_id , ip_cat.prop_value_id cat_id , v_type.value_varchar cat , v_brand.value_varchar brand , group_concat(distinct p.id order by p.id) mands , REPLACE(sc.name, '&', '&') name4xml , max(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE((concat(ii.static_img_id, '_', si.orig_filename)), ' ', '%20'), '\#', '%23'), '&', '&'), '+', '%2B'), ',', '-')) prim_img_fn , IF(ubd.id is not null and bd.discount>12, round(ip_price.value_int*(bd.discount-12)/400),0) as basic_bonus , v_cat.alias4url cat_alias4url , ip_cat.prop_value_id category_id , ip_brand.prop_value_id brand_id , IF(ubd.id is not null, round(IF(bd.discount>12,ip_price.value_int*(bd.discount-12)/800,0) + ip_price.value_int*bd.bonus/1000),0) as expert_bonus , REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE( sc.html, ' ', ''), '—', '-'), '–', '-'), '«', '"'), '»', '"'), '®', '') , '°', 'o'), '•', '-'), '“', '"'), '”', '"') description , max(ig.item_gift_id) item_gift_id , max(gsc.name) gift_name , IFNULL(ima.articul, iua.articul) articul, IFNULL(ima.name, iua.name) articul_name from item i join static_content sc on sc.id=i.static_id join static_img si on si.static_id=i.static_id and si.prim join item_img ii on si.id=ii.static_img_id join item_prop_value ip_price on ip_price.prop_id=1 and ip_price.item_id=i.id join item_prop_value ip_brand on ip_brand.prop_id=4 and ip_brand.item_id=i.id join item_prop_value ip_cat on ip_cat.prop_id=3 and ip_cat.item_id=i.id join item_prop_value ip_type on ip_type.prop_id=35 and ip_type.item_id=i.id join prop_value v_type on v_type.id=ip_type.prop_value_id join prop_value v_brand on v_brand.id=ip_brand.prop_value_id join prop_value v_cat on v_cat.id=ip_cat.prop_value_id left join item_gift ig on ig.item_id=i.id left join item igi on igi.id=ig.item_gift_id left join static_content gsc on gsc.id=igi.static_id left join item_prop_value ip_avail on ip_avail.prop_id=2 and ip_avail.item_id=i.id left join prop_value v_avail on v_avail.id=ip_avail.prop_value_id left join item_prop_value pv on pv.item_id=i.id left join prop p on p.id=pv.prop_id and p.mand left join prop_value v on v.id=pv.prop_value_id left join bonus_disco bd on IF(bd.category_id=0, ip_cat.prop_value_id, bd.category_id)=ip_cat.prop_value_id and IF(bd.brand_id=0, ip_brand.prop_value_id, bd.brand_id)=ip_brand.prop_value_id left join users ubd on ubd.id=bd.user_id left join `item_manuf_articul` ima on i.id=ima.item_id left join `item_user_avail` iua on i.id=iua.item_id left join item sale_i on sale_i.sale_id=i.id left join static_content sale_sc on sale_sc.id=sale_i.static_id left join item_prop_value pv4 on pv4.prop_id=4 and pv4.item_id=i.id left join prop_value v4 on v4.id=pv4.prop_value_id where 1 and (IFNULL(pv4.prop_value_id,'') in ('165') or v4.alias4url in ('165') ) and i.id in (18903,18906,18907,18929,18932,18946,18947,18994,18995,19036,19037,19038,19058,19059,19060,19061,19062,19063,19064,19065,19066,19067,19068,19069,19070,19071,19072,19073,19074,19075,19076,19077,19078,19079,19080,19081,19082,19084,19091,19092,19094,19095,19096,19104,19112,19145,19146,19147,19148,19149,19150,19151,19152,19153,19155,19182,19203,19204,19205,19227,19228,19254,19305,19334,19335,19396,19471,19477,20783,20784,20785,20786,20787,20788,20789,20790,20792,20793,20794,20795,20796,20797,20798,20799,20800,20801,20802,20803,20805,20806,20807,20808,20809,20810,20811,20813,20814,20815,20816,20817,20818,20819,20820,20821,20822,20823,20824,20825,20826,20827,20828,20829,20830,20831,20833,20835,20836,20837,20838,20839,20840,20841,20842,20843,20844,20845,20846,20847,20848,20849,20850,20851,20852,20853,20854,20855,20856,20857,20858,20859,20860,20861,20862,20863,20864,20865,20866,20867,20868,20869,20870,20871,20872,20873,20874,20875,20876,20877,20878,20879,20880,20881,20883,20884,20886,20887,20888,20889,20890,20891,20892,20893,20894,20895,20896,20897,20898,20899,20900,20901,20902,20903,20904,20905,20906,20907,20908,20909,20910,20911,20912,20913,20914,20915,20916,20917,20918,20919,20920,20921,20922,20923,20924,20925,20926,20927,20928,20929,20930,20931,20932,20933,20934,20936,20937,20938,20940,20941,20942,20943,20944,20946,20948,20949,20950,20951,20952,20954,20955,20956,20957,20958,20959,20960,20961,20962,20963,20964,20965,20966,20967,20968,20969,20970,20971,20972,20973,20974,20975,20976,20977,20978,20979,20980,20981,20982,20983,20984,20985,20986,20987,20988,20989,20990,20991,20992,20993,20994,20995,20996,20997,20998,20999,21000,21001,21002,21003,21004,21005,21006,21007,21008,21009,21010,21011,21012,21013,21014,21015,21016,21017,21018,21019,21020,21021,21022,21023,21024,21025,21026,21027,21028,21029,21030,21031,21032,21033,21034,21035,21036,21037,21038,21039,21040,21041,21042,21043,21044,21045,21046,21047,21048,21049,21050,21052,21053,21054) and i.black=0 group by i.id having group_concat(distinct p.id order by p.id) = '1,3,4,35' and prim_img_fn and prim_img_fn is not null and price>0 [fetchmode] => 3 [modules:protected] => Array ( [Extended] => MDB2_Extended Object ( [db_index:protected] => 1 ) ) [destructor_registered:protected] => 1 [pear:protected] => PEAR Object ( [_debug] => [_default_error_mode] => [_default_error_options] => [_default_error_handler] => [_error_class] => PEAR_Error [_expected_errors] => Array ( ) ) ) [1] => Array ( [img] => 1 [4] => Array ( [0] => 165 ) ) ) ) ) [callback] => )