SELECT 
  cscart_pages.*, 
  cscart_page_descriptions.*, 
  cscart_seo_names.name as seo_name, 
  cscart_seo_names.path as seo_path 
FROM 
  cscart_pages 
  INNER JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id 
  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id 
  AND cscart_seo_names.type = 'a' 
  AND cscart_seo_names.dispatch = '' 
  AND cscart_seo_names.lang_code = 'en' 
  INNER JOIN cscart_ult_objects_sharing ON (
    cscart_ult_objects_sharing.share_object_id = cscart_pages.page_id 
    AND cscart_ult_objects_sharing.share_company_id = 2 
    AND cscart_ult_objects_sharing.share_object_type = 'pages'
  ) 
WHERE 
  cscart_pages.page_id = 110 
  AND cscart_page_descriptions.lang_code = 'en' 
  AND (
    cscart_pages.usergroup_ids = '' 
    OR FIND_IN_SET(0, cscart_pages.usergroup_ids) 
    OR FIND_IN_SET(1, cscart_pages.usergroup_ids)
  ) 
  AND cscart_pages.page_type IN ('T', 'L', 'B', 'F')

Query time 0.00072

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_pages const PRIMARY PRIMARY 3 const 1
1 SIMPLE cscart_page_descriptions const PRIMARY PRIMARY 9 const,const 1
1 SIMPLE cscart_ult_objects_sharing const PRIMARY PRIMARY 159 const,const,const 1 Using index
1 SIMPLE cscart_seo_names ref PRIMARY,dispatch PRIMARY 206 const,const,const,const 2 Using where

Result

page_id company_id parent_id id_path status page_type position timestamp usergroup_ids localization new_window use_avail_period avail_from_timestamp avail_till_timestamp facebook_obj_type staff_notes lang_code page description meta_keywords meta_description page_title link custom_header seo_name seo_path
110 2 109 109/110 A B 0 1621461600 0 0 N 0 0 activity en Window condensation <p style="text-align: justify;">Few words about condensation</p> <p style="text-align: center;"><img src="https://d2d2yzufo5fwh3.cloudfront.net/images/blog/23/dachfenster-im-winter-02.jpg?t=1514024743" style="width: 350px; height: 300px;" /><img alt="" src="https://d2d2yzufo5fwh3.cloudfront.net/images/blog/condensat_roof_window.jpg" style="height: 300px; width: 350px;" /></p> <p style="text-align: justify;">A common problem with windows is so called <strong>"sweating window"</strong>, it mainly occurs on roof windows. Because they are mounted on the roof, they are particularly exposed to environmental impacts such as rain, hail and temperature changes. How it occurs? When a hot, humid air hits the cold window, it cools down and some of the moisture condenses on the window (the transition from steam to water is called condensation). The better the insulation in the attic, the higher the condensation level. Despite of the water vapor diffusion in the insulation layer, water vapor stays in the room / attic. Both new buildings and old but well-renovated buildings are particularly tight nowadays, which is of course good for the energy balance, but not perfect for the indoor climate. This means that moisture generated inside cannot escape.</p> <p style="text-align: justify;">A small amount of water vapor, which mainly settles on the glass and the surrounding elements, can be considered as a normal process. However, if you find that your window is filled with water vapor between the windows, it means that the window has lost its heat-insulating properties and must be replaced.</p> <p style="text-align: justify;">Especially during the winter season, you can see that small drops of water form not only on the window but also on the window frame. Condensation occurs mainly after activities that cause a high moisture level, e.g. cooking, washing or showering. This means that humidity plays an important role in counteracting condensation. It is known that water always arises where the warm, humid air meets a cold surface. As a result of the cooling, the air can retain less moisture, so that an excess is condensed and in the form of water droplets appears on the cold surface. The room temperature therefore plays an important role, as does the temperature difference between inside and outside. If the temperature differences are higher than 20 ° C and the humidity is above 60%, condensation occurs. Condensation occurs mainly during the colder season when the temperature differences between day and night are extremely high. When the air is heated, the condensation evaporates. If there are other factors, such as a lot of snow on the windows, in extreme situations it can even lead to condensation freezing on the inside of the frame and damaging the structure, especially wooden windows.</p> <p style="text-align: justify;">In general, condensate is not harmful. There are two areas where condensation can have a negative impact though:</p> <ul> <li>On the one hand, it stays on window's elements - wood is of course particularly sensitive here - but also the cladding around the window, which is often made of plasterboard. Moisture cam create the mold on such surfaces and destroy them.</li> <li>The second area is the health of the inhabitants. Living in a humid environment can lead to coughing and shortness of breath. And once mold occurs, there are other negative effects on health e.g. allergic reaction.</li> </ul> <h2>How to stop condensation on windows?:</h2> <ul> <li><strong>Short-term ventilation </strong>- the windows should be fully opened 3-5 times every day for 10-15 minutes at a time. If there is a possibility to do a draft, it is even better. To do this, simultaneously open two roof winows that are placed opposite each other. In this way, you can quickly achieve an air exchange with minimal heat loss.</li> <li><strong>Windows with natural ventilatio</strong>n - this allows a constant air exchange between the damp inside with fresh outdoor air even when the window is closed.</li> <li><strong>Keep the room temperature as constant as possible throughout the day.</strong> Recommended temperatures: bedroom 18 ° C, children's room, bathroom 23 ° C, basement - not less than 15 ° C. The humidity should be between 40-60% in the apartment and up to 70% in the bathroom.</li> <li><strong>Regularly remove condensate</strong> / water vapour to prevent mold.</li> <li><strong>Location of radiators</strong>. It is recommended to install a radiator under each window. There should be a distance of at least 10 cm between the window sill and the radiator to ensure the hot air circulation. In this way, the extreme cooling of the window glass can be avoided and the risk of water vapour occurance reduced. In addition, the rising hot air absorbs already accumulated condensation and ensures faster drying.</li> <li><strong>Avoid humidifiers and water vaporizers on radiators if possible</strong>.</li> <li>When cooking and showering, <strong>open the windows</strong> so that the moisture can be released immediately. At the same time, keep the interior doors closed so that moisture cannot spread to other rooms.</li> <li><strong>Do not dry laundry in the living room</strong> to not to increase the humidity.</li> <li>Particular attention should be paid to the "sources of moisture" in the room, especially in winter. This means that temporary activities such as cooking or showering, high presence in the home also increase the humidity, as well as plants or pets. So it is better to divide such sources, especially in winter.</li> </ul> sweatting windows, moisture in the room, water on the windows, condensation, Controlling Your Home's Humidity Is the condensation a normal process? How to deal with sweatting windows? kondens-paa-takfoenster-en 109