SELECT 
  *, 
  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 = 944 
  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 = 944 
  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.00037

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 name object_id type dispatch path seo_name seo_path
944 412 412/944 2 1 0 A 13 330 1736377200 0 N N 0 N 0 default 0 N en High pivot <p>Looking for roof windows that offer maximum freedom and comfort without restricting space in the room? Choose roof windows with a high pivot – an innovative solution that combines the advantages of center-pivot windows with increased functionality. Thanks to the special design, the sash's pivot point is positioned above the center of the window, allowing convenient access to the open window and a panoramic view.</p> <p><strong>Advantages of&nbsp;High Pivot Roof Windows:</strong></p> <p>✅ <strong>More Space and Freedom of Movement:</strong> Due to the high pivot point, the window sash protrudes less into the room when opened, providing more freedom of movement and making the space under the window optimally usable. This is the ideal solution for rooms where every centimeter counts.<br /> ✅ <strong>Unrestricted View:</strong> The special construction of the window allows for an unobstructed view and lets more fresh air into the room.<br /> ✅ <strong>Convenient Operation:</strong> Roof windows with a high pivot point are usually equipped with a handle in the lower area of the sash, which makes opening and closing easier regardless of the installation height.<br /> ✅ <strong>Safe Cleaning:</strong> The locking mechanism that fixes the sash in the cleaning position ensures safe and convenient cleaning of the outside of the window from the inside.<br /> ✅ <strong>Available in Various Materials:</strong> Roof windows with a high pivot point are available in both wood and PVC versions, so they can be adapted to individual preferences and budgets.</p> high pivot roof windows, roof windows with high pivot point, top-hung roof windows, space saving roof windows, easy clean roof windows, panoramic view roof windows, loft windows, attic windows, roof window installation, roof window maintenance Discover high pivot roof windows for unobstructed views, easy cleaning, and maximum space efficiency. Perfect for attics and lofts. Browse our selection! High Pivot Roof Windows: Maximize Space & Views High Pivot Roof Windows: Panoramic Views, Easy Cleaning, and Space Efficiency high-pivot 944 c 412 high-pivot 412