Profile Information

Memory Usage

Queries logged

1. SELECT *
     FROM jos_session
     WHERE session_id = '9252ad35583fa608477bcf709ea4e005'
2. DELETE
     FROM jos_session
     WHERE ( TIME < '1337513196' )
3. SELECT *
     FROM jos_session
     WHERE session_id = '9252ad35583fa608477bcf709ea4e005'
4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( '9252ad35583fa608477bcf709ea4e005','1337514096','','0','1','0' )
5. SELECT *
     FROM jos_components
     WHERE parent = 0
6. SELECT folder AS TYPE, element AS name, params
     FROM jos_plugins
     WHERE published >= 1
     AND access <= 0
     ORDER BY ordering
7. SELECT name,player_id,ripper_id,postreplace
     FROM jos_avr_tags
8. SELECT name,player_id,ripper_id,postreplace
     FROM jos_avr_tags
9. SELECT *
     FROM `jos_rsfirewall_configuration`
10. SELECT *
      FROM jos_rsseo_redirects
      WHERE published = 1
11. SELECT *
      FROM jos_rsfirewall_hashes
      WHERE `type`='1.5.23'
12. SELECT *
      FROM jos_rsfirewall_hashes
      WHERE `type`='1.5.23'
13. SELECT *
      FROM jos_rsfirewall_hashes
      WHERE `type`='protect'
14. SELECT *
      FROM jos_rsfirewall_hashes
      WHERE `type`='protect'
15. SELECT m.*, c.`option` AS component
      FROM jos_menu AS m
      LEFT JOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
16. SELECT *
      FROM jos_rokcandy
      WHERE published=1
17. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 1)
      ORDER BY menuid DESC
      LIMIT 0, 1
18. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS SECTION, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
      FROM jos_content AS a
      INNER JOIN jos_content_frontpage AS f
      ON f.content_id = a.id
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_groups AS g
      ON a.access = g.id
      WHERE 1
      AND a.access <= 0
      AND a.state = 1
      AND (( cc.published = 1
      AND s.published = 1 ) OR ( a.catid = 0
      AND a.sectionid = 0 ) )
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-20 11:41:37' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-20 11:41:37' )
      ORDER BY  a.ordering
      LIMIT 0, 4
19. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS SECTION, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
      FROM jos_content AS a
      INNER JOIN jos_content_frontpage AS f
      ON f.content_id = a.id
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_groups AS g
      ON a.access = g.id
      WHERE 1
      AND a.access <= 0
      AND a.state = 1
      AND (( cc.published = 1
      AND s.published = 1 ) OR ( a.catid = 0
      AND a.sectionid = 0 ) )
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-20 11:41:37' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-20 11:41:37' )
      ORDER BY  a.ordering
20. SELECT *
      FROM `jos_sitelinkx_config`
21. SELECT *
      FROM `jos_sitelinkx`
      ORDER BY wort
22. SELECT *
      FROM `jos_sitelinkx_config`
23. SELECT *
      FROM `jos_sitelinkx`
      ORDER BY wort
24. SELECT *
      FROM `jos_sitelinkx_config`
25. SELECT *
      FROM `jos_sitelinkx`
      ORDER BY wort
26. SELECT code,minw,minh
      FROM jos_avr_player
      WHERE id = 37
27. SELECT code,minw,minh
      FROM jos_avr_player
      WHERE id = 37
28. SELECT *
      FROM `jos_sitelinkx_config`
29. SELECT *
      FROM `jos_sitelinkx`
      ORDER BY wort
30. SELECT *
      FROM `jos_rsseo_config`
31. SELECT `published`
      FROM `jos_plugins`
      WHERE `element` = 'jfrouter'
      AND `folder` = 'system'
32. SELECT ConfigValue
      FROM jos_rsseo_config
      WHERE ConfigName = 'crawler.enable.auto'
33. SELECT ConfigValue
      FROM jos_rsseo_config
      WHERE ConfigName = 'crawler.ignore'
34. SELECT IdPage
      FROM jos_rsseo_pages
      WHERE PageURL = ''
35. SELECT IdPage, PageModified, PageTitle , PageKeywords , PageDescription, PageCrawled , PageLevel
      FROM jos_rsseo_pages
      WHERE PageURL = ''
      AND published = 1
      LIMIT 1
36. SELECT ConfigValue
      FROM jos_rsseo_config
      WHERE ConfigName = 'component.heading'
37. SELECT ConfigValue
      FROM jos_rsseo_config
      WHERE ConfigName = 'content.heading'
38. SELECT m.*, am.params AS adv_params
      FROM jos_modules AS m
      LEFT JOIN jos_advancedmodules AS am
      ON am.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      ORDER BY m.ordering, m.id
39. SELECT *
      FROM jos_community_config
      WHERE name = 'config'
40. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,     a.`posted_on` AS _posted_on,    a.`avatar`      AS _avatar ,    a.`thumb`       AS _thumb ,     a.`invite`      AS _invite,     a.`params`      AS _cparams,    a.`view`        AS _view,  a.`friendcount` AS _friendcount,  a.`alias` AS _alias,  a.`profile_id` AS _profile_id,  a.`storage` AS _storage,  a.`watermark_hash` AS _watermark_hash, s.`userid` AS _isonline, u.*  
      FROM jos_community_users AS a  
      LEFT JOIN jos_users u  
      ON u.`id`=a.`userid`  
      LEFT
      OUTER JOIN jos_session s  
      ON s.`userid`=a.`userid`  
      AND s.client_id !='1'
      WHERE a.`userid`='0'
41. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%option=com_community&view=profile%'
      AND `published`=1
42. SELECT id
      FROM jos_menu
      WHERE `link` = 'index.php?option=com_community&view=frontpage'
      AND `published`=1
43. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%option=com_community&view=frontpage%'
      AND `published`=1
44. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%option=com_community&view=register%'
      AND `published`=1
45. SELECT g.*
      FROM jos_wbadvert_group AS g
      WHERE g.module_id = 173
      AND g.published = 1
      AND g.COUNT > 0
      GROUP BY g.id
      ORDER BY g.ordering
46. SELECT com.id AS id
      FROM jos_components AS com
      WHERE com.OPTION = 'com_wbadvert'
      AND com.parent = 0
      LIMIT 1
47. SELECT *
      FROM jos_components
      WHERE id = '123'
48. SELECT advert.*
      FROM jos_wbadvert AS advert
      LEFT JOIN jos_wbadvert_client AS client
      ON client.id = advert.client_id
      LEFT JOIN jos_wbadvert_idx_menu AS idx_menu
      ON idx_menu.advert_id = advert.id
      LEFT JOIN jos_wbadvert_idx_section AS idx_section
      ON idx_section.advert_id = advert.id
      LEFT JOIN jos_wbadvert_idx_category AS idx_category
      ON idx_category.advert_id = advert.id
      LEFT JOIN jos_wbadvert_idx_content AS idx_content
      ON idx_content.advert_id = advert.id
      WHERE advert.group_id = 1
      AND advert.published = 1
      AND client.published = 1
      AND ((advert.date_start = '0000-00-00 00:00:00') OR (advert.date_start <= '2012-05-20'))
      AND ((advert.date_stop = '0000-00-00 00:00:00') OR (advert.date_stop >= '2012-05-20'))
      AND ((advert.imptotal = 0) OR (advert.imptotal > advert.impmade))
      AND ((idx_menu.menu_id = 1) OR (idx_menu.menu_id = 0))
      AND ((idx_section.section_id = 0) OR (idx_section.section_id = 0))
      AND ((idx_category.category_id = 0) OR (idx_category.category_id = 0))
      AND ((idx_content.content_id = 0) OR (idx_content.content_id = 0))
      GROUP BY advert.id
      ORDER BY RAND()
      LIMIT 1
49. SELECT *
      FROM `jos_wbadvert`
      WHERE `id`='20'
      LIMIT 1
50. UPDATE jos_wbadvert
      SET impmade=(impmade+1)
      WHERE id=20
51. SELECT a.guest, a.usertype, a.client_id
     
      FROM jos_session AS a
     
      WHERE a.client_id=0
      AND a.time>'1337514039'
52. SELECT *
      FROM jos_jcalpro2_config
53. SELECT unix_timestamp( '2012-05-20 11:41:39');
54. SELECT name
      FROM jos_jcalpro2_themes
      WHERE published= '1'
55. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public frontend'
56. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos_core_acl_aro_groups AS g1
      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 3
      AND g1.lft <12
      GROUP BY g1.name
      ORDER BY g1.lft
57. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public backend'
58. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos_core_acl_aro_groups AS g1
      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 13
      AND g1.lft <20
      GROUP BY g1.name
      ORDER BY g1.lft
59. SELECT id, name
      FROM jos_core_acl_aro_groups;
60. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public frontend'
61. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos_core_acl_aro_groups AS g1
      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 3
      AND g1.lft <12
      GROUP BY g1.name
      ORDER BY g1.lft
62. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public backend'
63. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos_core_acl_aro_groups AS g1
      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 13
      AND g1.lft <20
      GROUP BY g1.name
      ORDER BY g1.lft
64. SELECT id, name
      FROM jos_core_acl_aro_groups;
65. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'manager'
66. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos_core_acl_aro_groups AS g1
      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 14
      AND g1.lft <19
      GROUP BY g1.name
      ORDER BY g1.lft
67. SELECT id, name
      FROM jos_core_acl_aro_groups;
68. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'manager'
69. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos_core_acl_aro_groups AS g1
      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 14
      AND g1.lft <19
      GROUP BY g1.name
      ORDER BY g1.lft
70. SELECT id, name
      FROM jos_core_acl_aro_groups;
71. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'manager'
72. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos_core_acl_aro_groups AS g1
      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 14
      AND g1.lft <19
      GROUP BY g1.name
      ORDER BY g1.lft
73. SELECT id, name
      FROM jos_core_acl_aro_groups;
74. SELECT
        cat_id, level
     
      FROM
        jos_jcalpro2_categories
75. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public frontend'
76. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos_core_acl_aro_groups AS g1
      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 3
      AND g1.lft <12
      GROUP BY g1.name
      ORDER BY g1.lft
77. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public backend'
78. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos_core_acl_aro_groups AS g1
      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 13
      AND g1.lft <20
      GROUP BY g1.name
      ORDER BY g1.lft
79. SELECT id, name
      FROM jos_core_acl_aro_groups;
80. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public frontend'
81. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos_core_acl_aro_groups AS g1
      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 3
      AND g1.lft <12
      GROUP BY g1.name
      ORDER BY g1.lft
82. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public backend'
83. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos_core_acl_aro_groups AS g1
      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 13
      AND g1.lft <20
      GROUP BY g1.name
      ORDER BY g1.lft
84. SELECT id, name
      FROM jos_core_acl_aro_groups;
85. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public frontend'
86. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos_core_acl_aro_groups AS g1
      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 3
      AND g1.lft <12
      GROUP BY g1.name
      ORDER BY g1.lft
87. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public backend'
88. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos_core_acl_aro_groups AS g1
      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 13
      AND g1.lft <20
      GROUP BY g1.name
      ORDER BY g1.lft
89. SELECT id, name
      FROM jos_core_acl_aro_groups;
90. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public frontend'
91. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos_core_acl_aro_groups AS g1
      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 3
      AND g1.lft <12
      GROUP BY g1.name
      ORDER BY g1.lft
92. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public backend'
93. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos_core_acl_aro_groups AS g1
      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 13
      AND g1.lft <20
      GROUP BY g1.name
      ORDER BY g1.lft
94. SELECT id, name
      FROM jos_core_acl_aro_groups;
95. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public frontend'
96. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos_core_acl_aro_groups AS g1
      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 3
      AND g1.lft <12
      GROUP BY g1.name
      ORDER BY g1.lft
97. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'public backend'
98. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos_core_acl_aro_groups AS g1
      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft > 13
      AND g1.lft <20
      GROUP BY g1.name
      ORDER BY g1.lft
99. SELECT id, name
      FROM jos_core_acl_aro_groups;
100. SELECT lft, rgt
       FROM jos_core_acl_aro_groups
       WHERE name = 'public frontend'
101. SELECT g1.id, g1.name, COUNT(g2.name) AS level
       FROM jos_core_acl_aro_groups AS g1
       INNER JOIN jos_core_acl_aro_groups AS g2
       ON g1.lft BETWEEN g2.lft
       AND g2.rgt
       WHERE g1.lft > 3
       AND g1.lft <12
       GROUP BY g1.name
       ORDER BY g1.lft
102. SELECT lft, rgt
       FROM jos_core_acl_aro_groups
       WHERE name = 'public backend'
103. SELECT g1.id, g1.name, COUNT(g2.name) AS level
       FROM jos_core_acl_aro_groups AS g1
       INNER JOIN jos_core_acl_aro_groups AS g2
       ON g1.lft BETWEEN g2.lft
       AND g2.rgt
       WHERE g1.lft > 13
       AND g1.lft <20
       GROUP BY g1.name
       ORDER BY g1.lft
104. SELECT id, name
       FROM jos_core_acl_aro_groups;
105. SELECT
         cal_id, level
      
       FROM
         jos_jcalpro2_calendars
106. SELECT lft, rgt
       FROM jos_core_acl_aro_groups
       WHERE name = 'public frontend'
107. SELECT g1.id, g1.name, COUNT(g2.name) AS level
       FROM jos_core_acl_aro_groups AS g1
       INNER JOIN jos_core_acl_aro_groups AS g2
       ON g1.lft BETWEEN g2.lft
       AND g2.rgt
       WHERE g1.lft > 3
       AND g1.lft <12
       GROUP BY g1.name
       ORDER BY g1.lft
108. SELECT lft, rgt
       FROM jos_core_acl_aro_groups
       WHERE name = 'public backend'
109. SELECT g1.id, g1.name, COUNT(g2.name) AS level
       FROM jos_core_acl_aro_groups AS g1
       INNER JOIN jos_core_acl_aro_groups AS g2
       ON g1.lft BETWEEN g2.lft
       AND g2.rgt
       WHERE g1.lft > 13
       AND g1.lft <20
       GROUP BY g1.name
       ORDER BY g1.lft
110. SELECT id, name
       FROM jos_core_acl_aro_groups;
111. SELECT cat_id
       FROM jos_jcalpro2_categories
       WHERE `published`='1'
112. SELECT e.*, c.cat_id, cal.cal_id, cal.cal_name, c.cat_name, c.color, c.description AS cat_desc
       FROM jos_jcalpro2_events AS e
       LEFT JOIN jos_jcalpro2_categories AS c
       ON e.cat=c.cat_id  
       LEFT JOIN jos_jcalpro2_calendars AS cal
       ON e.cal_id=cal.cal_id
       WHERE (    ( e.start_date <= '2012-05-20 05:00:00'
       AND e.end_date >= '2012-05-21 04:59:59'
       AND e.end_date != '2038-01-18 00:00:00'
       AND e.end_date != '0000-00-00 00:00:01'
       AND e.end_date != '9999-12-01 00:00:00')  OR ((e.start_date >= '2012-05-20 05:00:00'
       AND e.start_date < '2012-05-21 04:59:59')  
       AND (e.end_date = '2038-01-18 00:00:00' OR e.end_date = '0000-00-00 00:00:01' OR e.end_date = '9999-12-01 00:00:00'))   OR ( e.start_date > '2012-05-20 05:00:00'
       AND e.start_date <= '2012-05-21 04:59:59')  OR ( e.end_date > '2012-05-20 05:00:00'
       AND e.end_date <= '2012-05-21 04:59:59' ) )
       AND c.published = '1'
       AND e.published = '1'
       AND cal.published='1'
       AND approved = '1'
       AND e.cat IN (1, 2, 3, 4, 5, 6)
       AND e.cal_id IN (1)
       AND (e.private IN ('0', '2') OR (e.owner_id = '0'
       AND e.private = '1'))
       ORDER BY start_date ASC,title
113. SELECT e.*, c.cat_id, cal.cal_id, cal.cal_name, c.cat_name, c.color, c.description AS cat_desc
       FROM jos_jcalpro2_events AS e
       LEFT JOIN jos_jcalpro2_categories AS c
       ON e.cat=c.cat_id  
       LEFT JOIN jos_jcalpro2_calendars AS cal
       ON e.cal_id=cal.cal_id
       WHERE (    ( e.start_date <= '2012-05-20 11:41:39'
       AND e.end_date >= '2038-01-17 00:00:00'
       AND e.end_date != '2038-01-18 00:00:00'
       AND e.end_date != '0000-00-00 00:00:01'
       AND e.end_date != '9999-12-01 00:00:00')  OR ((e.start_date >= '2012-05-20 11:41:39'
       AND e.start_date < '2038-01-17 00:00:00')  
       AND (e.end_date = '2038-01-18 00:00:00' OR e.end_date = '0000-00-00 00:00:01' OR e.end_date = '9999-12-01 00:00:00'))   OR ( e.start_date > '2012-05-20 11:41:39'
       AND e.start_date <= '2038-01-17 00:00:00')  OR ( e.end_date > '2012-05-20 11:41:39'
       AND e.end_date <= '2038-01-17 00:00:00' ) )
       AND c.published = '1'
       AND e.published = '1'
       AND cal.published='1'
       AND approved = '1'
       AND e.cat IN (1, 2, 3, 4, 5, 6)
       AND e.cal_id IN (1)
       AND (e.private IN ('0', '2') OR (e.owner_id = '0'
       AND e.private = '1'))
       ORDER BY start_date ASC,title
114. SELECT e.*, c.cat_id, cal.cal_id, cal.cal_name, c.cat_name, c.color, c.description AS cat_desc
       FROM jos_jcalpro2_events AS e
       LEFT JOIN jos_jcalpro2_categories AS c
       ON e.cat=c.cat_id  
       LEFT JOIN jos_jcalpro2_calendars AS cal
       ON e.cal_id=cal.cal_id
       WHERE (    ( e.start_date <= '2012-06-01 05:00:00'
       AND e.end_date >= '2012-07-01 04:59:59'
       AND e.end_date != '2038-01-18 00:00:00'
       AND e.end_date != '0000-00-00 00:00:01'
       AND e.end_date != '9999-12-01 00:00:00')  OR ((e.start_date >= '2012-06-01 05:00:00'
       AND e.start_date < '2012-07-01 04:59:59')  
       AND (e.end_date = '2038-01-18 00:00:00' OR e.end_date = '0000-00-00 00:00:01' OR e.end_date = '9999-12-01 00:00:00'))   OR ( e.start_date > '2012-06-01 05:00:00'
       AND e.start_date <= '2012-07-01 04:59:59')  OR ( e.end_date > '2012-06-01 05:00:00'
       AND e.end_date <= '2012-07-01 04:59:59' ) )
       AND c.published = '1'
       AND e.published = '1'
       AND cal.published='1'
       AND approved = '1'
       AND e.cat IN (1, 2, 3, 4, 5, 6)
       AND e.cal_id IN (1)
       AND (e.private IN ('0', '2') OR (e.owner_id = '0'
       AND e.private = '1'))
       ORDER BY start_date ASC,title
115. SELECT id
       FROM jos_components
       WHERE `option`='com_phocagallery'
       AND parent = 0
       LIMIT 0, 1
116. SELECT *
       FROM jos_components
       WHERE id = '43'
117. SELECT cc.title AS text, cc.id AS id, cc.parent_id AS parentid, cc.alias AS alias, cc.access AS access, cc.accessuserid AS accessuserid
       FROM jos_phocagallery_categories AS cc
       WHERE cc.published = 1
       AND cc.access <= 0
       ORDER BY cc.ordering
118. SELECT cc.id AS idcat, a.id AS idimage
       FROM jos_phocagallery_categories AS cc
       LEFT JOIN jos_phocagallery AS a
       ON a.catid = cc.id
       WHERE a.published = 1
       AND a.approved = 1
       AND cc.published = 1
       AND cc.id IN (1,2)
       ORDER BY a.DATE DESC
       LIMIT 0,20
119. SELECT cc.id, a.id, a.catid, a.title, a.alias, a.filename, a.description, a.extm, a.exts,a.extl, a.exto, a.extw, a.exth, a.extid, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END AS catslug,  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug
       FROM jos_phocagallery_categories AS cc
       LEFT JOIN jos_phocagallery AS a
       ON a.catid = cc.id
       WHERE a.id IN (89,105,104,103,102,101,100,99,98,97,96,95,94,93,92,91,90,106,107,124)
       ORDER BY a.DATE DESC
120. SELECT v.*, c.directory, u.username  
       FROM jos_jomtube_videos AS v JOIN jos_jomtube_categories AS c
       ON c.id = v.category_id  
       LEFT JOIN jos_users AS u
       ON v.user_id = u.id  
       WHERE v.published = 1
       ORDER BY v.date_added DESC, v.id DESC
       LIMIT  6
121. SELECT AVG(rating)
       FROM jos_jomtube_rating
       WHERE v_id = 32
122. SELECT AVG(rating)
       FROM jos_jomtube_rating
       WHERE v_id = 31
123. SELECT AVG(rating)
       FROM jos_jomtube_rating
       WHERE v_id = 27
124. SELECT AVG(rating)
       FROM jos_jomtube_rating
       WHERE v_id = 26
125. SELECT AVG(rating)
       FROM jos_jomtube_rating
       WHERE v_id = 25
126. SELECT AVG(rating)
       FROM jos_jomtube_rating
       WHERE v_id = 21
127. SELECT id
       FROM jos_menu
       WHERE `link` LIKE "%com_jomtube%"
       ORDER BY id DESC
128. SELECT g.*
       FROM jos_wbadvert_group AS g
       WHERE g.module_id = 250
       AND g.published = 1
       AND g.COUNT > 0
       GROUP BY g.id
       ORDER BY g.ordering
129. SELECT advert.*
       FROM jos_wbadvert AS advert
       LEFT JOIN jos_wbadvert_client AS client
       ON client.id = advert.client_id
       LEFT JOIN jos_wbadvert_idx_menu AS idx_menu
       ON idx_menu.advert_id = advert.id
       LEFT JOIN jos_wbadvert_idx_section AS idx_section
       ON idx_section.advert_id = advert.id
       LEFT JOIN jos_wbadvert_idx_category AS idx_category
       ON idx_category.advert_id = advert.id
       LEFT JOIN jos_wbadvert_idx_content AS idx_content
       ON idx_content.advert_id = advert.id
       WHERE advert.group_id = 2
       AND advert.published = 1
       AND client.published = 1
       AND ((advert.date_start = '0000-00-00 00:00:00') OR (advert.date_start <= '2012-05-20'))
       AND ((advert.date_stop = '0000-00-00 00:00:00') OR (advert.date_stop >= '2012-05-20'))
       AND ((advert.imptotal = 0) OR (advert.imptotal > advert.impmade))
       AND ((idx_menu.menu_id = 1) OR (idx_menu.menu_id = 0))
       AND ((idx_section.section_id = 0) OR (idx_section.section_id = 0))
       AND ((idx_category.category_id = 0) OR (idx_category.category_id = 0))
       AND ((idx_content.content_id = 0) OR (idx_content.content_id = 0))
       AND advert.id NOT IN (20)
       GROUP BY advert.id
       ORDER BY RAND()
       LIMIT 1
130. SELECT *
       FROM `jos_wbadvert`
       WHERE `id`='17'
       LIMIT 1
131. UPDATE jos_wbadvert
       SET impmade=(impmade+1)
       WHERE id=17
132. SELECT a.*,  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
       FROM jos_content AS a
       INNER JOIN jos_categories AS cc
       ON cc.id = a.catid
       INNER JOIN jos_sections AS s
       ON s.id = a.sectionid
       WHERE a.state = 1
       AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-20 11:41:37' )
       AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-20 11:41:37' )
       AND s.id > 0
       AND a.access <= 0
       AND cc.access <= 0
       AND s.access <= 0
       AND (cc.id=38)
       AND s.published = 1
       AND cc.published = 1
       ORDER BY a.ordering
       LIMIT 0, 15
133. SELECT *
       FROM `jos_sitelinkx_config`
134. SELECT *
       FROM `jos_sitelinkx`
       ORDER BY wort
135. SELECT *
       FROM `jos_sitelinkx_config`
136. SELECT *
       FROM `jos_sitelinkx`
       ORDER BY wort
137. SELECT *
       FROM `jos_sitelinkx_config`
138. SELECT *
       FROM `jos_sitelinkx`
       ORDER BY wort
139. SELECT *
       FROM `jos_sitelinkx_config`
140. SELECT *
       FROM `jos_sitelinkx`
       ORDER BY wort
141. SELECT *
       FROM `jos_sitelinkx_config`
142. SELECT *
       FROM `jos_sitelinkx`
       ORDER BY wort
143. SELECT *
       FROM `jos_sitelinkx_config`
144. SELECT *
       FROM `jos_sitelinkx`
       ORDER BY wort
145. SELECT *
       FROM `jos_sitelinkx_config`
146. SELECT *
       FROM `jos_sitelinkx`
       ORDER BY wort
147. SELECT *
       FROM `jos_sitelinkx_config`
148. SELECT *
       FROM `jos_sitelinkx`
       ORDER BY wort
149. SELECT *
       FROM `jos_sitelinkx_config`
150. SELECT *
       FROM `jos_sitelinkx`
       ORDER BY wort
151. SELECT *
       FROM `jos_sitelinkx_config`
152. SELECT *
       FROM `jos_sitelinkx`
       ORDER BY wort
153. SELECT *
       FROM `jos_sitelinkx_config`
154. SELECT *
       FROM `jos_sitelinkx`
       ORDER BY wort
155. SELECT *
       FROM `jos_sitelinkx_config`
156. SELECT *
       FROM `jos_sitelinkx`
       ORDER BY wort
157. SELECT *
                            
       FROM jos_menu
                            
       WHERE menutype='mainmenu'
       AND published=1
                            
       ORDER BY sublevel DESC,ordering
                             ;
158. SELECT *
                            
       FROM jos_modules
                            
       WHERE published=1
                            
       ORDER BY id
                             ;
159. SELECT *
       FROM jos_fb_users
       WHERE userid = '0'
160. SHOW TABLES LIKE 'jos_fb_%'
161. SELECT *
       FROM jos_fb_config
162. SELECT ConfigValue
       FROM jos_rsseo_config
       WHERE ConfigName = 'enable.keyword.replace'
163. SELECT Keyword , KeywordBold ,KeywordUnderline ,KeywordAttributes ,KeywordLink
       FROM jos_rsseo_keywords
       ORDER BY CHAR_LENGTH(Keyword) DESC
164. SELECT ConfigValue
       FROM jos_rsseo_config
       WHERE ConfigName = 'approved.chars'
165. SELECT ConfigValue
       FROM jos_rsseo_config
       WHERE ConfigName = 'approved.chars'
166. SELECT ConfigValue
       FROM jos_rsseo_config
       WHERE ConfigName = 'approved.chars'
167. SELECT ConfigValue
       FROM jos_rsseo_config
       WHERE ConfigName = 'approved.chars'
168. SELECT ConfigValue
       FROM jos_rsseo_config
       WHERE ConfigName = 'approved.chars'
169. SELECT ConfigValue
       FROM jos_rsseo_config
       WHERE ConfigName = 'approved.chars'
170. SELECT ConfigValue
       FROM jos_rsseo_config
       WHERE ConfigName = 'approved.chars'
171. SELECT ConfigValue
       FROM jos_rsseo_config
       WHERE ConfigName = 'approved.chars'
172. SELECT ConfigValue
       FROM jos_rsseo_config
       WHERE ConfigName = 'approved.chars'
173. SELECT ConfigValue
       FROM jos_rsseo_config
       WHERE ConfigName = 'approved.chars'
174. SELECT ConfigValue
       FROM jos_rsseo_config
       WHERE ConfigName = 'approved.chars'
175. SELECT ConfigValue
       FROM jos_rsseo_config
       WHERE ConfigName = 'approved.chars'

Language Files Loaded

• /home/roatan/public_html/language/en-GB/en-GB.ini 1
• /home/roatan/public_html/language/en-GB/en-GB.mod_hellome.ini 1
• /home/roatan/public_html/language/en-GB/en-GB.com_community.ini 1
• /home/roatan/public_html/language/en-GB/en-GB.mod_wbadvert.ini
• /home/roatan/public_html/language/en-GB/en-GB.mod_slick_rss.ini
• /home/roatan/public_html/language/en-GB/en-GB.mod_whosonline.ini 1
• /home/roatan/public_html/language/en-GB/en-GB.mod_jcalpro_flex.ini
• /home/roatan/public_html/language/en-GB/en-GB.mod_roktwittie.ini 1
• /home/roatan/public_html/language/en-GB/en-GB.mod_phocagallery_image.ini 1
• /home/roatan/public_html/language/en-GB/en-GB.mod_jomtube_aio.ini
• /home/roatan/public_html/language/en-GB/en-GB.mod_roktabs.ini
• /home/roatan/public_html/language/en-GB/en-GB.plg_content_pagebreak.ini 1
• /home/roatan/public_html/language/en-GB/en-GB.mod_rokajaxsearch.ini 1
• /home/roatan/public_html/language/en-GB/en-GB.mod_smooth_gallery_camp26.ini 1
• /home/roatan/public_html/language/en-GB/en-GB.mod_maximenu_CK.ini
• /home/roatan/public_html/language/en-GB/en-GB.mod_mainmenu.ini 1
• /home/roatan/public_html/language/en-GB/en-GB.mod_nice_social_bookmark.ini

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None