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 = 853 AND top_decore_is_active = 1 AND top_decore_is_approved = 1)OR(bottom_decore_id = 853 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 = 853 OR products.bottom_decore_id = 853) GROUP BY products.core_material_id ORDER BY categories.lft, sku_id Table 'krono_ver3.sku_format_sizes' 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 = 853 AND top_decore_is_active = 1 AND top_decore_is_approved = 1)OR(bottom_decore_id = 853 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
Minstrel Oak presenta un color marrón terroso e intenso con varios tonos y tintes. El diseño se asemeja a la pátina natural de la madera cuando se expone a las condiciones meteorológicas a lo largo del tiempo. Combina bien con estilos de diseño tipo rústicos, casas de campo o costeros.
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.