There are no products in this section
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 = 10610 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
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 )
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 )
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 )
210 323 888 Mon-Fr from 8a.m. to 5p.m.
Email tde@tamda.eu
Address
(Everyday from 8:00 — 17:00)
Customer service by email
© 2013 - 2025 Tamda Express