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 ('canton') or v4.alias4url in ('canton') ) and i.id in (11549,11550,11551,11552,11553,11554,11555,11556,11557,11558,11559,11560,11561,11562,11563,11564,11565,11566,11567,11568,11569,11570,11571,11572,11573,11574,11575,11576,11577,11578,11579,11580,11581,11582,11583,11584,11585,11586,11587,11588,11589,11590,11591,11592,11593,11594,11595,11596,11597,11598,11599,11600,11601,11602,11603,11604,11605,11606,11607,11608,11609,11610,11611,11612,11613,11614,11615,11616,11617,11618,11619,11620,11621,11622,11623,11624,11625,11626,11627,11628,11629,11630,11631,11632,11633,11634,11635,11636,11637,11638,11639,11640,11641,11642,11643,11644,11645,11646,11647,11648,11649,11650,11651,11652,11653,11654,11655,11656,11657,11658,11659,11660,11693,11726,11727,11728,11729,11730,11769,11808,11809,11845,11882,11883,11884,11927,11970,11971,11972,12013,12054,12055,12056,12097,12138,12139,12140,12141,12142,12143,12144,12145,12146,12147,12148,12149,12150,12151,12152,12153,12154,12155,12156,12157,12158,12233,12252,12253,12254,12255,12256,14530,14531,14655,14670,14671,14685,14686,14691,14717,14718,14724,14725,14741,14742,14743,14751,14752,14789,14790,14791,14792,14793,14794,14812,14813,14816,14817,14819,14820,14823,14840,14841,14849,14850,14861,14862,14874,14875,14883,14884,14885,14980,14981,14982,14983,14984,14985,14986,14987,14988,14989,14990,14991,14992,14993,14994,14995,14996,14997,14998,14999,15000,15001,15002,15003,15004,15005,15006,15007,15008,15009,15010,15011,15012,18736,18739,47522,47523,47552,47553,47586,47610,47611,47612,47623,47639,47640,47686,47723) 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 ('canton') or v4.alias4url in ('canton') ) and i.id in (11549,11550,11551,11552,11553,11554,11555,11556,11557,11558,11559,11560,11561,11562,11563,11564,11565,11566,11567,11568,11569,11570,11571,11572,11573,11574,11575,11576,11577,11578,11579,11580,11581,11582,11583,11584,11585,11586,11587,11588,11589,11590,11591,11592,11593,11594,11595,11596,11597,11598,11599,11600,11601,11602,11603,11604,11605,11606,11607,11608,11609,11610,11611,11612,11613,11614,11615,11616,11617,11618,11619,11620,11621,11622,11623,11624,11625,11626,11627,11628,11629,11630,11631,11632,11633,11634,11635,11636,11637,11638,11639,11640,11641,11642,11643,11644,11645,11646,11647,11648,11649,11650,11651,11652,11653,11654,11655,11656,11657,11658,11659,11660,11693,11726,11727,11728,11729,11730,11769,11808,11809,11845,11882,11883,11884,11927,11970,11971,11972,12013,12054,12055,12056,12097,12138,12139,12140,12141,12142,12143,12144,12145,12146,12147,12148,12149,12150,12151,12152,12153,12154,12155,12156,12157,12158,12233,12252,12253,12254,12255,12256,14530,14531,14655,14670,14671,14685,14686,14691,14717,14718,14724,14725,14741,14742,14743,14751,14752,14789,14790,14791,14792,14793,14794,14812,14813,14816,14817,14819,14820,14823,14840,14841,14849,14850,14861,14862,14874,14875,14883,14884,14885,14980,14981,14982,14983,14984,14985,14986,14987,14988,14989,14990,14991,14992,14993,14994,14995,14996,14997,14998,14999,15000,15001,15002,15003,15004,15005,15006,15007,15008,15009,15010,15011,15012,18736,18739,47522,47523,47552,47553,47586,47610,47611,47612,47623,47639,47640,47686,47723) 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 ('canton') or v4.alias4url in ('canton') ) and i.id in (11549,11550,11551,11552,11553,11554,11555,11556,11557,11558,11559,11560,11561,11562,11563,11564,11565,11566,11567,11568,11569,11570,11571,11572,11573,11574,11575,11576,11577,11578,11579,11580,11581,11582,11583,11584,11585,11586,11587,11588,11589,11590,11591,11592,11593,11594,11595,11596,11597,11598,11599,11600,11601,11602,11603,11604,11605,11606,11607,11608,11609,11610,11611,11612,11613,11614,11615,11616,11617,11618,11619,11620,11621,11622,11623,11624,11625,11626,11627,11628,11629,11630,11631,11632,11633,11634,11635,11636,11637,11638,11639,11640,11641,11642,11643,11644,11645,11646,11647,11648,11649,11650,11651,11652,11653,11654,11655,11656,11657,11658,11659,11660,11693,11726,11727,11728,11729,11730,11769,11808,11809,11845,11882,11883,11884,11927,11970,11971,11972,12013,12054,12055,12056,12097,12138,12139,12140,12141,12142,12143,12144,12145,12146,12147,12148,12149,12150,12151,12152,12153,12154,12155,12156,12157,12158,12233,12252,12253,12254,12255,12256,14530,14531,14655,14670,14671,14685,14686,14691,14717,14718,14724,14725,14741,14742,14743,14751,14752,14789,14790,14791,14792,14793,14794,14812,14813,14816,14817,14819,14820,14823,14840,14841,14849,14850,14861,14862,14874,14875,14883,14884,14885,14980,14981,14982,14983,14984,14985,14986,14987,14988,14989,14990,14991,14992,14993,14994,14995,14996,14997,14998,14999,15000,15001,15002,15003,15004,15005,15006,15007,15008,15009,15010,15011,15012,18736,18739,47522,47523,47552,47553,47586,47610,47611,47612,47623,47639,47640,47686,47723) 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 ('canton') or v4.alias4url in ('canton') ) and i.id in (11549,11550,11551,11552,11553,11554,11555,11556,11557,11558,11559,11560,11561,11562,11563,11564,11565,11566,11567,11568,11569,11570,11571,11572,11573,11574,11575,11576,11577,11578,11579,11580,11581,11582,11583,11584,11585,11586,11587,11588,11589,11590,11591,11592,11593,11594,11595,11596,11597,11598,11599,11600,11601,11602,11603,11604,11605,11606,11607,11608,11609,11610,11611,11612,11613,11614,11615,11616,11617,11618,11619,11620,11621,11622,11623,11624,11625,11626,11627,11628,11629,11630,11631,11632,11633,11634,11635,11636,11637,11638,11639,11640,11641,11642,11643,11644,11645,11646,11647,11648,11649,11650,11651,11652,11653,11654,11655,11656,11657,11658,11659,11660,11693,11726,11727,11728,11729,11730,11769,11808,11809,11845,11882,11883,11884,11927,11970,11971,11972,12013,12054,12055,12056,12097,12138,12139,12140,12141,12142,12143,12144,12145,12146,12147,12148,12149,12150,12151,12152,12153,12154,12155,12156,12157,12158,12233,12252,12253,12254,12255,12256,14530,14531,14655,14670,14671,14685,14686,14691,14717,14718,14724,14725,14741,14742,14743,14751,14752,14789,14790,14791,14792,14793,14794,14812,14813,14816,14817,14819,14820,14823,14840,14841,14849,14850,14861,14862,14874,14875,14883,14884,14885,14980,14981,14982,14983,14984,14985,14986,14987,14988,14989,14990,14991,14992,14993,14994,14995,14996,14997,14998,14999,15000,15001,15002,15003,15004,15005,15006,15007,15008,15009,15010,15011,15012,18736,18739,47522,47523,47552,47553,47586,47610,47611,47612,47623,47639,47640,47686,47723) 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 ('canton') or v4.alias4url in ('canton') ) and i.id in (11549,11550,11551,11552,11553,11554,11555,11556,11557,11558,11559,11560,11561,11562,11563,11564,11565,11566,11567,11568,11569,11570,11571,11572,11573,11574,11575,11576,11577,11578,11579,11580,11581,11582,11583,11584,11585,11586,11587,11588,11589,11590,11591,11592,11593,11594,11595,11596,11597,11598,11599,11600,11601,11602,11603,11604,11605,11606,11607,11608,11609,11610,11611,11612,11613,11614,11615,11616,11617,11618,11619,11620,11621,11622,11623,11624,11625,11626,11627,11628,11629,11630,11631,11632,11633,11634,11635,11636,11637,11638,11639,11640,11641,11642,11643,11644,11645,11646,11647,11648,11649,11650,11651,11652,11653,11654,11655,11656,11657,11658,11659,11660,11693,11726,11727,11728,11729,11730,11769,11808,11809,11845,11882,11883,11884,11927,11970,11971,11972,12013,12054,12055,12056,12097,12138,12139,12140,12141,12142,12143,12144,12145,12146,12147,12148,12149,12150,12151,12152,12153,12154,12155,12156,12157,12158,12233,12252,12253,12254,12255,12256,14530,14531,14655,14670,14671,14685,14686,14691,14717,14718,14724,14725,14741,14742,14743,14751,14752,14789,14790,14791,14792,14793,14794,14812,14813,14816,14817,14819,14820,14823,14840,14841,14849,14850,14861,14862,14874,14875,14883,14884,14885,14980,14981,14982,14983,14984,14985,14986,14987,14988,14989,14990,14991,14992,14993,14994,14995,14996,14997,14998,14999,15000,15001,15002,15003,15004,15005,15006,15007,15008,15009,15010,15011,15012,18736,18739,47522,47523,47552,47553,47586,47610,47611,47612,47623,47639,47640,47686,47723) 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 ('canton') or v4.alias4url in ('canton') ) and i.id in (11549,11550,11551,11552,11553,11554,11555,11556,11557,11558,11559,11560,11561,11562,11563,11564,11565,11566,11567,11568,11569,11570,11571,11572,11573,11574,11575,11576,11577,11578,11579,11580,11581,11582,11583,11584,11585,11586,11587,11588,11589,11590,11591,11592,11593,11594,11595,11596,11597,11598,11599,11600,11601,11602,11603,11604,11605,11606,11607,11608,11609,11610,11611,11612,11613,11614,11615,11616,11617,11618,11619,11620,11621,11622,11623,11624,11625,11626,11627,11628,11629,11630,11631,11632,11633,11634,11635,11636,11637,11638,11639,11640,11641,11642,11643,11644,11645,11646,11647,11648,11649,11650,11651,11652,11653,11654,11655,11656,11657,11658,11659,11660,11693,11726,11727,11728,11729,11730,11769,11808,11809,11845,11882,11883,11884,11927,11970,11971,11972,12013,12054,12055,12056,12097,12138,12139,12140,12141,12142,12143,12144,12145,12146,12147,12148,12149,12150,12151,12152,12153,12154,12155,12156,12157,12158,12233,12252,12253,12254,12255,12256,14530,14531,14655,14670,14671,14685,14686,14691,14717,14718,14724,14725,14741,14742,14743,14751,14752,14789,14790,14791,14792,14793,14794,14812,14813,14816,14817,14819,14820,14823,14840,14841,14849,14850,14861,14862,14874,14875,14883,14884,14885,14980,14981,14982,14983,14984,14985,14986,14987,14988,14989,14990,14991,14992,14993,14994,14995,14996,14997,14998,14999,15000,15001,15002,15003,15004,15005,15006,15007,15008,15009,15010,15011,15012,18736,18739,47522,47523,47552,47553,47586,47610,47611,47612,47623,47639,47640,47686,47723) 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 ('canton') or v4.alias4url in ('canton') ) and i.id in (11549,11550,11551,11552,11553,11554,11555,11556,11557,11558,11559,11560,11561,11562,11563,11564,11565,11566,11567,11568,11569,11570,11571,11572,11573,11574,11575,11576,11577,11578,11579,11580,11581,11582,11583,11584,11585,11586,11587,11588,11589,11590,11591,11592,11593,11594,11595,11596,11597,11598,11599,11600,11601,11602,11603,11604,11605,11606,11607,11608,11609,11610,11611,11612,11613,11614,11615,11616,11617,11618,11619,11620,11621,11622,11623,11624,11625,11626,11627,11628,11629,11630,11631,11632,11633,11634,11635,11636,11637,11638,11639,11640,11641,11642,11643,11644,11645,11646,11647,11648,11649,11650,11651,11652,11653,11654,11655,11656,11657,11658,11659,11660,11693,11726,11727,11728,11729,11730,11769,11808,11809,11845,11882,11883,11884,11927,11970,11971,11972,12013,12054,12055,12056,12097,12138,12139,12140,12141,12142,12143,12144,12145,12146,12147,12148,12149,12150,12151,12152,12153,12154,12155,12156,12157,12158,12233,12252,12253,12254,12255,12256,14530,14531,14655,14670,14671,14685,14686,14691,14717,14718,14724,14725,14741,14742,14743,14751,14752,14789,14790,14791,14792,14793,14794,14812,14813,14816,14817,14819,14820,14823,14840,14841,14849,14850,14861,14862,14874,14875,14883,14884,14885,14980,14981,14982,14983,14984,14985,14986,14987,14988,14989,14990,14991,14992,14993,14994,14995,14996,14997,14998,14999,15000,15001,15002,15003,15004,15005,15006,15007,15008,15009,15010,15011,15012,18736,18739,47522,47523,47552,47553,47586,47610,47611,47612,47623,47639,47640,47686,47723) 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 ('canton') or v4.alias4url in ('canton') ) and i.id in (11549,11550,11551,11552,11553,11554,11555,11556,11557,11558,11559,11560,11561,11562,11563,11564,11565,11566,11567,11568,11569,11570,11571,11572,11573,11574,11575,11576,11577,11578,11579,11580,11581,11582,11583,11584,11585,11586,11587,11588,11589,11590,11591,11592,11593,11594,11595,11596,11597,11598,11599,11600,11601,11602,11603,11604,11605,11606,11607,11608,11609,11610,11611,11612,11613,11614,11615,11616,11617,11618,11619,11620,11621,11622,11623,11624,11625,11626,11627,11628,11629,11630,11631,11632,11633,11634,11635,11636,11637,11638,11639,11640,11641,11642,11643,11644,11645,11646,11647,11648,11649,11650,11651,11652,11653,11654,11655,11656,11657,11658,11659,11660,11693,11726,11727,11728,11729,11730,11769,11808,11809,11845,11882,11883,11884,11927,11970,11971,11972,12013,12054,12055,12056,12097,12138,12139,12140,12141,12142,12143,12144,12145,12146,12147,12148,12149,12150,12151,12152,12153,12154,12155,12156,12157,12158,12233,12252,12253,12254,12255,12256,14530,14531,14655,14670,14671,14685,14686,14691,14717,14718,14724,14725,14741,14742,14743,14751,14752,14789,14790,14791,14792,14793,14794,14812,14813,14816,14817,14819,14820,14823,14840,14841,14849,14850,14861,14862,14874,14875,14883,14884,14885,14980,14981,14982,14983,14984,14985,14986,14987,14988,14989,14990,14991,14992,14993,14994,14995,14996,14997,14998,14999,15000,15001,15002,15003,15004,15005,15006,15007,15008,15009,15010,15011,15012,18736,18739,47522,47523,47552,47553,47586,47610,47611,47612,47623,47639,47640,47686,47723) 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 ('canton') or v4.alias4url in ('canton') ) and i.id in (11549,11550,11551,11552,11553,11554,11555,11556,11557,11558,11559,11560,11561,11562,11563,11564,11565,11566,11567,11568,11569,11570,11571,11572,11573,11574,11575,11576,11577,11578,11579,11580,11581,11582,11583,11584,11585,11586,11587,11588,11589,11590,11591,11592,11593,11594,11595,11596,11597,11598,11599,11600,11601,11602,11603,11604,11605,11606,11607,11608,11609,11610,11611,11612,11613,11614,11615,11616,11617,11618,11619,11620,11621,11622,11623,11624,11625,11626,11627,11628,11629,11630,11631,11632,11633,11634,11635,11636,11637,11638,11639,11640,11641,11642,11643,11644,11645,11646,11647,11648,11649,11650,11651,11652,11653,11654,11655,11656,11657,11658,11659,11660,11693,11726,11727,11728,11729,11730,11769,11808,11809,11845,11882,11883,11884,11927,11970,11971,11972,12013,12054,12055,12056,12097,12138,12139,12140,12141,12142,12143,12144,12145,12146,12147,12148,12149,12150,12151,12152,12153,12154,12155,12156,12157,12158,12233,12252,12253,12254,12255,12256,14530,14531,14655,14670,14671,14685,14686,14691,14717,14718,14724,14725,14741,14742,14743,14751,14752,14789,14790,14791,14792,14793,14794,14812,14813,14816,14817,14819,14820,14823,14840,14841,14849,14850,14861,14862,14874,14875,14883,14884,14885,14980,14981,14982,14983,14984,14985,14986,14987,14988,14989,14990,14991,14992,14993,14994,14995,14996,14997,14998,14999,15000,15001,15002,15003,15004,15005,15006,15007,15008,15009,15010,15011,15012,18736,18739,47522,47523,47552,47553,47586,47610,47611,47612,47623,47639,47640,47686,47723) 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 ('canton') or v4.alias4url in ('canton') ) and i.id in (11549,11550,11551,11552,11553,11554,11555,11556,11557,11558,11559,11560,11561,11562,11563,11564,11565,11566,11567,11568,11569,11570,11571,11572,11573,11574,11575,11576,11577,11578,11579,11580,11581,11582,11583,11584,11585,11586,11587,11588,11589,11590,11591,11592,11593,11594,11595,11596,11597,11598,11599,11600,11601,11602,11603,11604,11605,11606,11607,11608,11609,11610,11611,11612,11613,11614,11615,11616,11617,11618,11619,11620,11621,11622,11623,11624,11625,11626,11627,11628,11629,11630,11631,11632,11633,11634,11635,11636,11637,11638,11639,11640,11641,11642,11643,11644,11645,11646,11647,11648,11649,11650,11651,11652,11653,11654,11655,11656,11657,11658,11659,11660,11693,11726,11727,11728,11729,11730,11769,11808,11809,11845,11882,11883,11884,11927,11970,11971,11972,12013,12054,12055,12056,12097,12138,12139,12140,12141,12142,12143,12144,12145,12146,12147,12148,12149,12150,12151,12152,12153,12154,12155,12156,12157,12158,12233,12252,12253,12254,12255,12256,14530,14531,14655,14670,14671,14685,14686,14691,14717,14718,14724,14725,14741,14742,14743,14751,14752,14789,14790,14791,14792,14793,14794,14812,14813,14816,14817,14819,14820,14823,14840,14841,14849,14850,14861,14862,14874,14875,14883,14884,14885,14980,14981,14982,14983,14984,14985,14986,14987,14988,14989,14990,14991,14992,14993,14994,14995,14996,14997,14998,14999,15000,15001,15002,15003,15004,15005,15006,15007,15008,15009,15010,15011,15012,18736,18739,47522,47523,47552,47553,47586,47610,47611,47612,47623,47639,47640,47686,47723) 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 ('canton') or v4.alias4url in ('canton') ) and i.id in (11549,11550,11551,11552,11553,11554,11555,11556,11557,11558,11559,11560,11561,11562,11563,11564,11565,11566,11567,11568,11569,11570,11571,11572,11573,11574,11575,11576,11577,11578,11579,11580,11581,11582,11583,11584,11585,11586,11587,11588,11589,11590,11591,11592,11593,11594,11595,11596,11597,11598,11599,11600,11601,11602,11603,11604,11605,11606,11607,11608,11609,11610,11611,11612,11613,11614,11615,11616,11617,11618,11619,11620,11621,11622,11623,11624,11625,11626,11627,11628,11629,11630,11631,11632,11633,11634,11635,11636,11637,11638,11639,11640,11641,11642,11643,11644,11645,11646,11647,11648,11649,11650,11651,11652,11653,11654,11655,11656,11657,11658,11659,11660,11693,11726,11727,11728,11729,11730,11769,11808,11809,11845,11882,11883,11884,11927,11970,11971,11972,12013,12054,12055,12056,12097,12138,12139,12140,12141,12142,12143,12144,12145,12146,12147,12148,12149,12150,12151,12152,12153,12154,12155,12156,12157,12158,12233,12252,12253,12254,12255,12256,14530,14531,14655,14670,14671,14685,14686,14691,14717,14718,14724,14725,14741,14742,14743,14751,14752,14789,14790,14791,14792,14793,14794,14812,14813,14816,14817,14819,14820,14823,14840,14841,14849,14850,14861,14862,14874,14875,14883,14884,14885,14980,14981,14982,14983,14984,14985,14986,14987,14988,14989,14990,14991,14992,14993,14994,14995,14996,14997,14998,14999,15000,15001,15002,15003,15004,15005,15006,15007,15008,15009,15010,15011,15012,18736,18739,47522,47523,47552,47553,47586,47610,47611,47612,47623,47639,47640,47686,47723) 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 ('canton') or v4.alias4url in ('canton') ) and i.id in (11549,11550,11551,11552,11553,11554,11555,11556,11557,11558,11559,11560,11561,11562,11563,11564,11565,11566,11567,11568,11569,11570,11571,11572,11573,11574,11575,11576,11577,11578,11579,11580,11581,11582,11583,11584,11585,11586,11587,11588,11589,11590,11591,11592,11593,11594,11595,11596,11597,11598,11599,11600,11601,11602,11603,11604,11605,11606,11607,11608,11609,11610,11611,11612,11613,11614,11615,11616,11617,11618,11619,11620,11621,11622,11623,11624,11625,11626,11627,11628,11629,11630,11631,11632,11633,11634,11635,11636,11637,11638,11639,11640,11641,11642,11643,11644,11645,11646,11647,11648,11649,11650,11651,11652,11653,11654,11655,11656,11657,11658,11659,11660,11693,11726,11727,11728,11729,11730,11769,11808,11809,11845,11882,11883,11884,11927,11970,11971,11972,12013,12054,12055,12056,12097,12138,12139,12140,12141,12142,12143,12144,12145,12146,12147,12148,12149,12150,12151,12152,12153,12154,12155,12156,12157,12158,12233,12252,12253,12254,12255,12256,14530,14531,14655,14670,14671,14685,14686,14691,14717,14718,14724,14725,14741,14742,14743,14751,14752,14789,14790,14791,14792,14793,14794,14812,14813,14816,14817,14819,14820,14823,14840,14841,14849,14850,14861,14862,14874,14875,14883,14884,14885,14980,14981,14982,14983,14984,14985,14986,14987,14988,14989,14990,14991,14992,14993,14994,14995,14996,14997,14998,14999,15000,15001,15002,15003,15004,15005,15006,15007,15008,15009,15010,15011,15012,18736,18739,47522,47523,47552,47553,47586,47610,47611,47612,47623,47639,47640,47686,47723) 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 ('canton') or v4.alias4url in ('canton') ) and i.id in (11549,11550,11551,11552,11553,11554,11555,11556,11557,11558,11559,11560,11561,11562,11563,11564,11565,11566,11567,11568,11569,11570,11571,11572,11573,11574,11575,11576,11577,11578,11579,11580,11581,11582,11583,11584,11585,11586,11587,11588,11589,11590,11591,11592,11593,11594,11595,11596,11597,11598,11599,11600,11601,11602,11603,11604,11605,11606,11607,11608,11609,11610,11611,11612,11613,11614,11615,11616,11617,11618,11619,11620,11621,11622,11623,11624,11625,11626,11627,11628,11629,11630,11631,11632,11633,11634,11635,11636,11637,11638,11639,11640,11641,11642,11643,11644,11645,11646,11647,11648,11649,11650,11651,11652,11653,11654,11655,11656,11657,11658,11659,11660,11693,11726,11727,11728,11729,11730,11769,11808,11809,11845,11882,11883,11884,11927,11970,11971,11972,12013,12054,12055,12056,12097,12138,12139,12140,12141,12142,12143,12144,12145,12146,12147,12148,12149,12150,12151,12152,12153,12154,12155,12156,12157,12158,12233,12252,12253,12254,12255,12256,14530,14531,14655,14670,14671,14685,14686,14691,14717,14718,14724,14725,14741,14742,14743,14751,14752,14789,14790,14791,14792,14793,14794,14812,14813,14816,14817,14819,14820,14823,14840,14841,14849,14850,14861,14862,14874,14875,14883,14884,14885,14980,14981,14982,14983,14984,14985,14986,14987,14988,14989,14990,14991,14992,14993,14994,14995,14996,14997,14998,14999,15000,15001,15002,15003,15004,15005,15006,15007,15008,15009,15010,15011,15012,18736,18739,47522,47523,47552,47553,47586,47610,47611,47612,47623,47639,47640,47686,47723) 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 ('canton') or v4.alias4url in ('canton') ) and i.id in (11549,11550,11551,11552,11553,11554,11555,11556,11557,11558,11559,11560,11561,11562,11563,11564,11565,11566,11567,11568,11569,11570,11571,11572,11573,11574,11575,11576,11577,11578,11579,11580,11581,11582,11583,11584,11585,11586,11587,11588,11589,11590,11591,11592,11593,11594,11595,11596,11597,11598,11599,11600,11601,11602,11603,11604,11605,11606,11607,11608,11609,11610,11611,11612,11613,11614,11615,11616,11617,11618,11619,11620,11621,11622,11623,11624,11625,11626,11627,11628,11629,11630,11631,11632,11633,11634,11635,11636,11637,11638,11639,11640,11641,11642,11643,11644,11645,11646,11647,11648,11649,11650,11651,11652,11653,11654,11655,11656,11657,11658,11659,11660,11693,11726,11727,11728,11729,11730,11769,11808,11809,11845,11882,11883,11884,11927,11970,11971,11972,12013,12054,12055,12056,12097,12138,12139,12140,12141,12142,12143,12144,12145,12146,12147,12148,12149,12150,12151,12152,12153,12154,12155,12156,12157,12158,12233,12252,12253,12254,12255,12256,14530,14531,14655,14670,14671,14685,14686,14691,14717,14718,14724,14725,14741,14742,14743,14751,14752,14789,14790,14791,14792,14793,14794,14812,14813,14816,14817,14819,14820,14823,14840,14841,14849,14850,14861,14862,14874,14875,14883,14884,14885,14980,14981,14982,14983,14984,14985,14986,14987,14988,14989,14990,14991,14992,14993,14994,14995,14996,14997,14998,14999,15000,15001,15002,15003,15004,15005,15006,15007,15008,15009,15010,15011,15012,18736,18739,47522,47523,47552,47553,47586,47610,47611,47612,47623,47639,47640,47686,47723) 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 ('canton') or v4.alias4url in ('canton') ) and i.id in (11549,11550,11551,11552,11553,11554,11555,11556,11557,11558,11559,11560,11561,11562,11563,11564,11565,11566,11567,11568,11569,11570,11571,11572,11573,11574,11575,11576,11577,11578,11579,11580,11581,11582,11583,11584,11585,11586,11587,11588,11589,11590,11591,11592,11593,11594,11595,11596,11597,11598,11599,11600,11601,11602,11603,11604,11605,11606,11607,11608,11609,11610,11611,11612,11613,11614,11615,11616,11617,11618,11619,11620,11621,11622,11623,11624,11625,11626,11627,11628,11629,11630,11631,11632,11633,11634,11635,11636,11637,11638,11639,11640,11641,11642,11643,11644,11645,11646,11647,11648,11649,11650,11651,11652,11653,11654,11655,11656,11657,11658,11659,11660,11693,11726,11727,11728,11729,11730,11769,11808,11809,11845,11882,11883,11884,11927,11970,11971,11972,12013,12054,12055,12056,12097,12138,12139,12140,12141,12142,12143,12144,12145,12146,12147,12148,12149,12150,12151,12152,12153,12154,12155,12156,12157,12158,12233,12252,12253,12254,12255,12256,14530,14531,14655,14670,14671,14685,14686,14691,14717,14718,14724,14725,14741,14742,14743,14751,14752,14789,14790,14791,14792,14793,14794,14812,14813,14816,14817,14819,14820,14823,14840,14841,14849,14850,14861,14862,14874,14875,14883,14884,14885,14980,14981,14982,14983,14984,14985,14986,14987,14988,14989,14990,14991,14992,14993,14994,14995,14996,14997,14998,14999,15000,15001,15002,15003,15004,15005,15006,15007,15008,15009,15010,15011,15012,18736,18739,47522,47523,47552,47553,47586,47610,47611,47612,47623,47639,47640,47686,47723) 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 ('canton') or v4.alias4url in ('canton') ) and i.id in (11549,11550,11551,11552,11553,11554,11555,11556,11557,11558,11559,11560,11561,11562,11563,11564,11565,11566,11567,11568,11569,11570,11571,11572,11573,11574,11575,11576,11577,11578,11579,11580,11581,11582,11583,11584,11585,11586,11587,11588,11589,11590,11591,11592,11593,11594,11595,11596,11597,11598,11599,11600,11601,11602,11603,11604,11605,11606,11607,11608,11609,11610,11611,11612,11613,11614,11615,11616,11617,11618,11619,11620,11621,11622,11623,11624,11625,11626,11627,11628,11629,11630,11631,11632,11633,11634,11635,11636,11637,11638,11639,11640,11641,11642,11643,11644,11645,11646,11647,11648,11649,11650,11651,11652,11653,11654,11655,11656,11657,11658,11659,11660,11693,11726,11727,11728,11729,11730,11769,11808,11809,11845,11882,11883,11884,11927,11970,11971,11972,12013,12054,12055,12056,12097,12138,12139,12140,12141,12142,12143,12144,12145,12146,12147,12148,12149,12150,12151,12152,12153,12154,12155,12156,12157,12158,12233,12252,12253,12254,12255,12256,14530,14531,14655,14670,14671,14685,14686,14691,14717,14718,14724,14725,14741,14742,14743,14751,14752,14789,14790,14791,14792,14793,14794,14812,14813,14816,14817,14819,14820,14823,14840,14841,14849,14850,14861,14862,14874,14875,14883,14884,14885,14980,14981,14982,14983,14984,14985,14986,14987,14988,14989,14990,14991,14992,14993,14994,14995,14996,14997,14998,14999,15000,15001,15002,15003,15004,15005,15006,15007,15008,15009,15010,15011,15012,18736,18739,47522,47523,47552,47553,47586,47610,47611,47612,47623,47639,47640,47686,47723) 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 ('canton') or v4.alias4url in ('canton') ) and i.id in (11549,11550,11551,11552,11553,11554,11555,11556,11557,11558,11559,11560,11561,11562,11563,11564,11565,11566,11567,11568,11569,11570,11571,11572,11573,11574,11575,11576,11577,11578,11579,11580,11581,11582,11583,11584,11585,11586,11587,11588,11589,11590,11591,11592,11593,11594,11595,11596,11597,11598,11599,11600,11601,11602,11603,11604,11605,11606,11607,11608,11609,11610,11611,11612,11613,11614,11615,11616,11617,11618,11619,11620,11621,11622,11623,11624,11625,11626,11627,11628,11629,11630,11631,11632,11633,11634,11635,11636,11637,11638,11639,11640,11641,11642,11643,11644,11645,11646,11647,11648,11649,11650,11651,11652,11653,11654,11655,11656,11657,11658,11659,11660,11693,11726,11727,11728,11729,11730,11769,11808,11809,11845,11882,11883,11884,11927,11970,11971,11972,12013,12054,12055,12056,12097,12138,12139,12140,12141,12142,12143,12144,12145,12146,12147,12148,12149,12150,12151,12152,12153,12154,12155,12156,12157,12158,12233,12252,12253,12254,12255,12256,14530,14531,14655,14670,14671,14685,14686,14691,14717,14718,14724,14725,14741,14742,14743,14751,14752,14789,14790,14791,14792,14793,14794,14812,14813,14816,14817,14819,14820,14823,14840,14841,14849,14850,14861,14862,14874,14875,14883,14884,14885,14980,14981,14982,14983,14984,14985,14986,14987,14988,14989,14990,14991,14992,14993,14994,14995,14996,14997,14998,14999,15000,15001,15002,15003,15004,15005,15006,15007,15008,15009,15010,15011,15012,18736,18739,47522,47523,47552,47553,47586,47610,47611,47612,47623,47639,47640,47686,47723) 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] => 478 [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 ('canton') or v4.alias4url in ('canton') ) and i.id in (11549,11550,11551,11552,11553,11554,11555,11556,11557,11558,11559,11560,11561,11562,11563,11564,11565,11566,11567,11568,11569,11570,11571,11572,11573,11574,11575,11576,11577,11578,11579,11580,11581,11582,11583,11584,11585,11586,11587,11588,11589,11590,11591,11592,11593,11594,11595,11596,11597,11598,11599,11600,11601,11602,11603,11604,11605,11606,11607,11608,11609,11610,11611,11612,11613,11614,11615,11616,11617,11618,11619,11620,11621,11622,11623,11624,11625,11626,11627,11628,11629,11630,11631,11632,11633,11634,11635,11636,11637,11638,11639,11640,11641,11642,11643,11644,11645,11646,11647,11648,11649,11650,11651,11652,11653,11654,11655,11656,11657,11658,11659,11660,11693,11726,11727,11728,11729,11730,11769,11808,11809,11845,11882,11883,11884,11927,11970,11971,11972,12013,12054,12055,12056,12097,12138,12139,12140,12141,12142,12143,12144,12145,12146,12147,12148,12149,12150,12151,12152,12153,12154,12155,12156,12157,12158,12233,12252,12253,12254,12255,12256,14530,14531,14655,14670,14671,14685,14686,14691,14717,14718,14724,14725,14741,14742,14743,14751,14752,14789,14790,14791,14792,14793,14794,14812,14813,14816,14817,14819,14820,14823,14840,14841,14849,14850,14861,14862,14874,14875,14883,14884,14885,14980,14981,14982,14983,14984,14985,14986,14987,14988,14989,14990,14991,14992,14993,14994,14995,14996,14997,14998,14999,15000,15001,15002,15003,15004,15005,15006,15007,15008,15009,15010,15011,15012,18736,18739,47522,47523,47552,47553,47586,47610,47611,47612,47623,47639,47640,47686,47723) 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 [brand] => Array ( [0] => canton ) ) ) ) ) [callback] => )