SELECT formats.id AS format_id, formats.title AS format_title, GROUP_CONCAT( DISTINCT sizes.id ORDER BY sizes.ord ASC SEPARATOR ',' ) AS size_ids, GROUP_CONCAT( DISTINCT sizes.title ORDER BY sizes.ord ASC SEPARATOR '<->' ) AS size_titles FROM 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 = 90 AND families_i18n.is_approved = 1 AND families_i18n.is_active = 1 INNER JOIN ( products INNER JOIN ( sizes INNER JOIN sku_format_sizes ON sizes.id = sku_format_sizes.size_id INNER JOIN formats ON sku_format_sizes.format_id = formats.id ) ON products.sku_id = sku_format_sizes.sku_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 = 90 AND collections_i18n.is_approved = 1 AND collections_i18n.is_active = 1 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 = 90 AND collection_childs_i18n.is_approved = 1 AND collection_childs_i18n.is_active = 1 ) ON collections.id = collection_childs.parent_id ) ON products.collection_id = collections.id ) ON products.family_id = families.id AND products.i18n_country_language_id = 90 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.collection_id = 0 OR (products.collection_is_active = 1 AND products.collection_is_approved = 1)) WHERE families.parent_id = 6 AND EXISTS(SELECT 1 FROM decores_i18n INNER JOIN decores ON decores.id = decores_i18n.i18n_foreign_key INNER JOIN module_attributes ON module_attributes.foreign_class = 'decores' AND module_attributes.foreign_id = decores.id AND module_attributes.attribute_id = 210 WHERE decores_i18n.i18n_foreign_key IN(products.top_decore_id, products.bottom_decore_id) AND decores_i18n.i18n_country_language_id = 90 AND decores_i18n.is_active = 1 AND decores_i18n.is_approved = 1 AND EXISTS( SELECT 1 FROM collections INNER JOIN collections_i18n ON collections_i18n.i18n_foreign_key = collections.id INNER JOIN decores_collections ON decores_collections.collection_id = collections.id WHERE decores_collections.decore_id = decores_i18n.i18n_foreign_key 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))) ) GROUP BY families.id, collections.id, collection_childs.id, formats.id ORDER BY families.lft ASC, collections.lft ASC, collection_childs.lft ASC
Server shutdown in progressSELECT families.id AS family_id, families_i18n.title AS family_title, families.main_image AS family_pictogram, collections.id AS collection_id, collections_i18n.title AS collection_title, collections.main_image AS collection_pictogram, collection_childs.id AS collections_child_id, collection_childs_i18n.title AS collections_child_title, formats.id AS format_id, formats.title AS format_title, GROUP_CONCAT( DISTINCT sizes.id ORDER BY sizes.ord ASC SEPARATOR ',' ) AS size_ids, GROUP_CONCAT( DISTINCT sizes.title ORDER BY sizes.ord ASC SEPARATOR '<->' ) AS size_titles FROM 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 = 90 AND families_i18n.is_approved = 1 AND families_i18n.is_active = 1 INNER JOIN ( products INNER JOIN ( sizes INNER JOIN sku_format_sizes ON sizes.id = sku_format_sizes.size_id INNER JOIN formats ON sku_format_sizes.format_id = formats.id ) ON products.sku_id = sku_format_sizes.sku_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 = 90 AND collections_i18n.is_approved = 1 AND collections_i18n.is_active = 1 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 = 90 AND collection_childs_i18n.is_approved = 1 AND collection_childs_i18n.is_active = 1 ) ON collections.id = collection_childs.parent_id ) ON products.collection_id = collections.id ) ON products.family_id = families.id AND products.i18n_country_language_id = 90 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.collection_id = 0 OR (products.collection_is_active = 1 AND products.collection_is_approved = 1)) WHERE families.parent_id = 6 AND (families.id IN(1180) OR collections.id IN (1180) OR collection_childs.id IN (1180)) AND EXISTS(SELECT 1 FROM decores_i18n INNER JOIN decores ON decores.id = decores_i18n.i18n_foreign_key INNER JOIN module_attributes ON module_attributes.foreign_class = 'decores' AND module_attributes.foreign_id = decores.id AND module_attributes.attribute_id = 210 WHERE decores_i18n.i18n_foreign_key IN (714) AND decores_i18n.i18n_foreign_key IN(products.top_decore_id, products.bottom_decore_id) AND decores_i18n.i18n_country_language_id = 90 AND decores_i18n.is_active = 1 AND decores_i18n.is_approved = 1 AND EXISTS( SELECT 1 FROM collections INNER JOIN collections_i18n ON collections_i18n.i18n_foreign_key = collections.id INNER JOIN decores_collections ON decores_collections.collection_id = collections.id WHERE decores_collections.decore_id = decores_i18n.i18n_foreign_key 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))) ) GROUP BY families.id, collections.id, collection_childs.id, formats.id ORDER BY families.lft ASC, collections.lft ASC, collection_childs.lft ASC
MySQL server has gone awaySELECT 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 = 90 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 = 90 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 = 90 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 = 90 AND categories_i18n.i18n_country_language_id = 90 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
MySQL server has gone awaySELECT 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` = 90) 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 = 90 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` = 90) 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` = 90) WHERE is_active = 1 AND is_approved = 1 LIMIT 1
MySQL server has gone away Disponibilidad de stock - Kronodesign - Servicio Express - Kronospan
{{country.title}}
{{country.title}}
{{locale.abbr}} {{locale.abbr}}
No hay resultados.
Kronospan S.L.

Barrio de Castañares, s/n
09199 Burgos
Spain

phone

T +34 947 484 900

 phone

T +34 947 484 900

 phone

F +34 947 483 713

 phone

F +34 947 483 713

 email

sales@kronospan.es

 email

Ver en el mapa
Home / Servicio Express / Disponibilidad de stock - Kronodesign

Sin resultados
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.
Rechazar cookies
Aceptar cookies