LOGTRAIN INTERNATIONAL

Profile Information

Memory Usage

85 queries logged

1. SELECT *
     FROM joj_session
     WHERE session_id = 'bb29e2be12142e7ebb8134a8aa484181'
2. DELETE
     FROM joj_session
     WHERE ( TIME < '1337448427' )
3. SELECT *
     FROM joj_session
     WHERE session_id = 'bb29e2be12142e7ebb8134a8aa484181'
4. INSERT INTO `joj_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( 'bb29e2be12142e7ebb8134a8aa484181','1337451127','','0','1','0' )
5. SELECT *
     FROM joj_components
     WHERE parent = 0
6. SELECT folder AS TYPE, element AS name, params
     FROM joj_plugins
     WHERE published >= 1
     AND access <= 0
     ORDER BY ordering
7. SELECT m.*, c.`option` AS component
     FROM joj_menu AS m
     LEFT JOIN joj_components AS c
     ON m.componentid = c.id
     WHERE m.published = 1
     ORDER BY m.sublevel, m.parent, m.ordering
8. SELECT template
     FROM joj_templates_menu
     WHERE client_id = 0
     AND (menuid = 0 OR menuid = 1)
     ORDER BY menuid DESC
     LIMIT 0, 1
9. 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 joj_content AS a
     INNER JOIN joj_content_frontpage AS f
     ON f.content_id = a.id
     LEFT JOIN joj_categories AS cc
     ON cc.id = a.catid
     LEFT JOIN joj_sections AS s
     ON s.id = a.sectionid
     LEFT JOIN joj_users AS u
     ON u.id = a.created_by
     LEFT JOIN joj_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-19 18:12:07' )
     AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-19 18:12:07' )
     ORDER BY  f.ordering
     LIMIT 0, 9
10. 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 joj_content AS a
      INNER JOIN joj_content_frontpage AS f
      ON f.content_id = a.id
      LEFT JOIN joj_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN joj_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN joj_users AS u
      ON u.id = a.created_by
      LEFT JOIN joj_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-19 18:12:07' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-19 18:12:07' )
      ORDER BY  f.ordering
11. SELECT id, title, module, POSITION, content, showtitle, control, params
      FROM joj_modules AS m
      LEFT JOIN joj_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 = 1 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
12. SELECT m.*
      FROM joj_menu AS m
      WHERE menutype='mainmenu'
      AND published = 1
      AND access <= 0
      AND parent = 0
      ORDER BY ordering
13. SELECT *
      FROM joj_community_config
      WHERE name = 'config'
14. SELECT *
      FROM `joj_users` AS a
      INNER JOIN `joj_community_users` AS b
      ON a.`id` = b.`userid`
      WHERE a.`block` = '0'  
      ORDER BY a.`registerDate` DESC
      LIMIT 10
15. 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.`friends` AS _friends,  a.`alias`  AS _alias,  a.`profile_id` AS _profile_id,  a.`friendcount` AS _friendcount,  a.`storage` AS _storage,  a.`watermark_hash` AS _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` AS _isonline, u.*  
      FROM `joj_community_users` AS a  
      LEFT JOIN `joj_users` u  
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `joj_session`s  
      ON s.`userid`=a.`userid`
      WHERE a.`userid` IN (92,91,90,89,88,87,86,85,83,82)
16. SELECT COUNT(DISTINCT connect_to)  
      FROM `joj_community_connection` AS a, `joj_users` AS b
      WHERE a.`connect_from`='82'
      AND b.block=0  
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `joj_community_blocklist` AS d
      WHERE d.`userid` = '82'
      AND d.`blocked_userid` = a.`connect_to`)  
      ORDER BY a.`connection_id` DESC
17. SELECT COUNT(DISTINCT connect_to)  
      FROM `joj_community_connection` AS a, `joj_users` AS b
      WHERE a.`connect_from`='83'
      AND b.block=0  
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `joj_community_blocklist` AS d
      WHERE d.`userid` = '83'
      AND d.`blocked_userid` = a.`connect_to`)  
      ORDER BY a.`connection_id` DESC
18. SELECT COUNT(DISTINCT connect_to)  
      FROM `joj_community_connection` AS a, `joj_users` AS b
      WHERE a.`connect_from`='85'
      AND b.block=0  
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `joj_community_blocklist` AS d
      WHERE d.`userid` = '85'
      AND d.`blocked_userid` = a.`connect_to`)  
      ORDER BY a.`connection_id` DESC
19. SELECT COUNT(DISTINCT connect_to)  
      FROM `joj_community_connection` AS a, `joj_users` AS b
      WHERE a.`connect_from`='86'
      AND b.block=0  
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `joj_community_blocklist` AS d
      WHERE d.`userid` = '86'
      AND d.`blocked_userid` = a.`connect_to`)  
      ORDER BY a.`connection_id` DESC
20. SELECT COUNT(DISTINCT connect_to)  
      FROM `joj_community_connection` AS a, `joj_users` AS b
      WHERE a.`connect_from`='87'
      AND b.block=0  
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `joj_community_blocklist` AS d
      WHERE d.`userid` = '87'
      AND d.`blocked_userid` = a.`connect_to`)  
      ORDER BY a.`connection_id` DESC
21. SELECT COUNT(DISTINCT connect_to)  
      FROM `joj_community_connection` AS a, `joj_users` AS b
      WHERE a.`connect_from`='88'
      AND b.block=0  
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `joj_community_blocklist` AS d
      WHERE d.`userid` = '88'
      AND d.`blocked_userid` = a.`connect_to`)  
      ORDER BY a.`connection_id` DESC
22. SELECT COUNT(DISTINCT connect_to)  
      FROM `joj_community_connection` AS a, `joj_users` AS b
      WHERE a.`connect_from`='89'
      AND b.block=0  
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `joj_community_blocklist` AS d
      WHERE d.`userid` = '89'
      AND d.`blocked_userid` = a.`connect_to`)  
      ORDER BY a.`connection_id` DESC
23. SELECT COUNT(DISTINCT connect_to)  
      FROM `joj_community_connection` AS a, `joj_users` AS b
      WHERE a.`connect_from`='90'
      AND b.block=0  
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `joj_community_blocklist` AS d
      WHERE d.`userid` = '90'
      AND d.`blocked_userid` = a.`connect_to`)  
      ORDER BY a.`connection_id` DESC
24. SELECT COUNT(DISTINCT connect_to)  
      FROM `joj_community_connection` AS a, `joj_users` AS b
      WHERE a.`connect_from`='91'
      AND b.block=0  
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `joj_community_blocklist` AS d
      WHERE d.`userid` = '91'
      AND d.`blocked_userid` = a.`connect_to`)  
      ORDER BY a.`connection_id` DESC
25. SELECT COUNT(DISTINCT connect_to)  
      FROM `joj_community_connection` AS a, `joj_users` AS b
      WHERE a.`connect_from`='92'
      AND b.block=0  
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `joj_community_blocklist` AS d
      WHERE d.`userid` = '92'
      AND d.`blocked_userid` = a.`connect_to`)  
      ORDER BY a.`connection_id` DESC
26. SELECT `id`
      FROM `joj_menu`
      WHERE `link` LIKE '%option=com_community&view=profile%'
      AND `published`='1'
      AND `menutype`!='jomsocial'
      AND `type`='component'
27. SELECT `id`
      FROM `joj_menu`
      WHERE `link` = 'index.php?option=com_community&view=frontpage'
      AND `published`='1'
      AND `type`='component'
28. SELECT `id`
      FROM `joj_menu`
      WHERE `link` LIKE '%option=com_community%'
      AND `published`='1'
      AND `type`='component'
29. 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.`friends` AS _friends,  a.`groups` AS _groups,  a.`friendcount` AS _friendcount,  a.`alias` AS _alias,  a.`profile_id` AS _profile_id,  a.`storage` AS _storage,  a.`watermark_hash` AS _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` AS _isonline, u.*  
      FROM `joj_community_users` AS a  
      LEFT JOIN `joj_users` u  
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `joj_session` s  
      ON s.`userid`=a.`userid`
      AND s.`client_id` !='1'
      WHERE a.`userid`='0'
30. SELECT *
      FROM `joj_community_users`
      WHERE `userid`='92'
      AND (`status_access` <= 10)
      ORDER BY `posted_on` DESC
      LIMIT 1
31. SELECT *
      FROM `joj_community_users`
      WHERE `userid`='91'
      AND (`status_access` <= 10)
      ORDER BY `posted_on` DESC
      LIMIT 1
32. SELECT *
      FROM `joj_community_users`
      WHERE `userid`='90'
      AND (`status_access` <= 10)
      ORDER BY `posted_on` DESC
      LIMIT 1
33. SELECT *
      FROM `joj_community_users`
      WHERE `userid`='89'
      AND (`status_access` <= 10)
      ORDER BY `posted_on` DESC
      LIMIT 1
34. SELECT *
      FROM `joj_community_users`
      WHERE `userid`='88'
      AND (`status_access` <= 10)
      ORDER BY `posted_on` DESC
      LIMIT 1
35. SELECT *
      FROM `joj_community_users`
      WHERE `userid`='87'
      AND (`status_access` <= 10)
      ORDER BY `posted_on` DESC
      LIMIT 1
36. SELECT *
      FROM `joj_community_users`
      WHERE `userid`='86'
      AND (`status_access` <= 10)
      ORDER BY `posted_on` DESC
      LIMIT 1
37. SELECT *
      FROM `joj_community_users`
      WHERE `userid`='85'
      AND (`status_access` <= 10)
      ORDER BY `posted_on` DESC
      LIMIT 1
38. SELECT *
      FROM `joj_community_users`
      WHERE `userid`='83'
      AND (`status_access` <= 10)
      ORDER BY `posted_on` DESC
      LIMIT 1
39. SELECT *
      FROM `joj_community_users`
      WHERE `userid`='82'
      AND (`status_access` <= 10)
      ORDER BY `posted_on` DESC
      LIMIT 1
40. SELECT `id`
      FROM `joj_menu`
      WHERE `link` LIKE '%option=com_community&view=search%'
      AND `published`='1'
      AND `menutype`!='jomsocial'
      AND `type`='component'
41. SELECT
                                                    `cid`,
                                                    COUNT(`cid`) AS `count`
                                       
      FROM
                                                    `joj_community_activities` a
                             
      INNER JOIN     `joj_community_groups` b
      ON a.`cid` = b.`id`
                                     
      WHERE
                                                    a.`app` = 'groups'
      AND
                                                    b.`published` = '1'
      AND
                                                    a.`archived` = '0'
      AND
                                                    a.`cid` != '0'
                               
      GROUP BY a.`cid`
                               
      ORDER BY `count` DESC
                               
      LIMIT 20
42. SELECT a.*, b.`name` AS ownername , c.`name` AS category
      FROM `joj_community_groups` AS a  
      INNER JOIN `joj_users` AS b  
      INNER JOIN `joj_community_groups_category` AS c  
      WHERE a.`id`='13'  
      AND a.`ownerid`=b.`id`
      AND a.`categoryid`=c.`id`
43. SELECT a.`memberid` AS id, a.`approved` , b.`name` AS name
      FROM`joj_community_groups_members` AS a  
      INNER JOIN `joj_users` AS b  
      WHERE b.`id`=a.`memberid`
      AND a.`groupid`='13'
      AND b.`block`='0'  
      AND a.`permissions` !='-1'
      AND a.`approved`='1'
      ORDER BY b.`name`
44. SELECT COUNT(*)
      FROM `joj_community_groups_members` AS a  
      INNER JOIN `joj_users` AS b  
      WHERE b.`id`=a.`memberid`
      AND a.`groupid`='13'
      AND b.`block`='0'
      AND a.`approved`='1'
45. SELECT a.*, b.`name` AS ownername , c.`name` AS category
      FROM `joj_community_groups` AS a  
      INNER JOIN `joj_users` AS b  
      INNER JOIN `joj_community_groups_category` AS c  
      WHERE a.`id`='15'  
      AND a.`ownerid`=b.`id`
      AND a.`categoryid`=c.`id`
46. SELECT a.`memberid` AS id, a.`approved` , b.`name` AS name
      FROM`joj_community_groups_members` AS a  
      INNER JOIN `joj_users` AS b  
      WHERE b.`id`=a.`memberid`
      AND a.`groupid`='15'
      AND b.`block`='0'  
      AND a.`permissions` !='-1'
      AND a.`approved`='1'
      ORDER BY b.`name`
47. SELECT COUNT(*)
      FROM `joj_community_groups_members` AS a  
      INNER JOIN `joj_users` AS b  
      WHERE b.`id`=a.`memberid`
      AND a.`groupid`='15'
      AND b.`block`='0'
      AND a.`approved`='1'
48. SELECT a.*, b.`name` AS ownername , c.`name` AS category
      FROM `joj_community_groups` AS a  
      INNER JOIN `joj_users` AS b  
      INNER JOIN `joj_community_groups_category` AS c  
      WHERE a.`id`='2'  
      AND a.`ownerid`=b.`id`
      AND a.`categoryid`=c.`id`
49. SELECT a.`memberid` AS id, a.`approved` , b.`name` AS name
      FROM`joj_community_groups_members` AS a  
      INNER JOIN `joj_users` AS b  
      WHERE b.`id`=a.`memberid`
      AND a.`groupid`='2'
      AND b.`block`='0'  
      AND a.`permissions` !='-1'
      AND a.`approved`='1'
      ORDER BY b.`name`
50. SELECT COUNT(*)
      FROM `joj_community_groups_members` AS a  
      INNER JOIN `joj_users` AS b  
      WHERE b.`id`=a.`memberid`
      AND a.`groupid`='2'
      AND b.`block`='0'
      AND a.`approved`='1'
51. SELECT a.*, b.`name` AS ownername , c.`name` AS category
      FROM `joj_community_groups` AS a  
      INNER JOIN `joj_users` AS b  
      INNER JOIN `joj_community_groups_category` AS c  
      WHERE a.`id`='1'  
      AND a.`ownerid`=b.`id`
      AND a.`categoryid`=c.`id`
52. SELECT a.`memberid` AS id, a.`approved` , b.`name` AS name
      FROM`joj_community_groups_members` AS a  
      INNER JOIN `joj_users` AS b  
      WHERE b.`id`=a.`memberid`
      AND a.`groupid`='1'
      AND b.`block`='0'  
      AND a.`permissions` !='-1'
      AND a.`approved`='1'
      ORDER BY b.`name`
53. SELECT COUNT(*)
      FROM `joj_community_groups_members` AS a  
      INNER JOIN `joj_users` AS b  
      WHERE b.`id`=a.`memberid`
      AND a.`groupid`='1'
      AND b.`block`='0'
      AND a.`approved`='1'
54. SELECT a.*, b.`name` AS ownername , c.`name` AS category
      FROM `joj_community_groups` AS a  
      INNER JOIN `joj_users` AS b  
      INNER JOIN `joj_community_groups_category` AS c  
      WHERE a.`id`='10'  
      AND a.`ownerid`=b.`id`
      AND a.`categoryid`=c.`id`
55. SELECT a.`memberid` AS id, a.`approved` , b.`name` AS name
      FROM`joj_community_groups_members` AS a  
      INNER JOIN `joj_users` AS b  
      WHERE b.`id`=a.`memberid`
      AND a.`groupid`='10'
      AND b.`block`='0'  
      AND a.`permissions` !='-1'
      AND a.`approved`='1'
      ORDER BY b.`name`
56. SELECT COUNT(*)
      FROM `joj_community_groups_members` AS a  
      INNER JOIN `joj_users` AS b  
      WHERE b.`id`=a.`memberid`
      AND a.`groupid`='10'
      AND b.`block`='0'
      AND a.`approved`='1'
57. SELECT a.*, b.`name` AS ownername , c.`name` AS category
      FROM `joj_community_groups` AS a  
      INNER JOIN `joj_users` AS b  
      INNER JOIN `joj_community_groups_category` AS c  
      WHERE a.`id`='14'  
      AND a.`ownerid`=b.`id`
      AND a.`categoryid`=c.`id`
58. SELECT a.`memberid` AS id, a.`approved` , b.`name` AS name
      FROM`joj_community_groups_members` AS a  
      INNER JOIN `joj_users` AS b  
      WHERE b.`id`=a.`memberid`
      AND a.`groupid`='14'
      AND b.`block`='0'  
      AND a.`permissions` !='-1'
      AND a.`approved`='1'
      ORDER BY b.`name`
59. SELECT COUNT(*)
      FROM `joj_community_groups_members` AS a  
      INNER JOIN `joj_users` AS b  
      WHERE b.`id`=a.`memberid`
      AND a.`groupid`='14'
      AND b.`block`='0'
      AND a.`approved`='1'
60. SELECT a.*, b.`name` AS ownername , c.`name` AS category
      FROM `joj_community_groups` AS a  
      INNER JOIN `joj_users` AS b  
      INNER JOIN `joj_community_groups_category` AS c  
      WHERE a.`id`='12'  
      AND a.`ownerid`=b.`id`
      AND a.`categoryid`=c.`id`
61. SELECT a.`memberid` AS id, a.`approved` , b.`name` AS name
      FROM`joj_community_groups_members` AS a  
      INNER JOIN `joj_users` AS b  
      WHERE b.`id`=a.`memberid`
      AND a.`groupid`='12'
      AND b.`block`='0'  
      AND a.`permissions` !='-1'
      AND a.`approved`='1'
      ORDER BY b.`name`
62. SELECT COUNT(*)
      FROM `joj_community_groups_members` AS a  
      INNER JOIN `joj_users` AS b  
      WHERE b.`id`=a.`memberid`
      AND a.`groupid`='12'
      AND b.`block`='0'
      AND a.`approved`='1'
63. SELECT a.*, b.`name` AS ownername , c.`name` AS category
      FROM `joj_community_groups` AS a  
      INNER JOIN `joj_users` AS b  
      INNER JOIN `joj_community_groups_category` AS c  
      WHERE a.`id`='11'  
      AND a.`ownerid`=b.`id`
      AND a.`categoryid`=c.`id`
64. SELECT a.`memberid` AS id, a.`approved` , b.`name` AS name
      FROM`joj_community_groups_members` AS a  
      INNER JOIN `joj_users` AS b  
      WHERE b.`id`=a.`memberid`
      AND a.`groupid`='11'
      AND b.`block`='0'  
      AND a.`permissions` !='-1'
      AND a.`approved`='1'
      ORDER BY b.`name`
65. SELECT COUNT(*)
      FROM `joj_community_groups_members` AS a  
      INNER JOIN `joj_users` AS b  
      WHERE b.`id`=a.`memberid`
      AND a.`groupid`='11'
      AND b.`block`='0'
      AND a.`approved`='1'
66. SELECT a.*, b.`name` AS ownername , c.`name` AS category
      FROM `joj_community_groups` AS a  
      INNER JOIN `joj_users` AS b  
      INNER JOIN `joj_community_groups_category` AS c  
      WHERE a.`id`='9'  
      AND a.`ownerid`=b.`id`
      AND a.`categoryid`=c.`id`
67. SELECT a.`memberid` AS id, a.`approved` , b.`name` AS name
      FROM`joj_community_groups_members` AS a  
      INNER JOIN `joj_users` AS b  
      WHERE b.`id`=a.`memberid`
      AND a.`groupid`='9'
      AND b.`block`='0'  
      AND a.`permissions` !='-1'
      AND a.`approved`='1'
      ORDER BY b.`name`
68. SELECT COUNT(*)
      FROM `joj_community_groups_members` AS a  
      INNER JOIN `joj_users` AS b  
      WHERE b.`id`=a.`memberid`
      AND a.`groupid`='9'
      AND b.`block`='0'
      AND a.`approved`='1'
69. SELECT `id`
      FROM `joj_menu`
      WHERE `link` LIKE '%option=com_community&view=groups%'
      AND `published`='1'
      AND `menutype`!='jomsocial'
      AND `type`='component'
70. SELECT id
      FROM joj_core_acl_aro
      WHERE section_value='users'
      AND VALUE='0'
71. SELECT m.*,n.`name`
      FROM `joj_community_blocklist` m
      LEFT JOIN `joj_users` n
      ON m.`blocked_userid`=n.`id`
      WHERE m.`userid`='0'
      AND m.`blocked_userid`!=0
72. SELECT a.*,  TO_DAYS('2012-05-19 20:12:07') -  TO_DAYS( DATE_ADD(a.`created`, INTERVAL 2 HOUR ) ) AS _daydiff
      FROM `joj_community_activities` AS a  
      WHERE  `archived`=0
      AND (a.`access` <= 10)
      GROUP BY a.`id`
      ORDER BY a.`created` DESC
      LIMIT 40
73. SELECT a.*  
      FROM `joj_community_wall` AS a  
      WHERE  (  a.`type`='profile.status'
      AND  a.`contentid` IN (41,39,38,37,36,5)  )  OR  (  a.`type`='profile.avatar.upload'
      AND  a.`contentid` IN (87,63,62)  )  OR  (  a.`type`='groups.wall'
      AND  a.`contentid` IN (1)  )  
      ORDER BY `id` DESC
74. SELECT a.*  
      FROM `joj_community_likes` AS a  
      WHERE  (  a.`element`='profile.status'
      AND  a.`uid` IN (41,39,38,37,36,5)  )  OR  (  a.`element`='profile.avatar.upload'
      AND  a.`uid` IN (87,63,62)  )
75. SELECT `name`
      FROM `joj_plugins`
      WHERE `element`='profile'
      AND `folder`='community'
76. SELECT `name`
      FROM `joj_plugins`
      WHERE `element`='profile'
      AND `folder`='community'
77. SELECT `name`
      FROM `joj_plugins`
      WHERE `element`='profile'
      AND `folder`='community'
78. SELECT `name`
      FROM `joj_plugins`
      WHERE `element`='profile'
      AND `folder`='community'
79. SELECT COUNT(1)
      FROM `joj_community_activities`
80. SELECT COUNT(1)
      FROM `joj_community_activities`
81. SELECT *
      FROM joj_acymailing_config
82. SELECT m.senddate, m.alias, m.subject, m.mailid, l.listid, l.alias AS listalias
      FROM joj_acymailing_list AS l
      LEFT JOIN joj_acymailing_listmail AS b
      ON l.listid = b.listid
      LEFT JOIN joj_acymailing_mail AS m
      ON b.mailid = m.mailid
      WHERE m.TYPE = 'news'
      AND l.published = 1
      AND m.published = 1
      AND l.visible = 1
      AND m.visible = 1
      AND l.TYPE= 'list'
      GROUP BY m.mailid
      ORDER BY m.senddate DESC
      LIMIT 5
83. SELECT *
      FROM joj_acymailing_list
      WHERE TYPE = 'list'
      ORDER BY ordering ASC
84. 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 joj_content AS a
      LEFT JOIN joj_content_frontpage AS f
      ON f.content_id = a.id
      INNER JOIN joj_categories AS cc
      ON cc.id = a.catid
      INNER JOIN joj_sections AS s
      ON s.id = a.sectionid
      WHERE ( a.state = 1
      AND s.id > 0 )
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-19 18:12:07' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-19 18:12:07' )
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (s.id=2)
      AND s.published = 1
      AND cc.published = 1
      ORDER BY a.hits DESC
      LIMIT 0, 13
85. SELECT `value`
      FROM `joj_admintools_storage`
      WHERE `key` = 'cparams'

Language Files Loaded

• /home/tradsatt/public_html/language/en-GB/en-GB.ini 1
• /home/tradsatt/public_html/administrator/language/en-GB/en-GB.com_community.menu.ini 1
• /home/tradsatt/public_html/language/en-GB/en-GB.plg_system_debug.ini 1
• /home/tradsatt/public_html/administrator/language/en-GB/en-GB.plg_system_jcemediabox.ini 1
• /home/tradsatt/public_html/language/en-GB/en-GB.com_content.ini 1
• administrator/language/en-GB/en-GB.plg_content_jw_allvideos.ini
• /home/tradsatt/public_html/language/en-GB/en-GB.mod_simple_video_flash_player.ini
• /home/tradsatt/public_html/language/en-GB/en-GB.plg_content_pagebreak.ini 1
• /home/tradsatt/public_html/language/en-GB/en-GB.tpl_logtrainnew.ini
• /home/tradsatt/public_html/language/en-GB/en-GB.mod_exmenu-j15.ini
• /home/tradsatt/public_html/language/en-GB/en-GB.mod_mainmenu.ini 1
• /home/tradsatt/public_html/language/en-GB/en-GB.mod_latestmembers.ini 1
• /home/tradsatt/public_html/language/en-GB/en-GB.com_community.ini 1
• /home/tradsatt/public_html/language/en-GB/en-GB.mod_activegroups.ini 1
• /home/tradsatt/public_html/language/en-GB/en-GB.mod_activitystream.ini
• /home/tradsatt/public_html/language/en-GB/en-GB.mod_acymailing_latest.ini
• /home/tradsatt/public_html/language/en-GB/en-GB.com_acymailing.ini 1
• /home/tradsatt/public_html/language/en-GB/en-GB.com_acymailing_custom.ini
• /home/tradsatt/public_html/language/en-GB/en-GB.mod_acymailing.ini
• /home/tradsatt/public_html/language/en-GB/en-GB.mod_mostread.ini 1

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None