116 QUERIES GELOGD
SELECT `data` 
  FROM `s3gof_session` 
  WHERE `session_id` = 'a85628d8ca43b123878f9a22e0420967'
SELECT folder AS type, element AS name, params 
  FROM s3gof_extensions 
  WHERE enabled >= 1 
  AND type ='plugin' 
  AND state >= 0 
  AND access IN (1,1) 
  ORDER BY ordering
SELECT extension_id AS id, element AS "option", params, enabled 
  FROM s3gof_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_languages'
SELECT `value` 
  FROM `s3gof_admintools_storage` 
  WHERE `key` = 'cparams'
SELECT `query` 
  FROM `s3gof_admintools_wafexceptions` 
  WHERE (`option` IS NULL OR `option` = '') 
  AND (`view` IS NULL OR `view` = '') 
  GROUP BY `query` 
  ORDER BY `query` ASC
SELECT `enabled` 
  FROM `s3gof_extensions` 
  WHERE `element` = 'com_akeeba' 
  AND `type` = 'component'
SELECT * 
  FROM `s3gof_rsfirewall_configuration`
SELECT * 
  FROM `s3gof_admintools_ipautoban` 
  WHERE `ip` = '83.82.146.207'
SELECT `value` 
  FROM `s3gof_admintools_storage` 
  WHERE `key` = 'cparams'
SELECT `source` 
  FROM `s3gof_admintools_redirects` 
  WHERE (`dest` = 'component/hikashop/product/listing.html') OR (`dest` = 'component/hikashop/product/listing.html?Itemid=0') 
  AND `published` = '1' 
  ORDER BY `ordering` DESC 
  LIMIT 0, 1
SELECT `ip` 
  FROM s3gof_rsfirewall_lists 
  WHERE (`ip`='83.82.146.207' OR `ip` LIKE '%*%') 
  AND `type`='1' 
  AND `published`='1'
SELECT `ip` 
  FROM s3gof_rsfirewall_lists 
  WHERE (`ip`='83.82.146.207' OR `ip` LIKE '%*%') 
  AND `type`='1' 
  AND `published`='1'
SELECT `ip`, `reason` 
  FROM s3gof_rsfirewall_lists 
  WHERE (`ip`='83.82.146.207' OR `ip` LIKE '%*%') 
  AND `type`='0' 
  AND `published`='1'
SELECT * 
  FROM s3gof_rsfirewall_snapshots 
  WHERE `type`='lockdown'
SHOW FULL COLUMNS 
  FROM `s3gof_users`
SELECT * 
  FROM `s3gof_users` 
  WHERE `id` = 44
SELECT `g`.`id`,`g`.`title` 
  FROM `s3gof_usergroups` AS g 
  INNER JOIN `s3gof_user_usergroup_map` AS m 
  ON m.group_id = g.id 
  WHERE `m`.`user_id` = 44
SELECT * 
  FROM `s3gof_users` 
  WHERE `id` = 43
SELECT `g`.`id`,`g`.`title` 
  FROM `s3gof_usergroups` AS g 
  INNER JOIN `s3gof_user_usergroup_map` AS m 
  ON m.group_id = g.id 
  WHERE `m`.`user_id` = 43
SELECT id 
  FROM s3gof_usergroups
SELECT parent.id, parent.lft, parent.rgt 
  FROM s3gof_usergroups AS parent 
  ORDER BY parent.lft
SELECT b.rules 
  FROM s3gof_assets AS a 
  LEFT JOIN s3gof_assets AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt 
  WHERE (a.id = 1 OR a.parent_id=0) 
  GROUP BY b.id, b.rules, b.lft 
  ORDER BY b.lft
DELETE 
  FROM s3gof_users 
  WHERE `id` IN (SELECT user_id 
  FROM s3gof_user_usergroup_map 
  WHERE user_id NOT IN (44,43) 
  AND group_id IN (6,7,8))
SELECT * 
  FROM s3gof_rsfirewall_hashes 
  WHERE `type`='2.5.7'
SELECT * 
  FROM s3gof_rsfirewall_hashes 
  WHERE `type`='2.5.7'
SELECT * 
  FROM s3gof_rsfirewall_hashes 
  WHERE `type`='protect'
SELECT * 
  FROM s3gof_rsfirewall_hashes 
  WHERE `type`='protect'
SELECT * 
  FROM s3gof_rsseo_redirects 
  WHERE published = 1
SELECT * 
  FROM s3gof_hikashop_config
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM s3gof_menu AS m 
  LEFT JOIN s3gof_extensions AS e 
  ON m.component_id = e.extension_id 
  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0 
  ORDER BY m.lft
SELECT `ip` 
  FROM s3gof_rsfirewall_lists 
  WHERE (`ip`='83.82.146.207' OR `ip` LIKE '%*%') 
  AND `type`='1' 
  AND `published`='1'
SELECT `ip` 
  FROM s3gof_rsfirewall_lists 
  WHERE (`ip`='83.82.146.207' OR `ip` LIKE '%*%') 
  AND `type`='1' 
  AND `published`='1'
SELECT extension_id AS id, element AS "option", params, enabled 
  FROM s3gof_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_hikashop'
SELECT * 
  FROM s3gof_languages 
  WHERE published=1 
  ORDER BY ordering ASC
SELECT extension_id AS id, element AS "option", params, enabled 
  FROM s3gof_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_menus'
SELECT id, home, template, s.params 
  FROM s3gof_template_styles as s 
  LEFT JOIN s3gof_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id 
  WHERE s.client_id = 0 
  AND e.enabled = 1
SELECT * 
  FROM s3gof_hikashop_category 
  WHERE category_id = '2' 
  LIMIT 1
SELECT extension_id AS id, element AS "option", params, enabled 
  FROM s3gof_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_users'
SELECT category_id 
  FROM s3gof_hikashop_category 
  WHERE (category_access = 'all' OR category_access LIKE '%,1,%') 
  AND category_id IN (2)
SELECT * 
  FROM s3gof_hikashop_filter 
  WHERE filter_published = 1 
  AND (filter_access = 'all' OR filter_access LIKE '%,1,%') 
  ORDER BY filter_ordering
SELECT DISTINCT b.* 
  FROM s3gof_hikashop_category AS a 
  LEFT JOIN s3gof_hikashop_category AS b 
  ON a.category_left >= b.category_left 
  WHERE b.category_right >= a.category_right 
  AND a.category_id=2 
  ORDER BY b.category_left
SELECT a.*,b.* 
  FROM s3gof_hikashop_category AS a 
  LEFT JOIN s3gof_hikashop_file AS b 
  ON a.category_id=b.file_ref_id 
  AND b.file_type='category' 
  WHERE a.category_id = 2 
  LIMIT 1
SELECT DISTINCT b.* 
  FROM s3gof_hikashop_product_category AS a 
  LEFT JOIN s3gof_hikashop_product AS b 
  ON a.product_id=b.product_id 
  WHERE b.product_published=1 
  AND b.product_type = 'main' 
  AND a.category_id IN (2) 
  AND (b.product_access = 'all' OR b.product_access LIKE '%,1,%') 
  AND ( b.product_description LIKE '%duplo%' ) 
  ORDER BY a.ordering ASC 
  LIMIT 0, 20
SELECT count( DISTINCT b.product_id) 
  FROM s3gof_hikashop_product_category AS a 
  LEFT JOIN s3gof_hikashop_product AS b 
  ON a.product_id=b.product_id 
  WHERE b.product_published=1 
  AND b.product_type = 'main' 
  AND a.category_id IN (2) 
  AND (b.product_access = 'all' OR b.product_access LIKE '%,1,%') 
  AND ( b.product_description LIKE '%duplo%' ) 
  ORDER BY a.ordering ASC
SELECT DISTINCT b.* 
  FROM s3gof_hikashop_category AS a 
  LEFT JOIN s3gof_hikashop_category AS b 
  ON a.category_left >= b.category_left 
  WHERE b.category_right >= a.category_right 
  AND a.category_id=2 
  ORDER BY b.category_left
SELECT * 
  FROM s3gof_hikashop_field as a 
  WHERE a.`field_published` = 1 
  AND a.`field_frontcomp` = 1 
  AND a.field_table='category' 
  AND (a.field_access = 'all' OR a.field_access LIKE '%,1,%') 
  AND ((field_with_sub_categories=0 
  AND (field_categories="all" OR field_categories LIKE '%,2,%'))OR (field_with_sub_categories=1 
  AND (field_categories="all" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%'))) 
  ORDER BY a.`field_ordering` ASC
SELECT DISTINCT b.* 
  FROM s3gof_hikashop_category AS a 
  LEFT JOIN s3gof_hikashop_category AS b 
  ON a.category_left >= b.category_left 
  WHERE b.category_right >= a.category_right 
  AND a.category_id=2 
  ORDER BY b.category_left
SELECT * 
  FROM `s3gof_rsseo_config`
SELECT ConfigValue 
  FROM s3gof_rsseo_config 
  WHERE ConfigName = 'crawler.enable.auto'
SELECT ConfigValue 
  FROM s3gof_rsseo_config 
  WHERE ConfigName = 'crawler.ignore'
SELECT IdPage 
  FROM s3gof_rsseo_pages 
  WHERE PageURL = 'component/hikashop/product/listing.html?Itemid=0'
SELECT IdPage, PageModified, PageTitle , PageKeywords , PageDescription, PageCrawled , PageLevel, canonical, robots 
  FROM s3gof_rsseo_pages 
  WHERE PageURL = 'component/hikashop/product/listing.html?Itemid=0' 
  AND published = 1 
  LIMIT 1
SELECT ConfigValue 
  FROM s3gof_rsseo_config 
  WHERE ConfigName = 'component.heading'
SELECT ConfigValue 
  FROM s3gof_rsseo_config 
  WHERE ConfigName = 'content.heading'
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM s3gof_modules AS m 
  LEFT JOIN s3gof_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN s3gof_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-18 06:21:36') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2012-10-18 06:21:36') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 0 OR mm.menuid <= 0) 
  ORDER BY m.position, m.ordering
SELECT extension_id AS id, element AS "option", params, enabled 
  FROM s3gof_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_content'
SELECT a.* 
  FROM s3gof_hikashop_cart AS a 
  WHERE (a.session_id = 'a85628d8ca43b123878f9a22e0420967') 
  AND a.cart_type = 'cart' 
  ORDER BY a.cart_modified DESC 
  LIMIT 1
SELECT * 
  FROM s3gof_hikashop_field as a 
  WHERE a.`field_published` = 1 
  AND a.`field_frontcomp` = 1 
  AND a.field_table='item' 
  AND (a.field_access = 'all' OR a.field_access LIKE '%,1,%') 
  ORDER BY a.`field_ordering` ASC
SELECT a.* 
  FROM s3gof_hikashop_cart AS a 
  WHERE (a.session_id = 'a85628d8ca43b123878f9a22e0420967') 
  AND a.cart_type = 'wishlist' 
  ORDER BY a.cart_modified DESC 
  LIMIT 1
SELECT * 
  FROM s3gof_hikashop_category 
  WHERE category_id = '2' 
  LIMIT 1
SELECT category_id 
  FROM s3gof_hikashop_category 
  WHERE (category_access = 'all' OR category_access LIKE '%,1,%') 
  AND category_type='product' 
  AND category_id IN (2)
SELECT a.* 
  FROM s3gof_hikashop_category AS a 
  WHERE a.category_parent_id = 2 
  AND a.category_published=1 
  AND (a.category_access = 'all' OR a.category_access LIKE '%,1,%') 
  ORDER BY a.category_name ASC 
  LIMIT 0, 40
SELECT * 
  FROM s3gof_hikashop_file 
  WHERE file_type='category' 
  AND file_ref_id IN (14,18,19,21,20,22,24,25,26,28,27,15,23,29,30,31,12,32,33,35,34,17,36,16,37,38,39)
SELECT COUNT(*) 
  FROM s3gof_hikashop_category AS a 
  WHERE a.category_parent_id = 2 
  AND a.category_published=1 
  AND (a.category_access = 'all' OR a.category_access LIKE '%,1,%')
SELECT category_left,category_right 
  FROM s3gof_hikashop_category 
  WHERE category_id IN (14,18,19,21,20,22,24,25,26,28,27,15,23,29,30,31,12,32,33,35,34,17,36,16,37,38,39)
SELECT a.* 
  FROM s3gof_hikashop_category AS a 
  WHERE ((a.category_left > 3 
  AND a.category_right < 38) OR (a.category_left > 39 
  AND a.category_right < 40) OR (a.category_left > 41 
  AND a.category_right < 74) OR (a.category_left > 75 
  AND a.category_right < 76) OR (a.category_left > 77 
  AND a.category_right < 78) OR (a.category_left > 79 
  AND a.category_right < 80) OR (a.category_left > 81 
  AND a.category_right < 82) OR (a.category_left > 83 
  AND a.category_right < 88) OR (a.category_left > 89 
  AND a.category_right < 90) OR (a.category_left > 91 
  AND a.category_right < 92) OR (a.category_left > 93 
  AND a.category_right < 94) OR (a.category_left > 95 
  AND a.category_right < 96) OR (a.category_left > 97 
  AND a.category_right < 98) OR (a.category_left > 99 
  AND a.category_right < 100) OR (a.category_left > 101 
  AND a.category_right < 102) OR (a.category_left > 103 
  AND a.category_right < 108) OR (a.category_left > 109 
  AND a.category_right < 110) OR (a.category_left > 111 
  AND a.category_right < 128) OR (a.category_left > 129 
  AND a.category_right < 130) OR (a.category_left > 131 
  AND a.category_right < 132) OR (a.category_left > 133 
  AND a.category_right < 134) OR (a.category_left > 135 
  AND a.category_right < 136) OR (a.category_left > 137 
  AND a.category_right < 138) OR (a.category_left > 139 
  AND a.category_right < 140) OR (a.category_left > 141 
  AND a.category_right < 142) OR (a.category_left > 143 
  AND a.category_right < 144) OR (a.category_left > 145 
  AND a.category_right < 146)) 
  AND a.category_published=1 
  AND (a.category_access = 'all' OR a.category_access LIKE '%,1,%') 
  ORDER BY a.category_name ASC
SELECT count(a.product_id) AS number_of_products,a.category_id 
  FROM s3gof_hikashop_product_category AS a 
  INNER JOIN s3gof_hikashop_product AS b 
  ON a.product_id=b.product_id 
  AND b.product_published>0 
  AND product_parent_id=0 
  WHERE a.category_id IN (14,18,19,21,20,22,24,25,26,28,27,15,23,29,30,31,12,32,33,35,34,17,36,16,37,38,39,40,41,61,72,75,63,65,66,43,45,67,90,85,79,77,78,76,84,88,74,48,49,81,50,51,73,52,91,53,47,68,54,69,80,70,86,55,56,57,82,83,58,62,13,64)
  GROUP BY a.category_id
SELECT category_id 
  FROM s3gof_hikashop_category 
  WHERE (category_access = 'all' OR category_access LIKE '%,1,%') 
  AND category_id IN (2)
SELECT * 
  FROM s3gof_hikashop_filter 
  WHERE filter_published = 1 
  AND (filter_access = 'all' OR filter_access LIKE '%,1,%') 
  ORDER BY filter_ordering
SELECT DISTINCT b.* 
  FROM s3gof_hikashop_category AS a 
  LEFT JOIN s3gof_hikashop_category AS b 
  ON a.category_left >= b.category_left 
  WHERE b.category_right >= a.category_right 
  AND a.category_id=2 
  ORDER BY b.category_left
SELECT a.*,b.* 
  FROM s3gof_hikashop_category AS a 
  LEFT JOIN s3gof_hikashop_file AS b 
  ON a.category_id=b.file_ref_id 
  AND b.file_type='category' 
  WHERE a.category_id = 2 
  LIMIT 1
SELECT * 
  FROM s3gof_hikashop_category 
  WHERE category_id = '2' 
  LIMIT 1
SELECT a.* 
  FROM s3gof_hikashop_category AS a 
  WHERE a.category_left > 2 
  AND a.category_right < 147 
  AND a.category_type = 'product' 
  AND a.category_published=1 
  AND (a.category_access = 'all' OR a.category_access LIKE '%,1,%')
SELECT DISTINCT b.* 
  FROM s3gof_hikashop_product_category AS a 
  LEFT JOIN s3gof_hikashop_product AS b 
  ON a.product_id=b.product_id 
  WHERE b.product_published=1 
  AND b.product_type = 'main' 
  AND a.category_id IN (12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,43,45,48,47,49,50,51,52,53,54,55,56,57,58,62,61,63,64,65,66,67,68,69,70,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,88,90,91,2)
  AND (b.product_access = 'all' OR b.product_access LIKE '%,1,%') 
  ORDER BY b.product_created DESC 
  LIMIT 0, 5
SELECT * 
  FROM s3gof_hikashop_file 
  WHERE file_ref_id IN (3883,3882,3881,1558,1677) 
  AND file_type='product' 
  ORDER BY file_ref_id ASC, file_ordering ASC, file_id ASC
SELECT * 
  FROM s3gof_hikashop_variant 
  WHERE variant_product_id IN (3883,3882,3881,1558,1677)
SELECT * 
  FROM s3gof_hikashop_discount 
  WHERE discount_type='discount' 
  AND discount_published=1 
  AND ( discount_quota>discount_used_times OR discount_quota=0 ) 
  AND discount_start < 1350541296 
  AND ( discount_end > 1350541296 OR discount_end = 0 ) 
  AND ( discount_product_id IN (3883,3882,3881,1558,1677) OR discount_product_id=0 ) 
  AND ( discount_flat_amount!=0 OR discount_percent_amount!=0 ) 
  AND (discount_access = 'all' OR discount_access LIKE '%,1,%')
SELECT currency_id 
  FROM s3gof_hikashop_currency 
  WHERE currency_published=1 OR currency_id = 1
SELECT a.* 
  FROM s3gof_hikashop_price AS a 
  WHERE a.price_product_id IN (3883,3882,3881,1558,1677) 
  AND a.price_currency_id IN (1) 
  AND (a.price_access = 'all' OR a.price_access LIKE '%,1,%') 
  ORDER BY a.price_value DESC
SELECT b.*,c.* 
  FROM s3gof_hikashop_category AS a 
  LEFT JOIN s3gof_hikashop_taxation AS b 
  ON a.category_namekey=b.category_namekey 
  LEFT JOIN s3gof_hikashop_tax AS c 
  ON b.tax_namekey=c.tax_namekey 
  WHERE a.category_id = 11 
  AND b.taxation_published=1 
  AND ( taxation_type = '' OR taxation_type = 'individual' ) 
  AND (b.taxation_access = 'all' OR b.taxation_access LIKE '%,1,%')
SELECT * 
  FROM s3gof_hikashop_zone 
  WHERE zone_id = 150
SELECT b.* 
  FROM s3gof_hikashop_zone_link AS a 
  LEFT JOIN s3gof_hikashop_zone AS b 
  ON a.zone_parent_namekey=b.zone_namekey 
  WHERE a.zone_child_namekey IN ('country_Netherlands_150') 
  AND a.zone_parent_namekey NOT IN ('country_Netherlands_150') 
  AND (b.zone_type IN('state','country') OR ( b.zone_type='tax' 
  AND b.zone_namekey IN ('') ))
SELECT * 
  FROM s3gof_hikashop_currency 
  WHERE currency_id IN (1)
SELECT count( DISTINCT b.product_id) 
  FROM s3gof_hikashop_product_category AS a 
  LEFT JOIN s3gof_hikashop_product AS b 
  ON a.product_id=b.product_id 
  WHERE b.product_published=1 
  AND b.product_type = 'main' 
  AND a.category_id IN (12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,43,45,48,47,49,50,51,52,53,54,55,56,57,58,62,61,63,64,65,66,67,68,69,70,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,88,90,91,2)
  AND (b.product_access = 'all' OR b.product_access LIKE '%,1,%') 
  ORDER BY b.product_created DESC
SELECT category_id 
  FROM s3gof_hikashop_product_category 
  WHERE product_id=3883 
  ORDER BY ordering ASC
SELECT DISTINCT b.* 
  FROM s3gof_hikashop_category AS a 
  LEFT JOIN s3gof_hikashop_category AS b 
  ON a.category_left >= b.category_left 
  WHERE b.category_right >= a.category_right 
  AND a.category_id IN (72) 
  ORDER BY b.category_left
SELECT a.* 
  FROM s3gof_hikashop_badge AS a 
  WHERE a.badge_start <= 1350541296 
  AND ( a.badge_end >= 1350541296 OR a.badge_end =0 ) 
  AND a.badge_published=1 
  AND badge_discount_id=0 
  AND ((badge_category_childs = 0 
  AND (badge_category_id = 0 OR badge_category_id = 72))OR (badge_category_childs = 1 
  AND (badge_category_id=0 OR badge_category_id = 1 OR badge_category_id = 2 OR badge_category_id = 28 OR badge_category_id = 72))) 
  ORDER BY a.badge_ordering ASC,a.badge_id ASC
SELECT category_id 
  FROM s3gof_hikashop_product_category 
  WHERE product_id=3882 
  ORDER BY ordering ASC
SELECT DISTINCT b.* 
  FROM s3gof_hikashop_category AS a 
  LEFT JOIN s3gof_hikashop_category AS b 
  ON a.category_left >= b.category_left 
  WHERE b.category_right >= a.category_right 
  AND a.category_id IN (24) 
  ORDER BY b.category_left
SELECT a.* 
  FROM s3gof_hikashop_badge AS a 
  WHERE a.badge_start <= 1350541296 
  AND ( a.badge_end >= 1350541296 OR a.badge_end =0 ) 
  AND a.badge_published=1 
  AND badge_discount_id=0 
  AND ((badge_category_childs = 0 
  AND (badge_category_id = 0 OR badge_category_id = 24))OR (badge_category_childs = 1 
  AND (badge_category_id=0 OR badge_category_id = 1 OR badge_category_id = 2 OR badge_category_id = 24))) 
  ORDER BY a.badge_ordering ASC,a.badge_id ASC
SELECT category_id 
  FROM s3gof_hikashop_product_category 
  WHERE product_id=3881 
  ORDER BY ordering ASC
SELECT DISTINCT b.* 
  FROM s3gof_hikashop_category AS a 
  LEFT JOIN s3gof_hikashop_category AS b 
  ON a.category_left >= b.category_left 
  WHERE b.category_right >= a.category_right 
  AND a.category_id IN (61) 
  ORDER BY b.category_left
SELECT a.* 
  FROM s3gof_hikashop_badge AS a 
  WHERE a.badge_start <= 1350541296 
  AND ( a.badge_end >= 1350541296 OR a.badge_end =0 ) 
  AND a.badge_published=1 
  AND badge_discount_id=0 
  AND ((badge_category_childs = 0 
  AND (badge_category_id = 0 OR badge_category_id = 61))OR (badge_category_childs = 1 
  AND (badge_category_id=0 OR badge_category_id = 1 OR badge_category_id = 2 OR badge_category_id = 20 OR badge_category_id = 61))) 
  ORDER BY a.badge_ordering ASC,a.badge_id ASC
SELECT category_id 
  FROM s3gof_hikashop_product_category 
  WHERE product_id=1558 
  ORDER BY ordering ASC
SELECT DISTINCT b.* 
  FROM s3gof_hikashop_category AS a 
  LEFT JOIN s3gof_hikashop_category AS b 
  ON a.category_left >= b.category_left 
  WHERE b.category_right >= a.category_right 
  AND a.category_id IN (13) 
  ORDER BY b.category_left
SELECT a.* 
  FROM s3gof_hikashop_badge AS a 
  WHERE a.badge_start <= 1350541296 
  AND ( a.badge_end >= 1350541296 OR a.badge_end =0 ) 
  AND a.badge_published=1 
  AND (badge_discount_id=2 OR badge_discount_id=0 )
  AND ((badge_category_childs = 0 
  AND (badge_category_id = 0 OR badge_category_id = 13))OR (badge_category_childs = 1 
  AND (badge_category_id=0 OR badge_category_id = 1 OR badge_category_id = 2 OR badge_category_id = 12 OR badge_category_id = 13))) 
  ORDER BY a.badge_ordering ASC,a.badge_id ASC
SELECT category_id 
  FROM s3gof_hikashop_product_category 
  WHERE product_id=1677 
  ORDER BY ordering ASC
SELECT DISTINCT b.* 
  FROM s3gof_hikashop_category AS a 
  LEFT JOIN s3gof_hikashop_category AS b 
  ON a.category_left >= b.category_left 
  WHERE b.category_right >= a.category_right 
  AND a.category_id IN (13) 
  ORDER BY b.category_left
SELECT a.* 
  FROM s3gof_hikashop_badge AS a 
  WHERE a.badge_start <= 1350541296 
  AND ( a.badge_end >= 1350541296 OR a.badge_end =0 ) 
  AND a.badge_published=1 
  AND badge_discount_id=0 
  AND ((badge_category_childs = 0 
  AND (badge_category_id = 0 OR badge_category_id = 13))OR (badge_category_childs = 1 
  AND (badge_category_id=0 OR badge_category_id = 1 OR badge_category_id = 2 OR badge_category_id = 12 OR badge_category_id = 13))) 
  ORDER BY a.badge_ordering ASC,a.badge_id ASC
SELECT * 
  FROM s3gof_hikashop_currency 
  WHERE currency_id IN (1)
SELECT DISTINCT b.* 
  FROM s3gof_hikashop_category AS a 
  LEFT JOIN s3gof_hikashop_category AS b 
  ON a.category_left >= b.category_left 
  WHERE b.category_right >= a.category_right 
  AND a.category_id IN (72) 
  ORDER BY b.category_left
SELECT * 
  FROM s3gof_hikashop_field as a 
  WHERE a.`field_published` = 1 
  AND a.`field_frontcomp` = 1 
  AND a.field_table='item' 
  AND (a.field_access = 'all' OR a.field_access LIKE '%,1,%') 
  AND ((field_with_sub_categories=0 
  AND (field_categories="all" OR field_categories LIKE '%,72,%'))OR (field_with_sub_categories=1 
  AND (field_categories="all" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%' OR field_categories LIKE '%,28,%' OR field_categories LIKE '%,72,%'))) 
  ORDER BY a.`field_ordering` ASC
SELECT DISTINCT b.* 
  FROM s3gof_hikashop_category AS a 
  LEFT JOIN s3gof_hikashop_category AS b 
  ON a.category_left >= b.category_left 
  WHERE b.category_right >= a.category_right 
  AND a.category_id IN (24) 
  ORDER BY b.category_left
SELECT * 
  FROM s3gof_hikashop_field as a 
  WHERE a.`field_published` = 1 
  AND a.`field_frontcomp` = 1 
  AND a.field_table='item' 
  AND (a.field_access = 'all' OR a.field_access LIKE '%,1,%') 
  AND ((field_with_sub_categories=0 
  AND (field_categories="all" OR field_categories LIKE '%,24,%'))OR (field_with_sub_categories=1 
  AND (field_categories="all" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%' OR field_categories LIKE '%,24,%'))) 
  ORDER BY a.`field_ordering` ASC
SELECT DISTINCT b.* 
  FROM s3gof_hikashop_category AS a 
  LEFT JOIN s3gof_hikashop_category AS b 
  ON a.category_left >= b.category_left 
  WHERE b.category_right >= a.category_right 
  AND a.category_id IN (61) 
  ORDER BY b.category_left
SELECT * 
  FROM s3gof_hikashop_field as a 
  WHERE a.`field_published` = 1 
  AND a.`field_frontcomp` = 1 
  AND a.field_table='item' 
  AND (a.field_access = 'all' OR a.field_access LIKE '%,1,%') 
  AND ((field_with_sub_categories=0 
  AND (field_categories="all" OR field_categories LIKE '%,61,%'))OR (field_with_sub_categories=1 
  AND (field_categories="all" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%' OR field_categories LIKE '%,20,%' OR field_categories LIKE '%,61,%'))) 
  ORDER BY a.`field_ordering` ASC
SELECT DISTINCT b.* 
  FROM s3gof_hikashop_category AS a 
  LEFT JOIN s3gof_hikashop_category AS b 
  ON a.category_left >= b.category_left 
  WHERE b.category_right >= a.category_right 
  AND a.category_id IN (13) 
  ORDER BY b.category_left
SELECT * 
  FROM s3gof_hikashop_field as a 
  WHERE a.`field_published` = 1 
  AND a.`field_frontcomp` = 1 
  AND a.field_table='item' 
  AND (a.field_access = 'all' OR a.field_access LIKE '%,1,%') 
  AND ((field_with_sub_categories=0 
  AND (field_categories="all" OR field_categories LIKE '%,13,%'))OR (field_with_sub_categories=1 
  AND (field_categories="all" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%' OR field_categories LIKE '%,12,%' OR field_categories LIKE '%,13,%'))) 
  ORDER BY a.`field_ordering` ASC
SELECT DISTINCT b.* 
  FROM s3gof_hikashop_category AS a 
  LEFT JOIN s3gof_hikashop_category AS b 
  ON a.category_left >= b.category_left 
  WHERE b.category_right >= a.category_right 
  AND a.category_id IN (13) 
  ORDER BY b.category_left
SELECT * 
  FROM s3gof_hikashop_filter 
  WHERE filter_published = 1 
  AND (filter_access = 'all' OR filter_access LIKE '%,1,%') 
  ORDER BY filter_ordering
SELECT DISTINCT b.product_id 
  FROM s3gof_hikashop_product_category AS a 
  LEFT JOIN s3gof_hikashop_product AS b 
  ON a.product_id=b.product_id 
  WHERE b.product_published=1 
  AND b.product_type = 'main' 
  AND a.category_id IN (12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,43,45,48,47,49,50,51,52,53,54,55,56,57,58,62,61,63,64,65,66,67,68,69,70,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,88,90,91,2)
  AND (b.product_access = 'all' OR b.product_access LIKE '%,1,%') 
  ORDER BY b.product_created DESC
SELECT DISTINCT b.product_id 
  FROM s3gof_hikashop_product_category AS a 
  LEFT JOIN s3gof_hikashop_product AS b 
  ON a.product_id=b.product_id 
  WHERE b.product_published=1 
  AND b.product_type = 'main' 
  AND a.category_id IN (12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,43,45,48,47,49,50,51,52,53,54,55,56,57,58,62,61,63,64,65,66,67,68,69,70,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,88,90,91,2)
  AND (b.product_access = 'all' OR b.product_access LIKE '%,1,%') 
  ORDER BY b.product_created DESC
SELECT ConfigValue 
  FROM s3gof_rsseo_config 
  WHERE ConfigName = 'enable.keyword.replace'
SELECT Keyword , KeywordBold ,KeywordUnderline,KeywordLimit ,KeywordAttributes ,KeywordLink 
  FROM s3gof_rsseo_keywords 
  ORDER BY CHAR_LENGTH(Keyword) DESC
SELECT ConfigValue 
  FROM s3gof_rsseo_config 
  WHERE ConfigName = 'ga.tracking'
UPDATE `s3gof_session` 
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:5;s:19:\"session.timer.start\";i:1350541134;s:18:\"session.timer.last\";i:1350541283;s:17:\"session.timer.now\";i:1350541296;s:22:\"session.client.browser\";s:106:\"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.4 (KHTML, like Gecko) Chrome/22.0.1229.94 Safari/537.4\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:12:\"com_hikashop\";O:8:\"stdClass\":4:{s:12:\"ssl_redirect\";i:0;s:7:\"zone_id\";s:3:\"150\";s:15:\"0_filter_Zoeken\";s:5:\"duplo\";s:45:\"product_hikashop_category_information_menu__2\";O:8:\"stdClass\":1:{s:10:\"limitstart\";i:0;}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";N;s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"041931ef86f2dd82c56455672b8cc2b4\";}VMCHECK|s:7:\"NOCHECK\";' , `time` = '1350541297' 
  WHERE `session_id` = 'a85628d8ca43b123878f9a22e0420967'
57 QUERY TYPES GELOGD, GESORTEERD OP WEERGAVE
SELECTEER Tabellen:
14 × SELECT DISTINCT b.* 
  FROM s3gof_hikashop_category AS a 
  LEFT JOIN s3gof_hikashop_category AS b 
  ON a.category_left >= b.category_left
6 × SELECT * 
  FROM s3gof_hikashop_field as a
6 × SELECT ConfigValue 
  FROM s3gof_rsseo_config
5 × SELECT category_id 
  FROM s3gof_hikashop_product_category
5 × SELECT a.* 
  FROM s3gof_hikashop_badge AS a
5 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM s3gof_extensions
4 × SELECT * 
  FROM s3gof_rsfirewall_hashes
4 × SELECT `ip` 
  FROM s3gof_rsfirewall_lists
3 × SELECT category_id 
  FROM s3gof_hikashop_category
3 × SELECT * 
  FROM s3gof_hikashop_filter
3 × SELECT * 
  FROM s3gof_hikashop_category
3 × SELECT a.* 
  FROM s3gof_hikashop_category AS a
2 × SELECT DISTINCT b.product_id 
  FROM s3gof_hikashop_product_category AS a 
  LEFT JOIN s3gof_hikashop_product AS b 
  ON a.product_id=b.product_id
2 × SELECT DISTINCT b.* 
  FROM s3gof_hikashop_product_category AS a 
  LEFT JOIN s3gof_hikashop_product AS b 
  ON a.product_id=b.product_id
2 × SELECT * 
  FROM s3gof_hikashop_currency
2 × SELECT a.* 
  FROM s3gof_hikashop_cart AS a
2 × SELECT * 
  FROM s3gof_hikashop_file
2 × SELECT count( DISTINCT b.product_id) 
  FROM s3gof_hikashop_product_category AS a 
  LEFT JOIN s3gof_hikashop_product AS b 
  ON a.product_id=b.product_id
2 × SELECT a.*,b.* 
  FROM s3gof_hikashop_category AS a 
  LEFT JOIN s3gof_hikashop_file AS b 
  ON a.category_id=b.file_ref_id 
  AND b.file_type='category'
2 × SELECT `g`.`id`,`g`.`title` 
  FROM `s3gof_usergroups` AS g 
  INNER JOIN `s3gof_user_usergroup_map` AS m 
  ON m.group_id = g.id
2 × SELECT `value` 
  FROM `s3gof_admintools_storage`
2 × SELECT * 
  FROM `s3gof_users`
1 × SELECT currency_id 
  FROM s3gof_hikashop_currency
1 × SELECT * 
  FROM s3gof_hikashop_discount
1 × SELECT count(a.product_id) AS number_of_products,a.category_id 
  FROM s3gof_hikashop_product_category AS a 
  INNER JOIN s3gof_hikashop_product AS b 
  ON a.product_id=b.product_id 
  AND b.product_published>0 
  AND product_parent_id=0
1 × SELECT COUNT(*) 
  FROM s3gof_hikashop_category AS a
1 × SELECT category_left,category_right 
  FROM s3gof_hikashop_category
1 × SELECT * 
  FROM s3gof_hikashop_variant
1 × SELECT b.*,c.* 
  FROM s3gof_hikashop_category AS a 
  LEFT JOIN s3gof_hikashop_taxation AS b 
  ON a.category_namekey=b.category_namekey 
  LEFT JOIN s3gof_hikashop_tax AS c 
  ON b.tax_namekey=c.tax_namekey
1 × SELECT `enabled` 
  FROM `s3gof_extensions`
1 × SELECT `query` 
  FROM `s3gof_admintools_wafexceptions`
1 × SELECT Keyword , KeywordBold ,KeywordUnderline,KeywordLimit ,KeywordAttributes ,KeywordLink 
  FROM s3gof_rsseo_keywords
1 × SELECT * 
  FROM `s3gof_rsfirewall_configuration
1 × SELECT b.* 
  FROM s3gof_hikashop_zone_link AS a 
  LEFT JOIN s3gof_hikashop_zone AS b 
  ON a.zone_parent_namekey=b.zone_namekey
1 × SELECT * 
  FROM `s3gof_admintools_ipautoban`
1 × SELECT * 
  FROM s3gof_hikashop_zone
1 × SELECT a.* 
  FROM s3gof_hikashop_price AS a
1 × SELECT `ip`, `reason` 
  FROM s3gof_rsfirewall_lists
1 × SELECT b.rules 
  FROM s3gof_assets AS a 
  LEFT JOIN s3gof_assets AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt
1 × SELECT parent.id, parent.lft, parent.rgt 
  FROM s3gof_usergroups AS parent
1 × SELECT `data` 
  FROM `s3gof_session`
1 × SELECT * 
  FROM s3gof_rsseo_redirects
1 × SELECT id, home, template, s.params 
  FROM s3gof_template_styles as s 
  LEFT JOIN s3gof_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM s3gof_menu AS m 
  LEFT JOIN s3gof_extensions AS e 
  ON m.component_id = e.extension_id
1 × SELECT * 
  FROM s3gof_languages
1 × SELECT folder AS type, element AS name, params 
  FROM s3gof_extensions
1 × SELECT id 
  FROM s3gof_usergroup
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM s3gof_modules AS m 
  LEFT JOIN s3gof_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN s3gof_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id
1 × SELECT * 
  FROM s3gof_hikashop_confi
1 × SELECT IdPage, PageModified, PageTitle , PageKeywords , PageDescription, PageCrawled , PageLevel, canonical, robots 
  FROM s3gof_rsseo_pages
1 × SELECT IdPage 
  FROM s3gof_rsseo_pages
1 × SELECT * 
  FROM `s3gof_rsseo_config
1 × SELECT * 
  FROM s3gof_rsfirewall_snapshots
1 × SELECT `source` 
  FROM `s3gof_admintools_redirects`
ANDERE Tabellen:
1 × UPDATE `s3gof_session` 
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:5;s:19:\"session.timer.start\";i:1350541134;s:18:\"session.timer.last\";i:1350541283;s:17:\"session.timer.now\";i:1350541296;s:22:\"session.client.browser\";s:106:\"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.4 (KHTML, like Gecko) Chrome/22.0.1229.94 Safari/537.4\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:12:\"com_hikashop\";O:8:\"stdClass\":4:{s:12:\"ssl_redirect\";i:0;s:7:\"zone_id\";s:3:\"150\";s:15:\"0_filter_Zoeken\";s:5:\"duplo\";s:45:\"product_hikashop_category_information_menu__2\";O:8:\"stdClass\":1:{s:10:\"limitstart\";i:0;}}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";N;s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"041931ef86f2dd82c56455672b8cc2b4\";}VMCHECK|s:7:\"NOCHECK\";' , `time` = '1350541297'
1 × DELETE 
  FROM s3gof_users
1 × SHOW FULL COLUMNS 
  FROM `s3gof_users