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 = 926 
  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 = 926 
  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 = 2

Query time 0.00036

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
926 261 261/926 2 2 0 A 7 30 1736290800 0 N N 0 N 0 default 0 N en OptiLight (FAKRO Group) <p>OptiLight roof windows are the ideal solution for those looking for solid and functional roof windows at an attractive price. Manufactured by Kronmat (FAKRO Group), OptiLight windows combine modern technology with attention to detail, providing comfort and energy efficiency. They are the perfect choice for customers who value good value for money.</p> <p><strong>Advantages of OptiLight roof windows:</strong></p> <p><strong>✅ Quality guaranteed by Kronmat (FAKRO Group):</strong> OptiLight is a brand of Kronmat, a member of the FAKRO Group, one of the leading roof window manufacturers worldwide. This is a guarantee of high quality and solid workmanship.<br /> <strong>✅ Energy-saving glazing units:</strong> OptiLight windows are equipped with energy-saving glazing units (including double-chamber triple glazing), which ensure good thermal insulation, minimize heat loss and reduce heating costs.<br /> <strong>✅ Attractive price:</strong> OptiLight offers roof windows with a very good price-performance ratio and is a competitive alternative to more expensive brands.<br /> <strong>✅ Modern technology and precise workmanship:</strong> Modern production technology and processing of elements as well as strict quality control at every stage of production guarantee the high quality and durability of OptiLight windows.<br /> <strong>✅ Wide range of FAKRO accessories for OptiLight windows:</strong> OptiLight roof windows are compatible with a wide range of FAKRO accessories, including internal and external accessories such as roller blinds, venetian blinds, pleated blinds, mosquito nets and awnings, up to electric and solar-powered external roller shutters. This wide selection of types and colors allows for full personalization of the windows and their adaptation to the individual needs of each customer.</p> Roof windows, OptiLight, windows, Kronmat, FAKRO, window manufacturers, affordable, high-quality, energy-efficient, accessories, roller blinds, venetian blinds, pleated blinds, mosquito nets, awnings, prices, quality, comfort, durability Discover high-quality OptiLight roof windows from Kronmat (FAKRO Group) at attractive prices. Energy-efficient windows with a wide range of accessories. Learn more! OptiLight Roof Windows - Affordable & High-Quality | byggbaY.se Roof Windows by OptiLight - Attractive Prices & FAKRO Quality optilight-en 261