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 = 5560 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)
210 323 888 Mon-Fr from 8a.m. to 5p.m.
Email tde@tamda.eu
Address
No items found matching the search criteria
No items found matching the search criteria
No items found matching the search criteria
No items found matching the search criteria
(Everyday from 8:00 — 17:00)
Customer service by email
© 2013 - 2025 Tamda Express