SELECT ads.`id_search`, ads.`id_hook`, ads.`unique_search` FROM `ps_pm_advancedsearch` ads JOIN `ps_pm_advancedsearch_shop` adss ON (ads.`id_search`=adss.`id_search` AND adss.`id_shop`=1) WHERE 1 AND ads.`active`=1 ORDER BY ads.`position`
array(1) { [0]=> array(3) { ["id_search"]=> string(1) "1" ["id_hook"]=> string(1) "8" ["unique_search"]=> string(1) "1" } }

SELECT id_category FROM `ps_pm_advancedsearch_category` WHERE id_search=1
array(0) { }

SELECT id_category FROM `ps_pm_advancedsearch_products_cat` WHERE id_search=1
array(0) { }

SELECT id_cms FROM `ps_pm_advancedsearch_cms` WHERE id_search=1
array(0) { }

SELECT id_supplier FROM `ps_pm_advancedsearch_suppliers` WHERE id_search=1
array(0) { }

SELECT id_manufacturer FROM `ps_pm_advancedsearch_manufacturers` WHERE id_search=1
array(0) { }

SELECT id_product FROM `ps_pm_advancedsearch_products` WHERE id_search=1
array(0) { }

SELECT page FROM `ps_pm_advancedsearch_special_pages` WHERE id_search=1
array(0) { }

SELECT ads.* , adsl.*, ads.`id_search` FROM `ps_pm_advancedsearch` ads LEFT JOIN `ps_pm_advancedsearch_lang` adsl ON (ads.`id_search` = adsl.`id_search` AND adsl.`id_lang` = 1 ) WHERE ads.`id_search` IN (1) ORDER BY ads.`position`
array(1) { [0]=> array(38) { ["id_search"]=> string(1) "1" ["id_hook"]=> string(1) "8" ["active"]=> string(1) "1" ["internal_name"]=> string(11) "search_book" ["css_classes"]=> string(9) "col-xs-12" ["search_results_selector_css"]=> string(0) "" ["display_nb_result_on_blc"]=> string(1) "0" ["display_nb_result_criterion"]=> string(1) "0" ["remind_selection"]=> string(1) "1" ["show_hide_crit_method"]=> string(1) "1" ["filter_by_emplacement"]=> string(1) "1" ["search_on_stock"]=> string(1) "1" ["hide_empty_crit_group"]=> string(1) "1" ["search_method"]=> string(1) "1" ["step_search"]=> string(1) "0" ["hide_criterions_group_with_no_effect"]=> string(1) "0" ["step_search_next_in_disabled"]=> string(1) "0" ["position"]=> string(1) "0" ["unique_search"]=> string(1) "1" ["scrolltop_active"]=> string(1) "0" ["id_category_root"]=> string(1) "0" ["redirect_one_product"]=> string(1) "1" ["add_anchor_to_url"]=> string(1) "1" ["reset_group"]=> string(1) "1" ["insert_in_center_column"]=> string(1) "0" ["smarty_var_name"]=> string(17) "as4_57fb0323488d8" ["search_results_selector"]=> string(14) "#center_column" ["recursing_indexing"]=> string(1) "1" ["display_empty_criteria"]=> string(1) "0" ["keep_category_information"]=> string(1) "1" ["priority_on_combination_image"]=> string(1) "1" ["use_cache"]=> string(1) "0" ["products_per_page"]=> string(2) "12" ["products_order_by"]=> string(1) "6" ["products_order_way"]=> string(1) "1" ["id_lang"]=> string(1) "1" ["title"]=> string(27) "Фильтр товаров" ["description"]=> string(0) "" } }

SELECT ac.`id_criterion`, ac.`id_criterion_group`, acg.`visible`,aclink.`id_criterion_linked` FROM `ps_pm_advancedsearch_criterion_1` ac JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`) LEFT JOIN `ps_pm_advancedsearch_criterion_group_1` acg ON (acg.`id_criterion_group` = ac.`id_criterion_group`) WHERE acg.`criterion_group_type` = "category" AND aclink.`id_criterion_linked` = 2358
array(1) { [0]=> array(4) { ["id_criterion"]=> string(5) "50460" ["id_criterion_group"]=> string(2) "25" ["visible"]=> string(1) "0" ["id_criterion_linked"]=> string(4) "2358" } }

SELECT acg.*, acgl.* FROM `ps_pm_advancedsearch_criterion_group_1` acg LEFT JOIN `ps_pm_advancedsearch_criterion_group_1_lang` acgl ON (acg.`id_criterion_group` = acgl.`id_criterion_group` AND acgl.`id_lang` = 1 ) WHERE acg.`id_search` = 1 ORDER BY `position`
array(32) { [0]=> array(29) { ["id_criterion_group"]=> string(2) "35" ["id_search"]=> string(1) "1" ["criterion_group_type"]=> string(11) "subcategory" ["sort_by"]=> string(10) "alphabetic" ["sort_way"]=> string(3) "ASC" ["id_criterion_group_linked"]=> string(1) "0" ["display_type"]=> string(1) "1" ["context_type"]=> string(1) "0" ["is_multicriteria"]=> string(1) "1" ["filter_option"]=> string(1) "1" ["is_combined"]=> string(1) "0" ["range"]=> string(1) "0" ["range_nb"]=> string(5) "15.00" ["show_all_depth"]=> string(1) "0" ["only_children"]=> string(1) "0" ["hidden"]=> string(1) "0" ["max_display"]=> string(1) "0" ["css_classes"]=> string(18) "col-xs-12 col-sm-3" ["overflow_height"]=> string(1) "0" ["position"]=> string(1) "3" ["visible"]=> string(1) "1" ["id_lang"]=> string(1) "1" ["name"]=> string(18) "Категория" ["url_identifier"]=> string(10) "kategoriya" ["url_identifier_original"]=> string(10) "kategoriya" ["icon"]=> string(0) "" ["range_sign"]=> string(0) "" ["range_interval"]=> string(0) "" ["all_label"]=> string(0) "" } [1]=> array(29) { ["id_criterion_group"]=> string(2) "64" ["id_search"]=> string(1) "1" ["criterion_group_type"]=> string(7) "feature" ["sort_by"]=> string(10) "alphabetic" ["sort_way"]=> string(3) "ASC" ["id_criterion_group_linked"]=> string(2) "33" ["display_type"]=> string(1) "1" ["context_type"]=> string(1) "0" ["is_multicriteria"]=> string(1) "1" ["filter_option"]=> string(1) "0" ["is_combined"]=> string(1) "0" ["range"]=> string(1) "0" ["range_nb"]=> string(5) "15.00" ["show_all_depth"]=> string(1) "0" ["only_children"]=> string(1) "0" ["hidden"]=> string(1) "0" ["max_display"]=> string(1) "0" ["css_classes"]=> string(18) "col-xs-12 col-sm-3" ["overflow_height"]=> string(1) "0" ["position"]=> string(1) "5" ["visible"]=> string(1) "1" ["id_lang"]=> string(1) "1" ["name"]=> string(16) "Тематика" ["url_identifier"]=> string(8) "tematika" ["url_identifier_original"]=> string(8) "tematika" ["icon"]=> string(0) "" ["range_sign"]=> string(0) "" ["range_interval"]=> string(0) "" ["all_label"]=> string(0) "" } [2]=> array(29) { ["id_criterion_group"]=> string(2) "72" ["id_search"]=> string(1) "1" ["criterion_group_type"]=> string(7) "feature" ["sort_by"]=> string(10) "nb_product" ["sort_way"]=> string(4) "DESC" ["id_criterion_group_linked"]=> string(3) "120" ["display_type"]=> string(1) "1" ["context_type"]=> string(1) "0" ["is_multicriteria"]=> string(1) "1" ["filter_option"]=> string(1) "0" ["is_combined"]=> string(1) "0" ["range"]=> string(1) "0" ["range_nb"]=> string(5) "15.00" ["show_all_depth"]=> string(1) "0" ["only_children"]=> string(1) "0" ["hidden"]=> string(1) "0" ["max_display"]=> string(1) "0" ["css_classes"]=> string(18) "col-xs-12 col-sm-3" ["overflow_height"]=> string(1) "0" ["position"]=> string(1) "7" ["visible"]=> string(1) "1" ["id_lang"]=> string(1) "1" ["name"]=> string(17) "Тип книги" ["url_identifier"]=> string(9) "tip_knigi" ["url_identifier_original"]=> string(9) "tip_knigi" ["icon"]=> string(0) "" ["range_sign"]=> string(0) "" ["range_interval"]=> string(0) "" ["all_label"]=> string(0) "" } [3]=> array(29) { ["id_criterion_group"]=> string(1) "5" ["id_search"]=> string(1) "1" ["criterion_group_type"]=> string(7) "feature" ["sort_by"]=> string(10) "alphabetic" ["sort_way"]=> string(3) "ASC" ["id_criterion_group_linked"]=> string(1) "8" ["display_type"]=> string(1) "1" ["context_type"]=> string(1) "2" ["is_multicriteria"]=> string(1) "0" ["filter_option"]=> string(1) "1" ["is_combined"]=> string(1) "0" ["range"]=> string(1) "0" ["range_nb"]=> string(5) "15.00" ["show_all_depth"]=> string(1) "0" ["only_children"]=> string(1) "0" ["hidden"]=> string(1) "0" ["max_display"]=> string(1) "0" ["css_classes"]=> string(18) "col-xs-12 col-sm-3" ["overflow_height"]=> string(1) "0" ["position"]=> string(1) "8" ["visible"]=> string(1) "1" ["id_lang"]=> string(1) "1" ["name"]=> string(19) "ФИО Автора" ["url_identifier"]=> string(10) "fio_avtora" ["url_identifier_original"]=> string(10) "fio_avtora" ["icon"]=> string(0) "" ["range_sign"]=> string(0) "" ["range_interval"]=> string(0) "" ["all_label"]=> string(0) "" } [4]=> array(29) { ["id_criterion_group"]=> string(2) "69" ["id_search"]=> string(1) "1" ["criterion_group_type"]=> string(7) "feature" ["sort_by"]=> string(10) "alphabetic" ["sort_way"]=> string(3) "ASC" ["id_criterion_group_linked"]=> string(1) "9" ["display_type"]=> string(1) "1" ["context_type"]=> string(1) "0" ["is_multicriteria"]=> string(1) "1" ["filter_option"]=> string(1) "0" ["is_combined"]=> string(1) "0" ["range"]=> string(1) "0" ["range_nb"]=> string(5) "15.00" ["show_all_depth"]=> string(1) "0" ["only_children"]=> string(1) "0" ["hidden"]=> string(1) "0" ["max_display"]=> string(1) "0" ["css_classes"]=> string(18) "col-xs-12 col-sm-3" ["overflow_height"]=> string(1) "0" ["position"]=> string(2) "10" ["visible"]=> string(1) "1" ["id_lang"]=> string(1) "1" ["name"]=> string(24) "Издательство" ["url_identifier"]=> string(11) "izdatelstvo" ["url_identifier_original"]=> string(11) "izdatelstvo" ["icon"]=> string(0) "" ["range_sign"]=> string(0) "" ["range_interval"]=> string(0) "" ["all_label"]=> string(0) "" } [5]=> array(29) { ["id_criterion_group"]=> string(2) "31" ["id_search"]=> string(1) "1" ["criterion_group_type"]=> string(7) "feature" ["sort_by"]=> string(10) "nb_product" ["sort_way"]=> string(4) "DESC" ["id_criterion_group_linked"]=> string(2) "18" ["display_type"]=> string(1) "1" ["context_type"]=> string(1) "2" ["is_multicriteria"]=> string(1) "1" ["filter_option"]=> string(1) "0" ["is_combined"]=> string(1) "0" ["range"]=> string(1) "0" ["range_nb"]=> string(5) "15.00" ["show_all_depth"]=> string(1) "0" ["only_children"]=> string(1) "0" ["hidden"]=> string(1) "0" ["max_display"]=> string(1) "0" ["css_classes"]=> string(18) "col-xs-12 col-sm-3" ["overflow_height"]=> string(1) "0" ["position"]=> string(2) "12" ["visible"]=> string(1) "1" ["id_lang"]=> string(1) "1" ["name"]=> string(12) "Бумага" ["url_identifier"]=> string(6) "bumaga" ["url_identifier_original"]=> string(6) "bumaga" ["icon"]=> string(0) "" ["range_sign"]=> string(0) "" ["range_interval"]=> string(0) "" ["all_label"]=> string(0) "" } [6]=> array(29) { ["id_criterion_group"]=> string(2) "37" ["id_search"]=> string(1) "1" ["criterion_group_type"]=> string(7) "feature" ["sort_by"]=> string(10) "nb_product" ["sort_way"]=> string(4) "DESC" ["id_criterion_group_linked"]=> string(2) "28" ["display_type"]=> string(1) "1" ["context_type"]=> string(1) "0" ["is_multicriteria"]=> string(1) "1" ["filter_option"]=> string(1) "1" ["is_combined"]=> string(1) "0" ["range"]=> string(1) "0" ["range_nb"]=> string(5) "15.00" ["show_all_depth"]=> string(1) "0" ["only_children"]=> string(1) "0" ["hidden"]=> string(1) "0" ["max_display"]=> string(1) "0" ["css_classes"]=> string(18) "col-xs-12 col-sm-3" ["overflow_height"]=> string(1) "0" ["position"]=> string(2) "14" ["visible"]=> string(1) "1" ["id_lang"]=> string(1) "1" ["name"]=> string(16) "Переплет" ["url_identifier"]=> string(8) "pereplet" ["url_identifier_original"]=> string(8) "pereplet" ["icon"]=> string(0) "" ["range_sign"]=> string(0) "" ["range_interval"]=> string(0) "" ["all_label"]=> string(0) "" } [7]=> array(29) { ["id_criterion_group"]=> string(2) "27" ["id_search"]=> string(1) "1" ["criterion_group_type"]=> string(7) "feature" ["sort_by"]=> string(10) "alphabetic" ["sort_way"]=> string(3) "ASC" ["id_criterion_group_linked"]=> string(2) "11" ["display_type"]=> string(1) "1" ["context_type"]=> string(1) "2" ["is_multicriteria"]=> string(1) "1" ["filter_option"]=> string(1) "0" ["is_combined"]=> string(1) "0" ["range"]=> string(1) "0" ["range_nb"]=> string(5) "15.00" ["show_all_depth"]=> string(1) "0" ["only_children"]=> string(1) "0" ["hidden"]=> string(1) "0" ["max_display"]=> string(1) "0" ["css_classes"]=> string(18) "col-xs-12 col-sm-3" ["overflow_height"]=> string(1) "0" ["position"]=> string(2) "16" ["visible"]=> string(1) "1" ["id_lang"]=> string(1) "1" ["name"]=> string(8) "Язык" ["url_identifier"]=> string(5) "yazyk" ["url_identifier_original"]=> string(5) "yazyk" ["icon"]=> string(0) "" ["range_sign"]=> string(0) "" ["range_interval"]=> string(0) "" ["all_label"]=> string(0) "" } [8]=> array(29) { ["id_criterion_group"]=> string(2) "71" ["id_search"]=> string(1) "1" ["criterion_group_type"]=> string(7) "feature" ["sort_by"]=> string(8) "position" ["sort_way"]=> string(3) "ASC" ["id_criterion_group_linked"]=> string(2) "14" ["display_type"]=> string(1) "1" ["context_type"]=> string(1) "0" ["is_multicriteria"]=> string(1) "0" ["filter_option"]=> string(1) "0" ["is_combined"]=> string(1) "0" ["range"]=> string(1) "0" ["range_nb"]=> string(5) "15.00" ["show_all_depth"]=> string(1) "0" ["only_children"]=> string(1) "0" ["hidden"]=> string(1) "0" ["max_display"]=> string(1) "0" ["css_classes"]=> string(18) "col-xs-12 col-sm-3" ["overflow_height"]=> string(1) "0" ["position"]=> string(2) "18" ["visible"]=> string(1) "1" ["id_lang"]=> string(1) "1" ["name"]=> string(22) "Иллюстрации" ["url_identifier"]=> string(12) "illyustracii" ["url_identifier_original"]=> string(12) "illyustracii" ["icon"]=> string(0) "" ["range_sign"]=> string(0) "" ["range_interval"]=> string(0) "" ["all_label"]=> string(0) "" } [9]=> array(29) { ["id_criterion_group"]=> string(2) "41" ["id_search"]=> string(1) "1" ["criterion_group_type"]=> string(7) "feature" ["sort_by"]=> string(8) "position" ["sort_way"]=> string(3) "ASC" ["id_criterion_group_linked"]=> string(2) "26" ["display_type"]=> string(1) "1" ["context_type"]=> string(1) "0" ["is_multicriteria"]=> string(1) "0" ["filter_option"]=> string(1) "1" ["is_combined"]=> string(1) "0" ["range"]=> string(1) "0" ["range_nb"]=> string(5) "15.00" ["show_all_depth"]=> string(1) "0" ["only_children"]=> string(1) "0" ["hidden"]=> string(1) "0" ["max_display"]=> string(1) "0" ["css_classes"]=> string(18) "col-xs-12 col-sm-3" ["overflow_height"]=> string(1) "0" ["position"]=> string(2) "19" ["visible"]=> string(1) "1" ["id_lang"]=> string(1) "1" ["name"]=> string(16) "Издатель" ["url_identifier"]=> string(7) "izdatel" ["url_identifier_original"]=> string(7) "izdatel" ["icon"]=> string(0) "" ["range_sign"]=> string(0) "" ["range_interval"]=> string(0) "" ["all_label"]=> string(0) "" } [10]=> array(29) { ["id_criterion_group"]=> string(2) "39" ["id_search"]=> string(1) "1" ["criterion_group_type"]=> string(7) "feature" ["sort_by"]=> string(8) "position" ["sort_way"]=> string(3) "ASC" ["id_criterion_group_linked"]=> string(2) "36" ["display_type"]=> string(1) "1" ["context_type"]=> string(1) "0" ["is_multicriteria"]=> string(1) "0" ["filter_option"]=> string(1) "0" ["is_combined"]=> string(1) "0" ["range"]=> string(1) "0" ["range_nb"]=> string(5) "15.00" ["show_all_depth"]=> string(1) "0" ["only_children"]=> string(1) "0" ["hidden"]=> string(1) "0" ["max_display"]=> string(1) "0" ["css_classes"]=> string(18) "col-xs-12 col-sm-3" ["overflow_height"]=> string(1) "0" ["position"]=> string(2) "21" ["visible"]=> string(1) "1" ["id_lang"]=> string(1) "1" ["name"]=> string(14) "Возраст" ["url_identifier"]=> string(7) "vozrast" ["url_identifier_original"]=> string(7) "vozrast" ["icon"]=> string(0) "" ["range_sign"]=> string(0) "" ["range_interval"]=> string(0) "" ["all_label"]=> string(0) "" } [11]=> array(29) { ["id_criterion_group"]=> string(2) "40" ["id_search"]=> string(1) "1" ["criterion_group_type"]=> string(7) "feature" ["sort_by"]=> string(8) "position" ["sort_way"]=> string(3) "ASC" ["id_criterion_group_linked"]=> string(2) "35" ["display_type"]=> string(1) "1" ["context_type"]=> string(1) "0" ["is_multicriteria"]=> string(1) "0" ["filter_option"]=> string(1) "0" ["is_combined"]=> string(1) "0" ["range"]=> string(1) "0" ["range_nb"]=> string(5) "15.00" ["show_all_depth"]=> string(1) "0" ["only_children"]=> string(1) "0" ["hidden"]=> string(1) "0" ["max_display"]=> string(1) "0" ["css_classes"]=> string(18) "col-xs-12 col-sm-3" ["overflow_height"]=> string(1) "0" ["position"]=> string(2) "23" ["visible"]=> string(1) "1" ["id_lang"]=> string(1) "1" ["name"]=> string(19) "Время игры" ["url_identifier"]=> string(11) "vremya_igry" ["url_identifier_original"]=> string(11) "vremya_igry" ["icon"]=> string(0) "" ["range_sign"]=> string(0) "" ["range_interval"]=> string(0) "" ["all_label"]=> string(0) "" } [12]=> array(29) { ["id_criterion_group"]=> string(2) "38" ["id_search"]=> string(1) "1" ["criterion_group_type"]=> string(7) "feature" ["sort_by"]=> string(10) "alphabetic" ["sort_way"]=> string(3) "ASC" ["id_criterion_group_linked"]=> string(2) "27" ["display_type"]=> string(1) "1" ["context_type"]=> string(1) "0" ["is_multicriteria"]=> string(1) "1" ["filter_option"]=> string(1) "0" ["is_combined"]=> string(1) "0" ["range"]=> string(1) "0" ["range_nb"]=> string(5) "15.00" ["show_all_depth"]=> string(1) "0" ["only_children"]=> string(1) "0" ["hidden"]=> string(1) "0" ["max_display"]=> string(1) "0" ["css_classes"]=> string(18) "col-xs-12 col-sm-3" ["overflow_height"]=> string(1) "0" ["position"]=> string(2) "25" ["visible"]=> string(1) "1" ["id_lang"]=> string(1) "1" ["name"]=> string(26) "Кол-во игроков" ["url_identifier"]=> string(14) "kol_vo_igrokov" ["url_identifier_original"]=> string(14) "kol_vo_igrokov" ["icon"]=> string(0) "" ["range_sign"]=> string(0) "" ["range_interval"]=> string(0) "" ["all_label"]=> string(0) "" } [13]=> array(29) { ["id_criterion_group"]=> string(2) "43" ["id_search"]=> string(1) "1" ["criterion_group_type"]=> string(7) "feature" ["sort_by"]=> string(10) "alphabetic" ["sort_way"]=> string(3) "ASC" ["id_criterion_group_linked"]=> string(2) "34" ["display_type"]=> string(1) "1" ["context_type"]=> string(1) "0" ["is_multicriteria"]=> string(1) "1" ["filter_option"]=> string(1) "0" ["is_combined"]=> string(1) "0" ["range"]=> string(1) "0" ["range_nb"]=> string(5) "15.00" ["show_all_depth"]=> string(1) "0" ["only_children"]=> string(1) "0" ["hidden"]=> string(1) "0" ["max_display"]=> string(1) "0" ["css_classes"]=> string(18) "col-xs-12 col-sm-3" ["overflow_height"]=> string(1) "0" ["position"]=> string(2) "27" ["visible"]=> string(1) "1" ["id_lang"]=> string(1) "1" ["name"]=> string(15) "Тип игры" ["url_identifier"]=> string(8) "tip_igry" ["url_identifier_original"]=> string(8) "tip_igry" ["icon"]=> string(0) "" ["range_sign"]=> string(0) "" ["range_interval"]=> string(0) "" ["all_label"]=> string(0) "" } [14]=> array(29) { ["id_criterion_group"]=> string(2) "46" ["id_search"]=> string(1) "1" ["criterion_group_type"]=> string(7) "feature" ["sort_by"]=> string(10) "alphabetic" ["sort_way"]=> string(3) "ASC" ["id_criterion_group_linked"]=> string(2) "38" ["display_type"]=> string(1) "1" ["context_type"]=> string(1) "0" ["is_multicriteria"]=> string(1) "1" ["filter_option"]=> string(1) "0" ["is_combined"]=> string(1) "0" ["range"]=> string(1) "0" ["range_nb"]=> string(5) "15.00" ["show_all_depth"]=> string(1) "0" ["only_children"]=> string(1) "0" ["hidden"]=> string(1) "0" ["max_display"]=> string(1) "0" ["css_classes"]=> string(18) "col-xs-12 col-sm-3" ["overflow_height"]=> string(1) "0" ["position"]=> string(2) "29" ["visible"]=> string(1) "1" ["id_lang"]=> string(1) "1" ["name"]=> string(6) "Тип" ["url_identifier"]=> string(3) "tip" ["url_identifier_original"]=> string(3) "tip" ["icon"]=> string(0) "" ["range_sign"]=> string(0) "" ["range_interval"]=> string(0) "" ["all_label"]=> string(0) "" } [15]=> array(29) { ["id_criterion_group"]=> string(2) "47" ["id_search"]=> string(1) "1" ["criterion_group_type"]=> string(7) "feature" ["sort_by"]=> string(8) "position" ["sort_way"]=> string(3) "ASC" ["id_criterion_group_linked"]=> string(2) "43" ["display_type"]=> string(1) "1" ["context_type"]=> string(1) "0" ["is_multicriteria"]=> string(1) "1" ["filter_option"]=> string(1) "0" ["is_combined"]=> string(1) "0" ["range"]=> string(1) "0" ["range_nb"]=> string(5) "15.00" ["show_all_depth"]=> string(1) "0" ["only_children"]=> string(1) "0" ["hidden"]=> string(1) "0" ["max_display"]=> string(1) "0" ["css_classes"]=> string(18) "col-xs-12 col-sm-3" ["overflow_height"]=> string(1) "0" ["position"]=> string(2) "31" ["visible"]=> string(1) "1" ["id_lang"]=> string(1) "1" ["name"]=> string(16) "Материал" ["url_identifier"]=> string(8) "material" ["url_identifier_original"]=> string(8) "material" ["icon"]=> string(0) "" ["range_sign"]=> string(0) "" ["range_interval"]=> string(0) "" ["all_label"]=> string(0) "" } [16]=> array(29) { ["id_criterion_group"]=> string(2) "48" ["id_search"]=> string(1) "1" ["criterion_group_type"]=> string(7) "feature" ["sort_by"]=> string(7) "numeric" ["sort_way"]=> string(3) "ASC" ["id_criterion_group_linked"]=> string(2) "40" ["display_type"]=> string(1) "5" ["context_type"]=> string(1) "0" ["is_multicriteria"]=> string(1) "0" ["filter_option"]=> string(1) "0" ["is_combined"]=> string(1) "0" ["range"]=> string(1) "0" ["range_nb"]=> string(5) "15.00" ["show_all_depth"]=> string(1) "0" ["only_children"]=> string(1) "0" ["hidden"]=> string(1) "0" ["max_display"]=> string(1) "0" ["css_classes"]=> string(18) "col-xs-12 col-sm-3" ["overflow_height"]=> string(1) "0" ["position"]=> string(2) "33" ["visible"]=> string(1) "1" ["id_lang"]=> string(1) "1" ["name"]=> string(26) "Кол-во деталей" ["url_identifier"]=> string(14) "kol_vo_detalej" ["url_identifier_original"]=> string(14) "kol_vo_detalej" ["icon"]=> string(0) "" ["range_sign"]=> string(0) "" ["range_interval"]=> string(0) "" ["all_label"]=> string(0) "" } [17]=> array(29) { ["id_criterion_group"]=> string(2) "51" ["id_search"]=> string(1) "1" ["criterion_group_type"]=> string(7) "feature" ["sort_by"]=> string(10) "alphabetic" ["sort_way"]=> string(3) "ASC" ["id_criterion_group_linked"]=> string(2) "53" ["display_type"]=> string(1) "1" ["context_type"]=> string(1) "0" ["is_multicriteria"]=> string(1) "1" ["filter_option"]=> string(1) "0" ["is_combined"]=> string(1) "0" ["range"]=> string(1) "0" ["range_nb"]=> string(5) "15.00" ["show_all_depth"]=> string(1) "0" ["only_children"]=> string(1) "0" ["hidden"]=> string(1) "0" ["max_display"]=> string(1) "0" ["css_classes"]=> string(18) "col-xs-12 col-sm-3" ["overflow_height"]=> string(1) "0" ["position"]=> string(2) "35" ["visible"]=> string(1) "1" ["id_lang"]=> string(1) "1" ["name"]=> string(27) "Торговая марка" ["url_identifier"]=> string(15) "torgovaya_marka" ["url_identifier_original"]=> string(15) "torgovaya_marka" ["icon"]=> string(0) "" ["range_sign"]=> string(0) "" ["range_interval"]=> string(0) "" ["all_label"]=> string(0) "" } [18]=> array(29) { ["id_criterion_group"]=> string(2) "63" ["id_search"]=> string(1) "1" ["criterion_group_type"]=> string(7) "feature" ["sort_by"]=> string(8) "position" ["sort_way"]=> string(3) "ASC" ["id_criterion_group_linked"]=> string(2) "63" ["display_type"]=> string(1) "1" ["context_type"]=> string(1) "0" ["is_multicriteria"]=> string(1) "0" ["filter_option"]=> string(1) "0" ["is_combined"]=> string(1) "0" ["range"]=> string(1) "0" ["range_nb"]=> string(5) "15.00" ["show_all_depth"]=> string(1) "0" ["only_children"]=> string(1) "0" ["hidden"]=> string(1) "0" ["max_display"]=> string(1) "0" ["css_classes"]=> string(18) "col-xs-12 col-sm-3" ["overflow_height"]=> string(1) "0" ["position"]=> string(2) "37" ["visible"]=> string(1) "1" ["id_lang"]=> string(1) "1" ["name"]=> string(37) "Завод производитель" ["url_identifier"]=> string(18) "zavod_proizvoditel" ["url_identifier_original"]=> string(18) "zavod_proizvoditel" ["icon"]=> string(0) "" ["range_sign"]=> string(0) "" ["range_interval"]=> string(0) "" ["all_label"]=> string(0) "" } [19]=> array(29) { ["id_criterion_group"]=> string(2) "66" ["id_search"]=> string(1) "1" ["criterion_group_type"]=> string(7) "feature" ["sort_by"]=> string(8) "position" ["sort_way"]=> string(3) "ASC" ["id_criterion_group_linked"]=> string(2) "59" ["display_type"]=> string(1) "1" ["context_type"]=> string(1) "0" ["is_multicriteria"]=> string(1) "0" ["filter_option"]=> string(1) "0" ["is_combined"]=> string(1) "0" ["range"]=> string(1) "0" ["range_nb"]=> string(5) "15.00" ["show_all_depth"]=> string(1) "0" ["only_children"]=> string(1) "0" ["hidden"]=> string(1) "0" ["max_display"]=> string(1) "0" ["css_classes"]=> string(18) "col-xs-12 col-sm-3" ["overflow_height"]=> string(1) "0" ["position"]=> string(2) "39" ["visible"]=> string(1) "1" ["id_lang"]=> string(1) "1" ["name"]=> string(39) "Страна производитель" ["url_identifier"]=> string(19) "strana_proizvoditel" ["url_identifier_original"]=> string(19) "strana_proizvoditel" ["icon"]=> string(0) "" ["range_sign"]=> string(0) "" ["range_interval"]=> string(0) "" ["all_label"]=> string(0) "" } [20]=> array(29) { ["id_criterion_group"]=> string(2) "52" ["id_search"]=> string(1) "1" ["criterion_group_type"]=> string(7) "feature" ["sort_by"]=> string(10) "alphabetic" ["sort_way"]=> string(3) "ASC" ["id_criterion_group_linked"]=> string(2) "61" ["display_type"]=> string(1) "4" ["context_type"]=> string(1) "0" ["is_multicriteria"]=> string(1) "1" ["filter_option"]=> string(1) "0" ["is_combined"]=> string(1) "0" ["range"]=> string(1) "0" ["range_nb"]=> string(5) "15.00" ["show_all_depth"]=> string(1) "0" ["only_children"]=> string(1) "0" ["hidden"]=> string(1) "0" ["max_display"]=> string(1) "0" ["css_classes"]=> string(18) "col-xs-12 col-sm-3" ["overflow_height"]=> string(1) "0" ["position"]=> string(2) "41" ["visible"]=> string(1) "1" ["id_lang"]=> string(1) "1" ["name"]=> string(33) "Сложность рисунка" ["url_identifier"]=> string(17) "slozhnost_risunka" ["url_identifier_original"]=> string(17) "slozhnost_risunka" ["icon"]=> string(0) "" ["range_sign"]=> string(0) "" ["range_interval"]=> string(0) "" ["all_label"]=> string(0) "" } [21]=> array(29) { ["id_criterion_group"]=> string(2) "65" ["id_search"]=> string(1) "1" ["criterion_group_type"]=> string(7) "feature" ["sort_by"]=> string(8) "position" ["sort_way"]=> string(3) "ASC" ["id_criterion_group_linked"]=> string(2) "75" ["display_type"]=> string(1) "1" ["context_type"]=> string(1) "0" ["is_multicriteria"]=> string(1) "0" ["filter_option"]=> string(1) "0" ["is_combined"]=> string(1) "0" ["range"]=> string(1) "0" ["range_nb"]=> string(5) "15.00" ["show_all_depth"]=> string(1) "0" ["only_children"]=> string(1) "0" ["hidden"]=> string(1) "0" ["max_display"]=> string(1) "0" ["css_classes"]=> string(18) "col-xs-12 col-sm-3" ["overflow_height"]=> string(1) "0" ["position"]=> string(2) "43" ["visible"]=> string(1) "1" ["id_lang"]=> string(1) "1" ["name"]=> string(73) "Расстояние поездки на аккумуляторах, км" ["url_identifier"]=> string(41) "rasstoyanie_poezdki_na_akkumulyatorakh_km" ["url_identifier_original"]=> string(41) "rasstoyanie_poezdki_na_akkumulyatorakh_km" ["icon"]=> string(0) "" ["range_sign"]=> string(0) "" ["range_interval"]=> string(0) "" ["all_label"]=> string(0) "" } [22]=> array(29) { ["id_criterion_group"]=> string(2) "54" ["id_search"]=> string(1) "1" ["criterion_group_type"]=> string(7) "feature" ["sort_by"]=> string(10) "alphabetic" ["sort_way"]=> string(3) "ASC" ["id_criterion_group_linked"]=> string(2) "58" ["display_type"]=> string(1) "1" ["context_type"]=> string(1) "0" ["is_multicriteria"]=> string(1) "1" ["filter_option"]=> string(1) "0" ["is_combined"]=> string(1) "0" ["range"]=> string(1) "0" ["range_nb"]=> string(5) "15.00" ["show_all_depth"]=> string(1) "0" ["only_children"]=> string(1) "0" ["hidden"]=> string(1) "0" ["max_display"]=> string(1) "0" ["css_classes"]=> string(18) "col-xs-12 col-sm-3" ["overflow_height"]=> string(1) "0" ["position"]=> string(2) "45" ["visible"]=> string(1) "1" ["id_lang"]=> string(1) "1" ["name"]=> string(26) "Производитель" ["url_identifier"]=> string(14) "proizvoditel_2" ["url_identifier_original"]=> string(12) "proizvoditel" ["icon"]=> string(0) "" ["range_sign"]=> string(0) "" ["range_interval"]=> string(0) "" ["all_label"]=> string(0) "" } [23]=> array(29) { ["id_criterion_group"]=> string(2) "62" ["id_search"]=> string(1) "1" ["criterion_group_type"]=> string(7) "feature" ["sort_by"]=> string(8) "position" ["sort_way"]=> string(3) "ASC" ["id_criterion_group_linked"]=> string(2) "70" ["display_type"]=> string(1) "1" ["context_type"]=> string(1) "0" ["is_multicriteria"]=> string(1) "0" ["filter_option"]=> string(1) "0" ["is_combined"]=> string(1) "0" ["range"]=> string(1) "0" ["range_nb"]=> string(5) "15.00" ["show_all_depth"]=> string(1) "0" ["only_children"]=> string(1) "0" ["hidden"]=> string(1) "0" ["max_display"]=> string(1) "0" ["css_classes"]=> string(18) "col-xs-12 col-sm-3" ["overflow_height"]=> string(1) "0" ["position"]=> string(2) "47" ["visible"]=> string(1) "1" ["id_lang"]=> string(1) "1" ["name"]=> string(40) "Гарантийный срок, мес." ["url_identifier"]=> string(20) "garantijnyj_srok_mes" ["url_identifier_original"]=> string(20) "garantijnyj_srok_mes" ["icon"]=> string(0) "" ["range_sign"]=> string(0) "" ["range_interval"]=> string(0) "" ["all_label"]=> string(0) "" } [24]=> array(29) { ["id_criterion_group"]=> string(2) "55" ["id_search"]=> string(1) "1" ["criterion_group_type"]=> string(7) "feature" ["sort_by"]=> string(8) "position" ["sort_way"]=> string(3) "ASC" ["id_criterion_group_linked"]=> string(2) "62" ["display_type"]=> string(1) "4" ["context_type"]=> string(1) "0" ["is_multicriteria"]=> string(1) "0" ["filter_option"]=> string(1) "0" ["is_combined"]=> string(1) "0" ["range"]=> string(1) "0" ["range_nb"]=> string(5) "15.00" ["show_all_depth"]=> string(1) "0" ["only_children"]=> string(1) "0" ["hidden"]=> string(1) "0" ["max_display"]=> string(1) "0" ["css_classes"]=> string(18) "col-xs-12 col-sm-3" ["overflow_height"]=> string(1) "0" ["position"]=> string(2) "49" ["visible"]=> string(1) "1" ["id_lang"]=> string(1) "1" ["name"]=> string(20) "Ориентация" ["url_identifier"]=> string(11) "orientaciya" ["url_identifier_original"]=> string(11) "orientaciya" ["icon"]=> string(0) "" ["range_sign"]=> string(0) "" ["range_interval"]=> string(0) "" ["all_label"]=> string(0) "" } [25]=> array(29) { ["id_criterion_group"]=> string(2) "59" ["id_search"]=> string(1) "1" ["criterion_group_type"]=> string(7) "feature" ["sort_by"]=> string(8) "position" ["sort_way"]=> string(3) "ASC" ["id_criterion_group_linked"]=> string(2) "60" ["display_type"]=> string(1) "1" ["context_type"]=> string(1) "0" ["is_multicriteria"]=> string(1) "1" ["filter_option"]=> string(1) "0" ["is_combined"]=> string(1) "0" ["range"]=> string(1) "0" ["range_nb"]=> string(5) "15.00" ["show_all_depth"]=> string(1) "0" ["only_children"]=> string(1) "0" ["hidden"]=> string(1) "0" ["max_display"]=> string(1) "0" ["css_classes"]=> string(18) "col-xs-12 col-sm-3" ["overflow_height"]=> string(1) "0" ["position"]=> string(2) "51" ["visible"]=> string(1) "1" ["id_lang"]=> string(1) "1" ["name"]=> string(29) "Способ упаковки" ["url_identifier"]=> string(15) "sposob_upakovki" ["url_identifier_original"]=> string(15) "sposob_upakovki" ["icon"]=> string(0) "" ["range_sign"]=> string(0) "" ["range_interval"]=> string(0) "" ["all_label"]=> string(0) "" } [26]=> array(29) { ["id_criterion_group"]=> string(2) "56" ["id_search"]=> string(1) "1" ["criterion_group_type"]=> string(7) "feature" ["sort_by"]=> string(7) "numeric" ["sort_way"]=> string(3) "ASC" ["id_criterion_group_linked"]=> string(2) "55" ["display_type"]=> string(1) "8" ["context_type"]=> string(1) "0" ["is_multicriteria"]=> string(1) "0" ["filter_option"]=> string(1) "0" ["is_combined"]=> string(1) "0" ["range"]=> string(1) "0" ["range_nb"]=> string(4) "1.00" ["show_all_depth"]=> string(1) "0" ["only_children"]=> string(1) "0" ["hidden"]=> string(1) "0" ["max_display"]=> string(1) "0" ["css_classes"]=> string(18) "col-xs-12 col-sm-3" ["overflow_height"]=> string(1) "0" ["position"]=> string(2) "53" ["visible"]=> string(1) "1" ["id_lang"]=> string(1) "1" ["name"]=> string(33) "Количество красок" ["url_identifier"]=> string(18) "kolichestvo_krasok" ["url_identifier_original"]=> string(18) "kolichestvo_krasok" ["icon"]=> string(0) "" ["range_sign"]=> string(0) "" ["range_interval"]=> string(0) "" ["all_label"]=> string(0) "" } [27]=> array(29) { ["id_criterion_group"]=> string(2) "58" ["id_search"]=> string(1) "1" ["criterion_group_type"]=> string(7) "feature" ["sort_by"]=> string(7) "numeric" ["sort_way"]=> string(3) "ASC" ["id_criterion_group_linked"]=> string(2) "45" ["display_type"]=> string(1) "8" ["context_type"]=> string(1) "0" ["is_multicriteria"]=> string(1) "0" ["filter_option"]=> string(1) "0" ["is_combined"]=> string(1) "0" ["range"]=> string(1) "0" ["range_nb"]=> string(4) "1.00" ["show_all_depth"]=> string(1) "0" ["only_children"]=> string(1) "0" ["hidden"]=> string(1) "0" ["max_display"]=> string(1) "0" ["css_classes"]=> string(18) "col-xs-12 col-sm-3" ["overflow_height"]=> string(1) "0" ["position"]=> string(2) "55" ["visible"]=> string(1) "1" ["id_lang"]=> string(1) "1" ["name"]=> string(14) "Возраст" ["url_identifier"]=> string(9) "vozrast_2" ["url_identifier_original"]=> string(7) "vozrast" ["icon"]=> string(0) "" ["range_sign"]=> string(0) "" ["range_interval"]=> string(0) "" ["all_label"]=> string(0) "" } [28]=> array(29) { ["id_criterion_group"]=> string(1) "6" ["id_search"]=> string(1) "1" ["criterion_group_type"]=> string(5) "price" ["sort_by"]=> string(8) "position" ["sort_way"]=> string(3) "ASC" ["id_criterion_group_linked"]=> string(1) "0" ["display_type"]=> string(1) "5" ["context_type"]=> string(1) "2" ["is_multicriteria"]=> string(1) "0" ["filter_option"]=> string(1) "0" ["is_combined"]=> string(1) "0" ["range"]=> string(1) "0" ["range_nb"]=> string(4) "1.00" ["show_all_depth"]=> string(1) "0" ["only_children"]=> string(1) "0" ["hidden"]=> string(1) "0" ["max_display"]=> string(1) "0" ["css_classes"]=> string(18) "col-xs-12 col-sm-3" ["overflow_height"]=> string(1) "0" ["position"]=> string(2) "57" ["visible"]=> string(1) "1" ["id_lang"]=> string(1) "1" ["name"]=> string(8) "Цена" ["url_identifier"]=> string(4) "cena" ["url_identifier_original"]=> string(4) "cena" ["icon"]=> string(0) "" ["range_sign"]=> string(0) "" ["range_interval"]=> string(0) "" ["all_label"]=> string(0) "" } [29]=> array(29) { ["id_criterion_group"]=> string(2) "25" ["id_search"]=> string(1) "1" ["criterion_group_type"]=> string(8) "category" ["sort_by"]=> string(8) "position" ["sort_way"]=> string(3) "ASC" ["id_criterion_group_linked"]=> string(1) "0" ["display_type"]=> string(1) "1" ["context_type"]=> string(1) "0" ["is_multicriteria"]=> string(1) "0" ["filter_option"]=> string(1) "0" ["is_combined"]=> string(1) "0" ["range"]=> string(1) "0" ["range_nb"]=> string(5) "15.00" ["show_all_depth"]=> string(1) "0" ["only_children"]=> string(1) "0" ["hidden"]=> string(1) "0" ["max_display"]=> string(1) "0" ["css_classes"]=> string(18) "col-xs-12 col-sm-3" ["overflow_height"]=> string(1) "0" ["position"]=> string(3) "100" ["visible"]=> string(1) "0" ["id_lang"]=> string(1) "1" ["name"]=> string(18) "Категории" ["url_identifier"]=> string(9) "kategorii" ["url_identifier_original"]=> string(9) "kategorii" ["icon"]=> string(0) "" ["range_sign"]=> string(0) "" ["range_interval"]=> string(0) "" ["all_label"]=> string(0) "" } [30]=> array(29) { ["id_criterion_group"]=> string(1) "2" ["id_search"]=> string(1) "1" ["criterion_group_type"]=> string(8) "supplier" ["sort_by"]=> string(8) "position" ["sort_way"]=> string(3) "ASC" ["id_criterion_group_linked"]=> string(1) "0" ["display_type"]=> string(1) "1" ["context_type"]=> string(1) "2" ["is_multicriteria"]=> string(1) "0" ["filter_option"]=> string(1) "0" ["is_combined"]=> string(1) "0" ["range"]=> string(1) "0" ["range_nb"]=> string(5) "15.00" ["show_all_depth"]=> string(1) "0" ["only_children"]=> string(1) "0" ["hidden"]=> string(1) "0" ["max_display"]=> string(1) "0" ["css_classes"]=> string(18) "col-xs-12 col-sm-3" ["overflow_height"]=> string(1) "0" ["position"]=> string(3) "100" ["visible"]=> string(1) "0" ["id_lang"]=> string(1) "1" ["name"]=> string(18) "Поставщик" ["url_identifier"]=> string(11) "postavshhik" ["url_identifier_original"]=> string(11) "postavshhik" ["icon"]=> string(0) "" ["range_sign"]=> string(0) "" ["range_interval"]=> string(0) "" ["all_label"]=> string(0) "" } [31]=> array(29) { ["id_criterion_group"]=> string(1) "1" ["id_search"]=> string(1) "1" ["criterion_group_type"]=> string(12) "manufacturer" ["sort_by"]=> string(8) "position" ["sort_way"]=> string(3) "ASC" ["id_criterion_group_linked"]=> string(1) "0" ["display_type"]=> string(1) "1" ["context_type"]=> string(1) "2" ["is_multicriteria"]=> string(1) "0" ["filter_option"]=> string(1) "0" ["is_combined"]=> string(1) "0" ["range"]=> string(1) "0" ["range_nb"]=> string(5) "15.00" ["show_all_depth"]=> string(1) "0" ["only_children"]=> string(1) "0" ["hidden"]=> string(1) "0" ["max_display"]=> string(1) "0" ["css_classes"]=> string(18) "col-xs-12 col-sm-3" ["overflow_height"]=> string(1) "0" ["position"]=> string(3) "100" ["visible"]=> string(1) "0" ["id_lang"]=> string(1) "1" ["name"]=> string(26) "Производитель" ["url_identifier"]=> string(12) "proizvoditel" ["url_identifier_original"]=> string(12) "proizvoditel" ["icon"]=> string(0) "" ["range_sign"]=> string(0) "" ["range_interval"]=> string(0) "" ["all_label"]=> string(0) "" } }

SELECT acg.*, acgl.* FROM `ps_pm_advancedsearch_criterion_group_1` acg LEFT JOIN `ps_pm_advancedsearch_criterion_group_1_lang` acgl ON (acg.`id_criterion_group` = acgl.`id_criterion_group` AND acgl.`id_lang` = 1 ) WHERE acg.`id_criterion_group` IN (25) ORDER BY `position`
array(1) { [0]=> array(29) { ["id_criterion_group"]=> string(2) "25" ["id_search"]=> string(1) "1" ["criterion_group_type"]=> string(8) "category" ["sort_by"]=> string(8) "position" ["sort_way"]=> string(3) "ASC" ["id_criterion_group_linked"]=> string(1) "0" ["display_type"]=> string(1) "1" ["context_type"]=> string(1) "0" ["is_multicriteria"]=> string(1) "0" ["filter_option"]=> string(1) "0" ["is_combined"]=> string(1) "0" ["range"]=> string(1) "0" ["range_nb"]=> string(5) "15.00" ["show_all_depth"]=> string(1) "0" ["only_children"]=> string(1) "0" ["hidden"]=> string(1) "0" ["max_display"]=> string(1) "0" ["css_classes"]=> string(18) "col-xs-12 col-sm-3" ["overflow_height"]=> string(1) "0" ["position"]=> string(3) "100" ["visible"]=> string(1) "0" ["id_lang"]=> string(1) "1" ["name"]=> string(18) "Категории" ["url_identifier"]=> string(9) "kategorii" ["url_identifier_original"]=> string(9) "kategorii" ["icon"]=> string(0) "" ["range_sign"]=> string(0) "" ["range_interval"]=> string(0) "" ["all_label"]=> string(0) "" } }

SELECT aclist.`id_criterion_parent`, aclist.`id_criterion` FROM `ps_pm_advancedsearch_criterion_1` ac JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`) WHERE ac.`is_custom`=1
array(0) { }

SELECT ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc25.`id_cache_product`)) AS nb_product FROM `ps_pm_advancedsearch_criterion_1` ac JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`) JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`) LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`) LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`) JOIN `ps_product_shop` ps ON ( ps.id_shop IN (1) AND ps.`id_product` = acp.`id_product` ) JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc25 ON ( acp.`id_cache_product` = acpc25.`id_cache_product` AND acpc25.`id_criterion` IN (50460)) LEFT JOIN `ps_stock_available` sa1 ON ( sa1.`id_product` = acp.`id_product` AND sa1.`id_product_attribute`=0 AND sa1.id_shop = 1 AND sa1.id_shop_group = 0 ) LEFT JOIN `ps_product_attribute` pa35 ON (pa35.`id_product` = acp.`id_product` ) LEFT JOIN `ps_stock_available` sa2 ON ( sa2.`id_product` = acp.`id_product` AND sa2.`id_product_attribute` = IFNULL(pa35.`id_product_attribute`, 0) AND sa2.id_shop = 1 AND sa2.id_shop_group = 0 ) WHERE ps.`active` = 1 AND ps.`visibility` IN ("both", "search") AND (IF (sa1.`quantity` > 0, 1, IF (sa1.`out_of_stock` = 2, 1 = 1, sa1.`out_of_stock` = 1)) OR IF (sa2.`quantity` > 0,1, IF (sa2.`out_of_stock` = 2, 1 = 1, sa2.`out_of_stock` = 1))) AND ac.`id_criterion_group` = 35 AND ac.`visible` = 1 GROUP BY ac.`id_criterion` ORDER BY `value` ASC
array(4) { [0]=> array(14) { ["id_criterion"]=> string(2) "19" ["id_criterion_group"]=> string(2) "35" ["position"]=> string(1) "0" ["color"]=> string(0) "" ["level_depth"]=> string(1) "3" ["id_parent"]=> string(4) "2307" ["visible"]=> string(1) "1" ["is_custom"]=> string(1) "0" ["id_criterion_linked"]=> string(4) "2358" ["id_lang"]=> string(1) "1" ["icon"]=> string(0) "" ["value"]=> string(24) "Аккумуляторы" ["decimal_value"]=> string(8) "0.000000" ["nb_product"]=> string(1) "1" } [1]=> array(14) { ["id_criterion"]=> string(1) "2" ["id_criterion_group"]=> string(2) "35" ["position"]=> string(1) "0" ["color"]=> string(0) "" ["level_depth"]=> string(1) "1" ["id_parent"]=> string(1) "1" ["visible"]=> string(1) "1" ["is_custom"]=> string(1) "0" ["id_criterion_linked"]=> string(1) "2" ["id_lang"]=> string(1) "1" ["icon"]=> string(0) "" ["value"]=> string(14) "Главная" ["decimal_value"]=> string(8) "0.000000" ["nb_product"]=> string(1) "1" } [2]=> array(14) { ["id_criterion"]=> string(2) "15" ["id_criterion_group"]=> string(2) "35" ["position"]=> string(1) "0" ["color"]=> string(0) "" ["level_depth"]=> string(1) "2" ["id_parent"]=> string(1) "2" ["visible"]=> string(1) "1" ["is_custom"]=> string(1) "0" ["id_criterion_linked"]=> string(4) "2307" ["id_lang"]=> string(1) "1" ["icon"]=> string(0) "" ["value"]=> string(20) "Канцтовары" ["decimal_value"]=> string(8) "0.000000" ["nb_product"]=> string(1) "1" } [3]=> array(14) { ["id_criterion"]=> string(1) "1" ["id_criterion_group"]=> string(2) "35" ["position"]=> string(1) "0" ["color"]=> string(0) "" ["level_depth"]=> string(1) "0" ["id_parent"]=> string(1) "0" ["visible"]=> string(1) "1" ["is_custom"]=> string(1) "0" ["id_criterion_linked"]=> string(1) "1" ["id_lang"]=> string(1) "1" ["icon"]=> string(0) "" ["value"]=> string(12) "Корень" ["decimal_value"]=> string(8) "0.000000" ["nb_product"]=> string(1) "1" } }

SELECT ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc25.`id_cache_product`)) AS nb_product FROM `ps_pm_advancedsearch_criterion_1` ac JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`) JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`) LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`) LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`) JOIN `ps_product_shop` ps ON ( ps.id_shop IN (1) AND ps.`id_product` = acp.`id_product` ) JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc25 ON ( acp.`id_cache_product` = acpc25.`id_cache_product` AND acpc25.`id_criterion` IN (50460)) LEFT JOIN `ps_stock_available` sa1 ON ( sa1.`id_product` = acp.`id_product` AND sa1.`id_product_attribute`=0 AND sa1.id_shop = 1 AND sa1.id_shop_group = 0 ) LEFT JOIN `ps_product_attribute` pa64 ON (pa64.`id_product` = acp.`id_product` ) LEFT JOIN `ps_stock_available` sa2 ON ( sa2.`id_product` = acp.`id_product` AND sa2.`id_product_attribute` = IFNULL(pa64.`id_product_attribute`, 0) AND sa2.id_shop = 1 AND sa2.id_shop_group = 0 ) WHERE ps.`active` = 1 AND ps.`visibility` IN ("both", "search") AND (IF (sa1.`quantity` > 0, 1, IF (sa1.`out_of_stock` = 2, 1 = 1, sa1.`out_of_stock` = 1)) OR IF (sa2.`quantity` > 0,1, IF (sa2.`out_of_stock` = 2, 1 = 1, sa2.`out_of_stock` = 1))) AND ac.`id_criterion_group` = 64 AND ac.`visible` = 1 GROUP BY ac.`id_criterion` ORDER BY `value` ASC
array(0) { }

SELECT ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc25.`id_cache_product`)) AS nb_product FROM `ps_pm_advancedsearch_criterion_1` ac JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`) JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`) LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`) LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`) JOIN `ps_product_shop` ps ON ( ps.id_shop IN (1) AND ps.`id_product` = acp.`id_product` ) JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc25 ON ( acp.`id_cache_product` = acpc25.`id_cache_product` AND acpc25.`id_criterion` IN (50460)) LEFT JOIN `ps_stock_available` sa1 ON ( sa1.`id_product` = acp.`id_product` AND sa1.`id_product_attribute`=0 AND sa1.id_shop = 1 AND sa1.id_shop_group = 0 ) LEFT JOIN `ps_product_attribute` pa72 ON (pa72.`id_product` = acp.`id_product` ) LEFT JOIN `ps_stock_available` sa2 ON ( sa2.`id_product` = acp.`id_product` AND sa2.`id_product_attribute` = IFNULL(pa72.`id_product_attribute`, 0) AND sa2.id_shop = 1 AND sa2.id_shop_group = 0 ) WHERE ps.`active` = 1 AND ps.`visibility` IN ("both", "search") AND (IF (sa1.`quantity` > 0, 1, IF (sa1.`out_of_stock` = 2, 1 = 1, sa1.`out_of_stock` = 1)) OR IF (sa2.`quantity` > 0,1, IF (sa2.`out_of_stock` = 2, 1 = 1, sa2.`out_of_stock` = 1))) AND ac.`id_criterion_group` = 72 AND ac.`visible` = 1 GROUP BY ac.`id_criterion` ORDER BY nb_product DESC
array(0) { }

SELECT ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc25.`id_cache_product`)) AS nb_product FROM `ps_pm_advancedsearch_criterion_1` ac JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`) JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`) LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`) LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`) JOIN `ps_product_shop` ps ON ( ps.id_shop IN (1) AND ps.`id_product` = acp.`id_product` ) JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc25 ON ( acp.`id_cache_product` = acpc25.`id_cache_product` AND acpc25.`id_criterion` IN (50460)) LEFT JOIN `ps_stock_available` sa1 ON ( sa1.`id_product` = acp.`id_product` AND sa1.`id_product_attribute`=0 AND sa1.id_shop = 1 AND sa1.id_shop_group = 0 ) LEFT JOIN `ps_product_attribute` pa5 ON (pa5.`id_product` = acp.`id_product` ) LEFT JOIN `ps_stock_available` sa2 ON ( sa2.`id_product` = acp.`id_product` AND sa2.`id_product_attribute` = IFNULL(pa5.`id_product_attribute`, 0) AND sa2.id_shop = 1 AND sa2.id_shop_group = 0 ) WHERE ps.`active` = 1 AND ps.`visibility` IN ("both", "search") AND (IF (sa1.`quantity` > 0, 1, IF (sa1.`out_of_stock` = 2, 1 = 1, sa1.`out_of_stock` = 1)) OR IF (sa2.`quantity` > 0,1, IF (sa2.`out_of_stock` = 2, 1 = 1, sa2.`out_of_stock` = 1))) AND ac.`id_criterion_group` = 5 AND ac.`visible` = 1 GROUP BY ac.`id_criterion` ORDER BY `value` ASC
array(0) { }

SELECT ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc25.`id_cache_product`)) AS nb_product FROM `ps_pm_advancedsearch_criterion_1` ac JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`) JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`) LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`) LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`) JOIN `ps_product_shop` ps ON ( ps.id_shop IN (1) AND ps.`id_product` = acp.`id_product` ) JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc25 ON ( acp.`id_cache_product` = acpc25.`id_cache_product` AND acpc25.`id_criterion` IN (50460)) LEFT JOIN `ps_stock_available` sa1 ON ( sa1.`id_product` = acp.`id_product` AND sa1.`id_product_attribute`=0 AND sa1.id_shop = 1 AND sa1.id_shop_group = 0 ) LEFT JOIN `ps_product_attribute` pa69 ON (pa69.`id_product` = acp.`id_product` ) LEFT JOIN `ps_stock_available` sa2 ON ( sa2.`id_product` = acp.`id_product` AND sa2.`id_product_attribute` = IFNULL(pa69.`id_product_attribute`, 0) AND sa2.id_shop = 1 AND sa2.id_shop_group = 0 ) WHERE ps.`active` = 1 AND ps.`visibility` IN ("both", "search") AND (IF (sa1.`quantity` > 0, 1, IF (sa1.`out_of_stock` = 2, 1 = 1, sa1.`out_of_stock` = 1)) OR IF (sa2.`quantity` > 0,1, IF (sa2.`out_of_stock` = 2, 1 = 1, sa2.`out_of_stock` = 1))) AND ac.`id_criterion_group` = 69 AND ac.`visible` = 1 GROUP BY ac.`id_criterion` ORDER BY `value` ASC
array(0) { }

SELECT ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc25.`id_cache_product`)) AS nb_product FROM `ps_pm_advancedsearch_criterion_1` ac JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`) JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`) LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`) LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`) JOIN `ps_product_shop` ps ON ( ps.id_shop IN (1) AND ps.`id_product` = acp.`id_product` ) JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc25 ON ( acp.`id_cache_product` = acpc25.`id_cache_product` AND acpc25.`id_criterion` IN (50460)) LEFT JOIN `ps_stock_available` sa1 ON ( sa1.`id_product` = acp.`id_product` AND sa1.`id_product_attribute`=0 AND sa1.id_shop = 1 AND sa1.id_shop_group = 0 ) LEFT JOIN `ps_product_attribute` pa31 ON (pa31.`id_product` = acp.`id_product` ) LEFT JOIN `ps_stock_available` sa2 ON ( sa2.`id_product` = acp.`id_product` AND sa2.`id_product_attribute` = IFNULL(pa31.`id_product_attribute`, 0) AND sa2.id_shop = 1 AND sa2.id_shop_group = 0 ) WHERE ps.`active` = 1 AND ps.`visibility` IN ("both", "search") AND (IF (sa1.`quantity` > 0, 1, IF (sa1.`out_of_stock` = 2, 1 = 1, sa1.`out_of_stock` = 1)) OR IF (sa2.`quantity` > 0,1, IF (sa2.`out_of_stock` = 2, 1 = 1, sa2.`out_of_stock` = 1))) AND ac.`id_criterion_group` = 31 AND ac.`visible` = 1 GROUP BY ac.`id_criterion` ORDER BY nb_product DESC
array(0) { }

SELECT ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc25.`id_cache_product`)) AS nb_product FROM `ps_pm_advancedsearch_criterion_1` ac JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`) JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`) LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`) LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`) JOIN `ps_product_shop` ps ON ( ps.id_shop IN (1) AND ps.`id_product` = acp.`id_product` ) JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc25 ON ( acp.`id_cache_product` = acpc25.`id_cache_product` AND acpc25.`id_criterion` IN (50460)) LEFT JOIN `ps_stock_available` sa1 ON ( sa1.`id_product` = acp.`id_product` AND sa1.`id_product_attribute`=0 AND sa1.id_shop = 1 AND sa1.id_shop_group = 0 ) LEFT JOIN `ps_product_attribute` pa37 ON (pa37.`id_product` = acp.`id_product` ) LEFT JOIN `ps_stock_available` sa2 ON ( sa2.`id_product` = acp.`id_product` AND sa2.`id_product_attribute` = IFNULL(pa37.`id_product_attribute`, 0) AND sa2.id_shop = 1 AND sa2.id_shop_group = 0 ) WHERE ps.`active` = 1 AND ps.`visibility` IN ("both", "search") AND (IF (sa1.`quantity` > 0, 1, IF (sa1.`out_of_stock` = 2, 1 = 1, sa1.`out_of_stock` = 1)) OR IF (sa2.`quantity` > 0,1, IF (sa2.`out_of_stock` = 2, 1 = 1, sa2.`out_of_stock` = 1))) AND ac.`id_criterion_group` = 37 AND ac.`visible` = 1 GROUP BY ac.`id_criterion` ORDER BY nb_product DESC
array(0) { }

SELECT ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc25.`id_cache_product`)) AS nb_product FROM `ps_pm_advancedsearch_criterion_1` ac JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`) JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`) LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`) LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`) JOIN `ps_product_shop` ps ON ( ps.id_shop IN (1) AND ps.`id_product` = acp.`id_product` ) JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc25 ON ( acp.`id_cache_product` = acpc25.`id_cache_product` AND acpc25.`id_criterion` IN (50460)) LEFT JOIN `ps_stock_available` sa1 ON ( sa1.`id_product` = acp.`id_product` AND sa1.`id_product_attribute`=0 AND sa1.id_shop = 1 AND sa1.id_shop_group = 0 ) LEFT JOIN `ps_product_attribute` pa27 ON (pa27.`id_product` = acp.`id_product` ) LEFT JOIN `ps_stock_available` sa2 ON ( sa2.`id_product` = acp.`id_product` AND sa2.`id_product_attribute` = IFNULL(pa27.`id_product_attribute`, 0) AND sa2.id_shop = 1 AND sa2.id_shop_group = 0 ) WHERE ps.`active` = 1 AND ps.`visibility` IN ("both", "search") AND (IF (sa1.`quantity` > 0, 1, IF (sa1.`out_of_stock` = 2, 1 = 1, sa1.`out_of_stock` = 1)) OR IF (sa2.`quantity` > 0,1, IF (sa2.`out_of_stock` = 2, 1 = 1, sa2.`out_of_stock` = 1))) AND ac.`id_criterion_group` = 27 AND ac.`visible` = 1 GROUP BY ac.`id_criterion` ORDER BY `value` ASC
array(0) { }

SELECT ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc25.`id_cache_product`)) AS nb_product FROM `ps_pm_advancedsearch_criterion_1` ac JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`) JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`) LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`) LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`) JOIN `ps_product_shop` ps ON ( ps.id_shop IN (1) AND ps.`id_product` = acp.`id_product` ) JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc25 ON ( acp.`id_cache_product` = acpc25.`id_cache_product` AND acpc25.`id_criterion` IN (50460)) LEFT JOIN `ps_stock_available` sa1 ON ( sa1.`id_product` = acp.`id_product` AND sa1.`id_product_attribute`=0 AND sa1.id_shop = 1 AND sa1.id_shop_group = 0 ) LEFT JOIN `ps_product_attribute` pa71 ON (pa71.`id_product` = acp.`id_product` ) LEFT JOIN `ps_stock_available` sa2 ON ( sa2.`id_product` = acp.`id_product` AND sa2.`id_product_attribute` = IFNULL(pa71.`id_product_attribute`, 0) AND sa2.id_shop = 1 AND sa2.id_shop_group = 0 ) WHERE ps.`active` = 1 AND ps.`visibility` IN ("both", "search") AND (IF (sa1.`quantity` > 0, 1, IF (sa1.`out_of_stock` = 2, 1 = 1, sa1.`out_of_stock` = 1)) OR IF (sa2.`quantity` > 0,1, IF (sa2.`out_of_stock` = 2, 1 = 1, sa2.`out_of_stock` = 1))) AND ac.`id_criterion_group` = 71 AND ac.`visible` = 1 GROUP BY ac.`id_criterion` ORDER BY `position` ASC
array(0) { }

SELECT ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc25.`id_cache_product`)) AS nb_product FROM `ps_pm_advancedsearch_criterion_1` ac JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`) JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`) LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`) LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`) JOIN `ps_product_shop` ps ON ( ps.id_shop IN (1) AND ps.`id_product` = acp.`id_product` ) JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc25 ON ( acp.`id_cache_product` = acpc25.`id_cache_product` AND acpc25.`id_criterion` IN (50460)) LEFT JOIN `ps_stock_available` sa1 ON ( sa1.`id_product` = acp.`id_product` AND sa1.`id_product_attribute`=0 AND sa1.id_shop = 1 AND sa1.id_shop_group = 0 ) LEFT JOIN `ps_product_attribute` pa41 ON (pa41.`id_product` = acp.`id_product` ) LEFT JOIN `ps_stock_available` sa2 ON ( sa2.`id_product` = acp.`id_product` AND sa2.`id_product_attribute` = IFNULL(pa41.`id_product_attribute`, 0) AND sa2.id_shop = 1 AND sa2.id_shop_group = 0 ) WHERE ps.`active` = 1 AND ps.`visibility` IN ("both", "search") AND (IF (sa1.`quantity` > 0, 1, IF (sa1.`out_of_stock` = 2, 1 = 1, sa1.`out_of_stock` = 1)) OR IF (sa2.`quantity` > 0,1, IF (sa2.`out_of_stock` = 2, 1 = 1, sa2.`out_of_stock` = 1))) AND ac.`id_criterion_group` = 41 AND ac.`visible` = 1 GROUP BY ac.`id_criterion` ORDER BY `position` ASC
array(0) { }

SELECT ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc25.`id_cache_product`)) AS nb_product FROM `ps_pm_advancedsearch_criterion_1` ac JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`) JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`) LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`) LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`) JOIN `ps_product_shop` ps ON ( ps.id_shop IN (1) AND ps.`id_product` = acp.`id_product` ) JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc25 ON ( acp.`id_cache_product` = acpc25.`id_cache_product` AND acpc25.`id_criterion` IN (50460)) LEFT JOIN `ps_stock_available` sa1 ON ( sa1.`id_product` = acp.`id_product` AND sa1.`id_product_attribute`=0 AND sa1.id_shop = 1 AND sa1.id_shop_group = 0 ) LEFT JOIN `ps_product_attribute` pa39 ON (pa39.`id_product` = acp.`id_product` ) LEFT JOIN `ps_stock_available` sa2 ON ( sa2.`id_product` = acp.`id_product` AND sa2.`id_product_attribute` = IFNULL(pa39.`id_product_attribute`, 0) AND sa2.id_shop = 1 AND sa2.id_shop_group = 0 ) WHERE ps.`active` = 1 AND ps.`visibility` IN ("both", "search") AND (IF (sa1.`quantity` > 0, 1, IF (sa1.`out_of_stock` = 2, 1 = 1, sa1.`out_of_stock` = 1)) OR IF (sa2.`quantity` > 0,1, IF (sa2.`out_of_stock` = 2, 1 = 1, sa2.`out_of_stock` = 1))) AND ac.`id_criterion_group` = 39 AND ac.`visible` = 1 GROUP BY ac.`id_criterion` ORDER BY `position` ASC
array(0) { }

SELECT ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc25.`id_cache_product`)) AS nb_product FROM `ps_pm_advancedsearch_criterion_1` ac JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`) JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`) LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`) LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`) JOIN `ps_product_shop` ps ON ( ps.id_shop IN (1) AND ps.`id_product` = acp.`id_product` ) JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc25 ON ( acp.`id_cache_product` = acpc25.`id_cache_product` AND acpc25.`id_criterion` IN (50460)) LEFT JOIN `ps_stock_available` sa1 ON ( sa1.`id_product` = acp.`id_product` AND sa1.`id_product_attribute`=0 AND sa1.id_shop = 1 AND sa1.id_shop_group = 0 ) LEFT JOIN `ps_product_attribute` pa40 ON (pa40.`id_product` = acp.`id_product` ) LEFT JOIN `ps_stock_available` sa2 ON ( sa2.`id_product` = acp.`id_product` AND sa2.`id_product_attribute` = IFNULL(pa40.`id_product_attribute`, 0) AND sa2.id_shop = 1 AND sa2.id_shop_group = 0 ) WHERE ps.`active` = 1 AND ps.`visibility` IN ("both", "search") AND (IF (sa1.`quantity` > 0, 1, IF (sa1.`out_of_stock` = 2, 1 = 1, sa1.`out_of_stock` = 1)) OR IF (sa2.`quantity` > 0,1, IF (sa2.`out_of_stock` = 2, 1 = 1, sa2.`out_of_stock` = 1))) AND ac.`id_criterion_group` = 40 AND ac.`visible` = 1 GROUP BY ac.`id_criterion` ORDER BY `position` ASC
array(0) { }

SELECT ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc25.`id_cache_product`)) AS nb_product FROM `ps_pm_advancedsearch_criterion_1` ac JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`) JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`) LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`) LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`) JOIN `ps_product_shop` ps ON ( ps.id_shop IN (1) AND ps.`id_product` = acp.`id_product` ) JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc25 ON ( acp.`id_cache_product` = acpc25.`id_cache_product` AND acpc25.`id_criterion` IN (50460)) LEFT JOIN `ps_stock_available` sa1 ON ( sa1.`id_product` = acp.`id_product` AND sa1.`id_product_attribute`=0 AND sa1.id_shop = 1 AND sa1.id_shop_group = 0 ) LEFT JOIN `ps_product_attribute` pa38 ON (pa38.`id_product` = acp.`id_product` ) LEFT JOIN `ps_stock_available` sa2 ON ( sa2.`id_product` = acp.`id_product` AND sa2.`id_product_attribute` = IFNULL(pa38.`id_product_attribute`, 0) AND sa2.id_shop = 1 AND sa2.id_shop_group = 0 ) WHERE ps.`active` = 1 AND ps.`visibility` IN ("both", "search") AND (IF (sa1.`quantity` > 0, 1, IF (sa1.`out_of_stock` = 2, 1 = 1, sa1.`out_of_stock` = 1)) OR IF (sa2.`quantity` > 0,1, IF (sa2.`out_of_stock` = 2, 1 = 1, sa2.`out_of_stock` = 1))) AND ac.`id_criterion_group` = 38 AND ac.`visible` = 1 GROUP BY ac.`id_criterion` ORDER BY `value` ASC
array(0) { }

SELECT ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc25.`id_cache_product`)) AS nb_product FROM `ps_pm_advancedsearch_criterion_1` ac JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`) JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`) LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`) LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`) JOIN `ps_product_shop` ps ON ( ps.id_shop IN (1) AND ps.`id_product` = acp.`id_product` ) JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc25 ON ( acp.`id_cache_product` = acpc25.`id_cache_product` AND acpc25.`id_criterion` IN (50460)) LEFT JOIN `ps_stock_available` sa1 ON ( sa1.`id_product` = acp.`id_product` AND sa1.`id_product_attribute`=0 AND sa1.id_shop = 1 AND sa1.id_shop_group = 0 ) LEFT JOIN `ps_product_attribute` pa43 ON (pa43.`id_product` = acp.`id_product` ) LEFT JOIN `ps_stock_available` sa2 ON ( sa2.`id_product` = acp.`id_product` AND sa2.`id_product_attribute` = IFNULL(pa43.`id_product_attribute`, 0) AND sa2.id_shop = 1 AND sa2.id_shop_group = 0 ) WHERE ps.`active` = 1 AND ps.`visibility` IN ("both", "search") AND (IF (sa1.`quantity` > 0, 1, IF (sa1.`out_of_stock` = 2, 1 = 1, sa1.`out_of_stock` = 1)) OR IF (sa2.`quantity` > 0,1, IF (sa2.`out_of_stock` = 2, 1 = 1, sa2.`out_of_stock` = 1))) AND ac.`id_criterion_group` = 43 AND ac.`visible` = 1 GROUP BY ac.`id_criterion` ORDER BY `value` ASC
array(0) { }

SELECT ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc25.`id_cache_product`)) AS nb_product FROM `ps_pm_advancedsearch_criterion_1` ac JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`) JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`) LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`) LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`) JOIN `ps_product_shop` ps ON ( ps.id_shop IN (1) AND ps.`id_product` = acp.`id_product` ) JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc25 ON ( acp.`id_cache_product` = acpc25.`id_cache_product` AND acpc25.`id_criterion` IN (50460)) LEFT JOIN `ps_stock_available` sa1 ON ( sa1.`id_product` = acp.`id_product` AND sa1.`id_product_attribute`=0 AND sa1.id_shop = 1 AND sa1.id_shop_group = 0 ) LEFT JOIN `ps_product_attribute` pa46 ON (pa46.`id_product` = acp.`id_product` ) LEFT JOIN `ps_stock_available` sa2 ON ( sa2.`id_product` = acp.`id_product` AND sa2.`id_product_attribute` = IFNULL(pa46.`id_product_attribute`, 0) AND sa2.id_shop = 1 AND sa2.id_shop_group = 0 ) WHERE ps.`active` = 1 AND ps.`visibility` IN ("both", "search") AND (IF (sa1.`quantity` > 0, 1, IF (sa1.`out_of_stock` = 2, 1 = 1, sa1.`out_of_stock` = 1)) OR IF (sa2.`quantity` > 0,1, IF (sa2.`out_of_stock` = 2, 1 = 1, sa2.`out_of_stock` = 1))) AND ac.`id_criterion_group` = 46 AND ac.`visible` = 1 GROUP BY ac.`id_criterion` ORDER BY `value` ASC
array(1) { [0]=> array(14) { ["id_criterion"]=> string(5) "49393" ["id_criterion_group"]=> string(2) "46" ["position"]=> string(1) "0" ["color"]=> string(0) "" ["level_depth"]=> string(1) "0" ["id_parent"]=> string(1) "0" ["visible"]=> string(1) "1" ["is_custom"]=> string(1) "0" ["id_criterion_linked"]=> string(6) "286769" ["id_lang"]=> string(1) "1" ["icon"]=> string(0) "" ["value"]=> string(4) "АА" ["decimal_value"]=> string(8) "0.000000" ["nb_product"]=> string(1) "1" } }

SELECT ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc25.`id_cache_product`)) AS nb_product FROM `ps_pm_advancedsearch_criterion_1` ac JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`) JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`) LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`) LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`) JOIN `ps_product_shop` ps ON ( ps.id_shop IN (1) AND ps.`id_product` = acp.`id_product` ) JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc25 ON ( acp.`id_cache_product` = acpc25.`id_cache_product` AND acpc25.`id_criterion` IN (50460)) LEFT JOIN `ps_stock_available` sa1 ON ( sa1.`id_product` = acp.`id_product` AND sa1.`id_product_attribute`=0 AND sa1.id_shop = 1 AND sa1.id_shop_group = 0 ) LEFT JOIN `ps_product_attribute` pa47 ON (pa47.`id_product` = acp.`id_product` ) LEFT JOIN `ps_stock_available` sa2 ON ( sa2.`id_product` = acp.`id_product` AND sa2.`id_product_attribute` = IFNULL(pa47.`id_product_attribute`, 0) AND sa2.id_shop = 1 AND sa2.id_shop_group = 0 ) WHERE ps.`active` = 1 AND ps.`visibility` IN ("both", "search") AND (IF (sa1.`quantity` > 0, 1, IF (sa1.`out_of_stock` = 2, 1 = 1, sa1.`out_of_stock` = 1)) OR IF (sa2.`quantity` > 0,1, IF (sa2.`out_of_stock` = 2, 1 = 1, sa2.`out_of_stock` = 1))) AND ac.`id_criterion_group` = 47 AND ac.`visible` = 1 GROUP BY ac.`id_criterion` ORDER BY `position` ASC
array(0) { }

SELECT ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc25.`id_cache_product`)) AS nb_product FROM `ps_pm_advancedsearch_criterion_1` ac JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`) JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`) LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`) LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`) JOIN `ps_product_shop` ps ON ( ps.id_shop IN (1) AND ps.`id_product` = acp.`id_product` ) JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc25 ON ( acp.`id_cache_product` = acpc25.`id_cache_product` AND acpc25.`id_criterion` IN (50460)) LEFT JOIN `ps_stock_available` sa1 ON ( sa1.`id_product` = acp.`id_product` AND sa1.`id_product_attribute`=0 AND sa1.id_shop = 1 AND sa1.id_shop_group = 0 ) LEFT JOIN `ps_product_attribute` pa51 ON (pa51.`id_product` = acp.`id_product` ) LEFT JOIN `ps_stock_available` sa2 ON ( sa2.`id_product` = acp.`id_product` AND sa2.`id_product_attribute` = IFNULL(pa51.`id_product_attribute`, 0) AND sa2.id_shop = 1 AND sa2.id_shop_group = 0 ) WHERE ps.`active` = 1 AND ps.`visibility` IN ("both", "search") AND (IF (sa1.`quantity` > 0, 1, IF (sa1.`out_of_stock` = 2, 1 = 1, sa1.`out_of_stock` = 1)) OR IF (sa2.`quantity` > 0,1, IF (sa2.`out_of_stock` = 2, 1 = 1, sa2.`out_of_stock` = 1))) AND ac.`id_criterion_group` = 51 AND ac.`visible` = 1 GROUP BY ac.`id_criterion` ORDER BY `value` ASC
array(0) { }

SELECT ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc25.`id_cache_product`)) AS nb_product FROM `ps_pm_advancedsearch_criterion_1` ac JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`) JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`) LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`) LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`) JOIN `ps_product_shop` ps ON ( ps.id_shop IN (1) AND ps.`id_product` = acp.`id_product` ) JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc25 ON ( acp.`id_cache_product` = acpc25.`id_cache_product` AND acpc25.`id_criterion` IN (50460)) LEFT JOIN `ps_stock_available` sa1 ON ( sa1.`id_product` = acp.`id_product` AND sa1.`id_product_attribute`=0 AND sa1.id_shop = 1 AND sa1.id_shop_group = 0 ) LEFT JOIN `ps_product_attribute` pa63 ON (pa63.`id_product` = acp.`id_product` ) LEFT JOIN `ps_stock_available` sa2 ON ( sa2.`id_product` = acp.`id_product` AND sa2.`id_product_attribute` = IFNULL(pa63.`id_product_attribute`, 0) AND sa2.id_shop = 1 AND sa2.id_shop_group = 0 ) WHERE ps.`active` = 1 AND ps.`visibility` IN ("both", "search") AND (IF (sa1.`quantity` > 0, 1, IF (sa1.`out_of_stock` = 2, 1 = 1, sa1.`out_of_stock` = 1)) OR IF (sa2.`quantity` > 0,1, IF (sa2.`out_of_stock` = 2, 1 = 1, sa2.`out_of_stock` = 1))) AND ac.`id_criterion_group` = 63 AND ac.`visible` = 1 GROUP BY ac.`id_criterion` ORDER BY `position` ASC
array(0) { }

SELECT ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc25.`id_cache_product`)) AS nb_product FROM `ps_pm_advancedsearch_criterion_1` ac JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`) JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`) LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`) LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`) JOIN `ps_product_shop` ps ON ( ps.id_shop IN (1) AND ps.`id_product` = acp.`id_product` ) JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc25 ON ( acp.`id_cache_product` = acpc25.`id_cache_product` AND acpc25.`id_criterion` IN (50460)) LEFT JOIN `ps_stock_available` sa1 ON ( sa1.`id_product` = acp.`id_product` AND sa1.`id_product_attribute`=0 AND sa1.id_shop = 1 AND sa1.id_shop_group = 0 ) LEFT JOIN `ps_product_attribute` pa66 ON (pa66.`id_product` = acp.`id_product` ) LEFT JOIN `ps_stock_available` sa2 ON ( sa2.`id_product` = acp.`id_product` AND sa2.`id_product_attribute` = IFNULL(pa66.`id_product_attribute`, 0) AND sa2.id_shop = 1 AND sa2.id_shop_group = 0 ) WHERE ps.`active` = 1 AND ps.`visibility` IN ("both", "search") AND (IF (sa1.`quantity` > 0, 1, IF (sa1.`out_of_stock` = 2, 1 = 1, sa1.`out_of_stock` = 1)) OR IF (sa2.`quantity` > 0,1, IF (sa2.`out_of_stock` = 2, 1 = 1, sa2.`out_of_stock` = 1))) AND ac.`id_criterion_group` = 66 AND ac.`visible` = 1 GROUP BY ac.`id_criterion` ORDER BY `position` ASC
array(0) { }

SELECT ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc25.`id_cache_product`)) AS nb_product FROM `ps_pm_advancedsearch_criterion_1` ac JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`) JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`) LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`) LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`) JOIN `ps_product_shop` ps ON ( ps.id_shop IN (1) AND ps.`id_product` = acp.`id_product` ) JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc25 ON ( acp.`id_cache_product` = acpc25.`id_cache_product` AND acpc25.`id_criterion` IN (50460)) LEFT JOIN `ps_stock_available` sa1 ON ( sa1.`id_product` = acp.`id_product` AND sa1.`id_product_attribute`=0 AND sa1.id_shop = 1 AND sa1.id_shop_group = 0 ) LEFT JOIN `ps_product_attribute` pa52 ON (pa52.`id_product` = acp.`id_product` ) LEFT JOIN `ps_stock_available` sa2 ON ( sa2.`id_product` = acp.`id_product` AND sa2.`id_product_attribute` = IFNULL(pa52.`id_product_attribute`, 0) AND sa2.id_shop = 1 AND sa2.id_shop_group = 0 ) WHERE ps.`active` = 1 AND ps.`visibility` IN ("both", "search") AND (IF (sa1.`quantity` > 0, 1, IF (sa1.`out_of_stock` = 2, 1 = 1, sa1.`out_of_stock` = 1)) OR IF (sa2.`quantity` > 0,1, IF (sa2.`out_of_stock` = 2, 1 = 1, sa2.`out_of_stock` = 1))) AND ac.`id_criterion_group` = 52 AND ac.`visible` = 1 GROUP BY ac.`id_criterion` ORDER BY `value` ASC
array(0) { }

SELECT ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc25.`id_cache_product`)) AS nb_product FROM `ps_pm_advancedsearch_criterion_1` ac JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`) JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`) LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`) LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`) JOIN `ps_product_shop` ps ON ( ps.id_shop IN (1) AND ps.`id_product` = acp.`id_product` ) JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc25 ON ( acp.`id_cache_product` = acpc25.`id_cache_product` AND acpc25.`id_criterion` IN (50460)) LEFT JOIN `ps_stock_available` sa1 ON ( sa1.`id_product` = acp.`id_product` AND sa1.`id_product_attribute`=0 AND sa1.id_shop = 1 AND sa1.id_shop_group = 0 ) LEFT JOIN `ps_product_attribute` pa65 ON (pa65.`id_product` = acp.`id_product` ) LEFT JOIN `ps_stock_available` sa2 ON ( sa2.`id_product` = acp.`id_product` AND sa2.`id_product_attribute` = IFNULL(pa65.`id_product_attribute`, 0) AND sa2.id_shop = 1 AND sa2.id_shop_group = 0 ) WHERE ps.`active` = 1 AND ps.`visibility` IN ("both", "search") AND (IF (sa1.`quantity` > 0, 1, IF (sa1.`out_of_stock` = 2, 1 = 1, sa1.`out_of_stock` = 1)) OR IF (sa2.`quantity` > 0,1, IF (sa2.`out_of_stock` = 2, 1 = 1, sa2.`out_of_stock` = 1))) AND ac.`id_criterion_group` = 65 AND ac.`visible` = 1 GROUP BY ac.`id_criterion` ORDER BY `position` ASC
array(0) { }

SELECT ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc25.`id_cache_product`)) AS nb_product FROM `ps_pm_advancedsearch_criterion_1` ac JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`) JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`) LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`) LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`) JOIN `ps_product_shop` ps ON ( ps.id_shop IN (1) AND ps.`id_product` = acp.`id_product` ) JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc25 ON ( acp.`id_cache_product` = acpc25.`id_cache_product` AND acpc25.`id_criterion` IN (50460)) LEFT JOIN `ps_stock_available` sa1 ON ( sa1.`id_product` = acp.`id_product` AND sa1.`id_product_attribute`=0 AND sa1.id_shop = 1 AND sa1.id_shop_group = 0 ) LEFT JOIN `ps_product_attribute` pa54 ON (pa54.`id_product` = acp.`id_product` ) LEFT JOIN `ps_stock_available` sa2 ON ( sa2.`id_product` = acp.`id_product` AND sa2.`id_product_attribute` = IFNULL(pa54.`id_product_attribute`, 0) AND sa2.id_shop = 1 AND sa2.id_shop_group = 0 ) WHERE ps.`active` = 1 AND ps.`visibility` IN ("both", "search") AND (IF (sa1.`quantity` > 0, 1, IF (sa1.`out_of_stock` = 2, 1 = 1, sa1.`out_of_stock` = 1)) OR IF (sa2.`quantity` > 0,1, IF (sa2.`out_of_stock` = 2, 1 = 1, sa2.`out_of_stock` = 1))) AND ac.`id_criterion_group` = 54 AND ac.`visible` = 1 GROUP BY ac.`id_criterion` ORDER BY `value` ASC
array(1) { [0]=> array(14) { ["id_criterion"]=> string(5) "50290" ["id_criterion_group"]=> string(2) "54" ["position"]=> string(1) "0" ["color"]=> string(0) "" ["level_depth"]=> string(1) "0" ["id_parent"]=> string(1) "0" ["visible"]=> string(1) "1" ["is_custom"]=> string(1) "0" ["id_criterion_linked"]=> string(6) "270601" ["id_lang"]=> string(1) "1" ["icon"]=> string(0) "" ["value"]=> string(8) "Duracell" ["decimal_value"]=> string(8) "0.000000" ["nb_product"]=> string(1) "1" } }

SELECT ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc25.`id_cache_product`)) AS nb_product FROM `ps_pm_advancedsearch_criterion_1` ac JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`) JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`) LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`) LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`) JOIN `ps_product_shop` ps ON ( ps.id_shop IN (1) AND ps.`id_product` = acp.`id_product` ) JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc25 ON ( acp.`id_cache_product` = acpc25.`id_cache_product` AND acpc25.`id_criterion` IN (50460)) LEFT JOIN `ps_stock_available` sa1 ON ( sa1.`id_product` = acp.`id_product` AND sa1.`id_product_attribute`=0 AND sa1.id_shop = 1 AND sa1.id_shop_group = 0 ) LEFT JOIN `ps_product_attribute` pa62 ON (pa62.`id_product` = acp.`id_product` ) LEFT JOIN `ps_stock_available` sa2 ON ( sa2.`id_product` = acp.`id_product` AND sa2.`id_product_attribute` = IFNULL(pa62.`id_product_attribute`, 0) AND sa2.id_shop = 1 AND sa2.id_shop_group = 0 ) WHERE ps.`active` = 1 AND ps.`visibility` IN ("both", "search") AND (IF (sa1.`quantity` > 0, 1, IF (sa1.`out_of_stock` = 2, 1 = 1, sa1.`out_of_stock` = 1)) OR IF (sa2.`quantity` > 0,1, IF (sa2.`out_of_stock` = 2, 1 = 1, sa2.`out_of_stock` = 1))) AND ac.`id_criterion_group` = 62 AND ac.`visible` = 1 GROUP BY ac.`id_criterion` ORDER BY `position` ASC
array(0) { }

SELECT ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc25.`id_cache_product`)) AS nb_product FROM `ps_pm_advancedsearch_criterion_1` ac JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`) JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`) LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`) LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`) JOIN `ps_product_shop` ps ON ( ps.id_shop IN (1) AND ps.`id_product` = acp.`id_product` ) JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc25 ON ( acp.`id_cache_product` = acpc25.`id_cache_product` AND acpc25.`id_criterion` IN (50460)) LEFT JOIN `ps_stock_available` sa1 ON ( sa1.`id_product` = acp.`id_product` AND sa1.`id_product_attribute`=0 AND sa1.id_shop = 1 AND sa1.id_shop_group = 0 ) LEFT JOIN `ps_product_attribute` pa55 ON (pa55.`id_product` = acp.`id_product` ) LEFT JOIN `ps_stock_available` sa2 ON ( sa2.`id_product` = acp.`id_product` AND sa2.`id_product_attribute` = IFNULL(pa55.`id_product_attribute`, 0) AND sa2.id_shop = 1 AND sa2.id_shop_group = 0 ) WHERE ps.`active` = 1 AND ps.`visibility` IN ("both", "search") AND (IF (sa1.`quantity` > 0, 1, IF (sa1.`out_of_stock` = 2, 1 = 1, sa1.`out_of_stock` = 1)) OR IF (sa2.`quantity` > 0,1, IF (sa2.`out_of_stock` = 2, 1 = 1, sa2.`out_of_stock` = 1))) AND ac.`id_criterion_group` = 55 AND ac.`visible` = 1 GROUP BY ac.`id_criterion` ORDER BY `position` ASC
array(0) { }

SELECT ac.*, aclink.`id_criterion_linked` , acl.id_lang, acl.icon, acl.`value`, acl.`decimal_value`, (COUNT(DISTINCT acpc25.`id_cache_product`)) AS nb_product FROM `ps_pm_advancedsearch_criterion_1` ac JOIN `ps_pm_advancedsearch_criterion_1_link` aclink ON (ac.`id_criterion` = aclink.`id_criterion`) JOIN `ps_pm_advancedsearch_criterion_1_list` aclist ON (ac.`id_criterion` = aclist.`id_criterion_parent`) LEFT JOIN `ps_pm_advancedsearch_criterion_1_lang` acl ON (ac.`id_criterion` = acl.`id_criterion` AND acl.`id_lang` = 1)JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc ON (aclist.`id_criterion` = acpc.`id_criterion`) LEFT JOIN `ps_pm_advancedsearch_cache_product_1` acp ON (acp.`id_cache_product` = acpc.`id_cache_product`) JOIN `ps_product_shop` ps ON ( ps.id_shop IN (1) AND ps.`id_product` = acp.`id_product` ) JOIN `ps_pm_advancedsearch_cache_product_criterion_1` acpc25 ON ( acp.`id_cache_product` = acpc25.`id_cache_product` AND acpc25.`id_criterion` IN (50460)) LEFT JOIN `ps_stock_available` sa1 ON ( sa1.`id_product` = acp.`id_product` AND sa1.`id_product_attribute`=0 AND sa1.id_shop = 1 AND sa1.id_shop_group = 0 ) LEFT JOIN `ps_product_attribute` pa59 ON (pa59.`id_product` = acp.`id_product` ) LEFT JOIN `ps_stock_available` sa2 ON ( sa2.`id_product` = acp.`id_product` AND sa2.`id_product_attribute` = IFNULL(pa59.`id_product_attribute`, 0) AND sa2.id_shop = 1 AND sa2.id_shop_group = 0 ) WHERE ps.`active` = 1 AND ps.`visibility` IN ("both", "search") AND (IF (sa1.`quantity` > 0, 1, IF (sa1.`out_of_stock` = 2, 1 = 1, sa1.`out_of_stock` = 1)) OR IF (sa2.`quantity` > 0,1, IF (sa2.`out_of_stock` = 2, 1 = 1, sa2.`out_of_stock` = 1))) AND ac.`id_criterion_group` = 59 AND ac.`visible` = 1 GROUP BY ac.`id_criterion` ORDER BY `position` ASC
array(0) { }

SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("2020-08-12 00:00:00", INTERVAL 14 DAY)) > 0 AS new, product_shop.price AS orderprice, ps.quantity AS sales, jsa.stock AS stock FROM `ps_category_product` cp LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN ps_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `ps_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= 618 AND c.nright <= 619) LEFT JOIN `ps_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN ps_product_sale ps ON p.`id_product` = ps.`id_product` LEFT JOIN ps_jsoxActualsParams jsa ON p.`id_product` = jsa.`pid` WHERE c.id_category > 0 AND jsa.`stock` IN (1,2,3,4,5) AND product_shop.`id_shop` = 1 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.id_product ORDER BY `stock` ASC, `quantity` DESC LIMIT 0,12
array(1) { [0]=> array(75) { ["id_product"]=> string(6) "124616" ["id_supplier"]=> string(1) "0" ["id_manufacturer"]=> string(1) "0" ["id_category_default"]=> string(4) "2358" ["id_shop_default"]=> string(1) "1" ["id_tax_rules_group"]=> string(1) "1" ["on_sale"]=> string(1) "0" ["online_only"]=> string(1) "0" ["ean13"]=> string(0) "" ["upc"]=> string(0) "" ["ecotax"]=> string(8) "0.000000" ["quantity"]=> string(2) "10" ["minimal_quantity"]=> string(1) "1" ["price"]=> string(10) "140.000000" ["wholesale_price"]=> string(8) "0.000000" ["unity"]=> string(0) "" ["unit_price_ratio"]=> string(8) "0.000000" ["additional_shipping_cost"]=> string(4) "0.00" ["reference"]=> string(6) "218720" ["supplier_reference"]=> string(0) "" ["location"]=> string(0) "" ["width"]=> string(8) "0.000000" ["height"]=> string(8) "0.000000" ["depth"]=> string(8) "0.000000" ["weight"]=> string(8) "0.000000" ["out_of_stock"]=> string(1) "1" ["quantity_discount"]=> string(1) "0" ["customizable"]=> string(1) "0" ["uploadable_files"]=> string(1) "0" ["text_fields"]=> string(1) "0" ["active"]=> string(1) "1" ["redirect_type"]=> string(0) "" ["id_product_redirected"]=> string(1) "0" ["available_for_order"]=> string(1) "1" ["available_date"]=> string(10) "0000-00-00" ["condition"]=> string(3) "new" ["type_of_book"]=> string(7) "default" ["show_price"]=> string(1) "1" ["indexed"]=> string(1) "1" ["visibility"]=> string(4) "both" ["cache_is_pack"]=> string(1) "0" ["cache_has_attachments"]=> string(1) "0" ["is_virtual"]=> string(1) "0" ["cache_default_attribute"]=> string(1) "0" ["date_add"]=> string(19) "2019-10-23 19:53:44" ["date_upd"]=> string(19) "2019-12-02 12:44:54" ["advanced_stock_management"]=> string(1) "0" ["pack_stock_type"]=> string(1) "3" ["xml"]=> string(0) "" ["barcode"]=> string(0) "" ["uuid"]=> string(6) "124616" ["isbn"]=> string(0) "" ["block_price_recalculation"]=> string(1) "0" ["not_available_fid"]=> string(1) "0" ["id_shop"]=> string(1) "1" ["final_price"]=> string(8) "0.000000" ["id_product_attribute"]=> string(1) "0" ["product_attribute_minimal_quantity"]=> NULL ["description"]=> string(571) "

Полное описание

Аккумуляторы duracell аа емкостью 1300 mah идеально подходят для устройств со средним энергопотреблением, таких как беспроводная мышка или рация малыша. оснащены уникальной технологией сохранения заряда duralock, которая позволяет оставаться заряженными до 6 месяцев

" ["description_short"]=> string(286) "Аккумуляторы duracell аа емкостью 1300 mah идеально подходят для устройств со средним энергопотреблением, таких как беспроводная мышка или рация малыша. оснащен..." ["available_now"]=> string(0) "" ["available_later"]=> string(0) "" ["link_rewrite"]=> string(40) "akkumulyator-aa-duracell-1300-mah-s39186" ["meta_description"]=> string(252) "Купить Аккумулятор АА Duracell 1300 mAh s.39186, Duracell ➤ на bookovka.com.ua ☎ (044) 333-6783, (098) 054-3003 ✈ Бесплатная доставка ✓ Без выходных ★ Подарочное оформление" ["meta_keywords"]=> string(0) "" ["meta_title"]=> string(87) "Аккумулятор АА Duracell 1300 mAh s.39186 купить на bookovka.com.ua" ["name"]=> string(53) "Аккумулятор АА Duracell 1300 mAh s.39186" ["id_image"]=> string(6) "188552" ["legend"]=> string(0) "" ["manufacturer_name"]=> NULL ["category_default"]=> string(24) "Аккумуляторы" ["new"]=> string(1) "0" ["orderprice"]=> string(10) "140.000000" ["sales"]=> NULL ["stock"]=> string(1) "2" } }

SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("2020-08-12 00:00:00", INTERVAL 14 DAY)) > 0 AS new, product_shop.price AS orderprice, ps.quantity AS sales, jsa.stock AS stock FROM `ps_category_product` cp LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN ps_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `ps_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= 618 AND c.nright <= 619) LEFT JOIN `ps_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN ps_product_sale ps ON p.`id_product` = ps.`id_product` LEFT JOIN ps_jsoxActualsParams jsa ON p.`id_product` = jsa.`pid` WHERE c.id_category > 0 AND jsa.`stock` IN (1,2,3,4,5) AND product_shop.`id_shop` = 1 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.id_product ORDER BY `stock` ASC, `quantity` DESC LIMIT 0,12
array(1) { [0]=> array(75) { ["id_product"]=> string(6) "124616" ["id_supplier"]=> string(1) "0" ["id_manufacturer"]=> string(1) "0" ["id_category_default"]=> string(4) "2358" ["id_shop_default"]=> string(1) "1" ["id_tax_rules_group"]=> string(1) "1" ["on_sale"]=> string(1) "0" ["online_only"]=> string(1) "0" ["ean13"]=> string(0) "" ["upc"]=> string(0) "" ["ecotax"]=> string(8) "0.000000" ["quantity"]=> string(2) "10" ["minimal_quantity"]=> string(1) "1" ["price"]=> string(10) "140.000000" ["wholesale_price"]=> string(8) "0.000000" ["unity"]=> string(0) "" ["unit_price_ratio"]=> string(8) "0.000000" ["additional_shipping_cost"]=> string(4) "0.00" ["reference"]=> string(6) "218720" ["supplier_reference"]=> string(0) "" ["location"]=> string(0) "" ["width"]=> string(8) "0.000000" ["height"]=> string(8) "0.000000" ["depth"]=> string(8) "0.000000" ["weight"]=> string(8) "0.000000" ["out_of_stock"]=> string(1) "1" ["quantity_discount"]=> string(1) "0" ["customizable"]=> string(1) "0" ["uploadable_files"]=> string(1) "0" ["text_fields"]=> string(1) "0" ["active"]=> string(1) "1" ["redirect_type"]=> string(0) "" ["id_product_redirected"]=> string(1) "0" ["available_for_order"]=> string(1) "1" ["available_date"]=> string(10) "0000-00-00" ["condition"]=> string(3) "new" ["type_of_book"]=> string(7) "default" ["show_price"]=> string(1) "1" ["indexed"]=> string(1) "1" ["visibility"]=> string(4) "both" ["cache_is_pack"]=> string(1) "0" ["cache_has_attachments"]=> string(1) "0" ["is_virtual"]=> string(1) "0" ["cache_default_attribute"]=> string(1) "0" ["date_add"]=> string(19) "2019-10-23 19:53:44" ["date_upd"]=> string(19) "2019-12-02 12:44:54" ["advanced_stock_management"]=> string(1) "0" ["pack_stock_type"]=> string(1) "3" ["xml"]=> string(0) "" ["barcode"]=> string(0) "" ["uuid"]=> string(6) "124616" ["isbn"]=> string(0) "" ["block_price_recalculation"]=> string(1) "0" ["not_available_fid"]=> string(1) "0" ["id_shop"]=> string(1) "1" ["final_price"]=> string(8) "0.000000" ["id_product_attribute"]=> string(1) "0" ["product_attribute_minimal_quantity"]=> NULL ["description"]=> string(571) "

Полное описание

Аккумуляторы duracell аа емкостью 1300 mah идеально подходят для устройств со средним энергопотреблением, таких как беспроводная мышка или рация малыша. оснащены уникальной технологией сохранения заряда duralock, которая позволяет оставаться заряженными до 6 месяцев

" ["description_short"]=> string(286) "Аккумуляторы duracell аа емкостью 1300 mah идеально подходят для устройств со средним энергопотреблением, таких как беспроводная мышка или рация малыша. оснащен..." ["available_now"]=> string(0) "" ["available_later"]=> string(0) "" ["link_rewrite"]=> string(40) "akkumulyator-aa-duracell-1300-mah-s39186" ["meta_description"]=> string(252) "Купить Аккумулятор АА Duracell 1300 mAh s.39186, Duracell ➤ на bookovka.com.ua ☎ (044) 333-6783, (098) 054-3003 ✈ Бесплатная доставка ✓ Без выходных ★ Подарочное оформление" ["meta_keywords"]=> string(0) "" ["meta_title"]=> string(87) "Аккумулятор АА Duracell 1300 mAh s.39186 купить на bookovka.com.ua" ["name"]=> string(53) "Аккумулятор АА Duracell 1300 mAh s.39186" ["id_image"]=> string(6) "188552" ["legend"]=> string(0) "" ["manufacturer_name"]=> NULL ["category_default"]=> string(24) "Аккумуляторы" ["new"]=> string(1) "0" ["orderprice"]=> string(10) "140.000000" ["sales"]=> NULL ["stock"]=> string(1) "2" } }

Купить Канцтовары-Аккумуляторы на bookovka.ua - Буковка
Интернет-магазин «Bookovka» +380980543003;+38(044)333-6783;+38(099)109-3003;+38(073)053-3003 online@bookovka.com.ua
Киев ул.Тампере, 5

Фильтр товаров

Тип

Производитель

Цена

140 грн. - 140 грн.

Последние статьи

Все статьи

Аккумуляторы

Показать 1 - 1 из 1 предмета
  • Аккумуляторы duracell аа емкостью

    Аккумуляторы duracell аа емкостью 1300 mah идеально подходят для устройств со средним энергопотреблением, таких как беспроводная мышка или рация малыша. оснащен...

    140 грн.
    Код предмета:218720 На складе
Показать 1 - 1 из 1 предмета
Перечень
 (044) 333-6783   (099) 109-3003    (098) 054-3003    (073) 053-3003 Обратный звонок Онлайн чат Viber Telegram Написать на почту