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 = 1 AND products.sku_is_active = 1 AND (products.top_decore_id = 601 OR products.bottom_decore_id = 601) GROUP BY products.core_material_id ORDER BY categories.lft, sku_id
Server shutdown in progressSELECT assigned_to_decore_id AS id, decores_collections.collection_id, decores.number, decores_i18n.summary, products.core_material_main_image, products.top_decore_attached_image AS main_image, decores.border_around_image as border, CONCAT(decores.number, ' ', GROUP_CONCAT(DISTINCT CONCAT_WS('/', products.top_texture_abbreviation, products.bottom_texture_abbreviation) SEPARATOR '/'), ' ', decores_i18n.title) AS title FROM `decores`INNER JOIN `decores_i18n` ON (`decores`.`id` = `decores_i18n`.`i18n_foreign_key` AND `decores_i18n`.`i18n_country_language_id` = 1) INNER JOIN decores_decores ON decores.id = decores_decores.assigned_to_decore_id INNER JOIN decores_collections ON decores_collections.decore_id = decores.id AND decores_collections.collection_id = 97 INNER JOIN products ON products.top_decore_id = decores.id AND products.i18n_country_language_id = decores_i18n.i18n_country_language_id AND products.decore_collection_id = decores_collections.collection_id WHERE decores_decores.decore_id = 601 AND(decores_i18n.is_active = 1 AND decores_i18n.is_approved = 1) GROUP BY decores.id ORDER BY decores_i18n.order_weight ASC
MySQL server has gone awaySELECT decores.id, decores_decores.id as ord, assigned_to_decore_id, title as name, CONCAT(number, ' - ', title) AS title, decores.search_image AS image, decores_collections.collection_id, decores.number FROM `decores`INNER JOIN `decores_i18n` ON (`decores`.`id` = `decores_i18n`.`i18n_foreign_key` AND `decores_i18n`.`i18n_country_language_id` = 1) INNER JOIN decores_decores ON decores.id = decores_decores.assigned_to_decore_id LEFT JOIN attached_files ON attached_files.foreign_object_id = decores.id AND attached_files.foreign_object='Decore' AND attached_files.i18n_country_language_id = decores_i18n.i18n_country_language_id INNER JOIN decores_collections ON decores.id = decores_collections.decore_id WHERE decores_decores.decore_id = 601 GROUP BY decores.id ORDER BY ord ASC
MySQL server has gone awaySELECT 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` = 1) 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 = 601)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 <> 601 GROUP BY related_decore_combination_decores.decore_id ORDER BY decores_i18n.order_weight ASC
MySQL server has gone awaySELECT download_category_materials.id, download_category_materials_i18n.title, download_category_materials_i18n.doc_type, download_category_materials_i18n.file, download_category_materials_i18n.main_image, download_category_materials_i18n.description FROM decores_download_category_materials INNER JOIN download_category_materials ON decores_download_category_materials.download_category_material_id = download_category_materials.id INNER JOIN download_category_materials_i18n ON download_category_materials.id = download_category_materials_i18n.i18n_foreign_key AND decores_download_category_materials.i18n_country_language_id = download_category_materials_i18n.i18n_country_language_id WHERE decores_download_category_materials.decore_id = 601 AND decores_download_category_materials.i18n_country_language_id =1
MySQL server has gone awaySELECT 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 = 601 AND projects_slider.i18n_country_language_id = 1 AND attached_files.foreign_object = 'Projects' GROUP BY project_id
MySQL server has gone awaySELECT * FROM `decores`INNER JOIN `decores_i18n` ON (`decores`.`id` = `decores_i18n`.`i18n_foreign_key` AND `decores_i18n`.`i18n_country_language_id` = 1) WHERE `decores`.`id`=601 LIMIT 1
MySQL server has gone away