247 Queries Logged

1. SELECT `data`
  FROM `r2dr1_session`
  WHERE `session_id` = 'jt9ikld649vtdt1k76mtn3s5k4'
2. DELETE
  FROM `r2dr1_session`
  WHERE `time` < '1371704099'
3. SELECT `session_id`
  FROM `r2dr1_session`
  WHERE `session_id` = 'jt9ikld649vtdt1k76mtn3s5k4'
  LIMIT 0, 1
4. INSERT INTO `r2dr1_session` (`session_id`, `client_id`, `time`)
  VALUES ('jt9ikld649vtdt1k76mtn3s5k4', 0, '1371710099')
5. SELECT extension_id AS id, element AS "option", params, enabled
  FROM r2dr1_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_users'
6. SELECT b.id
  FROM r2dr1_usergroups AS a
  LEFT JOIN r2dr1_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.id = 1
7. SELECT id, rules
  FROM `r2dr1_viewlevels`
8. SELECT folder AS type, element AS name, params
  FROM r2dr1_extensions
  WHERE enabled >= 1
  AND type ='plugin'
  AND state >= 0
  AND access IN (1,1)
  ORDER BY ordering
9. SELECT extension_id AS id, element AS "option", params, enabled
  FROM r2dr1_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_languages'
10. SELECT `path`
  FROM r2dr1_rsfirewall_ignored
  WHERE `type`='ignore_folder' OR `type`='ignore_file'
11. SELECT `file`
  FROM r2dr1_rsfirewall_hashes
  WHERE `type`='protect'
12. SELECT *
  FROM r2dr1_rsfirewall_configuration
13. CREATE TABLE IF NOT EXISTS `r2dr1_ualog` ( `id` int(11) NOT NULL auto_increment, `user_id` int(11) NOT NULL, `option` varchar(255) NOT NULL, `task` varchar(255) NOT NULL, `action_link` text NOT NULL, `action_title` text NOT NULL, `item_title` varchar(255) NOT NULL, `cdate` int(11) NOT NULL, PRIMARY KEY (`id`))
14. SELECT id
  FROM r2dr1_menu
  WHERE link = 'index.php?option=com_community&view=frontpage'
  AND published = 1
15. SELECT extension_id AS id, element AS "option", params, enabled
  FROM r2dr1_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_autotweet'
16. SELECT template
  FROM r2dr1_template_styles as s
  WHERE s.client_id = 0
  AND s.home = 1
17. SELECT template
  FROM r2dr1_template_styles as s
  WHERE s.client_id = 0
  AND s.home = 1
18. SELECT extension, file, type
  FROM r2dr1_rokcommon_configs
  ORDER BY priority
19. SELECT `custom_data`
  FROM `r2dr1_extensions`
  WHERE `type` = 'component'
  AND `element` = 'com_sef'
20. SHOW FULL COLUMNS
  FROM `r2dr1_extensions`
21. SELECT `extension_id`
  FROM `r2dr1_extensions`
  WHERE type = 'component'
  AND element = 'com_roksprocket'
22. SELECT *
  FROM r2dr1_extensions
  WHERE `extension_id` = '10271'
23. SELECT `extension_id`
  FROM `r2dr1_extensions`
  WHERE type = 'module'
  AND element = 'mod_roksprocket'
24. SELECT *
  FROM r2dr1_extensions
  WHERE `extension_id` = '10271'
25. SELECT extension_id AS id, element AS "option", params, enabled
  FROM r2dr1_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_advancedmodules'
26. SELECT extension_id AS id, element AS "option", params, enabled
  FROM r2dr1_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_advancedmodules'
27. SELECT extension_id AS id, element AS "option", params, enabled
  FROM r2dr1_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_k2'
28. SELECT `params`
  FROM r2dr1_extensions
  WHERE `element`='com_sh404sef'
  AND `type`='component';
29. SELECT *
  FROM r2dr1_languages
  WHERE published=1
  ORDER BY ordering ASC
30. 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 r2dr1_menu AS m
  LEFT JOIN r2dr1_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
31. SHOW FULL COLUMNS
  FROM `r2dr1_rsfirewall_logs`
32. SELECT *
  FROM r2dr1_rsfirewall_hashes
  WHERE (`type`='2.5.11' OR `type`='protect')
  AND `flag`!='C'
33. SELECT *
  FROM r2dr1_rsfirewall_snapshots
  WHERE `type`='protect'
34. SELECT `ip`,`reason`
  FROM r2dr1_rsfirewall_lists
  WHERE (`ip`='67.202.9.192' OR `ip` LIKE '%*%')
  AND `type`='1'
  AND `published`='1'
35. SELECT `ip`,`reason`
  FROM r2dr1_rsfirewall_lists
  WHERE (`ip`='67.202.9.192' OR `ip` LIKE '%*%')
  AND `type`='0'
  AND `published`='1'
36. SELECT *
  FROM r2dr1_rsfirewall_exceptions
  WHERE `published`='1'
37. SELECT extension_id AS id, element AS "option", params, enabled
  FROM r2dr1_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_contenttemplater'
38. SELECT count(*)
  FROM r2dr1_eb_templates
39. SHOW TABLES
40. SHOW FULL COLUMNS
  FROM `r2dr1_autotweet_automator`
41. SELECT r2dr1_autotweet_automator.*
  FROM r2dr1_autotweet_automator
  WHERE `plugin` = 'automator'
42. SELECT r2dr1_autotweet_automator.*
  FROM r2dr1_autotweet_automator
  WHERE `plugin` = 'content'
43. SELECT a.rules
  FROM r2dr1_assets AS a
  WHERE (a.id = 1)
  GROUP BY a.id, a.rules, a.lft
44. SELECT b.rules
  FROM r2dr1_assets AS a
  LEFT JOIN r2dr1_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
45. INSERT INTO `r2dr1_rokuserstats` (`user_id`,`ip`,`session_id`,`page`,`referrer`)
  VALUES ('0','67.202.9.192','jt9ikld649vtdt1k76mtn3s5k4','/editors-desk/?p=28504','')
46. SELECT id, home, template, s.params
  FROM r2dr1_template_styles as s
  LEFT JOIN r2dr1_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
47. SELECT b.rules
  FROM r2dr1_assets AS a
  LEFT JOIN r2dr1_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE (a.name = 'com_k2' OR a.parent_id=0)
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
48. SELECT id
  FROM r2dr1_k2_categories
  WHERE published=1
  AND trash=0
  AND access IN(1,1)
49. SELECT *
  FROM r2dr1_k2_items
  WHERE id=38
  LIMIT 0, 1
50. SHOW FULL COLUMNS
  FROM `r2dr1_k2_categories`
51. SELECT *
  FROM r2dr1_k2_categories
  WHERE id = '16'
52. SELECT COUNT(*)
  FROM r2dr1_k2_comments
  WHERE itemID=38
  AND published=1
53. SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.params as adv_params, 0 as menuid, m.publish_up, m.publish_down
  FROM r2dr1_modules AS m
  LEFT JOIN r2dr1_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
  LEFT JOIN r2dr1_advancedmodules as am
  ON am.moduleid = m.id
  WHERE m.published = 1
  AND e.enabled = 1
  AND m.client_id = 0
  AND m.access IN (1,1)
  ORDER BY m.ordering, m.id
54. SELECT extension_id AS id, element AS "option", params, enabled
  FROM r2dr1_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_advancedmodules'
55. SELECT i.catid
  FROM r2dr1_k2_items AS i
  WHERE i.id = 38
56. SELECT t.parent
  FROM r2dr1_k2_categories as t
  WHERE t.id = 16
57. SELECT i.catid
  FROM r2dr1_k2_items AS i
  WHERE i.id = 38
58. SELECT t.parent
  FROM r2dr1_k2_categories as t
  WHERE t.id = 16
59. SELECT i.catid
  FROM r2dr1_k2_items AS i
  WHERE i.id = 38
60. SELECT t.parent
  FROM r2dr1_k2_categories as t
  WHERE t.id = 16
61. SELECT i.catid
  FROM r2dr1_k2_items AS i
  WHERE i.id = 38
62. SELECT t.parent
  FROM r2dr1_k2_categories as t
  WHERE t.id = 16
63. SELECT i.catid
  FROM r2dr1_k2_items AS i
  WHERE i.id = 38
64. SELECT t.parent
  FROM r2dr1_k2_categories as t
  WHERE t.id = 16
65. SELECT i.catid
  FROM r2dr1_k2_items AS i
  WHERE i.id = 38
66. SELECT t.parent
  FROM r2dr1_k2_categories as t
  WHERE t.id = 16
67. SELECT i.catid
  FROM r2dr1_k2_items AS i
  WHERE i.id = 38
68. SELECT t.parent
  FROM r2dr1_k2_categories as t
  WHERE t.id = 16
69. SELECT i.catid
  FROM r2dr1_k2_items AS i
  WHERE i.id = 38
70. SELECT t.parent
  FROM r2dr1_k2_categories as t
  WHERE t.id = 16
71. SELECT i.catid
  FROM r2dr1_k2_items AS i
  WHERE i.id = 38
72. SELECT t.parent
  FROM r2dr1_k2_categories as t
  WHERE t.id = 16
73. SELECT i.catid
  FROM r2dr1_k2_items AS i
  WHERE i.id = 38
74. SELECT t.parent
  FROM r2dr1_k2_categories as t
  WHERE t.id = 16
75. SELECT t.parent_id
  FROM r2dr1_menu as t
  WHERE t.id = 240
76. SELECT t.parent_id
  FROM r2dr1_menu as t
  WHERE t.id = 1
77. SELECT i.catid
  FROM r2dr1_k2_items AS i
  WHERE i.id = 38
78. SELECT i.catid
  FROM r2dr1_k2_items AS i
  WHERE i.id = 38
79. SELECT e.id,e.name,e.alias,e.description,e.params,e.image AS images,e.parent,(SELECT COUNT(count_table.id)
  FROM r2dr1_k2_items AS count_table
  WHERE e.id=count_table.catid) AS news_count
  FROM r2dr1_k2_categories AS e
  WHERE e.published IN (1)
  AND e.trash IN (0)
  AND e.parent >= 0
  AND e.access IN (1,1) -- Access condition
  AND e.language IN ('en-GB' , '*')
  GROUP BY e.id
80. SELECT e.id
  FROM r2dr1_k2_items AS e
  WHERE e.published IN (1)
  AND e.trash IN (0)
  AND e.catid IN (2,68,69,70,71,72,73,74,75)
  AND e.access IN (1,1) -- Access condition
  AND (e.publish_up = '0000-00-00 00:00:00' OR e.publish_up <= '2013-06-20 06:34:59')
  AND (e.publish_down = '0000-00-00 00:00:00' OR e.publish_down >= '2013-06-20 06:34:59')
  AND e.language IN ('en-GB' , '*')
  GROUP BY e.id
  ORDER BY e.created DESC
  LIMIT 0, 6
81. SELECT e.id,e.title,e.alias,e.introtext AS description,e.created,e.modified,e.hits,e.featured,e.catid,e.created_by AS author_id,(SELECT count(count_table.id)
  FROM r2dr1_k2_comments AS count_table
  WHERE count_table.itemID = e.id) AS comments
  FROM r2dr1_k2_items AS e
  WHERE e.id IN (8726,8721,8715,8725,8673,8659)
  GROUP BY e.id;
82. SHOW FULL COLUMNS
  FROM `r2dr1_users`
83. SELECT *
  FROM `r2dr1_users`
  WHERE `id` = 539
84. SELECT `g`.`id`,`g`.`title`
  FROM `r2dr1_usergroups` AS g
  INNER JOIN `r2dr1_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 539
85. SELECT *
  FROM `r2dr1_users`
  WHERE `id` = 515
86. SELECT `g`.`id`,`g`.`title`
  FROM `r2dr1_usergroups` AS g
  INNER JOIN `r2dr1_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 515
87. SELECT *
  FROM `r2dr1_users`
  WHERE `id` = 6172
88. SELECT `g`.`id`,`g`.`title`
  FROM `r2dr1_usergroups` AS g
  INNER JOIN `r2dr1_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 6172
89. SELECT *
  FROM `r2dr1_users`
  WHERE `id` = 499
90. SELECT `g`.`id`,`g`.`title`
  FROM `r2dr1_usergroups` AS g
  INNER JOIN `r2dr1_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 499
91. SELECT *
  FROM `r2dr1_users`
  WHERE `id` = 516
92. SELECT `g`.`id`,`g`.`title`
  FROM `r2dr1_usergroups` AS g
  INNER JOIN `r2dr1_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 516
93. SELECT *
  FROM `r2dr1_users`
  WHERE `id` = 592
94. SELECT `g`.`id`,`g`.`title`
  FROM `r2dr1_usergroups` AS g
  INNER JOIN `r2dr1_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 592
95. SELECT e.id
  FROM r2dr1_k2_items AS e
  WHERE e.published IN (1)
  AND e.trash IN (0)
  AND e.catid IN (3,76,77,78,79,80,81,82,83,84,85,86,87)
  AND e.access IN (1,1) -- Access condition
  AND (e.publish_up = '0000-00-00 00:00:00' OR e.publish_up <= '2013-06-20 06:34:59')
  AND (e.publish_down = '0000-00-00 00:00:00' OR e.publish_down >= '2013-06-20 06:34:59')
  AND e.language IN ('en-GB' , '*')
  GROUP BY e.id
  ORDER BY e.created DESC
  LIMIT 0, 6
96. SELECT e.id,e.title,e.alias,e.introtext AS description,e.created,e.modified,e.hits,e.featured,e.catid,e.created_by AS author_id,(SELECT count(count_table.id)
  FROM r2dr1_k2_comments AS count_table
  WHERE count_table.itemID = e.id) AS comments
  FROM r2dr1_k2_items AS e
  WHERE e.id IN (8730,8729,8724,8723,8727,8720)
  GROUP BY e.id;
97. SELECT *
  FROM `r2dr1_users`
  WHERE `id` = 24767
98. SELECT `g`.`id`,`g`.`title`
  FROM `r2dr1_usergroups` AS g
  INNER JOIN `r2dr1_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 24767
99. SELECT *
  FROM `r2dr1_users`
  WHERE `id` = 529
100. SELECT `g`.`id`,`g`.`title`
  FROM `r2dr1_usergroups` AS g
  INNER JOIN `r2dr1_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 529
101. SELECT e.id
  FROM r2dr1_k2_items AS e
  WHERE e.published IN (1)
  AND e.trash IN (0)
  AND e.catid IN (4)
  AND e.access IN (1,1) -- Access condition
  AND (e.publish_up = '0000-00-00 00:00:00' OR e.publish_up <= '2013-06-20 06:34:59')
  AND (e.publish_down = '0000-00-00 00:00:00' OR e.publish_down >= '2013-06-20 06:34:59')
  AND e.language IN ('en-GB' , '*')
  GROUP BY e.id
  ORDER BY e.created DESC
  LIMIT 0, 6
102. SELECT e.id,e.title,e.alias,e.introtext AS description,e.created,e.modified,e.hits,e.featured,e.catid,e.created_by AS author_id,(SELECT count(count_table.id)
  FROM r2dr1_k2_comments AS count_table
  WHERE count_table.itemID = e.id) AS comments
  FROM r2dr1_k2_items AS e
  WHERE e.id IN (8728,8585,8576,8482,8314,8178)
  GROUP BY e.id;
103. SELECT *
  FROM `r2dr1_users`
  WHERE `id` = 6114
104. SELECT `g`.`id`,`g`.`title`
  FROM `r2dr1_usergroups` AS g
  INNER JOIN `r2dr1_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 6114
105. SELECT *
  FROM `r2dr1_users`
  WHERE `id` = 494
106. SELECT `g`.`id`,`g`.`title`
  FROM `r2dr1_usergroups` AS g
  INNER JOIN `r2dr1_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 494
107. SELECT e.id
  FROM r2dr1_k2_items AS e
  WHERE e.published IN (1)
  AND e.trash IN (0)
  AND e.catid IN (10)
  AND e.access IN (1,1) -- Access condition
  AND (e.publish_up = '0000-00-00 00:00:00' OR e.publish_up <= '2013-06-20 06:34:59')
  AND (e.publish_down = '0000-00-00 00:00:00' OR e.publish_down >= '2013-06-20 06:34:59')
  AND e.language IN ('en-GB' , '*')
  GROUP BY e.id
  ORDER BY e.created DESC
  LIMIT 0, 6
108. SELECT e.id,e.title,e.alias,e.introtext AS description,e.created,e.modified,e.hits,e.featured,e.catid,e.created_by AS author_id,(SELECT count(count_table.id)
  FROM r2dr1_k2_comments AS count_table
  WHERE count_table.itemID = e.id) AS comments
  FROM r2dr1_k2_items AS e
  WHERE e.id IN (8518,8494,8179,8167,8165,4047)
  GROUP BY e.id;
109. SELECT *
  FROM `r2dr1_users`
  WHERE `id` = 535
110. SELECT `g`.`id`,`g`.`title`
  FROM `r2dr1_usergroups` AS g
  INNER JOIN `r2dr1_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 535
111. SELECT e.id
  FROM r2dr1_k2_items AS e
  WHERE e.published IN (1)
  AND e.trash IN (0)
  AND e.catid IN (7,88,89,90,106)
  AND e.access IN (1,1) -- Access condition
  AND (e.publish_up = '0000-00-00 00:00:00' OR e.publish_up <= '2013-06-20 06:34:59')
  AND (e.publish_down = '0000-00-00 00:00:00' OR e.publish_down >= '2013-06-20 06:34:59')
  AND e.language IN ('en-GB' , '*')
  GROUP BY e.id
  ORDER BY e.created DESC
  LIMIT 0, 6
112. SELECT e.id,e.title,e.alias,e.introtext AS description,e.created,e.modified,e.hits,e.featured,e.catid,e.created_by AS author_id,(SELECT count(count_table.id)
  FROM r2dr1_k2_comments AS count_table
  WHERE count_table.itemID = e.id) AS comments
  FROM r2dr1_k2_items AS e
  WHERE e.id IN (8732,8722,8718,8712,8711,8702)
  GROUP BY e.id;
113. SELECT *
  FROM `r2dr1_users`
  WHERE `id` = 490
114. SELECT `g`.`id`,`g`.`title`
  FROM `r2dr1_usergroups` AS g
  INNER JOIN `r2dr1_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 490
115. SELECT e.id
  FROM r2dr1_k2_items AS e
  WHERE e.published IN (1)
  AND e.trash IN (0)
  AND e.catid IN (11,91,92,93,94,105)
  AND e.access IN (1,1) -- Access condition
  AND (e.publish_up = '0000-00-00 00:00:00' OR e.publish_up <= '2013-06-20 06:34:59')
  AND (e.publish_down = '0000-00-00 00:00:00' OR e.publish_down >= '2013-06-20 06:34:59')
  AND e.language IN ('en-GB' , '*')
  GROUP BY e.id
  ORDER BY e.created DESC
  LIMIT 0, 6
116. SELECT e.id,e.title,e.alias,e.introtext AS description,e.created,e.modified,e.hits,e.featured,e.catid,e.created_by AS author_id,(SELECT count(count_table.id)
  FROM r2dr1_k2_comments AS count_table
  WHERE count_table.itemID = e.id) AS comments
  FROM r2dr1_k2_items AS e
  WHERE e.id IN (8713,8696,8681,8656,8638,8630)
  GROUP BY e.id;
117. SELECT e.id
  FROM r2dr1_k2_items AS e
  WHERE e.published IN (1)
  AND e.trash IN (0)
  AND e.catid IN (8)
  AND e.access IN (1,1) -- Access condition
  AND (e.publish_up = '0000-00-00 00:00:00' OR e.publish_up <= '2013-06-20 06:34:59')
  AND (e.publish_down = '0000-00-00 00:00:00' OR e.publish_down >= '2013-06-20 06:34:59')
  AND e.language IN ('en-GB' , '*')
  GROUP BY e.id
  ORDER BY e.created DESC
  LIMIT 0, 6
118. SELECT e.id,e.title,e.alias,e.introtext AS description,e.created,e.modified,e.hits,e.featured,e.catid,e.created_by AS author_id,(SELECT count(count_table.id)
  FROM r2dr1_k2_comments AS count_table
  WHERE count_table.itemID = e.id) AS comments
  FROM r2dr1_k2_items AS e
  WHERE e.id IN (8609,8549,802,804,3080,781)
  GROUP BY e.id;
119. SELECT *
  FROM `r2dr1_users`
  WHERE `id` = 537
120. SELECT `g`.`id`,`g`.`title`
  FROM `r2dr1_usergroups` AS g
  INNER JOIN `r2dr1_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 537
121. SELECT *
  FROM `r2dr1_users`
  WHERE `id` = 492
122. SELECT `g`.`id`,`g`.`title`
  FROM `r2dr1_usergroups` AS g
  INNER JOIN `r2dr1_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 492
123. SELECT e.id
  FROM r2dr1_k2_items AS e
  WHERE e.published IN (1)
  AND e.trash IN (0)
  AND e.catid IN (9)
  AND e.access IN (1,1) -- Access condition
  AND (e.publish_up = '0000-00-00 00:00:00' OR e.publish_up <= '2013-06-20 06:34:59')
  AND (e.publish_down = '0000-00-00 00:00:00' OR e.publish_down >= '2013-06-20 06:34:59')
  AND e.language IN ('en-GB' , '*')
  GROUP BY e.id
  ORDER BY e.created DESC
  LIMIT 0, 6
124. SELECT e.id,e.title,e.alias,e.introtext AS description,e.created,e.modified,e.hits,e.featured,e.catid,e.created_by AS author_id,(SELECT count(count_table.id)
  FROM r2dr1_k2_comments AS count_table
  WHERE count_table.itemID = e.id) AS comments
  FROM r2dr1_k2_items AS e
  WHERE e.id IN (8710,8700,8678,8662,8600,8569)
  GROUP BY e.id;
125. SELECT e.id
  FROM r2dr1_k2_items AS e
  WHERE e.published IN (1)
  AND e.trash IN (0)
  AND e.catid IN (12,95,96,97,98)
  AND e.access IN (1,1) -- Access condition
  AND (e.publish_up = '0000-00-00 00:00:00' OR e.publish_up <= '2013-06-20 06:34:59')
  AND (e.publish_down = '0000-00-00 00:00:00' OR e.publish_down >= '2013-06-20 06:34:59')
  AND e.language IN ('en-GB' , '*')
  GROUP BY e.id
  ORDER BY e.created DESC
  LIMIT 0, 6
126. SELECT e.id,e.title,e.alias,e.introtext AS description,e.created,e.modified,e.hits,e.featured,e.catid,e.created_by AS author_id,(SELECT count(count_table.id)
  FROM r2dr1_k2_comments AS count_table
  WHERE count_table.itemID = e.id) AS comments
  FROM r2dr1_k2_items AS e
  WHERE e.id IN (8645,4130,4129,8529,8515,8480)
  GROUP BY e.id;
127. SELECT *
  FROM `r2dr1_users`
  WHERE `id` = 534
128. SELECT `g`.`id`,`g`.`title`
  FROM `r2dr1_usergroups` AS g
  INNER JOIN `r2dr1_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 534
129. SELECT e.id
  FROM r2dr1_k2_items AS e
  WHERE e.published IN (1)
  AND e.trash IN (0)
  AND e.catid IN (13,99,100,101,102,103)
  AND e.access IN (1,1) -- Access condition
  AND (e.publish_up = '0000-00-00 00:00:00' OR e.publish_up <= '2013-06-20 06:34:59')
  AND (e.publish_down = '0000-00-00 00:00:00' OR e.publish_down >= '2013-06-20 06:34:59')
  AND e.language IN ('en-GB' , '*')
  GROUP BY e.id
  ORDER BY e.created DESC
  LIMIT 0, 6
130. SELECT e.id,e.title,e.alias,e.introtext AS description,e.created,e.modified,e.hits,e.featured,e.catid,e.created_by AS author_id,(SELECT count(count_table.id)
  FROM r2dr1_k2_comments AS count_table
  WHERE count_table.itemID = e.id) AS comments
  FROM r2dr1_k2_items AS e
  WHERE e.id IN (8686,4123,4122,4121,4120,8431)
  GROUP BY e.id;
131. SELECT *
  FROM `r2dr1_users`
  WHERE `id` = 533
132. SELECT `g`.`id`,`g`.`title`
  FROM `r2dr1_usergroups` AS g
  INNER JOIN `r2dr1_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 533
133. SELECT *
  FROM `r2dr1_users`
  WHERE `id` = 476
134. SELECT `g`.`id`,`g`.`title`
  FROM `r2dr1_usergroups` AS g
  INNER JOIN `r2dr1_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 476
135. SELECT b.id
  FROM r2dr1_user_usergroup_map AS map
  LEFT JOIN r2dr1_usergroups AS a
  ON a.id = map.group_id
  LEFT JOIN r2dr1_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE map.user_id = 476
136. SHOW FULL COLUMNS
  FROM `r2dr1_k2_items`
137. UPDATE r2dr1_k2_items
  SET `hits` = (`hits` + 1)
  WHERE id = '38'
138. SELECT extension_id AS id, element AS "option", params, enabled
  FROM r2dr1_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_hwdmediashare'
139. SHOW FULL COLUMNS
  FROM `r2dr1_community_config`
140. SELECT *
  FROM r2dr1_community_config
  WHERE `name` = 'config'
141. SELECT id
  FROM r2dr1_k2_categories
  WHERE parent IN (1)
  AND id NOT IN (1)
  AND published=1
  AND trash=0
  AND access IN(1,1)
142. SELECT id
  FROM r2dr1_k2_categories
  WHERE parent IN (2,3,4,7,8,9,10,11,12,13)
  AND id NOT IN (2,3,4,7,8,9,10,11,12,13)
  AND published=1
  AND trash=0
  AND access IN(1,1)
143. SELECT id
  FROM r2dr1_k2_categories
  WHERE parent IN (68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,105,106)
  AND id NOT IN (68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,105,106)
  AND published=1
  AND trash=0
  AND access IN(1,1)
144. SELECT i.*,
  CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
  FROM r2dr1_k2_items as i RIGHT JOIN r2dr1_k2_categories c
  ON c.id = i.catid
  WHERE i.published = 1
  AND i.access IN(1,1)
  AND i.trash = 0
  AND c.published = 1
  AND c.access IN(1,1)
  AND c.trash = 0
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2013-06-20 06:34:59' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2013-06-20 06:34:59' )
  AND i.catid IN (1,2,3,4,7,8,9,10,11,12,13,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,105,106)
  AND i.created > DATE_SUB('2013-06-20 06:34:59',INTERVAL 3 DAY)
  ORDER BY i.hits DESC
  LIMIT 0, 5
145. SELECT b.id
  FROM r2dr1_user_usergroup_map AS map
  LEFT JOIN r2dr1_usergroups AS a
  ON a.id = map.group_id
  LEFT JOIN r2dr1_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE map.user_id = 539
146. SELECT b.id
  FROM r2dr1_user_usergroup_map AS map
  LEFT JOIN r2dr1_usergroups AS a
  ON a.id = map.group_id
  LEFT JOIN r2dr1_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE map.user_id = 533
147. SELECT b.id
  FROM r2dr1_user_usergroup_map AS map
  LEFT JOIN r2dr1_usergroups AS a
  ON a.id = map.group_id
  LEFT JOIN r2dr1_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE map.user_id = 515
148. SELECT b.id
  FROM r2dr1_user_usergroup_map AS map
  LEFT JOIN r2dr1_usergroups AS a
  ON a.id = map.group_id
  LEFT JOIN r2dr1_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE map.user_id = 6114
149. SELECT b.id
  FROM r2dr1_user_usergroup_map AS map
  LEFT JOIN r2dr1_usergroups AS a
  ON a.id = map.group_id
  LEFT JOIN r2dr1_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE map.user_id = 6172
150. SHOW FULL COLUMNS
  FROM `r2dr1_hwdms_config`
151. SHOW FULL COLUMNS
  FROM `r2dr1_assets`
152. SELECT `id`
  FROM `r2dr1_assets`
  WHERE `name` = 'com_hwdmediashare'
153. SELECT *
  FROM r2dr1_assets
  WHERE `id` = '291'
154. SELECT *
  FROM r2dr1_hwdms_config
  WHERE `id` = '1'
155. SELECT b.rules
  FROM r2dr1_assets AS a
  LEFT JOIN r2dr1_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE (a.name = 'com_hwdmediashare' OR a.parent_id=0)
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
156. SELECT a.id, a.key, a.ext_id, a.title, a.description, a.alias, a.checked_out, a.checked_out_time,a.created_user_id, a.thumbnail_ext_id, a.location, a.hits, a.thumbnail, a.type, a.published, a.likes, a.dislikes, a.featured,a.status, a.publish_up, a.publish_down, a.duration, a.source, a.ordering, a.created, a.access,a.language, a.modified, a.created_user_id_alias,
  CASE WHEN a.created_user_id_alias > ' ' THEN a.created_user_id_alias ELSE ua.name END AS author,
  CASE WHEN a.ext_id > 0 THEN ext.media_type ELSE a.media_type END AS media_type,ext.ext
  FROM r2dr1_hwdms_media AS a
  LEFT JOIN r2dr1_users AS ua
  ON ua.id = a.created_user_id
  LEFT JOIN r2dr1_users AS uam
  ON uam.id = a.modified_user_id
  LEFT JOIN r2dr1_hwdms_ext AS ext
  ON ext.id = a.ext_id
  WHERE a.access IN (1,1)
  AND (a.private = 0 OR (a.private = 1 && a.created_user_id = 0))
  AND a.published = 1
  AND a.status = 1
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-06-20 06:34:59')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-06-20 06:34:59')
  AND (ext.media_type = 4 OR a.media_type = 4)
  ORDER BY a.hits DESC
157. SELECT a.id, a.key, a.ext_id, a.title, a.description, a.alias, a.checked_out, a.checked_out_time,a.created_user_id, a.thumbnail_ext_id, a.location, a.hits, a.thumbnail, a.type, a.published, a.likes, a.dislikes, a.featured,a.status, a.publish_up, a.publish_down, a.duration, a.source, a.ordering, a.created, a.access,a.language, a.modified, a.created_user_id_alias,
  CASE WHEN a.created_user_id_alias > ' ' THEN a.created_user_id_alias ELSE ua.name END AS author,
  CASE WHEN a.ext_id > 0 THEN ext.media_type ELSE a.media_type END AS media_type,ext.ext
  FROM r2dr1_hwdms_media AS a
  LEFT JOIN r2dr1_users AS ua
  ON ua.id = a.created_user_id
  LEFT JOIN r2dr1_users AS uam
  ON uam.id = a.modified_user_id
  LEFT JOIN r2dr1_hwdms_ext AS ext
  ON ext.id = a.ext_id
  WHERE a.access IN (1,1)
  AND (a.private = 0 OR (a.private = 1 && a.created_user_id = 0))
  AND a.published = 1
  AND a.status = 1
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-06-20 06:34:59')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-06-20 06:34:59')
  AND (ext.media_type = 4 OR a.media_type = 4)
  ORDER BY a.hits DESC
  LIMIT 0, 3
158. SELECT c.id, c.title
  FROM r2dr1_hwdms_category_map AS cmap
  LEFT JOIN r2dr1_categories AS c
  ON c.id = cmap.category_id
  WHERE `cmap`.`element_id` = '177'
  AND `cmap`.`element_type` = '1'
  AND `c`.`id` > 0
  AND c.access IN (1,1)
  AND c.published = 1
159. SELECT c.id, c.title
  FROM r2dr1_hwdms_category_map AS cmap
  LEFT JOIN r2dr1_categories AS c
  ON c.id = cmap.category_id
  WHERE `cmap`.`element_id` = '175'
  AND `cmap`.`element_type` = '1'
  AND `c`.`id` > 0
  AND c.access IN (1,1)
  AND c.published = 1
160. SELECT c.id, c.title
  FROM r2dr1_hwdms_category_map AS cmap
  LEFT JOIN r2dr1_categories AS c
  ON c.id = cmap.category_id
  WHERE `cmap`.`element_id` = '170'
  AND `cmap`.`element_type` = '1'
  AND `c`.`id` > 0
  AND c.access IN (1,1)
  AND c.published = 1
161. SELECT b.rules
  FROM r2dr1_assets AS a
  LEFT JOIN r2dr1_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE (a.name = 'com_hwdmediashare.media.177' OR a.parent_id=0)
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
162. SHOW FULL COLUMNS
  FROM `r2dr1_hwdms_media`
163. SELECT *
  FROM r2dr1_hwdms_media
  WHERE `id` = '177'
164. SELECT a.media_type
  FROM r2dr1_hwdms_ext AS a
  WHERE `id` = 0
165. SELECT *
  FROM r2dr1_hwdms_media
  WHERE `id` = '177'
166. SELECT a.media_type
  FROM r2dr1_hwdms_ext AS a
  WHERE `id` = 0
167. SELECT ext
  FROM r2dr1_hwdms_ext
  WHERE `id` = '32'
168. SELECT alias
  FROM r2dr1_categories
  WHERE id=65
169. SELECT b.rules
  FROM r2dr1_assets AS a
  LEFT JOIN r2dr1_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE (a.name = 'com_hwdmediashare.media.175' OR a.parent_id=0)
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
170. SELECT *
  FROM r2dr1_hwdms_media
  WHERE `id` = '175'
171. SELECT a.media_type
  FROM r2dr1_hwdms_ext AS a
  WHERE `id` = 0
172. SELECT *
  FROM r2dr1_hwdms_media
  WHERE `id` = '175'
173. SELECT a.media_type
  FROM r2dr1_hwdms_ext AS a
  WHERE `id` = 0
174. SELECT ext
  FROM r2dr1_hwdms_ext
  WHERE `id` = '32'
175. SELECT alias
  FROM r2dr1_categories
  WHERE id=65
176. SELECT b.rules
  FROM r2dr1_assets AS a
  LEFT JOIN r2dr1_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE (a.name = 'com_hwdmediashare.media.170' OR a.parent_id=0)
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
177. SELECT *
  FROM r2dr1_hwdms_media
  WHERE `id` = '170'
178. SELECT a.media_type
  FROM r2dr1_hwdms_ext AS a
  WHERE `id` = 0
179. SELECT *
  FROM r2dr1_hwdms_media
  WHERE `id` = '170'
180. SELECT a.media_type
  FROM r2dr1_hwdms_ext AS a
  WHERE `id` = 0
181. SELECT ext
  FROM r2dr1_hwdms_ext
  WHERE `id` = '32'
182. SELECT alias
  FROM r2dr1_categories
  WHERE id=65
183. SELECT extension_id AS id, element AS "option", params, enabled
  FROM r2dr1_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_avchat3'
184. SELECT name
  FROM r2dr1_extensions
  WHERE `element` LIKE 'com_community'
  and enabled = '1'
185. SELECT name
  FROM r2dr1_extensions
  WHERE `element` LIKE 'com_comprofiler'
  and enabled = '1'
186. SELECT b.rules
  FROM r2dr1_assets AS a
  LEFT JOIN r2dr1_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE (a.name = 'com_avchat3' OR a.parent_id=0)
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
187. SELECT DISTINCT c.id AS ID, c.name AS name, c.alias AS alias
  FROM r2dr1_k2_categories AS c
  LEFT JOIN r2dr1_k2_items AS content
  ON c.id = content.catid
  WHERE ( c.id = 1 OR c.id = 10 OR c.id = 7 OR c.id = 90 OR c.id = 88 OR c.id = 89 OR c.id = 4 OR c.id = 9 OR c.id = 12 OR c.id = 95 OR c.id = 98 OR c.id = 96 OR c.id = 97 OR c.id = 2 OR c.id = 75 OR c.id = 68 OR c.id = 74 OR c.id = 70 OR c.id = 73 OR c.id = 72 OR c.id = 71 OR c.id = 69 OR c.id = 8 OR c.id = 11 OR c.id = 105 OR c.id = 92 OR c.id = 91 OR c.id = 93 OR c.id = 94 OR c.id = 13 OR c.id = 99 OR c.id = 100 OR c.id = 103 OR c.id = 102 OR c.id = 101 OR c.id = 3 OR c.id = 76 OR c.id = 77 OR c.id = 78 OR c.id = 79 OR c.id = 80 OR c.id = 81 OR c.id = 86 OR c.id = 82 OR c.id = 87 OR c.id = 83 OR c.id = 84 OR c.id = 85 )
  AND c.published = 1
  AND c.access <= 1;
188. SELECT DISTINCT cats.name AS cat_name, cats.alias AS cat_alias, content.catid AS cat_id, users.name AS author, users.email AS author_email, users.id AS author_id, content.title AS title, content.introtext AS text, content.created AS date, content.publish_up AS date_publish, content.id AS ID, content.alias AS alias, content.hits AS hits, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count, content.plugins AS plugins
  FROM r2dr1_k2_items AS content
  LEFT JOIN r2dr1_k2_categories AS cats
  ON cats.id = content.catid
  LEFT JOIN r2dr1_users AS users
  ON users.id = content.created_by
  LEFT JOIN r2dr1_k2_rating AS content_rating
  ON content.id = content_rating.itemID
  WHERE content.trash = 0
  AND cats.access <= 1
  AND content.access <= 1
  AND content.published = 1
  AND cats.published = 1
  AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2013-06-20 06:35:00' )
  AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2013-06-20 06:35:00' )
  AND ( content.catid = 1 OR content.catid = 2 OR content.catid = 3 OR content.catid = 4 OR content.catid = 7 OR content.catid = 8 OR content.catid = 9 OR content.catid = 10 OR content.catid = 11 OR content.catid = 12 OR content.catid = 13 OR content.catid = 68 OR content.catid = 69 OR content.catid = 70 OR content.catid = 71 OR content.catid = 72 OR content.catid = 73 OR content.catid = 74 OR content.catid = 75 OR content.catid = 76 OR content.catid = 77 OR content.catid = 78 OR content.catid = 79 OR content.catid = 80 OR content.catid = 81 OR content.catid = 82 OR content.catid = 83 OR content.catid = 84 OR content.catid = 85 OR content.catid = 86 OR content.catid = 87 OR content.catid = 88 OR content.catid = 89 OR content.catid = 90 OR content.catid = 91 OR content.catid = 92 OR content.catid = 93 OR content.catid = 94 OR content.catid = 95 OR content.catid = 96 OR content.catid = 97 OR content.catid = 98 OR content.catid = 99 OR content.catid = 100 OR content.catid = 101 OR content.catid = 102 OR content.catid = 103 OR content.catid = 105 )
  AND content.featured = 1
  ORDER BY content.featured_ordering ASC
  LIMIT 0,12;
189. SELECT Count(*)
  FROM r2dr1_extensions as e
  WHERE e.element ='com_k2'
  and e.enabled=1
190. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=2
  AND published=1
  AND trash=0
  AND access<=1
  ORDER BY ordering
191. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=68
  AND published=1
  AND trash=0
  AND access<=1
192. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=69
  AND published=1
  AND trash=0
  AND access<=1
193. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=70
  AND published=1
  AND trash=0
  AND access<=1
194. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=71
  AND published=1
  AND trash=0
  AND access<=1
195. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=72
  AND published=1
  AND trash=0
  AND access<=1
196. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=73
  AND published=1
  AND trash=0
  AND access<=1
197. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=74
  AND published=1
  AND trash=0
  AND access<=1
198. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=75
  AND published=1
  AND trash=0
  AND access<=1
199. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=3
  AND published=1
  AND trash=0
  AND access<=1
  ORDER BY ordering
200. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=76
  AND published=1
  AND trash=0
  AND access<=1
201. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=77
  AND published=1
  AND trash=0
  AND access<=1
202. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=78
  AND published=1
  AND trash=0
  AND access<=1
203. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=79
  AND published=1
  AND trash=0
  AND access<=1
204. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=80
  AND published=1
  AND trash=0
  AND access<=1
205. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=81
  AND published=1
  AND trash=0
  AND access<=1
206. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=82
  AND published=1
  AND trash=0
  AND access<=1
207. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=83
  AND published=1
  AND trash=0
  AND access<=1
208. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=84
  AND published=1
  AND trash=0
  AND access<=1
209. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=85
  AND published=1
  AND trash=0
  AND access<=1
210. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=86
  AND published=1
  AND trash=0
  AND access<=1
211. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=87
  AND published=1
  AND trash=0
  AND access<=1
212. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=4
  AND published=1
  AND trash=0
  AND access<=1
  ORDER BY ordering
213. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=10
  AND published=1
  AND trash=0
  AND access<=1
  ORDER BY ordering
214. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=7
  AND published=1
  AND trash=0
  AND access<=1
  ORDER BY ordering
215. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=88
  AND published=1
  AND trash=0
  AND access<=1
216. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=89
  AND published=1
  AND trash=0
  AND access<=1
217. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=90
  AND published=1
  AND trash=0
  AND access<=1
218. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=106
  AND published=1
  AND trash=0
  AND access<=1
219. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=11
  AND published=1
  AND trash=0
  AND access<=1
  ORDER BY ordering
220. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=91
  AND published=1
  AND trash=0
  AND access<=1
221. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=92
  AND published=1
  AND trash=0
  AND access<=1
222. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=93
  AND published=1
  AND trash=0
  AND access<=1
223. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=94
  AND published=1
  AND trash=0
  AND access<=1
224. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=105
  AND published=1
  AND trash=0
  AND access<=1
225. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=8
  AND published=1
  AND trash=0
  AND access<=1
  ORDER BY ordering
226. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=9
  AND published=1
  AND trash=0
  AND access<=1
  ORDER BY ordering
227. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=12
  AND published=1
  AND trash=0
  AND access<=1
  ORDER BY ordering
228. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=95
  AND published=1
  AND trash=0
  AND access<=1
229. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=96
  AND published=1
  AND trash=0
  AND access<=1
230. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=97
  AND published=1
  AND trash=0
  AND access<=1
231. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=98
  AND published=1
  AND trash=0
  AND access<=1
232. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=13
  AND published=1
  AND trash=0
  AND access<=1
  ORDER BY ordering
233. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=99
  AND published=1
  AND trash=0
  AND access<=1
234. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=100
  AND published=1
  AND trash=0
  AND access<=1
235. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=101
  AND published=1
  AND trash=0
  AND access<=1
236. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=102
  AND published=1
  AND trash=0
  AND access<=1
237. SELECT *
  FROM r2dr1_k2_categories
  WHERE parent=103
  AND published=1
  AND trash=0
  AND access<=1
238. SELECT i.*, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
  FROM r2dr1_k2_items as i
  LEFT JOIN r2dr1_k2_categories c
  ON c.id = i.catid
  WHERE i.published = 1
  AND i.access <= 1
  AND i.trash = 0
  AND c.published = 1
  AND c.access <= 1
  AND c.trash = 0
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2013-06-20 06:34:59' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2013-06-20 06:34:59' )
  AND i.catid IN (2,3,4,10,7,11,8,9,12,13,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,106,91,92,93,94,105,95,96,97,98,99,100,101,102,103)
  ORDER BY i.created DESC
  LIMIT 0, 10
239. SELECT m.*
  FROM r2dr1_modules AS m
  LEFT JOIN r2dr1_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
  WHERE m.client_id = 0
  AND m.title = 'SocialConnect'
  AND m.access IN (1,1)
  AND m.published = 1
  AND e.enabled = 1
  ORDER BY m.ordering
240. SELECT a.params
  FROM r2dr1_advancedmodules AS a
  WHERE a.moduleid = 199
241. SELECT extension_id AS id, element AS "option", params, enabled
  FROM r2dr1_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_socialconnect'
242. SELECT m.*
  FROM r2dr1_modules AS m
  LEFT JOIN r2dr1_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
  WHERE m.client_id = 0
  AND m.title = 'SocialConnect'
  AND m.access IN (1,1)
  AND m.published = 1
  AND e.enabled = 1
  ORDER BY m.ordering
243. SELECT a.params
  FROM r2dr1_advancedmodules AS a
  WHERE a.moduleid = 199
244. SELECT m.*
  FROM r2dr1_modules AS m
  LEFT JOIN r2dr1_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
  WHERE m.client_id = 0
  AND m.title = 'SocialConnect'
  AND m.access IN (1,1)
  AND m.published = 1
  AND e.enabled = 1
  ORDER BY m.ordering
245. SELECT a.params
  FROM r2dr1_advancedmodules AS a
  WHERE a.moduleid = 199
246. SELECT *
  FROM r2dr1_rsform_config
247. UPDATE `r2dr1_session`
  SET `data` = '__default|a:10:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1371710099;s:18:\"session.timer.last\";i:1371710099;s:17:\"session.timer.now\";i:1371710099;s:22:\"session.client.browser\";s:9:\"CCBot/2.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\0*\0isRoot\";b:0;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\";a:1:{i:0;i:1;}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:3:\"gid\";i:1;}s:20:\"com_rsfirewall.geoip\";s:0:\"\";s:13:\"session.token\";s:32:\"0c3e82b7fa8ac4174938a7ac3b47cb3c\";s:16:\"com_mailto.links\";a:1:{s:40:\"f8f7f5789a6ceda02127b3b89f1b7524bf6e3717\";O:8:\"stdClass\":2:{s:4:\"link\";s:45:\"http://www.equities.com/editors-desk/?p=28504\";s:6:\"expiry\";i:1371710100;}}}skipped_email|b:0;' , `time` = '1371710101'
  WHERE `session_id` = 'jt9ikld649vtdt1k76mtn3s5k4'

78 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 49 × SELECT *
  FROM r2dr1_k2_categories
2. 17 × SELECT *
  FROM `r2dr1_users`
3. 17 × SELECT `g`.`id`,`g`.`title`
  FROM `r2dr1_usergroups` AS g
  INNER JOIN `r2dr1_user_usergroup_map` AS m
  ON m.group_id = g.id
4. 12 × SELECT i.catid
  FROM r2dr1_k2_items AS i
5. 11 × SELECT extension_id AS id, element AS "option", params, enabled
  FROM r2dr1_extensions
6. 10 × SELECT e.id
  FROM r2dr1_k2_items AS e
7. 10 × SELECT t.parent
  FROM r2dr1_k2_categories as t
8. 10 × SELECT e.id,e.title,e.alias,e.introtext AS description,e.created,e.modified,e.hits,e.featured,e.catid,e.created_by AS author_id,(SELECT count(count_table.id)
  FROM r2dr1_k2_comments AS count_table
9. 7 × SELECT b.rules
  FROM r2dr1_assets AS a
  LEFT JOIN r2dr1_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
10. 6 × SELECT *
  FROM r2dr1_hwdms_media
11. 6 × SELECT a.media_type
  FROM r2dr1_hwdms_ext AS a
12. 6 × SELECT b.id
  FROM r2dr1_user_usergroup_map AS map
  LEFT JOIN r2dr1_usergroups AS a
  ON a.id = map.group_id
  LEFT JOIN r2dr1_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
13. 3 × SELECT id
  FROM r2dr1_k2_categories
14. 3 × SELECT c.id, c.title
  FROM r2dr1_hwdms_category_map AS cmap
  LEFT JOIN r2dr1_categories AS c
  ON c.id = cmap.category_id
15. 3 × SELECT a.params
  FROM r2dr1_advancedmodules AS a
16. 3 × SELECT ext
  FROM r2dr1_hwdms_ext
17. 3 × SELECT alias
  FROM r2dr1_categories
18. 3 × SELECT m.*
  FROM r2dr1_modules AS m
  LEFT JOIN r2dr1_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
19. 2 × SELECT r2dr1_autotweet_automator.*
  FROM r2dr1_autotweet_automator
20. 2 × SELECT *
  FROM r2dr1_extensions
21. 2 × SELECT template
  FROM r2dr1_template_styles as s
22. 2 × SELECT name
  FROM r2dr1_extensions
23. 2 × SELECT t.parent_id
  FROM r2dr1_menu as t
24. 2 × SELECT a.id, a.key, a.ext_id, a.title, a.description, a.alias, a.checked_out, a.checked_out_time,a.created_user_id, a.thumbnail_ext_id, a.location, a.hits, a.thumbnail, a.type, a.published, a.likes, a.dislikes, a.featured,a.status, a.publish_up, a.publish_down, a.duration, a.source, a.ordering, a.created, a.access,a.language, a.modified, a.created_user_id_alias,
  CASE WHEN a.created_user_id_alias > ' ' THEN a.created_user_id_alias ELSE ua.name END AS author,
  CASE WHEN a.ext_id > 0 THEN ext.media_type ELSE a.media_type END AS media_type,ext.ext
  FROM r2dr1_hwdms_media AS a
  LEFT JOIN r2dr1_users AS ua
  ON ua.id = a.created_user_id
  LEFT JOIN r2dr1_users AS uam
  ON uam.id = a.modified_user_id
  LEFT JOIN r2dr1_hwdms_ext AS ext
  ON ext.id = a.ext_id
25. 2 × SELECT `ip`,`reason`
  FROM r2dr1_rsfirewall_lists
26. 2 × SELECT `extension_id`
  FROM `r2dr1_extensions`
27. 1 × SELECT i.*, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
  FROM r2dr1_k2_items as i
  LEFT JOIN r2dr1_k2_categories c
  ON c.id = i.catid
28. 1 × SELECT *
  FROM r2dr1_rsform_confi
29. 1 × SELECT Count(*)
  FROM r2dr1_extensions as e
30. 1 × SELECT i.*,
  CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
  FROM r2dr1_k2_items as i RIGHT JOIN r2dr1_k2_categories c
  ON c.id = i.catid
31. 1 × SELECT *
  FROM r2dr1_assets
32. 1 × SELECT *
  FROM r2dr1_hwdms_config
33. 1 × SELECT `id`
  FROM `r2dr1_assets`
34. 1 × SELECT *
  FROM r2dr1_community_config
35. 1 × SELECT DISTINCT c.id AS ID, c.name AS name, c.alias AS alias
  FROM r2dr1_k2_categories AS c
  LEFT JOIN r2dr1_k2_items AS content
  ON c.id = content.catid
36. 1 × SELECT DISTINCT cats.name AS cat_name, cats.alias AS cat_alias, content.catid AS cat_id, users.name AS author, users.email AS author_email, users.id AS author_id, content.title AS title, content.introtext AS text, content.created AS date, content.publish_up AS date_publish, content.id AS ID, content.alias AS alias, content.hits AS hits, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count, content.plugins AS plugins
  FROM r2dr1_k2_items AS content
  LEFT JOIN r2dr1_k2_categories AS cats
  ON cats.id = content.catid
  LEFT JOIN r2dr1_users AS users
  ON users.id = content.created_by
  LEFT JOIN r2dr1_k2_rating AS content_rating
  ON content.id = content_rating.itemID
37. 1 × SELECT COUNT(*)
  FROM r2dr1_k2_comments
38. 1 × SELECT id
  FROM r2dr1_menu
39. 1 × SELECT *
  FROM r2dr1_rsfirewall_configuratio
40. 1 × SELECT extension, file, type
  FROM r2dr1_rokcommon_configs
41. 1 × SELECT `custom_data`
  FROM `r2dr1_extensions`
42. 1 × SELECT `params`
  FROM r2dr1_extensions
43. 1 × SELECT `file`
  FROM r2dr1_rsfirewall_hashes
44. 1 × SELECT `path`
  FROM r2dr1_rsfirewall_ignored
45. 1 × SELECT `session_id`
  FROM `r2dr1_session`
46. 1 × SELECT b.id
  FROM r2dr1_usergroups AS a
  LEFT JOIN r2dr1_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
47. 1 × SELECT id, rules
  FROM `r2dr1_viewlevels
48. 1 × SELECT folder AS type, element AS name, params
  FROM r2dr1_extensions
49. 1 × SELECT *
  FROM r2dr1_languages
50. 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 r2dr1_menu AS m
  LEFT JOIN r2dr1_extensions AS e
  ON m.component_id = e.extension_id
51. 1 × SELECT id
  FROM r2dr1_k2_categories
52. 1 × SELECT *
  FROM r2dr1_k2_items
53. 1 × SELECT `data`
  FROM `r2dr1_session`
54. 1 × SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.params as adv_params, 0 as menuid, m.publish_up, m.publish_down
  FROM r2dr1_modules AS m
  LEFT JOIN r2dr1_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
  LEFT JOIN r2dr1_advancedmodules as am
  ON am.moduleid = m.id
55. 1 × SELECT id, home, template, s.params
  FROM r2dr1_template_styles as s
  LEFT JOIN r2dr1_extensions as e
  ON e.element=s.template
  AND e.type='template'
  AND e.client_id=s.client_id
56. 1 × SELECT a.rules
  FROM r2dr1_assets AS a
57. 1 × SELECT *
  FROM r2dr1_rsfirewall_hashes
58. 1 × SELECT *
  FROM r2dr1_rsfirewall_snapshots
59. 1 × SELECT *
  FROM r2dr1_rsfirewall_exceptions
60. 1 × SELECT count(*)
  FROM r2dr1_eb_template
61. 1 × SELECT e.id,e.name,e.alias,e.description,e.params,e.image AS images,e.parent,(SELECT COUNT(count_table.id)
  FROM r2dr1_k2_items AS count_table

OTHER Tables:

1. 1 × SHOW FULL COLUMNS
  FROM `r2dr1_community_config
2. 1 × UPDATE r2dr1_k2_items
  SET `hits` = (`hits` + 1)
3. 1 × SHOW FULL COLUMNS
  FROM `r2dr1_k2_items
4. 1 × SHOW FULL COLUMNS
  FROM `r2dr1_hwdms_config
5. 1 × SHOW FULL COLUMNS
  FROM `r2dr1_assets
6. 1 × UPDATE `r2dr1_session`
  SET `data` = '__default|a:10:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1371710099;s:18:\"session.timer.last\";i:1371710099;s:17:\"session.timer.now\";i:1371710099;s:22:\"session.client.browser\";s:9:\"CCBot/2.0\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\0*\0isRoot\";b:0;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\";a:1:{i:0;i:1;}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:3:\"gid\";i:1;}s:20:\"com_rsfirewall.geoip\";s:0:\"\";s:13:\"session.token\";s:32:\"0c3e82b7fa8ac4174938a7ac3b47cb3c\";s:16:\"com_mailto.links\";a:1:{s:40:\"f8f7f5789a6ceda02127b3b89f1b7524bf6e3717\";O:8:\"stdClass\":2:{s:4:\"link\";s:45:\"http://www.equities.com/editors-desk/?p=28504\";s:6:\"expiry\";i:1371710100;}}}skipped_email|b:0;' , `time` = '1371710101'
7. 1 × SHOW FULL COLUMNS
  FROM `r2dr1_hwdms_media
8. 1 × SHOW FULL COLUMNS
  FROM `r2dr1_users
9. 1 × SHOW FULL COLUMNS
  FROM `r2dr1_k2_categories
10. 1 × SHOW FULL COLUMNS
  FROM `r2dr1_extensions
11. 1 × CREATE TABLE IF NOT EXISTS `r2dr1_ualog` ( `id` int(11) NOT NULL auto_increment, `user_id` int(11) NOT NULL, `option` varchar(255) NOT NULL, `task` varchar(255) NOT NULL, `action_link` text NOT NULL, `action_title` text NOT NULL, `item_title` varchar(255) NOT NULL, `cdate` int(11) NOT NULL, PRIMARY KEY (`id`)
12. 1 × INSERT INTO `r2dr1_session` (`session_id`, `client_id`, `time`)
  VALUES ('jt9ikld649vtdt1k76mtn3s5k4', 0, '1371710099'
13. 1 × SHOW FULL COLUMNS
  FROM `r2dr1_rsfirewall_logs
14. 1 × SHOW TABLE
15. 1 × INSERT INTO `r2dr1_rokuserstats` (`user_id`,`ip`,`session_id`,`page`,`referrer`)
  VALUES ('0','67.202.9.192','jt9ikld649vtdt1k76mtn3s5k4','/editors-desk/?p=28504',''
16. 1 × SHOW FULL COLUMNS
  FROM `r2dr1_autotweet_automator
17. 1 × DELETE
  FROM `r2dr1_session`