1. Array
(
    [area] => C
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
            [3] => description
            [4] => companies
        )

    [custom_extend] => Array
        (
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 0
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [for_required_product] => 64369
    [include_child_variations] => 1
    [group_child_variations] => 
    [hide_out_of_stock_products] => 1
    [sort_by] => product
    [sort_order] => asc
    [for_current_storefront] => 1
    [company_status] => A
    [usergroup_ids] => Array
        (
            [0] => 0
            [1] => 1
        )

    [sort_order_rev] => desc
)


  1. SELECT SQL_CALC_FOUND_ROWS products.product_id, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product, companies.company as company_name, products.product_type, products.parent_product_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN ?:ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id  AND shared_descr.company_id = 1 AND shared_descr.lang_code = 'en' LEFT JOIN ?:product_required_products ON products.product_id = ?:product_required_products.required_id WHERE 1  AND companies.status IN ('A') AND (products.amount > 0 OR products.tracking = 'D') AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND ?:product_required_products.product_id = 64369 GROUP BY products.product_id   ORDER BY product asc, products.product_id ASC 

  1. Array
(
    [area] => C
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => categories
            [2] => companies
        )

    [custom_extend] => Array
        (
            [0] => product_name
            [1] => categories
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 0
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [group_child_variations] => 
    [include_child_variations] => 1
    [skip_rating] => 1
    [sort_by] => null
    [variation_group_id] => Array
        (
            [12789] => 12789
        )

    [get_amount] => 1
    [abt__ut2_load_variations_info] => 1
    [hide_out_of_stock_products] => 1
    [sort_order] => asc
    [for_current_storefront] => 1
    [company_status] => A
    [usergroup_ids] => Array
        (
            [0] => 0
            [1] => 1
        )

    [sort_order_rev] => desc
)


  1. SELECT SQL_CALC_FOUND_ROWS products.product_id, products.amount, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product, companies.company as company_name, variation_group_products.group_id AS variation_group_id, products.product_type, products.parent_product_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN ?:ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id  AND shared_descr.company_id = 1 AND shared_descr.lang_code = 'en' INNER JOIN ?:product_variation_group_products AS variation_group_products ON variation_group_products.product_id = products.product_id WHERE 1  AND companies.status IN ('A') AND (products.amount > 0 OR products.tracking = 'D') AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND variation_group_products.group_id IN (12789) GROUP BY products.product_id   ORDER BY NULL asc 

  1. Array
(
    [area] => C
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
            [3] => product_name
            [4] => companies
        )

    [custom_extend] => Array
        (
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 0
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [pid] => Array
        (
            [0] => 64368
            [1] => 64369
            [2] => 64370
            [3] => 64371
        )

    [group_child_variations] => 
    [skip_rating] => 1
    [sort_by] => null
    [hide_out_of_stock_products] => 1
    [sort_order] => asc
    [for_current_storefront] => 1
    [company_status] => A
    [usergroup_ids] => Array
        (
            [0] => 0
            [1] => 1
        )

    [include_child_variations] => 1
    [sort_order_rev] => desc
)


  1. SELECT SQL_CALC_FOUND_ROWS products.product_id, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product, companies.company as company_name, products.product_type, products.parent_product_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN ?:ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id  AND shared_descr.company_id = 1 AND shared_descr.lang_code = 'en' WHERE 1  AND companies.status IN ('A') AND (products.amount > 0 OR products.tracking = 'D') AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1)  AND  ((1  AND  products.product_id IN (64368, 64369, 64370, 64371)) AND companies.status IN ('A') AND prices.usergroup_id IN (0, 0, 1)) GROUP BY products.product_id   ORDER BY NULL asc
HELMETS :: Off Road Helmets :: AIR000KRA526-S - Ridersparadise 
  1. Array
(
    [area] => C
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
            [3] => companies
        )

    [custom_extend] => Array
        (
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 3
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [similar] => 1
    [main_product_id] => 64369
    [item_number] => N
    [number_of_columns] => 6
    [abt__ut2_loading_type] => onclick_and_scroll
    [thumbnail_width] => 
    [abt__ut2_thumbnail_height] => 
    [abt__ut2_demo_block_id] => 
    [skeleton_height_desktop] => 
    [skeleton_height_tablet] => 
    [skeleton_height_mobile] => 
    [hide_add_to_cart_button] => N
    [similar_category] => Y
    [similar_subcats] => Y
    [similar_in_stock] => Y
    [block_data] => Array
        (
            [grid_id] => 1154
            [block_id] => 138
            [content] => Array
                (
                    [items] => Array
                        (
                            [filling] => similar
                            [limit] => 3
                            [percent_range] => 
                            [similar_category] => Y
                            [similar_subcats] => Y
                            [similar_in_stock] => Y
                        )

                )

            [object_id] => 0
            [object_type] => 
            [object_ids] => 
            [snapping_id] => 1364
            [wrapper] => 
            [user_class] => 
            [order] => 2
            [status] => A
            [type] => products
            [properties] => Array
                (
                    [template] => blocks/products/ab__grid_list.tpl
                    [item_number] => N
                    [number_of_columns] => 6
                    [abt__ut2_loading_type] => onclick_and_scroll
                    [thumbnail_width] => 
                    [abt__ut2_thumbnail_height] => 
                    [abt__ut2_demo_block_id] => 
                    [skeleton_height_desktop] => 
                    [skeleton_height_tablet] => 
                    [skeleton_height_mobile] => 
                    [hide_add_to_cart_button] => N
                )

            [company_id] => 1
            [storefront_id] => 1
            [lang_code] => en
            [name] => Most Popular
            [items_array] => Array
                (
                )

            [items_count] => 0
            [availability] => Array
                (
                    [phone] => 1
                    [tablet] => 1
                    [desktop] => 1
                )

            [abt__ut2_use_lazy_load] => N
            [tab_id] => abt__ut2_grid_tab_1154_138_1364_products_64369
            [abt__ut2_show_blocks_in_tabs] => with_lazy_load
            [first] => 1
        )

    [apply_limit] => 
    [hide_out_of_stock_products] => 1
    [sort_by] => product
    [sort_order] => asc
    [exclude_pid] => 64369
    [cid] => 460
    [subcats] => Y
    [for_current_storefront] => 1
    [company_status] => A
    [usergroup_ids] => Array
        (
            [0] => 0
            [1] => 1
        )

    [include_child_variations] => 
    [group_child_variations] => 
    [parent_product_id] => 0
    [sort_order_rev] => desc
)


  1. SELECT SQL_CALC_FOUND_ROWS products.product_id, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product, companies.company as company_name, products.product_type, products.parent_product_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN ?:ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id  AND shared_descr.company_id = 1 AND shared_descr.lang_code = 'en' WHERE 1  AND ?:categories.category_id IN (460) AND products.product_id NOT IN (64369) AND companies.status IN ('A') AND (products.amount > 0 OR products.tracking = 'D') AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.parent_product_id = 0 GROUP BY products.product_id   ORDER BY product asc, products.product_id ASC  LIMIT 0, 3

  1. Array
(
    [area] => C
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => categories
            [2] => companies
        )

    [custom_extend] => Array
        (
            [0] => product_name
            [1] => categories
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 0
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [group_child_variations] => 
    [include_child_variations] => 1
    [skip_rating] => 1
    [sort_by] => null
    [variation_group_id] => Array
        (
            [9955] => 9955
            [10345] => 10345
            [10346] => 10346
        )

    [get_amount] => 1
    [abt__ut2_load_variations_info] => 1
    [hide_out_of_stock_products] => 1
    [sort_order] => asc
    [for_current_storefront] => 1
    [company_status] => A
    [usergroup_ids] => Array
        (
            [0] => 0
            [1] => 1
        )

    [sort_order_rev] => desc
)


  1. SELECT SQL_CALC_FOUND_ROWS products.product_id, products.amount, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product, companies.company as company_name, variation_group_products.group_id AS variation_group_id, products.product_type, products.parent_product_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN ?:ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id  AND shared_descr.company_id = 1 AND shared_descr.lang_code = 'en' INNER JOIN ?:product_variation_group_products AS variation_group_products ON variation_group_products.product_id = products.product_id WHERE 1  AND companies.status IN ('A') AND (products.amount > 0 OR products.tracking = 'D') AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND variation_group_products.group_id IN (9955, 10345, 10346) GROUP BY products.product_id   ORDER BY NULL asc 

  1. Array
(
    [area] => C
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
            [prices2] => 1
            [3] => on_sale
            [4] => companies
            [5] => categories
        )

    [custom_extend] => Array
        (
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 6
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [on_sale] => 1
    [sort_by] => on_sale
    [sort_order] => desc
    [item_number] => N
    [number_of_columns] => 6
    [abt__ut2_loading_type] => onclick
    [abt__ut2_demo_block_id] => 
    [hide_add_to_cart_button] => N
    [block_data] => Array
        (
            [grid_id] => 1154
            [block_id] => 139
            [content] => Array
                (
                    [items] => Array
                        (
                            [filling] => on_sale
                            [limit] => 18
                            [cid] => 
                        )

                )

            [object_id] => 0
            [object_type] => 
            [object_ids] => 
            [snapping_id] => 1365
            [wrapper] => 
            [user_class] => 
            [order] => 3
            [status] => A
            [type] => products
            [properties] => Array
                (
                    [template] => blocks/products/ab__grid_list.tpl
                    [item_number] => N
                    [number_of_columns] => 6
                    [abt__ut2_loading_type] => onclick
                    [abt__ut2_demo_block_id] => 
                    [hide_add_to_cart_button] => N
                )

            [company_id] => 1
            [storefront_id] => 1
            [lang_code] => en
            [name] => On Sale
            [items_array] => Array
                (
                )

            [items_count] => 0
            [availability] => Array
                (
                    [phone] => 1
                    [tablet] => 1
                    [desktop] => 1
                )

            [abt__ut2_use_lazy_load] => N
            [tab_id] => abt__ut2_grid_tab_1154_139_1365_products_64369
            [abt__ut2_show_blocks_in_tabs] => with_lazy_load
            [first] => 
        )

    [apply_limit] => 
    [hide_out_of_stock_products] => 1
    [for_current_storefront] => 1
    [company_status] => A
    [usergroup_ids] => Array
        (
            [0] => 0
            [1] => 1
        )

    [include_child_variations] => 
    [group_child_variations] => 
    [parent_product_id] => 0
    [sort_order_rev] => asc
)


  1. SELECT SQL_CALC_FOUND_ROWS products.product_id, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product, companies.company as company_name, popularity.total as popularity, IF(shared_prices.product_id IS NOT NULL, MIN(IF (shared_prices.percentage_discount = 0, shared_prices.price, shared_prices.price - (shared_prices.price * shared_prices.percentage_discount) / 100)), MIN(IF (prices.percentage_discount = 0, prices.price, prices.price - (prices.price * prices.percentage_discount) / 100))) as price, products.product_type, products.parent_product_id, products.list_price as list_price, MAX(100 - ((prices.price * 100) / products.list_price)) AS sales_discount, IF(COUNT(IF(?:categories.company_id = products.company_id, NULL, ?:categories.company_id)), 'Y', 'N') as is_shared_product FROM ?:products as products  LEFT JOIN ?:product_features_values ON ?:product_features_values.product_id = products.product_id AND ?:product_features_values.lang_code = 'en' LEFT JOIN ?:product_features ON ?:product_features_values.feature_id = ?:product_features.feature_id LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:product_prices as prices_2 ON prices.product_id = prices_2.product_id AND prices_2.lower_limit = 1 AND prices_2.price < prices.price  AND prices_2.usergroup_id IN (0, 0, 1) LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN ?:product_popularity as popularity ON popularity.product_id = products.product_id LEFT JOIN ?:ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id  AND shared_descr.company_id = 1 AND shared_descr.lang_code = 'en' LEFT JOIN ?:ult_product_prices as shared_prices ON shared_prices.product_id = products.product_id AND shared_prices.lower_limit = 1  AND shared_prices.usergroup_id IN (0, 0, 1) AND shared_prices.company_id = 1 LEFT JOIN ?:ult_product_prices as shared_prices_2 ON shared_prices.product_id = shared_prices_2.product_id AND shared_prices_2.company_id = 1 AND shared_prices_2.lower_limit = 1 AND shared_prices_2.price < shared_prices.price  AND shared_prices_2.usergroup_id IN (0, 0, 1) LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  WHERE 1  AND companies.status IN ('A') AND (products.amount > 0 OR products.tracking = 'D') AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND prices_2.price IS NULL AND shared_prices_2.price IS NULL AND products.parent_product_id = 0 GROUP BY products.product_id  HAVING sales_discount > 0 AND price < list_price  ORDER BY sales_discount desc, products.product_id ASC  LIMIT 0, 6

  1. Array
(
    [area] => C
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => categories
            [2] => companies
        )

    [custom_extend] => Array
        (
            [0] => product_name
            [1] => categories
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 0
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [group_child_variations] => 
    [include_child_variations] => 1
    [skip_rating] => 1
    [sort_by] => null
    [variation_group_id] => Array
        (
            [13002] => 13002
            [12218] => 12218
            [9760] => 9760
            [9761] => 9761
            [9762] => 9762
            [9763] => 9763
        )

    [get_amount] => 1
    [abt__ut2_load_variations_info] => 1
    [hide_out_of_stock_products] => 1
    [sort_order] => asc
    [for_current_storefront] => 1
    [company_status] => A
    [usergroup_ids] => Array
        (
            [0] => 0
            [1] => 1
        )

    [sort_order_rev] => desc
)


  1. SELECT SQL_CALC_FOUND_ROWS products.product_id, products.amount, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product, companies.company as company_name, variation_group_products.group_id AS variation_group_id, products.product_type, products.parent_product_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN ?:ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id  AND shared_descr.company_id = 1 AND shared_descr.lang_code = 'en' INNER JOIN ?:product_variation_group_products AS variation_group_products ON variation_group_products.product_id = products.product_id WHERE 1  AND companies.status IN ('A') AND (products.amount > 0 OR products.tracking = 'D') AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND variation_group_products.group_id IN (13002, 12218, 9760, 9761, 9762, 9763) GROUP BY products.product_id   ORDER BY NULL asc 

  1. Array
(
    [area] => C
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
            [3] => companies
        )

    [custom_extend] => Array
        (
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 6
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 0
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [apply_limit] => 1
    [force_get_by_ids] => 1
    [exclude_pid] => 64369
    [pid] => Array
        (
            [0] => 64368
        )

    [item_number] => N
    [number_of_columns] => 6
    [abt__ut2_demo_block_id] => 
    [skeleton_height_desktop] => 
    [skeleton_height_tablet] => 
    [skeleton_height_mobile] => 
    [hide_add_to_cart_button] => Y
    [block_data] => Array
        (
            [grid_id] => 1154
            [block_id] => 140
            [content] => Array
                (
                    [items] => Array
                        (
                            [filling] => recent_products
                            [limit] => 6
                        )

                )

            [object_id] => 0
            [object_type] => 
            [object_ids] => 
            [snapping_id] => 1366
            [wrapper] => 
            [user_class] => 
            [order] => 4
            [status] => A
            [type] => products
            [properties] => Array
                (
                    [template] => blocks/products/products_multicolumns.tpl
                    [item_number] => N
                    [number_of_columns] => 6
                    [abt__ut2_demo_block_id] => 
                    [skeleton_height_desktop] => 
                    [skeleton_height_tablet] => 
                    [skeleton_height_mobile] => 
                    [hide_add_to_cart_button] => Y
                )

            [company_id] => 1
            [storefront_id] => 1
            [lang_code] => en
            [name] => Recently Viewed
            [items_array] => Array
                (
                )

            [items_count] => 0
            [availability] => Array
                (
                    [phone] => 1
                    [tablet] => 1
                    [desktop] => 1
                )

            [abt__ut2_use_lazy_load] => N
            [tab_id] => abt__ut2_grid_tab_1154_140_1366_products_64369
            [abt__ut2_show_blocks_in_tabs] => with_lazy_load
            [first] => 
        )

    [hide_out_of_stock_products] => 1
    [sort_by] => product
    [sort_order] => asc
    [for_current_storefront] => 1
    [company_status] => A
    [usergroup_ids] => Array
        (
            [0] => 0
            [1] => 1
        )

    [include_child_variations] => 1
    [group_child_variations] => 
    [sort_order_rev] => desc
)


  1. SELECT SQL_CALC_FOUND_ROWS products.product_id, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product, companies.company as company_name, products.product_type, products.parent_product_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN ?:ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id  AND shared_descr.company_id = 1 AND shared_descr.lang_code = 'en' WHERE 1  AND products.product_id NOT IN (64369) AND companies.status IN ('A') AND (products.amount > 0 OR products.tracking = 'D') AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1)  AND  ((1  AND  products.product_id IN (64368)) AND companies.status IN ('A') AND prices.usergroup_id IN (0, 0, 1)) GROUP BY products.product_id   ORDER BY product asc, products.product_id ASC  LIMIT 0, 6

  1. Array
(
    [area] => C
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => categories
            [2] => companies
        )

    [custom_extend] => Array
        (
            [0] => product_name
            [1] => categories
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 0
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [group_child_variations] => 
    [include_child_variations] => 1
    [skip_rating] => 1
    [sort_by] => null
    [variation_group_id] => Array
        (
            [12789] => 12789
        )

    [get_amount] => 1
    [abt__ut2_load_variations_info] => 1
    [hide_out_of_stock_products] => 1
    [sort_order] => asc
    [for_current_storefront] => 1
    [company_status] => A
    [usergroup_ids] => Array
        (
            [0] => 0
            [1] => 1
        )

    [sort_order_rev] => desc
)


  1. SELECT SQL_CALC_FOUND_ROWS products.product_id, products.amount, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product, companies.company as company_name, variation_group_products.group_id AS variation_group_id, products.product_type, products.parent_product_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN ?:ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id  AND shared_descr.company_id = 1 AND shared_descr.lang_code = 'en' INNER JOIN ?:product_variation_group_products AS variation_group_products ON variation_group_products.product_id = products.product_id WHERE 1  AND companies.status IN ('A') AND (products.amount > 0 OR products.tracking = 'D') AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND variation_group_products.group_id IN (12789) GROUP BY products.product_id   ORDER BY NULL asc
US
Categories
0Cart
AIR000KRA526-S
Write a review
€38990 €46990
Add to cart

AIR000KRA526-S

Write a review
€38990 €46990 -17%
(Including tax)
In stock
+ −
Add to wish list Compare Ask a question 
    1. Array
(
    [area] => C
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => prices
            [2] => categories
            [3] => companies
        )

    [custom_extend] => Array
        (
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 100
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 0
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [variations_by_product_id] => 64369
    [product_variations.hide_add_to_wishlist_button] => N
    [hide_add_to_cart_button] => N
    [product_variations.show_product_code] => Y
    [product_variations.show_variation_thumbnails] => Y
    [variations_in_stock] => N
    [block_data] => Array
        (
            [block_id] => 52
            [type] => products
            [properties] => Array
                (
                    [template] => addons/product_variations/blocks/products/variations_list.tpl
                    [product_variations.hide_add_to_wishlist_button] => N
                    [hide_add_to_cart_button] => N
                    [product_variations.show_product_code] => Y
                    [product_variations.show_variation_thumbnails] => Y
                )

            [company_id] => 1
            [storefront_id] => 1
            [lang_code] => en
            [name] => Variations list
            [snapping_id] => 0
            [object_id] => 64369
            [object_type] => products
            [content] => Array
                (
                    [items] => Array
                        (
                            [filling] => product_variations.variations_filling
                            [limit] => 100
                            [variations_in_stock] => N
                        )

                )

            [availability] => Array
                (
                    [phone] => 1
                    [tablet] => 1
                    [desktop] => 1
                )

        )

    [hide_out_of_stock_products] => 1
    [sort_by] => product
    [sort_order] => asc
    [for_current_storefront] => 1
    [company_status] => A
    [usergroup_ids] => Array
        (
            [0] => 0
            [1] => 1
        )

    [include_child_variations] => 
    [group_child_variations] => 
    [parent_product_id] => 0
    [variation_group_id] => 12789
    [sort_order_rev] => desc
)


    1. SELECT SQL_CALC_FOUND_ROWS products.product_id, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product, companies.company as company_name, variation_group_products.group_id AS variation_group_id, products.product_type, products.parent_product_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN ?:ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id  AND shared_descr.company_id = 1 AND shared_descr.lang_code = 'en' INNER JOIN ?:product_variation_group_products AS variation_group_products ON variation_group_products.product_id = products.product_id WHERE 1  AND companies.status IN ('A') AND (products.amount > 0 OR products.tracking = 'D') AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND variation_group_products.group_id IN (12789) GROUP BY products.product_id   ORDER BY product asc, products.product_id ASC  LIMIT 0, 100

    1. Array
(
    [area] => C
    [use_caching] => 1
    [extend] => Array
        (
            [0] => product_name
            [1] => categories
            [2] => companies
        )

    [custom_extend] => Array
        (
            [0] => product_name
            [1] => categories
        )

    [pname] => 
    [pshort] => 
    [pfull] => 
    [pkeywords] => 
    [feature] => Array
        (
        )

    [type] => simple
    [page] => 1
    [action] => 
    [filter_variants] => Array
        (
        )

    [features_hash] => 
    [limit] => 0
    [bid] => 0
    [match] => 
    [tracking] => Array
        (
        )

    [get_frontend_urls] => 
    [items_per_page] => 0
    [apply_disabled_filters] => 
    [load_products_extra_data] => 1
    [storefront] => 
    [company_ids] => 
    [group_child_variations] => 
    [include_child_variations] => 1
    [skip_rating] => 1
    [sort_by] => null
    [variation_group_id] => Array
        (
            [12789] => 12789
        )

    [get_amount] => 1
    [abt__ut2_load_variations_info] => 1
    [hide_out_of_stock_products] => 1
    [sort_order] => asc
    [for_current_storefront] => 1
    [company_status] => A
    [usergroup_ids] => Array
        (
            [0] => 0
            [1] => 1
        )

    [sort_order_rev] => desc
)


    1. SELECT SQL_CALC_FOUND_ROWS products.product_id, products.amount, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product, companies.company as company_name, variation_group_products.group_id AS variation_group_id, products.product_type, products.parent_product_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN ?:ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id  AND shared_descr.company_id = 1 AND shared_descr.lang_code = 'en' INNER JOIN ?:product_variation_group_products AS variation_group_products ON variation_group_products.product_id = products.product_id WHERE 1  AND companies.status IN ('A') AND (products.amount > 0 OR products.tracking = 'D') AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND variation_group_products.group_id IN (12789) GROUP BY products.product_id   ORDER BY NULL asc
  • View all variations as list
Delivery
  • Also available in
  • Compatible Products
 
Features
Size
M
Find similar
Reviews

No reviews found

  • Most Popular
  • On Sale
  • Recently Viewed
Acerbis Airstrike-C ECE 22.06 26832.315 black/white
0.0
In stock
€45995 €49995 -8%
(Including tax)
+ −
BrandACERBIS SexFor Men, For Women
Acerbis Profile 5 ECE 22.06 25274.229 white/orange
0.0
In stock
€9990 €15995 -38%
(Including tax)
+ −
BrandACERBIS SexFor Men, For Women
Acerbis Profile 5 ECE 22.06 25274.344 red/blue
0.0
In stock
€9990 €15995 -38%
(Including tax)
+ −
BrandACERBIS SexFor Men, For Women
Fast and high quality delivery

Our company makes delivery all over the country

Quality assurance and service

We offer only those goods, in which quality we are sure

Returns within 30 days

You have 30 days to test your purchase