Profile Information

Memory Usage

234 queries logged

1. SELECT *
     FROM jos2_session
     WHERE session_id = 'j86pc1pol60tjh6pgs7bjro8m2'
2. DELETE
     FROM jos2_session
     WHERE ( time < '1246655743' )
3. SELECT *
     FROM jos2_session
     WHERE session_id = 'j86pc1pol60tjh6pgs7bjro8m2'
4. INSERT INTO `jos2_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( 'j86pc1pol60tjh6pgs7bjro8m2','1246662943','','0','1','0' )
5. SELECT *
     FROM jos2_components
     WHERE parent = 0
6. SELECT folder AS type, element AS name, params
     FROM jos2_plugins
     WHERE published >= 1
     AND access <= 0
     ORDER BY ordering
7. SELECT t.*
     FROM jos2_ambrasubs_config AS t
8. SELECT m.*, c.`option` AS component
     FROM jos2_menu AS m
     LEFT JOIN jos2_components AS c
     ON m.componentid = c.id
     WHERE m.published = 1
     ORDER BY m.sublevel, m.parent, m.ordering
9. SELECT m.*, c.`option` AS component
     FROM jos2_menu AS m
     LEFT JOIN jos2_components AS c
     ON m.componentid = c.id
     WHERE m.published = 1
     ORDER BY m.sublevel, m.parent, m.ordering
10. SELECT template
      FROM jos2_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 133)
      ORDER BY menuid DESC
      LIMIT 0, 1
11. SELECT *
      FROM jos2_community_config
      WHERE name = 'config'
12. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='0'
13. SELECT value
      FROM jos2_myblog_config
      WHERE name='all'
14. SELECT count(*)
      FROM jos2_components
      WHERE `option`='com_jomcomment'
15. SELECT VERSION()
16. SELECT id
      FROM jos2_menu
      WHERE `link` LIKE '%option=com_community&view=frontpage%'
      AND `published`=1
17. SELECT id
      FROM jos2_menu
      WHERE `link` LIKE '%option=com_community&view=profile%'
      AND `published`=1
18. SELECT id
      FROM jos2_menu
      WHERE `link` LIKE '%option=com_community&view=frontpage%'
      AND `published`=1
19. SELECT oldurl, dateadd
      FROM jos2_redirection
      WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=0&view=profile'
20. SELECT oldurl, dateadd
      FROM jos2_redirection
      WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&task=uploadAvatar&view=profile'
21. SELECT oldurl, dateadd
      FROM jos2_redirection
      WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&task=edit&view=profile'
22. SELECT oldurl, dateadd
      FROM jos2_redirection
      WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&task=editDetails&view=profile'
23. SELECT oldurl, dateadd
      FROM jos2_redirection
      WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&task=privacy&view=profile'
24. SELECT id
      FROM jos2_menu
      WHERE `link` LIKE '%option=com_community&view=friends%'
      AND `published`=1
25. SELECT id
      FROM jos2_menu
      WHERE `link` LIKE '%option=com_community&view=frontpage%'
      AND `published`=1
26. SELECT oldurl, dateadd
      FROM jos2_redirection
      WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=0&view=friends'
27. SELECT oldurl, dateadd
      FROM jos2_redirection
      WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&view=friends'
28. SELECT id
      FROM jos2_menu
      WHERE `link` LIKE '%option=com_community&view=search%'
      AND `published`=1
29. SELECT id
      FROM jos2_menu
      WHERE `link` LIKE '%option=com_community&view=frontpage%'
      AND `published`=1
30. SELECT oldurl, dateadd
      FROM jos2_redirection
      WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&view=search'
31. SELECT oldurl, dateadd
      FROM jos2_redirection
      WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&task=advancesearch&view=search'
32. SELECT oldurl, dateadd
      FROM jos2_redirection
      WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&task=invite&view=friends'
33. SELECT oldurl, dateadd
      FROM jos2_redirection
      WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&task=sent&view=friends'
34. SELECT oldurl, dateadd
      FROM jos2_redirection
      WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&task=pending&view=friends'
35. SELECT id
      FROM jos2_menu
      WHERE `link` LIKE '%option=com_community&view=apps%'
      AND `published`=1
36. SELECT id
      FROM jos2_menu
      WHERE `link` LIKE '%option=com_community&view=frontpage%'
      AND `published`=1
37. SELECT oldurl, dateadd
      FROM jos2_redirection
      WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&view=apps'
38. SELECT oldurl, dateadd
      FROM jos2_redirection
      WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&task=browse&view=apps'
39. SELECT id
      FROM jos2_menu
      WHERE `link` LIKE '%option=com_community&view=groups%'
      AND `published`=1
40. SELECT oldurl, dateadd
      FROM jos2_redirection
      WHERE newurl = 'index.php?option=com_community&Itemid=134&lang=en&task=mygroups&userid=0&view=groups'
41. SELECT id
      FROM jos2_menu
      WHERE `link` LIKE '%option=com_community&view=photos%'
      AND `published`=1
42. SELECT id
      FROM jos2_menu
      WHERE `link` LIKE '%option=com_community&view=frontpage%'
      AND `published`=1
43. SELECT oldurl, dateadd
      FROM jos2_redirection
      WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&task=myphotos&userid=0&view=photos'
44. SELECT id
      FROM jos2_menu
      WHERE `link` LIKE '%option=com_community&view=videos%'
      AND `published`=1
45. SELECT oldurl, dateadd
      FROM jos2_redirection
      WHERE newurl = 'index.php?option=com_community&Itemid=140&lang=en&task=myvideos&userid=0&view=videos'
46. SELECT id
      FROM jos2_menu
      WHERE `link` LIKE '%option=com_community&view=inbox%'
      AND `published`=1
47. SELECT id
      FROM jos2_menu
      WHERE `link` LIKE '%option=com_community&view=frontpage%'
      AND `published`=1
48. SELECT oldurl, dateadd
      FROM jos2_redirection
      WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&view=inbox'
49. SELECT oldurl, dateadd
      FROM jos2_redirection
      WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&task=sent&view=inbox'
50. SELECT oldurl, dateadd
      FROM jos2_redirection
      WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&task=write&view=inbox'
51. SELECT id
      FROM jos2_menu
      WHERE link LIKE '%option=com_myblog%'
      AND published='1'
      AND `id`='133'
52. SELECT id
      FROM jos2_menu
      WHERE (type='component' OR type='components')
      AND link='index.php?option=com_myblog'
      AND published='1'
53. SELECT oldurl, dateadd
      FROM jos2_redirection
      WHERE newurl = 'index.php?option=com_myblog&Itemid=18&lang=en&task=adminhome'
54. SELECT oldurl, dateadd
      FROM jos2_redirection
      WHERE newurl = 'index.php?option=com_myblog&Itemid=18&lang=en'
55. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='0'
56. SELECT *
      FROM `jos2_users`
      WHERE `block`='0'
      ORDER BY `registerDate` DESC
      LIMIT 41
57. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='215'
58. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='211'
59. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='206'
60. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='210'
61. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='170'
62. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='167'
63. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='166'
64. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='165'
65. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='62'
66. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='161'
67. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='160'
68. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='159'
69. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='157'
70. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='156'
71. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='155'
72. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='154'
73. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='133'
74. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='135'
75. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='134'
76. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='131'
77. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='132'
78. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='136'
79. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='137'
80. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='138'
81. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='139'
82. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='140'
83. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='141'
84. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='142'
85. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='143'
86. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='144'
87. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='145'
88. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='146'
89. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='147'
90. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='148'
91. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='149'
92. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='150'
93. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='151'
94. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='152'
95. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='130'
96. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='129'
97. 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, s.`userid` AS _isonline, u.* 
      FROM jos2_community_users AS a 
      LEFT JOIN jos2_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos2_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid`='128'
98. SELECT DISTINCT(a.id)
      FROM `jos2_users` AS a
      INNER JOIN `jos2_session` AS b
      ON a.id=b.userid
      WHERE a.block='0'
      AND client_id != '1'
      ORDER BY b.time DESC
      LIMIT 20
99. SELECT *
      FROM `jos2_community_photos`
      WHERE 1 
      AND `permissions`='0'
      ORDER BY created DESC
      LIMIT 20
100. SELECT *
       FROM jos2_community_users 
       WHERE `userid`='0'
       ORDER BY `posted_on` DESC
       LIMIT 1
101. SELECT COUNT(*)
       FROM `jos2_users`
       WHERE `block`='0'
102. 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, s.`userid` AS _isonline, u.* 
       FROM jos2_community_users AS a 
       LEFT JOIN jos2_users u 
       ON u.`id`=a.`userid` 
       LEFT
       OUTER JOIN jos2_session s 
       ON s.`userid`=a.`userid`
       WHERE a.`userid`='63'
103. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&view=profile'
104. SELECT id
       FROM jos2_menu
       WHERE `link` LIKE '%option=com_community&view=register%'
       AND `published`=1
105. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=84&lang=en&view=register'
106. SELECT id
       FROM jos2_menu
       WHERE `link` LIKE '%option=com_community&view=reset%'
       AND `published`=1
107. SELECT id
       FROM jos2_menu
       WHERE `link` LIKE '%option=com_community&view=frontpage%'
       AND `published`=1
108. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_user&Itemid=133&lang=en&view=reset'
109. SELECT id
       FROM jos2_menu
       WHERE `link` LIKE '%option=com_community&view=remind%'
       AND `published`=1
110. SELECT id
       FROM jos2_menu
       WHERE `link` LIKE '%option=com_community&view=frontpage%'
       AND `published`=1
111. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_user&Itemid=133&lang=en&view=remind'
112. SELECT a.*, TO_DAYS('2009-07-03 23:15:44') -  TO_DAYS( DATE_ADD(a.`created`, INTERVAL 0 HOUR ) ) AS 'daydiff' 
       FROM jos2_community_activities AS a   
       WHERE   `archived`=0
       ORDER BY a.`created` DESC
       LIMIT 100
113. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=63&view=profile'
114. SELECT name
       FROM jos2_plugins
       WHERE `element`='myblog'
115. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=77&view=profile'
116. SELECT name
       FROM jos2_plugins
       WHERE `element`='myarticles'
117. 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, s.`userid` AS _isonline, u.* 
       FROM jos2_community_users AS a 
       LEFT JOIN jos2_users u 
       ON u.`id`=a.`userid` 
       LEFT
       OUTER JOIN jos2_session s 
       ON s.`userid`=a.`userid`
       WHERE a.`userid`='77'
118. SELECT name
       FROM jos2_plugins
       WHERE `element`='slideshare'
119. SELECT name
       FROM jos2_plugins
       WHERE `element`='feeds'
120. SELECT name
       FROM jos2_plugins
       WHERE `element`='groups'
121. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=62&view=profile'
122. SELECT *
       FROM jos2_community_groups AS a
       WHERE a.`published`='1' 
       AND ( a.thumb != 'components/com_community/assets/group_thumb.jpg'
       AND a.avatar != 'components/com_community/assets/group.jpg' )
       ORDER BY a.created DESC 
       LIMIT 0 , 5
123. SELECT COUNT(*)
       FROM jos2_community_groups AS a
       WHERE a.published='1'
       AND ( a.thumb != 'components/com_community/assets/group_thumb.jpg'
       AND a.avatar != 'components/com_community/assets/group.jpg' )
124. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=134&groupid=18&lang=en&task=viewgroup&view=groups'
125. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=134&groupid=17&lang=en&task=viewgroup&view=groups'
126. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=134&groupid=16&lang=en&task=viewgroup&view=groups'
127. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=134&groupid=15&lang=en&task=viewgroup&view=groups'
128. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=134&groupid=14&lang=en&task=viewgroup&view=groups'
129. SELECT *
       FROM jos2_community_videos AS a
       WHERE a.`published`='1'
       AND a.`status`='ready' 
       ORDER BY a.created DESC 
       LIMIT 9
130. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=140&lang=en&task=video&userid=77&videoid=4&view=videos'
131. SELECT name, link,id
       FROM jos2_menu
       WHERE id = '140'
       AND published='1'
132. SELECT oldurl
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=140&lang=en&task=video&userid=77&view=videos'
133. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=140&lang=en&task=video&userid=77&videoid=4&view=videos'
134. SELECT name, link,id
       FROM jos2_menu
       WHERE id = '140'
       AND published='1'
135. SELECT oldurl
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=140&lang=en&task=video&userid=77&view=videos'
136. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=140&lang=en&task=video&userid=77&videoid=5&view=videos'
137. SELECT name, link,id
       FROM jos2_menu
       WHERE id = '140'
       AND published='1'
138. SELECT oldurl
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=140&lang=en&task=video&userid=77&view=videos'
139. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=140&lang=en&task=video&userid=77&videoid=5&view=videos'
140. SELECT name, link,id
       FROM jos2_menu
       WHERE id = '140'
       AND published='1'
141. SELECT oldurl
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=140&lang=en&task=video&userid=77&view=videos'
142. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=140&lang=en&task=video&userid=77&videoid=6&view=videos'
143. SELECT name, link,id
       FROM jos2_menu
       WHERE id = '140'
       AND published='1'
144. SELECT oldurl
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=140&lang=en&task=video&userid=77&view=videos'
145. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=140&lang=en&task=video&userid=77&videoid=6&view=videos'
146. SELECT name, link,id
       FROM jos2_menu
       WHERE id = '140'
       AND published='1'
147. SELECT oldurl
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=140&lang=en&task=video&userid=77&view=videos'
148. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=133&albumid=1&lang=en&task=photo&userid=63&view=photos'
149. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&view=photos'
150. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=140&view=profile'
151. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=145&view=profile'
152. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=150&view=profile'
153. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=146&view=profile'
154. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=155&view=profile'
155. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=142&view=profile'
156. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=206&view=profile'
157. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=161&view=profile'
158. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=132&view=profile'
159. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=159&view=profile'
160. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=156&view=profile'
161. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=138&view=profile'
162. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=211&view=profile'
163. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=135&view=profile'
164. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=143&view=profile'
165. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=157&view=profile'
166. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=151&view=profile'
167. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=133&view=profile'
168. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=170&view=profile'
169. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=137&view=profile'
170. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&task=browse&view=search'
171. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=140&lang=en&view=videos'
172. SELECT id, title, module, position, content, showtitle, control, params
       FROM jos2_modules AS m
       LEFT JOIN jos2_modules_menu AS mm
       ON mm.moduleid = m.id
       WHERE m.published = 1
       AND m.access <= 0
       AND m.client_id = 0
       AND ( mm.menuid = 133 OR mm.menuid = 0 )
       ORDER BY position, ordering
173. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_content&Itemid=139&lang=en&view=frontpage'
174. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_content&Itemid=171&id=101&lang=en&view=article'
175. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_content&Itemid=5&id=5&lang=en&layout=blog&view=section'
176. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_jreviews&Itemid=142&lang=en'
177. SELECT name, link,id
       FROM jos2_menu
       WHERE id = '142'
       AND published='1'
178. SELECT oldurl
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_jreviews&Itemid=142&lang=en&url=Idea-Bank'
179. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_jreviews&Itemid=150&lang=en'
180. SELECT name, link,id
       FROM jos2_menu
       WHERE id = '150'
       AND published='1'
181. SELECT oldurl
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_jreviews&Itemid=150&lang=en&url=Industry ProFiles'
182. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_jreviews&Itemid=166&lang=en'
183. SELECT name, link,id
       FROM jos2_menu
       WHERE id = '166'
       AND published='1'
184. SELECT oldurl
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_jreviews&Itemid=166&lang=en&url=Showcase'
185. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_jreviews&Itemid=167&lang=en'
186. SELECT name, link,id
       FROM jos2_menu
       WHERE id = '167'
       AND published='1'
187. SELECT oldurl
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_jreviews&Itemid=167&Tricks=&lang=en&url=Tips '
188. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&Itemid=134&lang=en&view=groups'
189. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_jreviews&Itemid=156&lang=en'
190. SELECT name, link,id
       FROM jos2_menu
       WHERE id = '156'
       AND published='1'
191. SELECT oldurl
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_jreviews&Itemid=156&lang=en&url=Submit Idea'
192. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_jreviews&Itemid=157&lang=en'
193. SELECT name, link,id
       FROM jos2_menu
       WHERE id = '157'
       AND published='1'
194. SELECT oldurl
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_jreviews&Itemid=157&lang=en&url=Submit Industry ProFile'
195. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_jreviews&Itemid=158&lang=en'
196. SELECT name, link,id
       FROM jos2_menu
       WHERE id = '158'
       AND published='1'
197. SELECT oldurl
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_jreviews&Itemid=158&lang=en&url=Submit Showcase'
198. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_jreviews&Itemid=159&lang=en'
199. SELECT name, link,id
       FROM jos2_menu
       WHERE id = '159'
       AND published='1'
200. SELECT oldurl
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_jreviews&Itemid=159&Tricks=&lang=en&url=Submit Tips '
201. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_docman&Itemid=160&lang=en'
202. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_content&Itemid=170&id=101&lang=en&view=article'
203. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_contact&Itemid=8&id=1&lang=en&view=contact'
204. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_content&Itemid=147&id=940&lang=en&layout=blog&view=category'
205. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_content&Itemid=165&id=117&lang=en&view=article'
206. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_user&Itemid=51&lang=en&view=login'
207. SELECT *
       FROM jos2_banner
       WHERE showBanner = 1
       AND (imptotal = 0 OR impmade < imptotal)
       AND cid = 1
       AND catid = 23
       ORDER BY sticky DESC, ordering
       LIMIT 0, 1
208. UPDATE jos2_banner
       SET impmade = impmade + 1
       WHERE bid = 6
209. INSERT INTO jos2_bannertrack ( track_type, banner_id, track_date )
       VALUES ( 1, 6, '2009-07-03' )
210. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_banners&bid=6&lang=en&task=click'
211. SELECT *
       FROM jos2_banner
       WHERE showBanner = 1
       AND (imptotal = 0 OR impmade < imptotal)
       AND cid = 1
       AND catid = 26
       ORDER BY sticky DESC, ordering
       LIMIT 0, 1
212. UPDATE jos2_banner
       SET impmade = impmade + 1
       WHERE bid = 8
213. INSERT INTO jos2_bannertrack ( track_type, banner_id, track_date )
       VALUES ( 1, 8, '2009-07-03' )
214. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_banners&bid=8&lang=en&task=click'
215. SELECT *
       FROM `jos2_acajoom_xonfig`
216. SELECT *
       FROM `jos2_acajoom_lists`
       WHERE `id` IN ( 1 )
       AND `published` = 1
217. SELECT Listing.id AS `Listing.listing_id`,
     Listing.title AS `Listing.title`,
     Listing.introtext AS `Listing.summary`,
     Listing.images AS `Listing.images`,
     Listing.hits AS `Listing.hits`,
     Listing.sectionid AS `Listing.section_id`,
     Listing.catid AS `Listing.cat_id`,
     Listing.created_by AS `Listing.user_id`,
     Listing.created_by_alias AS `Listing.author_alias`,
     Listing.created AS `Listing.created`,
     Listing.access AS `Listing.access`,
     Listing.state AS `Listing.state`,
     Listing.publish_up AS `Listing.publish_up`,
     Listing.state AS `Listing.publish_down`,
     Listing.metakey AS `Listing.metakey`,
     Listing.metadesc AS `Listing.metadesc`,
     'com_content' AS `Listing.extension`,
     Section.id AS `Section.section_id`,
     Section.title AS `Section.title`,
     Category.id AS `Category.cat_id`,
     Category.title AS `Category.title`,
     Category.image AS `Listing.category_image`,
     Directory.id AS `Directory.dir_id`,
     Directory.DESC AS `Directory.title`,
     Directory.title AS `Directory.slug`,
     Criteria.id AS `Criteria.criteria_id`,
     Criteria.criteria AS `Criteria.criteria`,
     Criteria.tooltips AS `Criteria.tooltips`,
     Criteria.weights AS `Criteria.weights`,
     Criteria.state AS `Criteria.state`,
     `Field`.featured AS `Listing.featured`,
     User.id AS `User.user_id`,
     User.name AS `User.name`,
     User.username AS `User.username`,
     User.email AS `User.email`,
     IF((sum(Rating.ratings_sum-Review.author*Rating.ratings_sum)/sum(Rating.ratings_qty-Review.author*Rating.ratings_qty))>0,1,0) AS `Review.user_rating_exists`,
     CASE WHEN CHAR_LENGTH(Listing.alias) THEN Listing.alias ELSE "" END AS `Listing.slug`,
     CASE WHEN CHAR_LENGTH(Category.alias) THEN Category.alias ELSE Category.title END AS `Category.slug`,
     CASE WHEN CHAR_LENGTH(Section.alias) THEN Section.alias ELSE Section.title END AS `Section.slug`,
     sum(Review.author*(Rating.ratings_sum/Rating.ratings_qty)) AS `Review.editor_rating`,
     IF(sum(Review.author*(Rating.ratings_sum/Rating.ratings_qty))>0,1,0) AS `Review.editor_rating_exists`,
     (sum(Rating.ratings_sum-Review.author*Rating.ratings_sum)/sum(Rating.ratings_qty-Review.author*Rating.ratings_qty)) AS `Review.user_rating`,
     IF((sum(Rating.ratings_sum-Review.author*Rating.ratings_sum)/sum(Rating.ratings_qty-Review.author*Rating.ratings_qty))>0,1,0) AS `Review.user_rating_exists`,
     (count(Review.id)-sum(Review.author)) AS `Review.review_count`,
     IF ((count(Review.id)-sum(Review.author))>0,1,0) AS `Review.review_count_exists`
      
       FROM jos2_content AS Listing
     
       LEFT JOIN jos2_jreviews_content AS FIELD
       ON FIELD.contentid = Listing.id
     
       LEFT JOIN jos2_sections AS Section
       ON Listing.sectionid = Section.id
     
       LEFT JOIN jos2_categories AS Category
       ON Listing.catid = Category.id
     
       INNER JOIN jos2_jreviews_categories AS JreviewsCategory
       ON Listing.catid = JreviewsCategory.id
       AND JreviewsCategory.`option` = 'com_content'
     
       LEFT JOIN jos2_jreviews_directories AS Directory
       ON JreviewsCategory.dirid = Directory.id
     
       LEFT JOIN jos2_jreviews_criteria AS Criteria
       ON JreviewsCategory.criteriaid = Criteria.id
     
       LEFT JOIN jos2_users AS User
       ON User.id = Listing.created_by
     
       LEFT JOIN jos2_jreviews_comments AS Review
       ON Listing.id = Review.pid
       AND Review.published = 1
       AND Review.mode = 'com_content'
     
       LEFT JOIN jos2_jreviews_ratings AS Rating
       ON Review.id = Rating.reviewid
      
       WHERE 1 = 1
       AND (
        Listing.state = 1
        
       AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2009-07-03 23:15" )
        
       AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2009-07-03 23:15" )
        
       AND Listing.access <= 0
        
       AND Listing.catid > 0
        
       AND JreviewsCategory.dirid IN (2)
        
       AND featured > 0
      )
      
       GROUP BY Listing.id
      
       ORDER BY RAND(754084579)
      
       LIMIT 5
218. SELECT COUNT(DISTINCT Listing.id)
      
       FROM jos2_content AS Listing
     
       LEFT JOIN jos2_jreviews_content AS FIELD
       ON FIELD.contentid = Listing.id
     
       LEFT JOIN jos2_sections AS Section
       ON Listing.sectionid = Section.id
     
       LEFT JOIN jos2_categories AS Category
       ON Listing.catid = Category.id
     
       INNER JOIN jos2_jreviews_categories AS JreviewsCategory
       ON Listing.catid = JreviewsCategory.id
       AND JreviewsCategory.`option` = 'com_content'
     
       LEFT JOIN jos2_jreviews_directories AS Directory
       ON JreviewsCategory.dirid = Directory.id
     
       LEFT JOIN jos2_jreviews_criteria AS Criteria
       ON JreviewsCategory.criteriaid = Criteria.id
     
       LEFT JOIN jos2_users AS User
       ON User.id = Listing.created_by
     
       LEFT JOIN jos2_jreviews_comments AS Review
       ON Listing.id = Review.pid
       AND Review.published = 1
       AND Review.mode = 'com_content'
     
       LEFT JOIN jos2_jreviews_ratings AS Rating
       ON Review.id = Rating.reviewid
      
       WHERE 1 = 1
       AND (
        Listing.state = 1
        
       AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2009-07-03 23:15" )
        
       AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2009-07-03 23:15" )
        
       AND Listing.access <= 0
        
       AND Listing.catid > 0
        
       AND JreviewsCategory.dirid IN (2)
        
       AND featured > 0
      )
219. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_jreviews&Itemid=133&lang=en&url=menu/lang*@*en/view*@*frontpage/page*@*1/limit*@*5/'
220. SELECT name, link,id
       FROM jos2_menu
       WHERE id = '133'
       AND published='1'
221. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_content&catid=950&id=108&lang=en&view=article'
222. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_jreviews&Itemid=150&lang=en&url=industry-profiles/individuals/festival-organisers_c950_m150/'
223. SELECT name, link,id
       FROM jos2_menu
       WHERE id = '150'
       AND published='1'
224. SELECT oldurl
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_jreviews&Itemid=150&lang=en&url=industry-profiles/individuals/festival-organisers_c950_m150'
225. SELECT Listing.id AS `Listing.listing_id`,
     Listing.title AS `Listing.title`,
     Listing.introtext AS `Listing.summary`,
     Listing.images AS `Listing.images`,
     Listing.hits AS `Listing.hits`,
     Listing.sectionid AS `Listing.section_id`,
     Listing.catid AS `Listing.cat_id`,
     Listing.created_by AS `Listing.user_id`,
     Listing.created_by_alias AS `Listing.author_alias`,
     Listing.created AS `Listing.created`,
     Listing.access AS `Listing.access`,
     Listing.state AS `Listing.state`,
     Listing.publish_up AS `Listing.publish_up`,
     Listing.state AS `Listing.publish_down`,
     Listing.metakey AS `Listing.metakey`,
     Listing.metadesc AS `Listing.metadesc`,
     'com_content' AS `Listing.extension`,
     Section.id AS `Section.section_id`,
     Section.title AS `Section.title`,
     Category.id AS `Category.cat_id`,
     Category.title AS `Category.title`,
     Category.image AS `Listing.category_image`,
     Directory.id AS `Directory.dir_id`,
     Directory.DESC AS `Directory.title`,
     Directory.title AS `Directory.slug`,
     Criteria.id AS `Criteria.criteria_id`,
     Criteria.criteria AS `Criteria.criteria`,
     Criteria.tooltips AS `Criteria.tooltips`,
     Criteria.weights AS `Criteria.weights`,
     Criteria.state AS `Criteria.state`,
     `Field`.featured AS `Listing.featured`,
     User.id AS `User.user_id`,
     User.name AS `User.name`,
     User.username AS `User.username`,
     User.email AS `User.email`,
     IF((sum(Rating.ratings_sum-Review.author*Rating.ratings_sum)/sum(Rating.ratings_qty-Review.author*Rating.ratings_qty))>0,1,0) AS `Review.user_rating_exists`,
     CASE WHEN CHAR_LENGTH(Listing.alias) THEN Listing.alias ELSE "" END AS `Listing.slug`,
     CASE WHEN CHAR_LENGTH(Category.alias) THEN Category.alias ELSE Category.title END AS `Category.slug`,
     CASE WHEN CHAR_LENGTH(Section.alias) THEN Section.alias ELSE Section.title END AS `Section.slug`,
     sum(Review.author*(Rating.ratings_sum/Rating.ratings_qty)) AS `Review.editor_rating`,
     IF(sum(Review.author*(Rating.ratings_sum/Rating.ratings_qty))>0,1,0) AS `Review.editor_rating_exists`,
     (sum(Rating.ratings_sum-Review.author*Rating.ratings_sum)/sum(Rating.ratings_qty-Review.author*Rating.ratings_qty)) AS `Review.user_rating`,
     IF((sum(Rating.ratings_sum-Review.author*Rating.ratings_sum)/sum(Rating.ratings_qty-Review.author*Rating.ratings_qty))>0,1,0) AS `Review.user_rating_exists`,
     (count(Review.id)-sum(Review.author)) AS `Review.review_count`,
     IF ((count(Review.id)-sum(Review.author))>0,1,0) AS `Review.review_count_exists`
      
       FROM jos2_content AS Listing
     
       LEFT JOIN jos2_jreviews_content AS FIELD
       ON FIELD.contentid = Listing.id
     
       LEFT JOIN jos2_sections AS Section
       ON Listing.sectionid = Section.id
     
       LEFT JOIN jos2_categories AS Category
       ON Listing.catid = Category.id
     
       INNER JOIN jos2_jreviews_categories AS JreviewsCategory
       ON Listing.catid = JreviewsCategory.id
       AND JreviewsCategory.`option` = 'com_content'
     
       LEFT JOIN jos2_jreviews_directories AS Directory
       ON JreviewsCategory.dirid = Directory.id
     
       LEFT JOIN jos2_jreviews_criteria AS Criteria
       ON JreviewsCategory.criteriaid = Criteria.id
     
       LEFT JOIN jos2_users AS User
       ON User.id = Listing.created_by
     
       LEFT JOIN jos2_jreviews_comments AS Review
       ON Listing.id = Review.pid
       AND Review.published = 1
       AND Review.mode = 'com_content'
     
       LEFT JOIN jos2_jreviews_ratings AS Rating
       ON Review.id = Rating.reviewid
      
       WHERE 1 = 1
       AND (
        Listing.state = 1
        
       AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2009-07-03 23:15" )
        
       AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2009-07-03 23:15" )
        
       AND Listing.access <= 0
        
       AND Listing.catid > 0
        
       AND JreviewsCategory.dirid IN (1)
        
       AND featured > 0
      )
      
       GROUP BY Listing.id
      
       ORDER BY RAND(1634369000)
      
       LIMIT 5
226. SELECT COUNT(DISTINCT Listing.id)
      
       FROM jos2_content AS Listing
     
       LEFT JOIN jos2_jreviews_content AS FIELD
       ON FIELD.contentid = Listing.id
     
       LEFT JOIN jos2_sections AS Section
       ON Listing.sectionid = Section.id
     
       LEFT JOIN jos2_categories AS Category
       ON Listing.catid = Category.id
     
       INNER JOIN jos2_jreviews_categories AS JreviewsCategory
       ON Listing.catid = JreviewsCategory.id
       AND JreviewsCategory.`option` = 'com_content'
     
       LEFT JOIN jos2_jreviews_directories AS Directory
       ON JreviewsCategory.dirid = Directory.id
     
       LEFT JOIN jos2_jreviews_criteria AS Criteria
       ON JreviewsCategory.criteriaid = Criteria.id
     
       LEFT JOIN jos2_users AS User
       ON User.id = Listing.created_by
     
       LEFT JOIN jos2_jreviews_comments AS Review
       ON Listing.id = Review.pid
       AND Review.published = 1
       AND Review.mode = 'com_content'
     
       LEFT JOIN jos2_jreviews_ratings AS Rating
       ON Review.id = Rating.reviewid
      
       WHERE 1 = 1
       AND (
        Listing.state = 1
        
       AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2009-07-03 23:15" )
        
       AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2009-07-03 23:15" )
        
       AND Listing.access <= 0
        
       AND Listing.catid > 0
        
       AND JreviewsCategory.dirid IN (1)
        
       AND featured > 0
      )
227. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_jreviews&Itemid=133&lang=en&url=menu/lang*@*en/view*@*frontpage/page*@*1/limit*@*5/'
228. SELECT name, link,id
       FROM jos2_menu
       WHERE id = '133'
       AND published='1'
229. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_content&catid=932&id=102&lang=en&view=article'
230. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_jreviews&Itemid=142&lang=en&url=idea-bank/festival-organisers/ideas4events_c932_m142/'
231. SELECT name, link,id
       FROM jos2_menu
       WHERE id = '142'
       AND published='1'
232. SELECT oldurl
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_jreviews&Itemid=142&lang=en&url=idea-bank/festival-organisers/ideas4events_c932_m142'
233. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_content&id=99&lang=en&tmpl=component&view=article'
234. SELECT oldurl, dateadd
       FROM jos2_redirection
       WHERE newurl = 'index.php?option=com_community&lang=en&view=groups'

1 legacy queries logged

1. SELECT m.*
     FROM jos2_menu AS m
   
     WHERE menutype='mainmenu'
     AND published='1'
     AND access <= '0'
   
     ORDER BY parent,ordering

Language Files Loaded

• /home/festcomm/public_html/festivalorganiser.com/language/en-GB/en-GB.ini 1
• /home/festcomm/public_html/festivalorganiser.com/language/en-GB/en-GB.com_parainvite.ini 1
• /home/festcomm/public_html/festivalorganiser.com/language/en-GB/en-GB.plg_system_debug.ini 1
• /home/festcomm/public_html/festivalorganiser.com/administrator/language/en-GB/en-GB.plg_system_checkambrasubs.ini 1
• /home/festcomm/public_html/festivalorganiser.com/language/en-GB/en-GB.com_community.ini 1
• /home/festcomm/public_html/festivalorganiser.com/administrator/language/en-GB/en-GB.plg_myblog.ini 1
• /home/festcomm/public_html/festivalorganiser.com/language/en-GB/en-GB.tpl_ja_rochea2.ini
• /home/festcomm/public_html/festivalorganiser.com/language/en-GB/en-GB.mod_mainmenu.ini 1
• /home/festcomm/public_html/festivalorganiser.com/language/en-GB/en-GB.mod_banners.ini 1
• /home/festcomm/public_html/festivalorganiser.com/language/en-GB/en-GB.mod_acajoom.ini
• /home/festcomm/public_html/festivalorganiser.com/language/en-GB/en-GB.mod_jreviews_listings.ini 1
• /home/festcomm/public_html/festivalorganiser.com/language/en-GB/en-GB.mod_breadcrumbs.ini 1

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None