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 = 1 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 = 1 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 = 1 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 = 1 AND categories_i18n.i18n_country_language_id = 1 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` = 1) 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 = 1 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` = 1) 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` = 1) WHERE is_active = 1 AND is_approved = 1 LIMIT 1
MySQL server has gone away Disponibilités des stocks - Kronodesign - Service express - Kronospan
{{country.title}}
{{country.title}}
{{locale.abbr}} {{locale.abbr}}
Pas de résultat trouvé
Kronospan Trading SRL

Str. Mihail Kogalniceanu Nr.59
Romania 515800 Sebes, Alba county

phone

T +40 258 80 11 00

 phone

T +40 258 80 11 00

 phone

F +40 258 80 11 99

 phone

F +40 258 80 11 99

 email

sales.sebes@kronospan.ro

 email

Voir sur la carte
Home / Service express / Disponibilités des stocks - Kronodesign

Produit 2
Sélécteur de décors 5
Réinitialiser
  1. Tous les stratifiés (HPL) pour les décors Mirror Gloss (MG) sont livrés en finition SQ.
  2. Le LHDF est livré en texture PE.

En stockEn stock

Sur demandeSur demande

Disponible sous 7 joursDisponible sous 7 jours

Formats (mm) Épaisseur (mm)
MF Boards
mf-boards_24x24_crop_478b24840a
MF PB
2800x2070
810121618222528
Brown
k2739_70x45_crop_478b24840a K2739 PW Cannolo Cremona Oak                
Ce site utilise des cookies fonctionnels et des technologies de suivi anonymes pour faciliter la navigation et améliorer nos services marketing. Veuillez accepter ou refuser l'enregistrement des cookies fonctionnels en sélectionnant l'une des options. Pour plus d'informations, veuillez lire notre Politique de confidentialité.
Refuser les cookies
Accepter les cookies