Joomla! Debug Console
Session
__default
session.client.browser ? Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/30.0.1599.101 Safari/537.36
user
session.token ? 2a78728798f50728733deeeebfacee23
__wf
session.token ? 4ad1a2c6d25237d1e2246422d4e96353
Profile Information
Application 0.001 seconds (+0.001); 1.34 MB (+1.340) - afterLoad
Application 0.087 seconds (+0.086); 13.96 MB (+12.623) - afterInitialise
Application 0.208 seconds (+0.121); 25.21 MB (+11.250) - afterRoute
Application 633.129 seconds (+632.921); 48.38 MB (+23.164) - afterDispatch
Application 633.133 seconds (+0.004); 48.53 MB (+0.155) - beforeRenderModule mod_version (Joomla Version)
Application 633.135 seconds (+0.002); 48.58 MB (+0.045) - afterRenderModule mod_version (Joomla Version)
Application 633.135 seconds (+0.000); 48.57 MB (-0.003) - beforeRenderModule mod_submenu (Admin Submenu)
Application 633.137 seconds (+0.002); 48.63 MB (+0.053) - afterRenderModule mod_submenu (Admin Submenu)
Application 633.138 seconds (+0.000); 48.62 MB (-0.001) - beforeRenderModule mod_title (Title)
Application 633.139 seconds (+0.002); 48.63 MB (+0.005) - afterRenderModule mod_title (Title)
Application 633.139 seconds (+0.000); 48.63 MB (-0.002) - beforeRenderModule mod_toolbar (Toolbar)
Application 633.142 seconds (+0.003); 48.69 MB (+0.059) - afterRenderModule mod_toolbar (Toolbar)
Application 633.142 seconds (+0.000); 48.68 MB (-0.002) - beforeRenderModule mod_status (User Status)
Application 633.145 seconds (+0.003); 48.69 MB (+0.007) - afterRenderModule mod_status (User Status)
Application 633.146 seconds (+0.000); 48.69 MB (-0.003) - beforeRenderModule mod_menu (Admin Menu)
Application 633.224 seconds (+0.079); 49.38 MB (+0.695) - afterRenderModule mod_menu (Admin Menu)
Application 633.225 seconds (+0.000); 49.26 MB (-0.120) - beforeRenderModule mod_cb_adminnav (Community Builder Admin menu)
Application 633.228 seconds (+0.003); 49.45 MB (+0.185) - afterRenderModule mod_cb_adminnav (Community Builder Admin menu)
Application 633.236 seconds (+0.008); 49.92 MB (+0.470) - afterRender
Memory Usage
48.53 MB (50,887,256 Bytes)
Database Queries
275 Queries Logged
SELECT `data` 
  FROM `sag13_session` 
  WHERE `session_id` = 'e834078a0bc57741572b7bf8c0b014ef'
DELETE 
  FROM `sag13_session` 
  WHERE `time` < '1384726149'
SELECT extension_id AS id, element AS "option", params, enabled 
  FROM sag13_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_languages'
SELECT folder AS type, element AS name, params 
  FROM sag13_extensions 
  WHERE enabled >= 1 
  AND type ='plugin' 
  AND state >= 0 
  AND access IN (1,1,2,3,5,6,7,8,9) 
  ORDER BY ordering
SELECT `enabled` 
  FROM `sag13_extensions` 
  WHERE `element` = 'com_akeeba' 
  AND `type` = 'component'
SELECT `value` 
  FROM `sag13_admintools_storage` 
  WHERE `key` = 'cparams'
SELECT `query` 
  FROM `sag13_admintools_wafexceptions` 
  WHERE (`option` IS NULL OR `option` = '' OR `option` = 'com_comprofiler') 
  AND (`view` IS NULL OR `view` = '') 
  GROUP BY `query` 
  ORDER BY `query` ASC
SELECT * 
  FROM `sag13_admintools_ipautoban` 
  WHERE `ip` = '220.239.105.169'
SELECT `value` 
  FROM `sag13_admintools_storage` 
  WHERE `key` = 'cparams'
SELECT `ip` 
  FROM `sag13_admintools_ipblock`
SELECT extension_id AS id, element AS "option", params, enabled 
  FROM sag13_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_fabrik'
SELECT extension_id AS id, element AS "option", params, enabled 
  FROM sag13_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_aclmanager'
SELECT * 
  FROM `sag13_cbsubs_config` 
  WHERE `id` = '1'
SHOW FULL COLUMNS 
  FROM `sag13_users`
SELECT c.*, u.* 
  FROM sag13_users AS u 
  LEFT JOIN sag13_comprofiler AS c 
  ON c.id = u.id 
  WHERE u.id = 838
SELECT a.id 
  FROM sag13_user_usergroup_map AS map 
  LEFT JOIN sag13_usergroups AS a 
  ON a.id = map.group_id 
  WHERE map.user_id = 838
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  WHERE s.user_id = 838 
  AND s.status = 'A' 
  ORDER BY s.plan_id
SELECT a.* 
  FROM `sag13_cbsubs_plans` AS a 
  WHERE a.`id` = 6
SELECT a.* 
  FROM `sag13_cbsubs_plans` AS a 
  LEFT JOIN `sag13_cbsubs_plans` AS b 
  ON b.`id` = a.`parent` 
  WHERE a.published = 1 
  AND a.viewaccesslevel IN (1,2,3,5,6,7,8,9) 
  GROUP BY a.id 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT template, s.params 
  FROM sag13_template_styles as s 
  LEFT JOIN sag13_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 home = 1 
  ORDER BY home
SELECT extension_id AS id, element AS "option", params, enabled 
  FROM sag13_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_comprofiler'
SELECT f.* 
  FROM sag13_comprofiler_fields f 
  INNER JOIN sag13_comprofiler_tabs AS t 
  ON (f.tabid = t.tabid) 
  ORDER BY t.position, t.ordering, f.ordering
SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name 
  FROM sag13_comprofiler_plugin 
  WHERE published = 1 
  AND access IN (0,1,2,5,6,7,8,9) 
  AND type = 'user' 
  ORDER BY ordering
SELECT * 
  FROM `sag13_comprofiler_plugin` 
  WHERE `element` = 'cbarticles'
SELECT * 
  FROM `sag13_comprofiler_tabs` 
  WHERE `pluginid` = 501
SELECT * 
  FROM `sag13_comprofiler_plugin` 
  WHERE `element` = 'cbautoactions'
SELECT * 
  FROM `sag13_comprofiler_plugin_autoactions` 
  WHERE ( `published` = 1 ) 
  ORDER BY `ordering` ASC
SELECT * 
  FROM `sag13_comprofiler_plugin` 
  WHERE `element` = 'cbconditional'
SELECT f.* 
  FROM sag13_comprofiler_fields f 
  INNER JOIN sag13_comprofiler_tabs AS t 
  ON (f.tabid = t.tabid) 
  WHERE f.published = 1 
  AND t.enabled = 1 
  ORDER BY t.position, t.ordering, f.ordering
SELECT * 
  FROM `sag13_usergroups` 
  ORDER BY `lft`
SELECT parent.id, parent.lft, parent.rgt 
  FROM sag13_usergroups AS parent 
  ORDER BY parent.lft
SHOW FULL COLUMNS 
  FROM `sag13_assets`
SELECT id 
  FROM sag13_assets 
  WHERE parent_id = 0
SELECT b.rules 
  FROM sag13_assets AS a 
  LEFT JOIN sag13_assets AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt 
  WHERE (a.name = '') 
  GROUP BY b.id, b.rules, b.lft 
  ORDER BY b.lft
SELECT id 
  FROM sag13_assets 
  WHERE parent_id = 0
SELECT rules 
  FROM sag13_assets 
  WHERE id = '1'
SELECT * 
  FROM `sag13_usergroups` 
  ORDER BY `lft`
SELECT b.id 
  FROM sag13_user_usergroup_map AS map 
  LEFT JOIN sag13_usergroups AS a 
  ON a.id = map.group_id 
  LEFT JOIN sag13_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt 
  WHERE map.user_id = 838
SELECT id 
  FROM sag13_assets 
  WHERE parent_id = 0
SELECT a.`id` AS value, a.`title` AS text, COUNT( DISTINCT b.`id` ) AS level 
  FROM `sag13_usergroups` AS a 
  LEFT JOIN `sag13_usergroups` AS b 
  ON a.`lft` > b.`lft` 
  AND a.`rgt` < b.`rgt` 
  GROUP BY a.`id` 
  ORDER BY a.`lft` ASC
SELECT * 
  FROM sag13_comprofiler_tabs t 
  WHERE t.enabled=1 
  AND t.useraccessgroupid IN (-2,-1,1,9,6,7,14,11,12,15,2,3,4,5,10,16,8) 
  ORDER BY t.position, t.ordering
SELECT fieldtitle AS `value`, fieldtitle AS `text`, concat('cbf',fieldvalueid) AS id 
  FROM sag13_comprofiler_field_values 
  WHERE fieldid = 71 
  ORDER BY ordering
SELECT fieldtitle AS `value`, fieldtitle AS `text`, concat('cbf',fieldvalueid) AS id 
  FROM sag13_comprofiler_field_values 
  WHERE fieldid = 80 
  ORDER BY ordering
SELECT fieldtitle AS `value`, fieldtitle AS `text`, concat('cbf',fieldvalueid) AS id 
  FROM sag13_comprofiler_field_values 
  WHERE fieldid = 88 
  ORDER BY ordering
SELECT fieldtitle AS `value`, fieldtitle AS `text`, concat('cbf',fieldvalueid) AS id 
  FROM sag13_comprofiler_field_values 
  WHERE fieldid = 89 
  ORDER BY ordering
SELECT fieldtitle AS `value`, fieldtitle AS `text`, concat('cbf',fieldvalueid) AS id 
  FROM sag13_comprofiler_field_values 
  WHERE fieldid = 90 
  ORDER BY ordering
SELECT fieldtitle AS `value`, fieldtitle AS `text`, concat('cbf',fieldvalueid) AS id 
  FROM sag13_comprofiler_field_values 
  WHERE fieldid = 91 
  ORDER BY ordering
SELECT fieldtitle AS `value`, fieldtitle AS `text`, concat('cbf',fieldvalueid) AS id 
  FROM sag13_comprofiler_field_values 
  WHERE fieldid = 111 
  ORDER BY ordering
SELECT fieldtitle AS `value`, fieldtitle AS `text`, concat('cbf',fieldvalueid) AS id 
  FROM sag13_comprofiler_field_values 
  WHERE fieldid = 70 
  ORDER BY ordering
SELECT fieldtitle AS `value`, fieldtitle AS `text`, concat('cbf',fieldvalueid) AS id 
  FROM sag13_comprofiler_field_values 
  WHERE fieldid = 99 
  ORDER BY ordering
SELECT fieldtitle AS `value`, fieldtitle AS `text`, concat('cbf',fieldvalueid) AS id 
  FROM sag13_comprofiler_field_values 
  WHERE fieldid = 100 
  ORDER BY ordering
SELECT fieldtitle AS `value`, fieldtitle AS `text`, concat('cbf',fieldvalueid) AS id 
  FROM sag13_comprofiler_field_values 
  WHERE fieldid = 101 
  ORDER BY ordering
SELECT fieldtitle AS `value`, fieldtitle AS `text`, concat('cbf',fieldvalueid) AS id 
  FROM sag13_comprofiler_field_values 
  WHERE fieldid = 103 
  ORDER BY ordering
SELECT COUNT(DISTINCT u.id) 
  FROM sag13_users AS u 
  LEFT JOIN sag13_comprofiler AS ue 
  ON u.id = ue.id 
  INNER JOIN sag13_user_usergroup_map AS aro 
  ON aro.user_id = u.id 
  INNER JOIN sag13_usergroups AS g 
  ON g.id = aro.group_id
SELECT u.*, GROUP_CONCAT( DISTINCT g.title 
  ORDER BY g.title SEPARATOR ', ') AS groupname, ue.approved, ue.confirmed, ue.cbactivation 
  FROM sag13_users AS u 
  LEFT JOIN sag13_comprofiler AS ue 
  ON u.id = ue.id 
  INNER JOIN sag13_user_usergroup_map AS aro 
  ON aro.user_id = u.id 
  INNER JOIN sag13_usergroups AS g 
  ON g.id = aro.group_id 
  GROUP BY u.id 
  LIMIT 0, 100
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 62
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 68
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 70
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 72
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 76
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 77
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 81
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 82
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 708
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 838
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 857
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22269
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22270
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22271
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22272
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22273
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22274
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22275
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22276
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22277
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22278
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22279
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22280
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22281
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22282
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22283
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22284
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22285
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22286
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22287
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22288
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22289
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22290
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22291
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22292
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22293
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22294
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22295
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22296
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22297
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22298
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22299
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22300
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22301
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22302
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22303
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22304
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22305
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22306
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22307
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22308
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22309
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22310
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22311
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22312
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22313
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22314
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22315
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22316
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22317
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22318
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22319
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22320
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22321
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22322
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22323
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22324
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22325
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22326
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22327
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22328
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22329
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22330
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22331
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22332
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22333
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22334
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22335
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22336
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22337
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22338
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22339
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22340
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22341
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22342
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22343
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22344
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22345
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22346
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22347
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22348
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22349
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22350
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22351
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22352
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22353
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22354
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22355
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22356
SELECT COUNT(s.userid) 
  FROM sag13_session AS s 
  WHERE s.userid = 22357
SELECT n.user_id, COUNT(n.id) AS note_count 
  FROM `sag13_user_notes` AS n 
  WHERE n.user_id IN (62,68,70,72,76,77,81,82,708,838,857,22269,22270,22271,22272,22273,22274,22275,22276,22277,22278,22279,22280,22281,22282,22283,22284,22285,22286,22287,22288,22289,22290,22291,22292,22293,22294,22295,22296,22297,22298,22299,22300,22301,22302,22303,22304,22305,22306,22307,22308,22309,22310,22311,22312,22313,22314,22315,22316,22317,22318,22319,22320,22321,22322,22323,22324,22325,22326,22327,22328,22329,22330,22331,22332,22333,22334,22335,22336,22337,22338,22339,22340,22341,22342,22343,22344,22345,22346,22347,22348,22349,22350,22351,22352,22353,22354,22355,22356,22357)
  AND n.state >= 0 
  GROUP BY n.user_id
SELECT id AS value, title AS text 
  FROM sag13_usergroups
SELECT a.* 
  FROM `sag13_cbsubs_plans` AS a 
  LEFT JOIN `sag13_cbsubs_plans` AS b 
  ON b.`id` = a.`parent` 
  WHERE a.published = 1 
  AND a.access IN (-2,-1,1,9,6,7,14,11,12,15,2,3,4,5,10,16,8) 
  AND a.viewaccesslevel IN (1,2,3,5,6,7,8,9) 
  GROUP BY a.id 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 62 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 68 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 70 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT a.* 
  FROM `sag13_cbsubs_plans` AS a 
  WHERE a.`id` = 21
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 72 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 76 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 77 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 81 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 82 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 708 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 838 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 857 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22269 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22270 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22271 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22272 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22273 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22274 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22275 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22276 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22277 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22278 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22279 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22280 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22281 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT a.* 
  FROM `sag13_cbsubs_plans` AS a 
  WHERE a.`id` = 4
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22282 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22283 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22284 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22285 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22286 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22287 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22288 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22289 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22290 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22291 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22292 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22293 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22294 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22295 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22296 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22297 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22298 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22299 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22300 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22301 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22302 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22303 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22304 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22305 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22306 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22307 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22308 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22309 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22310 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22311 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22312 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22313 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22314 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22315 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22316 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22317 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22318 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22319 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22320 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22321 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22322 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22323 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22324 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22325 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22326 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22327 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22328 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22329 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22330 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22331 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22332 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22333 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22334 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22335 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22336 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22337 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22338 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22339 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22340 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22341 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22342 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22343 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22344 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22345 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22346 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22347 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT a.* 
  FROM `sag13_cbsubs_plans` AS a 
  WHERE a.`id` = 14
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22348 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22349 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22350 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22351 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22352 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22353 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22354 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22355 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22356 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent` 
  WHERE s.user_id = 22357 
  AND s.status = 'A' 
  GROUP BY s.`id` 
  ORDER BY IF( ISNULL( b.`ordering` ) , a.`ordering`, b.`ordering` ) ASC, IF( ISNULL( b.`ordering` ) , a.`ordering`, 11000 + a.`ordering` ) ASC
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM sag13_modules AS m 
  LEFT JOIN sag13_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN sag13_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 <= '2013-11-17 23:04:42') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2013-11-17 23:04:42') 
  AND m.access IN (1,1,2,3,5,6,7,8,9) 
  AND m.client_id = 1 
  AND (mm.menuid = 0 OR mm.menuid <= 0) 
  ORDER BY m.position, m.ordering
SELECT COUNT(*) 
  FROM sag13_messages 
  WHERE state = 0 
  AND user_id_to = 838
SELECT COUNT(session_id) 
  FROM sag13_session 
  WHERE guest = 0 
  AND client_id = 1
SELECT COUNT(session_id) 
  FROM sag13_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 sag13_menu_types AS a 
  LEFT JOIN sag13_menu AS b 
  ON b.menutype = a.menutype 
  AND b.home != 0 
  LEFT JOIN sag13_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 sag13_menu AS m 
  LEFT JOIN sag13_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
SELECT `id` 
  FROM `sag13_comprofiler_plugin` 
  WHERE `element` = 'cbpaidsubscriptions' 
  LIMIT 0, 1
SELECT `id` 
  FROM `sag13_comprofiler_plugin` 
  WHERE `element` = 'cbgroupjive' 
  LIMIT 0, 1
SELECT `enabled` 
  FROM `sag13_extensions` 
  WHERE `element` = 'com_akeeba' 
  AND `type` = 'component'
SELECT extension_id AS id, element AS "option", params, enabled 
  FROM sag13_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_akeeba'
SELECT `enabled` 
  FROM `sag13_extensions` 
  WHERE `element` = 'com_admintools' 
  AND `type` = 'component'
SELECT `params` 
  FROM `sag13_extensions` 
  WHERE `element` = 'com_admintools' 
  AND `type` = 'component'
SELECT extension_id AS id, element AS "option", params, enabled 
  FROM sag13_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_installer'
UPDATE `sag13_session` 
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:47;s:19:\"session.timer.start\";i:1384721484;s:18:\"session.timer.last\";i:1384728135;s:17:\"session.timer.now\";i:1384728849;s:22:\"session.client.browser\";s:109:\"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/30.0.1599.101 Safari/537.36\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":7:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:13:\"com_installer\";O:8:\"stdClass\":2:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";}s:21:\"searchcom_comprofiler\";s:0:\"\";s:29:\"viewcom_comprofilerlimitstart\";i:0;s:29:\"viewcom_comprofilerlastCBlist\";s:9:\"showusers\";s:26:\"filter_typecom_comprofiler\";s:1:\"0\";s:13:\"viewlistlimit\";s:3:\"100\";}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:3:\"838\";s:4:\"name\";s:12:\"David Farmer\";s:8:\"username\";s:7:\"austega\";s:5:\"email\";s:24:\"david.farmer@austega.com\";s:8:\"password\";s:65:\"cad65c9b6dcc2315ef60dd1c46ef5f11:uiBiS6QUAdCwAuLy4HOjTEY7lMTxVJlo\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:19:\"Super Administrator\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"0\";s:12:\"registerDate\";s:19:\"2012-11-23 05:24:56\";s:13:\"lastvisitDate\";s:19:\"2013-11-15 11:53:26\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:92:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";s:6:\"groups\";a:2:{i:8;s:1:\"8\";i:15;s:2:\"15\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";}}s:14:\"\0*\0_authGroups\";a:4:{i:0;i:1;i:1;i:8;i:3;i:6;i:4;i:15;}s:14:\"\0*\0_authLevels\";a:9:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:5;i:5;i:6;i:6;i:7;i:7;i:8;i:8;i:9;}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:\"2a78728798f50728733deeeebfacee23\";}__wf|a:1:{s:13:\"session.token\";s:32:\"4ad1a2c6d25237d1e2246422d4e96353\";}' , `time` = '1384729482' 
  WHERE `session_id` = 'e834078a0bc57741572b7bf8c0b014ef'
46 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
100 × SELECT COUNT(s.userid) 
  FROM sag13_session AS s
100 × SELECT s.* 
  FROM sag13_cbsubs_subscriptions s 
  LEFT JOIN sag13_cbsubs_plans AS a 
  ON a.`id` = s.`plan_id` 
  LEFT JOIN sag13_cbsubs_plans AS b 
  ON b.`id` = a.`parent`
12 × SELECT fieldtitle AS `value`, fieldtitle AS `text`, concat('cbf',fieldvalueid) AS id 
  FROM sag13_comprofiler_field_values
6 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM sag13_extensions
4 × SELECT a.* 
  FROM `sag13_cbsubs_plans` AS a
3 × SELECT * 
  FROM `sag13_comprofiler_plugin`
3 × SELECT id 
  FROM sag13_assets
3 × SELECT `enabled` 
  FROM `sag13_extensions`
2 × SELECT a.* 
  FROM `sag13_cbsubs_plans` AS a 
  LEFT JOIN `sag13_cbsubs_plans` AS b 
  ON b.`id` = a.`parent`
2 × SELECT f.* 
  FROM sag13_comprofiler_fields f 
  INNER JOIN sag13_comprofiler_tabs AS t 
  ON (f.tabid = t.tabid)
2 × SELECT `id` 
  FROM `sag13_comprofiler_plugin`
2 × SELECT COUNT(session_id) 
  FROM sag13_session
2 × SELECT * 
  FROM `sag13_usergroups`
2 × SELECT `value` 
  FROM `sag13_admintools_storage`
1 × SELECT id AS value, title AS text 
  FROM sag13_usergroup
1 × SELECT n.user_id, COUNT(n.id) AS note_count 
  FROM `sag13_user_notes` AS n
1 × SELECT * 
  FROM `sag13_admintools_ipautoban`
1 × SELECT COUNT(DISTINCT u.id) 
  FROM sag13_users AS u 
  LEFT JOIN sag13_comprofiler AS ue 
  ON u.id = ue.id 
  INNER JOIN sag13_user_usergroup_map AS aro 
  ON aro.user_id = u.id 
  INNER JOIN sag13_usergroups AS g 
  ON g.id = aro.group_i
1 × SELECT u.*, GROUP_CONCAT( DISTINCT g.title 
  ORDER BY g.title SEPARATOR ', ') AS groupname, ue.approved, ue.confirmed, ue.cbactivation 
  FROM sag13_users AS u 
  LEFT JOIN sag13_comprofiler AS ue 
  ON u.id = ue.id 
  INNER JOIN sag13_user_usergroup_map AS aro 
  ON aro.user_id = u.id 
  INNER JOIN sag13_usergroups AS g 
  ON g.id = aro.group_id 
  GROUP BY u.id 
  LIMIT 0, 10
1 × SELECT `query` 
  FROM `sag13_admintools_wafexceptions`
1 × SELECT COUNT(*) 
  FROM sag13_messages
1 × SELECT folder AS type, element AS name, params 
  FROM sag13_extensions
1 × SELECT `params` 
  FROM `sag13_extensions`
1 × SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element 
  FROM sag13_menu AS m 
  LEFT JOIN sag13_extensions AS e 
  ON m.component_id = e.extension_id
1 × SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native 
  FROM sag13_menu_types AS a 
  LEFT JOIN sag13_menu AS b 
  ON b.menutype = a.menutype 
  AND b.home != 0 
  LEFT JOIN sag13_languages AS l 
  ON l.lang_code = language
1 × SELECT `ip` 
  FROM `sag13_admintools_ipblock
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM sag13_modules AS m 
  LEFT JOIN sag13_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN sag13_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id
1 × SELECT * 
  FROM sag13_comprofiler_tabs t
1 × SELECT * 
  FROM `sag13_comprofiler_tabs`
1 × SELECT * 
  FROM `sag13_comprofiler_plugin_autoactions`
1 × SELECT c.*, u.* 
  FROM sag13_users AS u 
  LEFT JOIN sag13_comprofiler AS c 
  ON c.id = u.id
1 × SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name 
  FROM sag13_comprofiler_plugin
1 × SELECT template, s.params 
  FROM sag13_template_styles as s 
  LEFT JOIN sag13_extensions as e 
  ON e.type='template' 
  AND e.element=s.template 
  AND e.client_id=s.client_id
1 × SELECT a.id 
  FROM sag13_user_usergroup_map AS map 
  LEFT JOIN sag13_usergroups AS a 
  ON a.id = map.group_id
1 × SELECT `data` 
  FROM `sag13_session`
1 × SELECT parent.id, parent.lft, parent.rgt 
  FROM sag13_usergroups AS parent
1 × SELECT b.id 
  FROM sag13_user_usergroup_map AS map 
  LEFT JOIN sag13_usergroups AS a 
  ON a.id = map.group_id 
  LEFT JOIN sag13_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt
1 × SELECT a.`id` AS value, a.`title` AS text, COUNT( DISTINCT b.`id` ) AS level 
  FROM `sag13_usergroups` AS a 
  LEFT JOIN `sag13_usergroups` AS b 
  ON a.`lft` > b.`lft` 
  AND a.`rgt` < b.`rgt` 
  GROUP BY a.`id`
1 × SELECT rules 
  FROM sag13_assets
1 × SELECT b.rules 
  FROM sag13_assets AS a 
  LEFT JOIN sag13_assets AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt
1 × SELECT * 
  FROM `sag13_cbsubs_config`
1 × SELECT s.* 
  FROM sag13_cbsubs_subscriptions s
OTHER Tables:
1 × UPDATE `sag13_session` 
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:47;s:19:\"session.timer.start\";i:1384721484;s:18:\"session.timer.last\";i:1384728135;s:17:\"session.timer.now\";i:1384728849;s:22:\"session.client.browser\";s:109:\"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/30.0.1599.101 Safari/537.36\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":7:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:13:\"com_installer\";O:8:\"stdClass\":2:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";}s:21:\"searchcom_comprofiler\";s:0:\"\";s:29:\"viewcom_comprofilerlimitstart\";i:0;s:29:\"viewcom_comprofilerlastCBlist\";s:9:\"showusers\";s:26:\"filter_typecom_comprofiler\";s:1:\"0\";s:13:\"viewlistlimit\";s:3:\"100\";}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:3:\"838\";s:4:\"name\";s:12:\"David Farmer\";s:8:\"username\";s:7:\"austega\";s:5:\"email\";s:24:\"david.farmer@austega.com\";s:8:\"password\";s:65:\"cad65c9b6dcc2315ef60dd1c46ef5f11:uiBiS6QUAdCwAuLy4HOjTEY7lMTxVJlo\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:19:\"Super Administrator\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"0\";s:12:\"registerDate\";s:19:\"2012-11-23 05:24:56\";s:13:\"lastvisitDate\";s:19:\"2013-11-15 11:53:26\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:92:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";s:6:\"groups\";a:2:{i:8;s:1:\"8\";i:15;s:2:\"15\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";}}s:14:\"\0*\0_authGroups\";a:4:{i:0;i:1;i:1;i:8;i:3;i:6;i:4;i:15;}s:14:\"\0*\0_authLevels\";a:9:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:5;i:5;i:6;i:6;i:7;i:7;i:8;i:8;i:9;}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:\"2a78728798f50728733deeeebfacee23\";}__wf|a:1:{s:13:\"session.token\";s:32:\"4ad1a2c6d25237d1e2246422d4e96353\";}' , `time` = '1384729482'
1 × SHOW FULL COLUMNS 
  FROM `sag13_assets
1 × SHOW FULL COLUMNS 
  FROM `sag13_users
1 × DELETE 
  FROM `sag13_session`