SELECT 
  cscart_settings_sections.name, 
  cscart_settings_sections.section_id, 
  cscart_settings_sections.position, 
  cscart_settings_sections.type, 
  cscart_settings_sections.name as description, 
  CONCAT(
    'settings.manage?section_id=', cscart_settings_sections.name
  ) as href 
FROM 
  cscart_settings_sections 
WHERE 
  1 
  AND (
    FIND_IN_SET(
      'ROOT', cscart_settings_sections.edition_type
    ) 
    OR FIND_IN_SET(
      'ULT:ROOT', cscart_settings_sections.edition_type
    ) 
    OR FIND_IN_SET(
      'VENDOR', cscart_settings_sections.edition_type
    ) 
    OR FIND_IN_SET(
      'ULT:VENDOR', cscart_settings_sections.edition_type
    )
  ) 
ORDER BY 
  cscart_settings_sections.position

Query time 0.00064

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_settings_sections ALL 89 Using where; Using filesort

Result

name section_id position type description href
general 93 0 TAB general settings.manage?section_id=general
discussion 63 0 ADDON discussion settings.manage?section_id=discussion
general 62 0 TAB general settings.manage?section_id=general
banners 61 0 ADDON banners settings.manage?section_id=banners
general 60 0 TAB general settings.manage?section_id=general
access_restrictions 59 0 ADDON access_restrictions settings.manage?section_id=access_restrictions
general 58 0 TAB general settings.manage?section_id=general
polls 57 0 ADDON polls settings.manage?section_id=polls
general 56 0 TAB general settings.manage?section_id=general
barcode 55 0 ADDON barcode settings.manage?section_id=barcode
general 54 0 TAB general settings.manage?section_id=general
call_requests 53 0 ADDON call_requests settings.manage?section_id=call_requests
general 52 0 TAB general settings.manage?section_id=general
google_analytics 51 0 ADDON google_analytics settings.manage?section_id=google_analytics
general 50 0 TAB general settings.manage?section_id=general
reward_points 49 0 ADDON reward_points settings.manage?section_id=reward_points
general 48 0 TAB general settings.manage?section_id=general
seo 47 0 ADDON seo settings.manage?section_id=seo
products 64 0 TAB products settings.manage?section_id=products
watermarks 70 0 ADDON watermarks settings.manage?section_id=watermarks
general 71 0 TAB general settings.manage?section_id=general
anti_fraud 92 0 ADDON anti_fraud settings.manage?section_id=anti_fraud
service 87 0 TAB service settings.manage?section_id=service
twigmo 86 0 ADDON twigmo settings.manage?section_id=twigmo
general 85 0 TAB general settings.manage?section_id=general
hybrid_auth 84 0 ADDON hybrid_auth settings.manage?section_id=hybrid_auth
general 83 0 TAB general settings.manage?section_id=general
catalog_mode 82 0 ADDON catalog_mode settings.manage?section_id=catalog_mode
general 81 0 TAB general settings.manage?section_id=general
janrain 80 0 ADDON janrain settings.manage?section_id=janrain
general 79 0 TAB general settings.manage?section_id=general
price_list 78 0 ADDON price_list settings.manage?section_id=price_list
general 77 0 TAB general settings.manage?section_id=general
data_feeds 76 0 ADDON data_feeds settings.manage?section_id=data_feeds
general 75 0 TAB general settings.manage?section_id=general
google_sitemap 74 0 ADDON google_sitemap settings.manage?section_id=google_sitemap
general 73 0 TAB general settings.manage?section_id=general
image_zoom 72 0 ADDON image_zoom settings.manage?section_id=image_zoom
general 45 0 TAB general settings.manage?section_id=general
bestsellers 44 0 ADDON bestsellers settings.manage?section_id=bestsellers
Emails 1 0 CORE Emails settings.manage?section_id=Emails
rss_feed 29 0 ADDON rss_feed settings.manage?section_id=rss_feed
general 28 0 TAB general settings.manage?section_id=general
tags 27 0 ADDON tags settings.manage?section_id=tags
general 26 0 TAB general settings.manage?section_id=general
paypal 25 0 ADDON paypal settings.manage?section_id=paypal
twitter 19 0 TAB twitter settings.manage?section_id=twitter
social_buttons 18 0 ADDON social_buttons settings.manage?section_id=social_buttons
Stores 17 0 CORE Stores settings.manage?section_id=Stores
Security 15 0 CORE Security settings.manage?section_id=Security
Upgrade_center 13 0 CORE Upgrade_center settings.manage?section_id=Upgrade_center
Image_verification 11 0 CORE Image_verification settings.manage?section_id=Image_verification
Company 5 0 CORE Company settings.manage?section_id=Company
general 30 0 TAB general settings.manage?section_id=general
newsletters 31 0 ADDON newsletters settings.manage?section_id=newsletters
general 43 0 TAB general settings.manage?section_id=general
rma 42 0 ADDON rma settings.manage?section_id=rma
general 41 0 TAB general settings.manage?section_id=general
store_locator 40 0 ADDON store_locator settings.manage?section_id=store_locator
general 39 0 TAB general settings.manage?section_id=general
gift_certificates 38 0 ADDON gift_certificates settings.manage?section_id=gift_certificates
general 35 0 TAB general settings.manage?section_id=general
email_marketing 34 0 ADDON email_marketing settings.manage?section_id=email_marketing
general 32 0 TAB general settings.manage?section_id=general
mailchimp 36 10 TAB mailchimp settings.manage?section_id=mailchimp
categories 65 10 TAB categories settings.manage?section_id=categories
facebook 20 10 TAB facebook settings.manage?section_id=facebook
promotions 33 10 TAB promotions settings.manage?section_id=promotions
newest 46 10 TAB newest settings.manage?section_id=newest
storefront 88 10 TAB storefront settings.manage?section_id=storefront
General 2 10 CORE General settings.manage?section_id=General
Appearance 4 20 CORE Appearance settings.manage?section_id=Appearance
admin_app 89 20 TAB admin_app settings.manage?section_id=admin_app
orders 66 20 TAB orders settings.manage?section_id=orders
vkontakte 21 20 TAB vkontakte settings.manage?section_id=vkontakte
madmimi 37 20 TAB madmimi settings.manage?section_id=madmimi
gplus 22 30 TAB gplus settings.manage?section_id=gplus
gift_registry 67 30 TAB gift_registry settings.manage?section_id=gift_registry
twg_push 90 30 TAB twg_push settings.manage?section_id=twg_push
pinterest 23 40 TAB pinterest settings.manage?section_id=pinterest
addon 91 40 TAB addon settings.manage?section_id=addon
Checkout 6 40 CORE Checkout settings.manage?section_id=Checkout
pages 68 40 TAB pages settings.manage?section_id=pages
email 24 50 TAB email settings.manage?section_id=email
testimonials 69 50 TAB testimonials settings.manage?section_id=testimonials
Sitemap 8 80 CORE Sitemap settings.manage?section_id=Sitemap
Logging 12 100 CORE Logging settings.manage?section_id=Logging
Thumbnails 9 110 CORE Thumbnails settings.manage?section_id=Thumbnails
Reports 10 140 CORE Reports settings.manage?section_id=Reports