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 = 90 AND decores_i18n.i18n_country_language_id = 90 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 = 610 AND top_decore_is_active = 1 AND top_decore_is_approved = 1)OR(bottom_decore_id = 610 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
Table 'krono_ver3.textures_i18n' doesn't existSELECT products.sku_id, GROUP_CONCAT(DISTINCT sizes.title) AS size, GROUP_CONCAT(DISTINCT formats.title) AS format, sku_format_sizes.availability, core_materials_i18n.summary, core_materials_i18n.title, core_materials.main_image as image, categories_i18n.title AS category_title, categories.main_image AS pictogram, products.core_material_id as id, products.family_id, products.collection_id, products.category_id, core_materials_i18n.slug, 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 top_texture_abbr, products.top_decore_number, decores_i18n.title as top_decore_title, products.bottom_decore_number FROM `products` INNER JOIN sku_format_sizes ON products.sku_id = sku_format_sizes.sku_id INNER JOIN sizes ON sku_format_sizes.size_id = sizes.id INNER JOIN formats ON sku_format_sizes.format_id = formats.id INNER JOIN core_materials_i18n ON products.core_material_id = core_materials_i18n.i18n_foreign_key AND products.i18n_country_language_id = core_materials_i18n.i18n_country_language_id INNER JOIN core_materials ON core_materials_i18n.i18n_foreign_key = core_materials.id INNER JOIN categories_i18n ON core_materials.family_id = categories_i18n.i18n_foreign_key AND products.i18n_country_language_id = categories_i18n.i18n_country_language_id INNER JOIN categories ON categories_i18n.i18n_foreign_key = categories.id LEFT JOIN textures AS topt ON products.top_texture_id = topt.id LEFT JOIN textures_i18n AS ti18nt ON topt.id = ti18nt.i18n_foreign_key AND products.i18n_country_language_id = ti18nt.i18n_country_language_id INNER JOIN decores_i18n ON products.top_decore_id = decores_i18n.i18n_foreign_key AND products.i18n_country_language_id = decores_i18n.i18n_country_language_id WHERE products.i18n_country_language_id = 90 AND products.sku_is_active = 1 AND (products.top_decore_id = 610 OR products.bottom_decore_id = 610) GROUP BY products.core_material_id ORDER BY categories.lft, sku_id
Table 'krono_ver3.sku_format_sizes' doesn't existSELECT decores.id, decores_collections.collection_id, decores.number, decores_i18n.summary, related_decore_combination_decores.is_inspirational, CONCAT(decores.number, ' ', decores_i18n.title) AS title, GROUP_CONCAT(DISTINCT related_decore_combination_files.file) AS inspiration_images, IF(decores.number = products.top_decore_number, products.top_decore_attached_image, products.bottom_decore_attached_image) AS image FROM `decore_combinations`INNER JOIN `decore_combinations_i18n` ON (`decore_combinations`.`id` = `decore_combinations_i18n`.`i18n_foreign_key` AND `decore_combinations_i18n`.`i18n_country_language_id` = 90) INNER JOIN related_decore_combination_decores ON related_decore_combination_decores.decore_combination_id = decore_combinations.id INNER JOIN decores ON decores.id = related_decore_combination_decores.decore_id INNER JOIN decores_i18n ON decores_i18n.i18n_foreign_key = decores.id AND decores_i18n.i18n_country_language_id = decore_combinations_i18n.i18n_country_language_id INNER JOIN decores_collections ON decores_collections.decore_id = decores.id AND EXISTS( SELECT 1 FROM collections INNER JOIN collections_i18n ON collections_i18n.i18n_foreign_key = collections.id WHERE collections.id = decores_collections.collection_id AND collections_i18n.is_active = 1 AND collections_i18n.is_approved = 1 AND collections_i18n.i18n_country_language_id = decores_i18n.i18n_country_language_id AND !EXISTS( SELECT 1 FROM collections c2 INNER JOIN collections_i18n c2_i18n ON c2_i18n.i18n_foreign_key = c2.id WHERE c2.lft < collections.lft AND c2.rght > collections.rght AND c2.parent_id <> 0 AND c2_i18n.i18n_country_language_id = collections_i18n.i18n_country_language_id AND (c2_i18n.is_active = 0 OR c2_i18n.is_approved = 0) ) ) INNER JOIN products ON (products.top_decore_id = decores.id OR products.bottom_decore_id = decores.id) AND products.i18n_country_language_id = decore_combinations_i18n.i18n_country_language_id AND products.decore_collection_id = decores_collections.collection_id INNER JOIN related_decore_combination_files ON related_decore_combination_files.decore_combination_id = decore_combinations.id WHERE EXISTS(SELECT 1 FROM related_decore_combination_decores WHERE related_decore_combination_decores.decore_combination_id = decore_combinations.id AND related_decore_combination_decores.decore_id = 610)AND decore_combinations_i18n.is_active = 1 AND decore_combinations_i18n.is_approved = 1 AND decores_i18n.is_active = 1 AND decores_i18n.is_approved = 1 AND products.sku_is_active = 1 AND products.sku_is_approved = 1 AND products.core_material_is_active = 1 AND products.core_material_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 decores.id <> 610 GROUP BY related_decore_combination_decores.decore_id ORDER BY decores_i18n.order_weight ASC
Table 'krono_ver3.related_decore_combination_decores' doesn't existSELECT projects_i18n.title, projects_i18n.i18n_foreign_key AS project_id, attached_files.file as image, slug FROM projects_slider_slides INNER JOIN projects_slider ON projects_slider_slides.slide_id = projects_slider.image_id INNER JOIN projects_i18n ON projects_slider.i18n_country_language_id = projects_i18n.i18n_country_language_id AND projects_slider.slider_id = projects_i18n.slider_id INNER JOIN attached_files ON projects_slider.image_id = attached_files.id AND projects_slider.i18n_country_language_id = attached_files.i18n_country_language_id WHERE projects_slider_slides.decore_id = 610 AND projects_slider.i18n_country_language_id = 90 AND attached_files.foreign_object = 'Projects' GROUP BY project_id
Table 'krono_ver3.projects_slider_slides' doesn't existSELECT 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 = 90 AND decores_i18n.i18n_country_language_id = 90 AND products.sku_has_sample = 1 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 = 610 AND top_decore_is_active = 1 AND top_decore_is_approved = 1)OR(bottom_decore_id = 610 AND bottom_decore_is_active = 1 AND bottom_decore_is_approved = 1)) GROUP BY products.top_texture_abbreviation ORDER BY products.sku_id LIMIT 10
Table 'krono_ver3.textures_i18n' doesn't exist AL03 Brushed Inox - Metal - Kronodesign - Diseños - Kronospan

AL03 Brushed Inox

Otros colores:
Otros colores:

Brushed Inox es un diseño metálico sofisticado y elegante con un aspecto fresco y urbano. Tiene un encanto moderno y combina perfectamente con materiales como la madera, la piedra, el vidrio y la cerámica. La textura cepillada crea un efecto óptico muy especial y una auténtica sensación de metal finamente lijado.

Tipo de diseño
  • Gris
  • Metálico
  • Colección del diseño
  • Metal
  • Este sitio web emplea cookies funcionales y tecnologías de rastreo anómimo para mejorar la navegación y mejorar nuestros servicios de marketing. Por favor acepte o rechace el uso de cookies funcionales escogiendo una de las opciones. Para más información, por favor lea nuestra Política de Privacidad.