Search - Kronospan - Leading manufacturer of wood-based panels

SELECT products.sku_id AS id, products.decore_collection_id, products.sku_has_sample, decores.border_around_image as border, products.top_decore_id, products.bottom_decore_id, products.core_material_id, products.core_material_title, products.top_decore_number, products.core_material_summary AS summary, decores_i18n.title, core_materials_i18n.description_s AS description_s, ( IF(products.collection_id, CASE product_collections.main_image WHEN '' THEN categories.main_image ELSE product_collections.main_image END, categories.main_image)) AS pictogram, CONCAT_WS(' / ', IF(top_texture_is_active = 1 AND top_texture_is_approved = 1, products.top_texture_abbreviation, NULL), IF(bottom_texture_is_active = 1 AND bottom_texture_is_approved = 1, products.bottom_texture_abbreviation, NULL)) AS abbreviations, CONCAT_WS(' - ', CONCAT_WS(' / ', IF(top_decore_is_active = 1 AND top_decore_is_approved = 1, products.top_decore_number, NULL), IF(bottom_decore_is_active = 1 AND bottom_decore_is_approved = 1, products.bottom_decore_number, NULL), IF(top_texture_is_active = 1 AND top_texture_is_approved = 1, products.top_texture_abbreviation, NULL), IF(bottom_texture_is_active = 1 AND bottom_texture_is_approved = 1, products.bottom_texture_abbreviation, NULL)), products.core_material_title) AS product_title, decores.search_image AS image, IF(top_texture_is_active = 1 AND top_texture_is_approved = 1, products.top_texture_abbreviation, NULL) AS top_texture_abbreviation, IF(bottom_texture_is_active = 1 AND bottom_texture_is_approved = 1, products.bottom_texture_abbreviation, NULL) AS bottom_texture_abbreviation, IF(top_texture_is_active = 1 AND top_texture_is_approved = 1, products.top_texture_attached_image, NULL) AS top_texture_attached_image, IF(bottom_texture_is_active = 1 AND bottom_texture_is_approved = 1, products.bottom_texture_attached_image, NULL) AS bottom_texture_attached_image, IF(top_texture_is_active = 1 AND top_texture_is_approved = 1, textures_top.summary, NULL) AS top_texture_summary, IF(bottom_texture_is_active = 1 AND bottom_texture_is_approved = 1, textures_bottom.summary, NULL) AS bottom_texture_summary, IF(bottom_texture_is_active = 1 AND bottom_texture_is_approved = 1, textures_bottom.title, textures_top.title) as fullname FROM `products` INNER JOIN core_materials_i18n ON core_materials_i18n.i18n_foreign_key = products.core_material_id AND core_materials_i18n.i18n_country_language_id = products.i18n_country_language_id INNER JOIN categories ON categories.id = products.family_id LEFT JOIN categories AS product_collections ON product_collections.id = products.collection_id LEFT JOIN decores ON decores.id = products.top_decore_id LEFT JOIN decores_i18n ON decores_i18n.i18n_foreign_key = decores.id LEFT JOIN textures_i18n AS textures_top ON textures_top.i18n_foreign_key = products.top_texture_id AND textures_top.i18n_country_language_id = products.i18n_country_language_id LEFT JOIN textures_i18n AS textures_bottom ON textures_bottom.i18n_foreign_key = products.bottom_texture_id AND textures_bottom.i18n_country_language_id = products.i18n_country_language_id WHERE products.i18n_country_language_id = 43 AND decores_i18n.i18n_country_language_id = 43 AND core_materials_i18n.is_active = 1 AND core_materials_i18n.is_approved = 1 AND products.sku_is_active = 1 AND products.sku_is_approved = 1 AND products.category_is_active = 1 AND products.category_is_approved = 1 AND(products.family_id = 0 OR(products.family_is_active = 1 AND products.family_is_approved = 1))AND(products.collection_id = 0 OR(products.collection_is_active = 1 AND products.collection_is_approved = 1))AND((top_decore_id = 611 AND top_decore_is_active = 1 AND top_decore_is_approved = 1)OR(bottom_decore_id = 611 AND bottom_decore_is_active = 1 AND bottom_decore_is_approved = 1)) GROUP BY products.sku_id ORDER BY categories.lft ASC, product_collections.lft ASC
Server shutdown in progressSELECT products.sku_id AS id, products.decore_collection_id, products.sku_has_sample, decores.border_around_image as border, products.top_decore_id, products.bottom_decore_id, products.core_material_id, products.core_material_title, products.top_decore_number, products.core_material_summary AS summary, decores_i18n.title, core_materials_i18n.description_s AS description_s, ( IF(products.collection_id, CASE product_collections.main_image WHEN '' THEN categories.main_image ELSE product_collections.main_image END, categories.main_image)) AS pictogram, CONCAT_WS(' / ', IF(top_texture_is_active = 1 AND top_texture_is_approved = 1, products.top_texture_abbreviation, NULL), IF(bottom_texture_is_active = 1 AND bottom_texture_is_approved = 1, products.bottom_texture_abbreviation, NULL)) AS abbreviations, CONCAT_WS(' - ', CONCAT_WS(' / ', IF(top_decore_is_active = 1 AND top_decore_is_approved = 1, products.top_decore_number, NULL), IF(bottom_decore_is_active = 1 AND bottom_decore_is_approved = 1, products.bottom_decore_number, NULL), IF(top_texture_is_active = 1 AND top_texture_is_approved = 1, products.top_texture_abbreviation, NULL), IF(bottom_texture_is_active = 1 AND bottom_texture_is_approved = 1, products.bottom_texture_abbreviation, NULL)), products.core_material_title) AS product_title, decores.search_image AS image, IF(top_texture_is_active = 1 AND top_texture_is_approved = 1, products.top_texture_abbreviation, NULL) AS top_texture_abbreviation, IF(bottom_texture_is_active = 1 AND bottom_texture_is_approved = 1, products.bottom_texture_abbreviation, NULL) AS bottom_texture_abbreviation, IF(top_texture_is_active = 1 AND top_texture_is_approved = 1, products.top_texture_attached_image, NULL) AS top_texture_attached_image, IF(bottom_texture_is_active = 1 AND bottom_texture_is_approved = 1, products.bottom_texture_attached_image, NULL) AS bottom_texture_attached_image, IF(top_texture_is_active = 1 AND top_texture_is_approved = 1, textures_top.summary, NULL) AS top_texture_summary, IF(bottom_texture_is_active = 1 AND bottom_texture_is_approved = 1, textures_bottom.summary, NULL) AS bottom_texture_summary, IF(bottom_texture_is_active = 1 AND bottom_texture_is_approved = 1, textures_bottom.title, textures_top.title) as fullname FROM `products` INNER JOIN core_materials_i18n ON core_materials_i18n.i18n_foreign_key = products.core_material_id AND core_materials_i18n.i18n_country_language_id = products.i18n_country_language_id INNER JOIN categories ON categories.id = products.family_id LEFT JOIN categories AS product_collections ON product_collections.id = products.collection_id LEFT JOIN decores ON decores.id = products.top_decore_id LEFT JOIN decores_i18n ON decores_i18n.i18n_foreign_key = decores.id LEFT JOIN textures_i18n AS textures_top ON textures_top.i18n_foreign_key = products.top_texture_id AND textures_top.i18n_country_language_id = products.i18n_country_language_id LEFT JOIN textures_i18n AS textures_bottom ON textures_bottom.i18n_foreign_key = products.bottom_texture_id AND textures_bottom.i18n_country_language_id = products.i18n_country_language_id WHERE products.i18n_country_language_id = 43 AND decores_i18n.i18n_country_language_id = 43 AND core_materials_i18n.is_active = 1 AND core_materials_i18n.is_approved = 1 AND products.sku_is_active = 1 AND products.sku_is_approved = 1 AND products.category_is_active = 1 AND products.category_is_approved = 1 AND(products.family_id = 0 OR(products.family_is_active = 1 AND products.family_is_approved = 1))AND(products.collection_id = 0 OR(products.collection_is_active = 1 AND products.collection_is_approved = 1))AND((top_decore_id = 29 AND top_decore_is_active = 1 AND top_decore_is_approved = 1)OR(bottom_decore_id = 29 AND bottom_decore_is_active = 1 AND bottom_decore_is_approved = 1)) GROUP BY products.sku_id ORDER BY categories.lft ASC, product_collections.lft ASC
MySQL server has gone awaySELECT attached_files.file, projects_slider.image_id as id FROM attached_files INNER JOIN projects_slider ON projects_slider.image_id = attached_files.id AND attached_files.foreign_object = 'Projects' INNER JOIN projects_i18n ON projects_i18n.slider_id = projects_slider.slider_id INNER JOIN projects ON projects_i18n.i18n_foreign_key = projects.id WHERE projects_i18n.is_active = 1 AND projects_i18n.is_approved = 1 AND projects_i18n.i18n_foreign_key=46 AND projects_i18n.i18n_country_language_id=43 AND projects_slider.i18n_country_language_id=43 GROUP BY projects_slider.image_id
MySQL server has gone awaySELECT attached_files.file, projects_slider.image_id as id FROM attached_files INNER JOIN projects_slider ON projects_slider.image_id = attached_files.id AND attached_files.foreign_object = 'Projects' INNER JOIN projects_i18n ON projects_i18n.slider_id = projects_slider.slider_id INNER JOIN projects ON projects_i18n.i18n_foreign_key = projects.id WHERE projects_i18n.is_active = 1 AND projects_i18n.is_approved = 1 AND projects_i18n.i18n_foreign_key=72 AND projects_i18n.i18n_country_language_id=43 AND projects_slider.i18n_country_language_id=43 GROUP BY projects_slider.image_id
MySQL server has gone awaySELECT COUNT(*) AS agg_result FROM `news`INNER JOIN `news_i18n` ON (`news`.`id` = `news_i18n`.`i18n_foreign_key` AND `news_i18n`.`i18n_country_language_id` = 43) WHERE is_active = 1 AND is_approved = 1 LIMIT 1
MySQL server has gone away Search - Kronospan - Leading manufacturer of wood-based panels

{{country.title}}

{{country.title}}

{{locale.abbr}} {{locale.abbr}}

There are no results.

Portugal

en

Home / Search

Found 22 results for search term black

This website uses functional cookies and anonymous tracking technologies to assist with navigation and improve our marketing services. Please accept or refuse the saving of functional cookies by selecting one of the options. For more information, please read our Privacy policy

© Kronoplus Limited 2024

Sign up now to be the first to get notified of upcoming events, corporate news, new products and design trends.

I acknowledge and agree to Kronospan’s Terms and Conditions and Privacy Policy and to Kronospan's use of my contact information to communicate with me about its products, services or events.