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 = 45 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 = 45 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 = 45 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 = 45 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 = 45 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 = 45 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 = 45 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 = 45 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 = 45 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(1198) OR collections.id IN (1198) OR collection_childs.id IN (1198)) 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 (611) AND decores_i18n.i18n_foreign_key IN(products.top_decore_id, products.bottom_decore_id) AND decores_i18n.i18n_country_language_id = 45 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 = 45 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 = 45 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 = 45 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 = 45 AND categories_i18n.i18n_country_language_id = 45 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` = 45) 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 = 45 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` = 45) 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` = 45) WHERE is_active = 1 AND is_approved = 1 LIMIT 1
MySQL server has gone away Stock Availability - Kronodesign - Express Services - Kronospan - Leading manufacturer of wood-based panels
{{country.title}}
{{country.title}}
{{locale.abbr}} {{locale.abbr}}
There are no results.
Home / Express Services / Stock Availability - Kronodesign

No results
This website uses functional cookies and anonymous tracking technologies to assist with navigation and improve our marketing services. Please accept or refuse the saving of functional cookies by selecting one of the options. For more information, please read our Privacy policy
Refuse cookies
Accept Cookies