SELECT `data`
  FROM `extjpc07_session`
  WHERE `session_id` = '5d9c3308c25d86cc9dcceaa15dedf0c2'
SELECT folder AS type, element AS name, params
  FROM extjpc07_extensions
  WHERE enabled >= 1
  AND type ='plugin'
  AND state >= 0
  AND access IN (1,1,2,3)
  ORDER BY ordering
SELECT extension_id AS id, element AS "option", params, enabled
  FROM extjpc07_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_kunena'
SELECT `value`
  FROM `extjpc07_admintools_storage`
  WHERE `key` = 'cparams'
SELECT template, s.params
  FROM extjpc07_template_styles as s
  LEFT JOIN extjpc07_extensions as e
  ON e.type='template'
  AND e.element=s.template
  AND e.client_id=s.client_id
  WHERE s.client_id = 1
  AND id = 2
  AND e.enabled = 1 OR s.client_id = 1
  AND home = 1
  ORDER BY home
SELECT extension_id AS id, element AS "option", params, enabled
  FROM extjpc07_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_hikashop'
SELECT *
  FROM extjpc07_hikashop_config
SELECT category_id
  FROM extjpc07_hikashop_category
  WHERE category_type='root'
  LIMIT 1
SELECT category_id
  FROM extjpc07_hikashop_category
  WHERE category_parent_id=1
  AND category_type='1'
  LIMIT 1
SELECT DISTINCT b.*
  FROM extjpc07_hikashop_category AS a
  LEFT JOIN extjpc07_hikashop_category AS b
  ON a.category_left >= b.category_left
  WHERE b.category_right >= a.category_right
  AND a.category_id IN (102)
  AND b.category_id!=1
  ORDER BY b.category_left
SELECT a.id
  FROM extjpc07_user_usergroup_map AS map
  LEFT JOIN extjpc07_usergroups AS a
  ON a.id = map.group_id
  WHERE map.user_id = 42
SELECT *
  FROM extjpc07_hikashop_field as a
  WHERE a.`field_published` = 1
  AND a.`field_backend_listing` = 1
  AND a.field_table='product'
  AND (a.field_access = 'all' OR a.field_access LIKE '%,8,%')
  AND ((field_with_sub_categories=0
  AND (field_categories="all" OR field_categories LIKE '%,102,%'))OR (field_with_sub_categories=1
  AND (field_categories="all" OR field_categories LIKE '%,2,%' OR field_categories LIKE '%,102,%')))
  ORDER BY a.`field_ordering` ASC
SELECT a.ordering, b.*
  FROM extjpc07_hikashop_product_category AS a
  LEFT JOIN extjpc07_hikashop_product AS b
  ON a.product_id=b.product_id
  WHERE a.category_id=102
  AND b.product_type = 'main'
  ORDER BY a.ordering asc
  LIMIT 0, 20
SELECT COUNT(DISTINCT(b.product_id))
  FROM extjpc07_hikashop_product_category AS a
  LEFT JOIN extjpc07_hikashop_product AS b
  ON a.product_id=b.product_id
  WHERE a.category_id=102
  AND b.product_type = 'main'
SELECT *
  FROM extjpc07_hikashop_price
  WHERE price_product_id IN (1760,1761,1762,1763,1764,1765)
SELECT DISTINCT b.*
  FROM extjpc07_hikashop_category AS a
  LEFT JOIN extjpc07_hikashop_category AS b
  ON a.category_left >= b.category_left
  WHERE b.category_right >= a.category_right
  AND a.category_id=102
  ORDER BY b.category_left
SELECT a.*
  FROM extjpc07_hikashop_category AS a
  WHERE a.category_parent_id IN (1,2,102)
  AND a.category_type IN ('product','root')
  ORDER BY a.category_name ASC
  LIMIT 0, 500
SHOW TABLES LIKE 'extjpc07_falang_content'
SHOW TABLES LIKE 'extjpc07_jf_content'
SELECT category_id,category_name
  FROM extjpc07_hikashop_category
  WHERE category_type = "manufacturer"
  AND category_depth != 1
  ORDER BY category_name ASC
SELECT a.*
  FROM extjpc07_hikashop_category AS a
  WHERE a.category_type IN ('product','root')
  ORDER BY a.category_parent_id ASC, a.category_ordering ASC
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM extjpc07_modules AS m
  LEFT JOIN extjpc07_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN extjpc07_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
  WHERE m.published = 1
  AND e.enabled = 1
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2012-10-30 07:52:38')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2012-10-30 07:52:38')
  AND m.access IN (1,1,2,3)
  AND m.client_id = 1
  AND (mm.menuid = 0 OR mm.menuid <= 0)
  ORDER BY m.position, m.ordering
SELECT COUNT(*)
  FROM extjpc07_messages
  WHERE state = 0
  AND user_id_to = 42
SELECT COUNT(session_id)
  FROM extjpc07_session
  WHERE guest = 0
  AND client_id = 1
SELECT COUNT(session_id)
  FROM extjpc07_session
  WHERE guest = 0
  AND client_id = 0
SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native
  FROM extjpc07_menu_types AS a
  LEFT JOIN extjpc07_menu AS b
  ON b.menutype = a.menutype
  AND b.home != 0
  LEFT JOIN extjpc07_languages AS l
  ON l.lang_code = language
  WHERE (b.client_id = 0 OR b.client_id IS NULL)
  GROUP BY a.id, a.menutype, a.description, a.title, b.menutype,b.language,l.image,l.sef,l.title_native
SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element
  FROM extjpc07_menu AS m
  LEFT JOIN extjpc07_extensions AS e
  ON m.component_id = e.extension_id
  WHERE m.client_id = 1
  AND e.enabled = 1
  AND m.id > 1
  ORDER BY m.lft