SELECT 
  cscart_categories.*, 
  cscart_category_descriptions.*, 
  cscart_seo_names.name as seo_name, 
  cscart_seo_names.path as seo_path 
FROM 
  cscart_categories 
  LEFT JOIN cscart_category_descriptions ON cscart_category_descriptions.category_id = cscart_categories.category_id 
  AND cscart_category_descriptions.lang_code = 'en' 
  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 947 
  AND cscart_seo_names.type = 'c' 
  AND cscart_seo_names.dispatch = '' 
  AND cscart_seo_names.lang_code = 'en' 
  AND cscart_seo_names.company_id = cscart_categories.company_id 
WHERE 
  cscart_categories.category_id = 947 
  AND (
    cscart_categories.usergroup_ids = '' 
    OR FIND_IN_SET(
      0, cscart_categories.usergroup_ids
    ) 
    OR FIND_IN_SET(
      1, cscart_categories.usergroup_ids
    )
  ) 
  AND cscart_categories.company_id = 1

Query time 0.00043

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_categories const PRIMARY,c_status,p_category_id,idx_category_id PRIMARY 3 const 1
1 SIMPLE cscart_category_descriptions const PRIMARY PRIMARY 9 const,const 1
1 SIMPLE cscart_seo_names const PRIMARY,dispatch PRIMARY 210 const,const,const,const,const 1

Result

category_id parent_id id_path level company_id usergroup_ids status product_count position timestamp size_chart_id is_op localization age_verification age_limit parent_age_verification parent_age_limit selected_views default_view product_details_view product_columns is_trash staff_notes action lang_code category description meta_keywords meta_description page_title age_warning_message custom_header seo_name seo_path
947 412 412/947 2 1 0 A 20 420 1736377200 0 N N 0 N 0 default 0 N en Installation accessories <p>The professional and absolutely tight installation of a roof window is the basis for a permanently comfortable attic. If you value long-term protection of roof windows and the roof, then investing in installation accessories that provide an optimal connection of the window to the roof surface is worthwhile. In addition to the necessary elements that ensure a tight connection to the roof structure and the effective drainage of moisture, there are also optional installation accessories. This helps in particular to minimize the risk of thermal bridges. We offer a wide selection of accessories that facilitate installation, provide thermal and vapor barrier insulation. Ready-made sets additionally simplify the work of the roofer. By choosing suitable installation accessories, you invest in the longevity, safety, and comfort of using roof windows for many years.</p> <p><strong>Advantages of using installation accessories:</strong></p> <p>✅ <strong>Tight connection to the roof:</strong> Sealing frames and vapor barrier film create a protective barrier against water, wind, and snow, preventing leaks and moisture in the attic.<br /> ✅ <strong>Thermal and vapor barrier insulation:</strong> Insulation sets, sealing tapes, and vapor barrier films reduce heat loss and prevent the condensation of water vapor within the roof structure, which increases thermal comfort and prevents the growth of mold.<br /> ✅ <strong>Compatibility with various window types:</strong> We offer installation accessories that are compatible with various roof windows.</p> <p><strong>Types of installation accessories available on our website:</strong></p> <ul> <li><strong>Insulation sets:</strong> (e.g., XDP, XDK) – contain insulating materials such as sheep's wool, Styrofoam, or polyurethane foam, as well as vapor barrier films.</li> <li><strong>Sealing tapes:</strong> (e.g., XWT Plus) – additional thermal insulation around the window frame.</li> <li><strong>Vapor barrier and vapor-permeable films:</strong> – protect the roof structure from moisture.</li> </ul> Roof window installation accessories, roof windows, window installation, window insulation, window sealing, insulation kits, sealing tapes, insulation films, vapor barrier films, sheep's wool, Styrofoam, polyurethane foam, Insulation sets, Sealing tapes, The professional and tight installation of a roof window is essential. We offer a wide selection of installation accessories, insulation, and sealing kits. Check out our offer! Roof Window Installation Accessories | Insulation & Sealing Installation accessories: Roof Window Insulation and Sealing Kits installation-accessories 412