SELECT products.core_material_id AS id,products.core_material_title as title,products.core_material_slug AS slug,products.category_id,products.family_id as family_id,products.collection_id as collection_id,products.i18n_country_language_id,products.core_material_main_image AS main_image,core_materials_i18n.summary AS summary,core_materials_i18n.description_s AS description_s,core_materials_i18n.description_m AS description_m,categories_i18n.title as category_name FROM products INNER JOIN core_materials ON core_materials.id = products.core_material_id 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_i18n ON categories_i18n.i18n_foreign_key = products.family_id INNER JOIN ( categories AS families INNER JOIN categories_i18n AS families_i18n ON families_i18n.i18n_foreign_key = families.id AND families_i18n.i18n_country_language_id = 127 AND families_i18n.is_approved = 1 AND families_i18n.is_active = 1 ) ON products.family_id = families.id LEFT JOIN ( categories AS collections INNER JOIN categories_i18n AS collections_i18n ON collections_i18n.i18n_foreign_key = collections.id AND collections_i18n.i18n_country_language_id = 127 AND collections_i18n.is_approved = 1 AND collections_i18n.is_active = 1 ) ON products.collection_id = collections.id LEFT JOIN ( categories AS collection_childs INNER JOIN categories_i18n AS collection_childs_i18n USE INDEX FOR JOIN (`categories_i18n_foreign_key_country_language_id_uk`) ON collection_childs_i18n.i18n_foreign_key = collection_childs.id AND collection_childs_i18n.i18n_country_language_id = 127 AND collection_childs_i18n.is_approved = 1 AND collection_childs_i18n.is_active = 1 ) ON collections.id = collection_childs.parent_id WHERE 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.i18n_country_language_id = 127 AND categories_i18n.i18n_country_language_id = 127 AND core_materials_i18n.is_active = 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 products.category_id = 6 GROUP BY products.core_material_id ORDER BY families.lft ASC, collections.lft ASC, collection_childs.lft ASC, core_materials.weight DESC, products.core_material_id ASC
Server shutdown in progressSELECT decores_i18n.i18n_foreign_key AS id, decores_i18n.title, decores.search_image, decores.number FROM `decores`INNER JOIN `decores_i18n` ON (`decores`.`id` = `decores_i18n`.`i18n_foreign_key` AND `decores_i18n`.`i18n_country_language_id` = 127) INNER JOIN products ON products.top_decore_id = decores.id WHERE products.sku_is_active = 1 AND products.sku_is_approved = 1 AND products.core_material_is_active = 1 AND products.family_is_active = 1 AND decores_i18n.is_active = 1 AND decores_i18n.is_approved = 1 AND products.category_id = 6 AND products.i18n_country_language_id = 127 GROUP BY decores.id
MySQL server has gone awaySELECT * FROM `core_materials`INNER JOIN `core_materials_i18n` ON (`core_materials`.`id` = `core_materials_i18n`.`i18n_foreign_key` AND `core_materials_i18n`.`i18n_country_language_id` = 127) WHERE 15 LIMIT 1
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` = 127) WHERE is_active = 1 AND is_approved = 1 LIMIT 1
MySQL server has gone away Disponibilidade de stock - Kronodesign - Serviço Expresso - Kronospan
{{country.title}}
{{country.title}}
{{locale.abbr}} {{locale.abbr}}
Não existem resultados.
Home / Serviço Expresso / Disponibilidade de stock - Kronodesign

Produto 2
Seletor de decoração 5
Limpar tudo
  1. HPL para todas as cores Mirror Gloss (MG) são entregues em textura SQ.
  2. LHDF e entrgue em textura PE

Em StockEm Stock

Sob pedidoSob pedido

Disponível em 7 diasDisponível em 7 dias

Formato (mm) Espessura (mm)
HPL
hpl_24x24_crop_478b24840a
HPL Standard
3050x1320
0.8
Beje
K535_70x45_crop_478b24840a K535 RW Gold Baroque Oak  
Este Website usa cookies e outras tecnologias de assistencia à navegaçao e á sua capacidade de respostas, analisando a sua utilizaçao dos nossos serviços e productos, assistir com o nosso esforço de marketing e fornecer conteúdos por parte de terceiros. Para mais informaçao, leia a nossa Politica de Privacidade.
Refuse cookies
Aceitar cookies