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 = 260 
  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 = 260 
  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.00040

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
260 0 260 1 2 0 A 0 60 1337983200 0 N N 0 N 0 default 0 N en Roof <h2>Do you need products for tiling the roof? Below you can find our offer.</h2> <p style="text-align: justify;">We present Creaton roof tiles with many colors and designes - wavy tiles, flat tiles, round-cut plain tiles. You can choose between natural red, brown, black, blue, green, burgundy and engobe, glazed or matt design. There is also wide range of additional tiles - such as left, right side tiles, ventitaltion tiles, ridge tiles and ridge connectors, but also decoartive ridge end-tiles.</p> <p style="text-align: justify;">Important part od each roof is snow protection and chemney access products. So in our online shop you will find snow bulks, snow fences, chimney steps and benches. Each product is available in wide range of colors, so that it can fit exactly to color of he roof tiles.</p> <p style="text-align: justify;">Furthermore here you can find wapour barrier (It protects against the growth of mold and fungi, it supports the proper ventilation of the house) and roof underlays (protects the thermal insulation layer against the moisture, both from outside and generated by people staying in the building).</p> <p style="text-align: justify;">We would gladly calculate product's quantity for your roof and prepare the offer. Contact us: <a href="mailto:info@byggbay.se">info@byggbay.se</a></p> roof tiles, creaton, glazed tiles, matt tiles, engobe tiles, flat roof, ridge tiles, ridge vent, snow protection, snow fence, snow bulk, chimney step, ridge connector, titania futura, harmonie, premion, domino, melodie, balance, harmonica ✓Creaton roof tiles ✓engobe, matt, glazed ✓flat tiles, wavy tiles ✓roof membrane, wapor barrier, roof underlay ✓snow fence ✓snow bulk ✓chimney steps ✓chimney bench ✓grips to roof accessories ✓ridge tiles ✓ventilation tiles Roof finishing | tiles, snow protection, membranes | byggbay.se roof-en-2 260 c roof-en-2