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 = 897 
  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 = 897 
  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.00065

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
897 412 412/897 2 1 0 A 0 700 1619128800 0 N N 0 N 0 default 0 N en Roof Window Accessories <p>Accessories for roof windows, such as blinds, awnings, insect screens and control elements, make it possible to adapt the functionality and aesthetics of every attic room. We offer a wide selection of accessories that not only increase comfort, but also improve energy efficiency, privacy and security.</p> <p><strong>How to choose the right accessories for roof windows?</strong></p> <ol> <li><strong>Blackout blinds:</strong> Ideal for bedrooms and rooms that require complete darkness. They block almost 100% of the incident light and offer full control over the brightness to create ideal conditions for sleep and relaxation, even during the day. They also change the style of your interior, as they are available in many colors and patterns.</li> <li><strong>Decorative blinds:</strong> If you only want a subtle dimming, protection from prying eyes and an improvement in the aesthetics of the room, a decorative blind is the best choice. Available in various colors and patterns, they match any interior design.</li> <li><strong>Awnings:</strong> To effectively lower the temperature in the attic and increase protection from the sun, especially on hot days, awnings are the best choice. They are mounted on the outside of the window and form a barrier to the sun's rays before they reach the glass, which significantly reduces the heating of the rooms. Unlike external roller shutters, awnings do not completely darken the room, but allow fresh air to circulate and allow a view to the outside.</li> <li><strong>External roller shutters:</strong> Roller shutters are a versatile solution that not only offers protection from sun and heat, but also additional thermal and sound insulation and more security. They are mounted on the outside of the window and provide effective protection against weather conditions, noise and potential break-ins.</li> <li><strong>Insect screens:</strong> Indispensable for enjoying fresh air without worrying about insects. They effectively protect against mosquitoes, flies and other insects.</li> <li><strong>Control elements:</strong> Rods, electric and solar-powered drives make it easier to operate windows, especially in hard-to-reach places.</li> </ol> <p><strong>Advantages of accessories for roof windows:</strong></p> <p>✅ <strong>Thermal comfort:</strong> Protection from the sun and heat loss.<br /> ✅ <strong>Light control:</strong> Precise regulation of the amount of light in the room.<br /> ✅ <strong>Privacy:</strong> Protection from prying eyes.<br /> ✅ <strong>Protection from insects:</strong> Peaceful sleep with the window open<br /> ✅ <strong>Easy operation:</strong> Thanks to the right accessories.<br /> ✅ <strong>Aesthetics:</strong> Improvement of the room design.<br /> ✅ <strong>Security:</strong> Protection against break-ins (with certain external roller shutters).</p> <p><strong>It is crucial to select the accessories according to the manufacturer and size designation of the roof window, e.g. OptiLight 78x118 or RoofLITE+ M6A.</strong></p> <p><strong>Avoid measuring windows and panes – always use the type plate to select the appropriate product.</strong>&nbsp;</p> Roof window accessories, blinds, awnings, insect screens, roof windows, attic, comfort, energy efficiency, privacy, security, control elements Discover a wide range of roof window accessories to enhance your attic space. Shop blinds, awnings, insect screens, and more for improved comfort and functionality. Accessories for Roof Windows | Blinds, Awnings and more Accessories for Roof Windows – Comfort and Functionality at a Glance accessories 412