1. SELECT SQL_CALC_FOUND_ROWS products.product_id, descr1.product as product, companies.company as company_name, products.amount AS p_amount, products.min_qty, products.max_qty, products.qty_step FROM ?:products as products  INNER JOIN ?:product_features_values as c_var ON c_var.product_id = products.product_id AND c_var.lang_code = 'cs' AND c_var.variant_id = 5438 LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'cs'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 AND prices.destination_id = 0 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.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  WHERE 1  AND companies.status IN ('A')  AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND prices.destination_id = 0 AND companies.show_products_on_login = 'N' GROUP BY products.product_id   ORDER BY CASE WHEN (products.amount > 0 AND products.amount >= products.min_qty) THEN 0 ELSE 1 END ASC,  product asc, products.product_id ASC  LIMIT 0, 60
    
Brands :: Strážnické brambůrky - Brand
Demo version, orders will not be delivered.
  1. Array
    (
        [grid_id] => 6976
        [block_id] => 1022
        [content] => Array
            (
                [items] => Array
                    (
                        [filling] => manually
                        [item_ids] => 332,338,339,336,337,341,334,340
                    )
    
            )
    
        [object_id] => 0
        [object_type] => 
        [object_ids] => 
        [snapping_id] => 8589
        [wrapper] => 
        [user_class] => ut2-filters sb-filters
        [order] => 1
        [status] => A
        [type] => product_filters
        [properties] => Array
            (
                [template] => blocks/product_filters/for_category/horizontal_filters.tpl
                [abt__ut2_demo_block_id] => 
            )
    
        [company_id] => 0
        [storefront_id] => 1
        [lang_code] => en
        [name] => Product filters (Brand)
        [items_array] => Array
            (
            )
    
        [items_count] => 0
        [availability] => Array
            (
                [phone] => 1
                [tablet] => 1
                [desktop] => 1
            )
    
        [abt__ut2_use_lazy_load] => N
    )
    
    
  1. Array
    (
        [grid_id] => 6976
        [block_id] => 1022
        [content] => Array
            (
                [items] => Array
                    (
                        [filling] => manually
                        [item_ids] => 332,338,339,336,337,341,334,340
                    )
    
            )
    
        [object_id] => 0
        [object_type] => 
        [object_ids] => 
        [snapping_id] => 8589
        [wrapper] => 
        [user_class] => ut2-filters sb-filters
        [order] => 1
        [status] => A
        [type] => product_filters
        [properties] => Array
            (
                [template] => blocks/product_filters/for_category/horizontal_filters.tpl
                [abt__ut2_demo_block_id] => 
            )
    
        [company_id] => 0
        [storefront_id] => 1
        [lang_code] => en
        [name] => Product filters (Brand)
        [items_array] => Array
            (
            )
    
        [items_count] => 0
        [availability] => Array
            (
                [phone] => 1
                [tablet] => 1
                [desktop] => 1
            )
    
        [abt__ut2_use_lazy_load] => N
    )
    
    
  1. Array
    (
        [grid_id] => 7005
        [block_id] => 1011
        [content] => Array
            (
                [items] => Array
                    (
                        [filling] => manually
                        [item_ids] => 332,334,336,338,341,340,344
                    )
    
            )
    
        [object_id] => 0
        [object_type] => 
        [object_ids] => 
        [snapping_id] => 8578
        [wrapper] => blocks/wrappers/abt__ut2_onclick_dropdown_outside_position.tpl
        [user_class] => ut2-filters
        [order] => 2
        [status] => A
        [type] => product_filters
        [properties] => Array
            (
                [template] => blocks/product_filters/for_category/original.tpl
                [abt__ut2_demo_block_id] => 
            )
    
        [company_id] => 0
        [storefront_id] => 1
        [lang_code] => en
        [name] => Filters
        [items_array] => Array
            (
            )
    
        [items_count] => 0
        [availability] => Array
            (
                [phone] => 1
                [tablet] => 1
                [desktop] => 1
            )
    
        [abt__ut2_use_lazy_load] => N
    )
    
    
  1. Array
    (
        [grid_id] => 7005
        [block_id] => 1011
        [content] => Array
            (
                [items] => Array
                    (
                        [filling] => manually
                        [item_ids] => 332,334,336,338,341,340,344
                    )
    
            )
    
        [object_id] => 0
        [object_type] => 
        [object_ids] => 
        [snapping_id] => 8578
        [wrapper] => blocks/wrappers/abt__ut2_onclick_dropdown_outside_position.tpl
        [user_class] => ut2-filters
        [order] => 2
        [status] => A
        [type] => product_filters
        [properties] => Array
            (
                [template] => blocks/product_filters/for_category/original.tpl
                [abt__ut2_demo_block_id] => 
            )
    
        [company_id] => 0
        [storefront_id] => 1
        [lang_code] => en
        [name] => Filters
        [items_array] => Array
            (
            )
    
        [items_count] => 0
        [availability] => Array
            (
                [phone] => 1
                [tablet] => 1
                [desktop] => 1
            )
    
        [abt__ut2_use_lazy_load] => N
    )
    
    
  1. Array
    (
        [grid_id] => 7005
        [block_id] => 948
        [content] => Array
            (
                [items] => Array
                    (
                        [filling] => manually
                        [item_ids] => 332,334,336,337,338,339,341,340
                    )
    
            )
    
        [object_id] => 0
        [object_type] => 
        [object_ids] => 
        [snapping_id] => 8583
        [wrapper] => 
        [user_class] => 
        [order] => 3
        [status] => A
        [type] => product_filters
        [properties] => Array
            (
                [template] => addons/sb_price_list_by_regions/blocks/product_filters/for_category/selected_filters.tpl
                [abt__ut2_demo_block_id] => 
            )
    
        [company_id] => 0
        [storefront_id] => 1
        [lang_code] => en
        [name] => Selected product filters (Search, Latek, New...)
        [items_array] => Array
            (
            )
    
        [items_count] => 0
        [availability] => Array
            (
                [phone] => 1
                [tablet] => 1
                [desktop] => 1
            )
    
        [abt__ut2_use_lazy_load] => N
    )
    
    
  1. Array
    (
        [grid_id] => 7005
        [block_id] => 948
        [content] => Array
            (
                [items] => Array
                    (
                        [filling] => manually
                        [item_ids] => 332,334,336,337,338,339,341,340
                    )
    
            )
    
        [object_id] => 0
        [object_type] => 
        [object_ids] => 
        [snapping_id] => 8583
        [wrapper] => 
        [user_class] => 
        [order] => 3
        [status] => A
        [type] => product_filters
        [properties] => Array
            (
                [template] => addons/sb_price_list_by_regions/blocks/product_filters/for_category/selected_filters.tpl
                [abt__ut2_demo_block_id] => 
            )
    
        [company_id] => 0
        [storefront_id] => 1
        [lang_code] => en
        [name] => Selected product filters (Search, Latek, New...)
        [items_array] => Array
            (
            )
    
        [items_count] => 0
        [availability] => Array
            (
                [phone] => 1
                [tablet] => 1
                [desktop] => 1
            )
    
        [abt__ut2_use_lazy_load] => N
    )
    
    
AB: FLY menu (Mobile)