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 pv3 on pv3.prop_id=3 and pv3.item_id=i.id left join prop_value v3 on v3.id=pv3.prop_value_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 left join item_prop_value pv35 on pv35.prop_id=35 and pv35.item_id=i.id left join prop_value v35 on v35.id=pv35.prop_value_id where 1 and (IFNULL(pv3.prop_value_id,'') in ('2') or v3.alias4url in ('2') ) and (IFNULL(pv4.prop_value_id,'') in ('162') or v4.alias4url in ('162') ) and (IFNULL(pv35.prop_value_id,'') in ('248') or v35.alias4url in ('248') ) and i.id in (19320,19459,19460,19572,19577,19578,19579,20163,20165,20168,21648,21649,21650,46519,46531) 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 pv3 on pv3.prop_id=3 and pv3.item_id=i.id left join prop_value v3 on v3.id=pv3.prop_value_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 left join item_prop_value pv35 on pv35.prop_id=35 and pv35.item_id=i.id left join prop_value v35 on v35.id=pv35.prop_value_id where 1 and (IFNULL(pv3.prop_value_id,'') in ('2') or v3.alias4url in ('2') ) and (IFNULL(pv4.prop_value_id,'') in ('162') or v4.alias4url in ('162') ) and (IFNULL(pv35.prop_value_id,'') in ('248') or v35.alias4url in ('248') ) and i.id in (19320,19459,19460,19572,19577,19578,19579,20163,20165,20168,21648,21649,21650,46519,46531) 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 pv3 on pv3.prop_id=3 and pv3.item_id=i.id left join prop_value v3 on v3.id=pv3.prop_value_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 left join item_prop_value pv35 on pv35.prop_id=35 and pv35.item_id=i.id left join prop_value v35 on v35.id=pv35.prop_value_id where 1 and (IFNULL(pv3.prop_value_id,'') in ('2') or v3.alias4url in ('2') ) and (IFNULL(pv4.prop_value_id,'') in ('162') or v4.alias4url in ('162') ) and (IFNULL(pv35.prop_value_id,'') in ('248') or v35.alias4url in ('248') ) and i.id in (19320,19459,19460,19572,19577,19578,19579,20163,20165,20168,21648,21649,21650,46519,46531) 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 pv3 on pv3.prop_id=3 and pv3.item_id=i.id left join prop_value v3 on v3.id=pv3.prop_value_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 left join item_prop_value pv35 on pv35.prop_id=35 and pv35.item_id=i.id left join prop_value v35 on v35.id=pv35.prop_value_id where 1 and (IFNULL(pv3.prop_value_id,'') in ('2') or v3.alias4url in ('2') ) and (IFNULL(pv4.prop_value_id,'') in ('162') or v4.alias4url in ('162') ) and (IFNULL(pv35.prop_value_id,'') in ('248') or v35.alias4url in ('248') ) and i.id in (19320,19459,19460,19572,19577,19578,19579,20163,20165,20168,21648,21649,21650,46519,46531) 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 pv3 on pv3.prop_id=3 and pv3.item_id=i.id left join prop_value v3 on v3.id=pv3.prop_value_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 left join item_prop_value pv35 on pv35.prop_id=35 and pv35.item_id=i.id left join prop_value v35 on v35.id=pv35.prop_value_id where 1 and (IFNULL(pv3.prop_value_id,'') in ('2') or v3.alias4url in ('2') ) and (IFNULL(pv4.prop_value_id,'') in ('162') or v4.alias4url in ('162') ) and (IFNULL(pv35.prop_value_id,'') in ('248') or v35.alias4url in ('248') ) and i.id in (19320,19459,19460,19572,19577,19578,19579,20163,20165,20168,21648,21649,21650,46519,46531) 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 pv3 on pv3.prop_id=3 and pv3.item_id=i.id left join prop_value v3 on v3.id=pv3.prop_value_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 left join item_prop_value pv35 on pv35.prop_id=35 and pv35.item_id=i.id left join prop_value v35 on v35.id=pv35.prop_value_id where 1 and (IFNULL(pv3.prop_value_id,'') in ('2') or v3.alias4url in ('2') ) and (IFNULL(pv4.prop_value_id,'') in ('162') or v4.alias4url in ('162') ) and (IFNULL(pv35.prop_value_id,'') in ('248') or v35.alias4url in ('248') ) and i.id in (19320,19459,19460,19572,19577,19578,19579,20163,20165,20168,21648,21649,21650,46519,46531) 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 pv3 on pv3.prop_id=3 and pv3.item_id=i.id left join prop_value v3 on v3.id=pv3.prop_value_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 left join item_prop_value pv35 on pv35.prop_id=35 and pv35.item_id=i.id left join prop_value v35 on v35.id=pv35.prop_value_id where 1 and (IFNULL(pv3.prop_value_id,'') in ('2') or v3.alias4url in ('2') ) and (IFNULL(pv4.prop_value_id,'') in ('162') or v4.alias4url in ('162') ) and (IFNULL(pv35.prop_value_id,'') in ('248') or v35.alias4url in ('248') ) and i.id in (19320,19459,19460,19572,19577,19578,19579,20163,20165,20168,21648,21649,21650,46519,46531) 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 pv3 on pv3.prop_id=3 and pv3.item_id=i.id left join prop_value v3 on v3.id=pv3.prop_value_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 left join item_prop_value pv35 on pv35.prop_id=35 and pv35.item_id=i.id left join prop_value v35 on v35.id=pv35.prop_value_id where 1 and (IFNULL(pv3.prop_value_id,'') in ('2') or v3.alias4url in ('2') ) and (IFNULL(pv4.prop_value_id,'') in ('162') or v4.alias4url in ('162') ) and (IFNULL(pv35.prop_value_id,'') in ('248') or v35.alias4url in ('248') ) and i.id in (19320,19459,19460,19572,19577,19578,19579,20163,20165,20168,21648,21649,21650,46519,46531) 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 pv3 on pv3.prop_id=3 and pv3.item_id=i.id left join prop_value v3 on v3.id=pv3.prop_value_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 left join item_prop_value pv35 on pv35.prop_id=35 and pv35.item_id=i.id left join prop_value v35 on v35.id=pv35.prop_value_id where 1 and (IFNULL(pv3.prop_value_id,'') in ('2') or v3.alias4url in ('2') ) and (IFNULL(pv4.prop_value_id,'') in ('162') or v4.alias4url in ('162') ) and (IFNULL(pv35.prop_value_id,'') in ('248') or v35.alias4url in ('248') ) and i.id in (19320,19459,19460,19572,19577,19578,19579,20163,20165,20168,21648,21649,21650,46519,46531) 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 pv3 on pv3.prop_id=3 and pv3.item_id=i.id left join prop_value v3 on v3.id=pv3.prop_value_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 left join item_prop_value pv35 on pv35.prop_id=35 and pv35.item_id=i.id left join prop_value v35 on v35.id=pv35.prop_value_id where 1 and (IFNULL(pv3.prop_value_id,'') in ('2') or v3.alias4url in ('2') ) and (IFNULL(pv4.prop_value_id,'') in ('162') or v4.alias4url in ('162') ) and (IFNULL(pv35.prop_value_id,'') in ('248') or v35.alias4url in ('248') ) and i.id in (19320,19459,19460,19572,19577,19578,19579,20163,20165,20168,21648,21649,21650,46519,46531) 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 pv3 on pv3.prop_id=3 and pv3.item_id=i.id left join prop_value v3 on v3.id=pv3.prop_value_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 left join item_prop_value pv35 on pv35.prop_id=35 and pv35.item_id=i.id left join prop_value v35 on v35.id=pv35.prop_value_id where 1 and (IFNULL(pv3.prop_value_id,'') in ('2') or v3.alias4url in ('2') ) and (IFNULL(pv4.prop_value_id,'') in ('162') or v4.alias4url in ('162') ) and (IFNULL(pv35.prop_value_id,'') in ('248') or v35.alias4url in ('248') ) and i.id in (19320,19459,19460,19572,19577,19578,19579,20163,20165,20168,21648,21649,21650,46519,46531) 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 pv3 on pv3.prop_id=3 and pv3.item_id=i.id left join prop_value v3 on v3.id=pv3.prop_value_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 left join item_prop_value pv35 on pv35.prop_id=35 and pv35.item_id=i.id left join prop_value v35 on v35.id=pv35.prop_value_id where 1 and (IFNULL(pv3.prop_value_id,'') in ('2') or v3.alias4url in ('2') ) and (IFNULL(pv4.prop_value_id,'') in ('162') or v4.alias4url in ('162') ) and (IFNULL(pv35.prop_value_id,'') in ('248') or v35.alias4url in ('248') ) and i.id in (19320,19459,19460,19572,19577,19578,19579,20163,20165,20168,21648,21649,21650,46519,46531) 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 pv3 on pv3.prop_id=3 and pv3.item_id=i.id left join prop_value v3 on v3.id=pv3.prop_value_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 left join item_prop_value pv35 on pv35.prop_id=35 and pv35.item_id=i.id left join prop_value v35 on v35.id=pv35.prop_value_id where 1 and (IFNULL(pv3.prop_value_id,'') in ('2') or v3.alias4url in ('2') ) and (IFNULL(pv4.prop_value_id,'') in ('162') or v4.alias4url in ('162') ) and (IFNULL(pv35.prop_value_id,'') in ('248') or v35.alias4url in ('248') ) and i.id in (19320,19459,19460,19572,19577,19578,19579,20163,20165,20168,21648,21649,21650,46519,46531) 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 pv3 on pv3.prop_id=3 and pv3.item_id=i.id left join prop_value v3 on v3.id=pv3.prop_value_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 left join item_prop_value pv35 on pv35.prop_id=35 and pv35.item_id=i.id left join prop_value v35 on v35.id=pv35.prop_value_id where 1 and (IFNULL(pv3.prop_value_id,'') in ('2') or v3.alias4url in ('2') ) and (IFNULL(pv4.prop_value_id,'') in ('162') or v4.alias4url in ('162') ) and (IFNULL(pv35.prop_value_id,'') in ('248') or v35.alias4url in ('248') ) and i.id in (19320,19459,19460,19572,19577,19578,19579,20163,20165,20168,21648,21649,21650,46519,46531) 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 pv3 on pv3.prop_id=3 and pv3.item_id=i.id left join prop_value v3 on v3.id=pv3.prop_value_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 left join item_prop_value pv35 on pv35.prop_id=35 and pv35.item_id=i.id left join prop_value v35 on v35.id=pv35.prop_value_id where 1 and (IFNULL(pv3.prop_value_id,'') in ('2') or v3.alias4url in ('2') ) and (IFNULL(pv4.prop_value_id,'') in ('162') or v4.alias4url in ('162') ) and (IFNULL(pv35.prop_value_id,'') in ('248') or v35.alias4url in ('248') ) and i.id in (19320,19459,19460,19572,19577,19578,19579,20163,20165,20168,21648,21649,21650,46519,46531) 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 pv3 on pv3.prop_id=3 and pv3.item_id=i.id left join prop_value v3 on v3.id=pv3.prop_value_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 left join item_prop_value pv35 on pv35.prop_id=35 and pv35.item_id=i.id left join prop_value v35 on v35.id=pv35.prop_value_id where 1 and (IFNULL(pv3.prop_value_id,'') in ('2') or v3.alias4url in ('2') ) and (IFNULL(pv4.prop_value_id,'') in ('162') or v4.alias4url in ('162') ) and (IFNULL(pv35.prop_value_id,'') in ('248') or v35.alias4url in ('248') ) and i.id in (19320,19459,19460,19572,19577,19578,19579,20163,20165,20168,21648,21649,21650,46519,46531) 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 pv3 on pv3.prop_id=3 and pv3.item_id=i.id left join prop_value v3 on v3.id=pv3.prop_value_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 left join item_prop_value pv35 on pv35.prop_id=35 and pv35.item_id=i.id left join prop_value v35 on v35.id=pv35.prop_value_id where 1 and (IFNULL(pv3.prop_value_id,'') in ('2') or v3.alias4url in ('2') ) and (IFNULL(pv4.prop_value_id,'') in ('162') or v4.alias4url in ('162') ) and (IFNULL(pv35.prop_value_id,'') in ('248') or v35.alias4url in ('248') ) and i.id in (19320,19459,19460,19572,19577,19578,19579,20163,20165,20168,21648,21649,21650,46519,46531) 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] => 793 [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 pv3 on pv3.prop_id=3 and pv3.item_id=i.id left join prop_value v3 on v3.id=pv3.prop_value_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 left join item_prop_value pv35 on pv35.prop_id=35 and pv35.item_id=i.id left join prop_value v35 on v35.id=pv35.prop_value_id where 1 and (IFNULL(pv3.prop_value_id,'') in ('2') or v3.alias4url in ('2') ) and (IFNULL(pv4.prop_value_id,'') in ('162') or v4.alias4url in ('162') ) and (IFNULL(pv35.prop_value_id,'') in ('248') or v35.alias4url in ('248') ) and i.id in (19320,19459,19460,19572,19577,19578,19579,20163,20165,20168,21648,21649,21650,46519,46531) 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 [3] => Array ( [0] => 2 ) [4] => Array ( [0] => 162 ) [35] => Array ( [0] => 248 ) ) ) ) ) [callback] => )