SELECT 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 = 633 OR products.bottom_decore_id = 633) 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 = 633)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 <> 633 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 = 633 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 = 633 AND top_decore_is_active = 1 AND top_decore_is_approved = 1)OR(bottom_decore_id = 633 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
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.