Информация о профиле

Использование памяти

Зарегистрировано запросов: 313

1. SELECT *
     FROM jos_session
     WHERE session_id = '0baa9b9b83bf95cd92a1a3e58933ead4'
2. DELETE
     FROM jos_session
     WHERE ( time < '1571737183' )
3. SELECT *
     FROM jos_session
     WHERE session_id = '0baa9b9b83bf95cd92a1a3e58933ead4'
4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( '0baa9b9b83bf95cd92a1a3e58933ead4','1571761183','','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 MAX(time) 
     FROM jos_vvcounter_logs
8. 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
9. SELECT *
     FROM jos_community_config
     WHERE name = 'config'
10. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 110)
      ORDER BY menuid DESC
      LIMIT 0, 1
11. 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
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.`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 `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'
13. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='0'
      ORDER BY `posted_on` DESC
      LIMIT 1
14. SELECT `id`
      FROM `jos_menu`
      WHERE `link` LIKE '%option=com_community&view=frontpage%'
      AND `published`='1'
      AND `menutype`!='jomsocial'
      AND `type`='component'
15. SELECT `id`
      FROM `jos_menu`
      WHERE `link` LIKE '%option=com_community&view=register%'
      AND `published`='1'
      AND `menutype`!='jomsocial'
      AND `type`='component'
16. SELECT COUNT(*)
      FROM `jos_users`
      WHERE `block`='0'
17. SELECT *
      FROM `jos_users` 
      WHERE `block`='0' 
      ORDER BY `registerDate`  DESC
      LIMIT 32
18. 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 `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`
      WHERE a.`userid` IN (1942,1941,1940,1939,1938,1937,1936,1935,1934,1933,1932,1931,1930,1929,1928,1927,1926,1925,1924,1923,1922,1921,1920,1919,1918,1917,1916,1915,1914,1913,1912,1911)
19. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1911'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1911'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
20. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1912'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1912'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
21. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1913'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1913'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
22. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1914'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1914'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
23. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1915'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1915'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
24. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1916'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1916'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
25. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1917'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1917'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
26. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1918'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1918'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
27. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1919'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1919'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
28. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1920'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1920'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
29. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1921'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1921'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
30. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1922'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1922'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
31. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1923'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1923'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
32. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1924'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1924'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
33. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1925'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1925'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
34. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1926'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1926'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
35. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1927'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1927'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
36. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1928'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1928'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
37. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1929'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1929'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
38. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1930'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1930'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
39. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1931'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1931'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
40. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1932'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1932'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
41. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1933'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1933'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
42. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1934'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1934'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
43. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1935'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1935'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
44. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1936'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1936'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
45. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1937'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1937'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
46. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1938'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1938'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
47. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1939'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1939'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
48. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1940'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1940'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
49. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1941'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1941'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
50. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1942'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1942'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
51. SELECT COUNT(*)
      FROM `jos_users`
      WHERE `block`='0'
52. SELECT `id`
      FROM `jos_menu`
      WHERE `link` LIKE '%option=com_community&view=profile%'
      AND `published`='1'
      AND `menutype`!='jomsocial'
      AND `type`='component'
53. SELECT `id`
      FROM `jos_menu`
      WHERE `link` = 'index.php?option=com_community&view=frontpage'
      AND `published`='1'
      AND `type`='component'
54. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1941'
      ORDER BY `posted_on` DESC
      LIMIT 1
55. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1923'
      ORDER BY `posted_on` DESC
      LIMIT 1
56. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1915'
      ORDER BY `posted_on` DESC
      LIMIT 1
57. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1920'
      ORDER BY `posted_on` DESC
      LIMIT 1
58. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1940'
      ORDER BY `posted_on` DESC
      LIMIT 1
59. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1924'
      ORDER BY `posted_on` DESC
      LIMIT 1
60. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1925'
      ORDER BY `posted_on` DESC
      LIMIT 1
61. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1933'
      ORDER BY `posted_on` DESC
      LIMIT 1
62. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1929'
      ORDER BY `posted_on` DESC
      LIMIT 1
63. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1935'
      ORDER BY `posted_on` DESC
      LIMIT 1
64. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1912'
      ORDER BY `posted_on` DESC
      LIMIT 1
65. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1939'
      ORDER BY `posted_on` DESC
      LIMIT 1
66. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1938'
      ORDER BY `posted_on` DESC
      LIMIT 1
67. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1930'
      ORDER BY `posted_on` DESC
      LIMIT 1
68. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1931'
      ORDER BY `posted_on` DESC
      LIMIT 1
69. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1942'
      ORDER BY `posted_on` DESC
      LIMIT 1
70. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1934'
      ORDER BY `posted_on` DESC
      LIMIT 1
71. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1922'
      ORDER BY `posted_on` DESC
      LIMIT 1
72. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1917'
      ORDER BY `posted_on` DESC
      LIMIT 1
73. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1926'
      ORDER BY `posted_on` DESC
      LIMIT 1
74. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1916'
      ORDER BY `posted_on` DESC
      LIMIT 1
75. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1936'
      ORDER BY `posted_on` DESC
      LIMIT 1
76. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1911'
      ORDER BY `posted_on` DESC
      LIMIT 1
77. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1918'
      ORDER BY `posted_on` DESC
      LIMIT 1
78. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1928'
      ORDER BY `posted_on` DESC
      LIMIT 1
79. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1921'
      ORDER BY `posted_on` DESC
      LIMIT 1
80. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1914'
      ORDER BY `posted_on` DESC
      LIMIT 1
81. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1927'
      ORDER BY `posted_on` DESC
      LIMIT 1
82. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1932'
      ORDER BY `posted_on` DESC
      LIMIT 1
83. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1913'
      ORDER BY `posted_on` DESC
      LIMIT 1
84. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1937'
      ORDER BY `posted_on` DESC
      LIMIT 1
85. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1919'
      ORDER BY `posted_on` DESC
      LIMIT 1
86. SELECT `id`
      FROM `jos_menu`
      WHERE `link` LIKE '%option=com_community&view=search%'
      AND `published`='1'
      AND `menutype`!='jomsocial'
      AND `type`='component'
87. SELECT *
      FROM `jos_community_groups` AS a
      WHERE a.`published`='1'
      ORDER BY a.`created` DESC 
      LIMIT 0 , 5
88. SELECT COUNT(*)
                                                      
      FROM jos_community_groups_members a
                                                      JOIN jos_users b
      ON a.memberid=b.id
                                                      
      WHERE `approved`='1'
      AND b.block=0
      AND groupid='6'
89. SELECT COUNT(*)
                                                      
      FROM jos_community_groups_members a
                                                      JOIN jos_users b
      ON a.memberid=b.id
                                                      
      WHERE `approved`='1'
      AND b.block=0
      AND groupid='5'
90. SELECT COUNT(*)
                                                      
      FROM jos_community_groups_members a
                                                      JOIN jos_users b
      ON a.memberid=b.id
                                                      
      WHERE `approved`='1'
      AND b.block=0
      AND groupid='4'
91. SELECT COUNT(*)
                                                      
      FROM jos_community_groups_members a
                                                      JOIN jos_users b
      ON a.memberid=b.id
                                                      
      WHERE `approved`='1'
      AND b.block=0
      AND groupid='3'
92. SELECT COUNT(*)
                                                      
      FROM jos_community_groups_members a
                                                      JOIN jos_users b
      ON a.memberid=b.id
                                                      
      WHERE `approved`='1'
      AND b.block=0
      AND groupid='2'
93. SELECT COUNT(*)
      FROM `jos_community_groups` AS a
      WHERE a.`published`='1'
94. SELECT `id`
      FROM `jos_menu`
      WHERE `link` LIKE '%option=com_community&view=groups%'
      AND `published`='1'
      AND `menutype`!='jomsocial'
      AND `type`='component'
95. SELECT *
      FROM jos_community_groups
      WHERE id = '6'
96. SELECT *
      FROM jos_community_groups
      WHERE id = '6'
97. SELECT *
      FROM jos_community_groups
      WHERE id = '5'
98. SELECT *
      FROM jos_community_groups
      WHERE id = '4'
99. SELECT *
      FROM jos_community_groups
      WHERE id = '3'
100. SELECT *
       FROM jos_community_groups
       WHERE id = '2'
101. SELECT v.*, v.`created` AS lastupdated
       FROM `jos_community_videos` AS v
       LEFT JOIN `jos_community_groups` AS g
       ON g.`id` = v.`groupid`
       WHERE v.`published` = '1'
       AND v.`status` = 'ready'
       AND v.`permissions` <= '0'
       AND (g.`approvals` = '0' OR g.`approvals` IS NULL)
       ORDER BY v.`created` DESC
       LIMIT 0, 6
102. SELECT COUNT(*)
       FROM `jos_community_videos` AS v
       LEFT JOIN `jos_community_groups` AS g
       ON g.`id` = v.`groupid`
       WHERE v.`published` = '1'
       AND v.`status` = 'ready'
       AND v.`permissions` <= '0'
       AND (g.`approvals` = '0' OR g.`approvals` IS NULL)
103. SELECT COUNT(*)
       FROM `jos_community_wall`
       WHERE `type` = 'videos'
       AND `published` = '1'
       AND `contentid` = '122'
104. SELECT COUNT(*)
       FROM `jos_community_wall`
       WHERE `type` = 'videos'
       AND `published` = '1'
       AND `contentid` = '121'
105. SELECT COUNT(*)
       FROM `jos_community_wall`
       WHERE `type` = 'videos'
       AND `published` = '1'
       AND `contentid` = '120'
106. SELECT COUNT(*)
       FROM `jos_community_wall`
       WHERE `type` = 'videos'
       AND `published` = '1'
       AND `contentid` = '118'
107. SELECT COUNT(*)
       FROM `jos_community_wall`
       WHERE `type` = 'videos'
       AND `published` = '1'
       AND `contentid` = '117'
108. SELECT COUNT(*)
       FROM `jos_community_wall`
       WHERE `type` = 'videos'
       AND `published` = '1'
       AND `contentid` = '116'
109. SELECT `id`
       FROM `jos_menu`
       WHERE `link` LIKE '%option=com_community&view=videos%'
       AND `published`='1'
       AND `menutype`!='jomsocial'
       AND `type`='component'
110. 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 `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`='62'
111. SELECT count(*) 
       FROM `jos_community_connection` AS a, `jos_users` AS b
       WHERE a.`connect_from`='62'
       AND b.block=0 
       AND a.`status`='1'
       AND a.`connect_to`=b.`id`
       AND NOT EXISTS ( SELECT d.`blocked_userid`
       FROM `jos_community_blocklist` AS d
       WHERE d.`userid` = '62'
       AND d.`blocked_userid` = a.`connect_to`) 
       ORDER BY a.`connection_id` DESC
112. SELECT *
       FROM jos_community_videos
       WHERE id = '121'
113. 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 `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`='126'
114. SELECT count(*) 
       FROM `jos_community_connection` AS a, `jos_users` AS b
       WHERE a.`connect_from`='126'
       AND b.block=0 
       AND a.`status`='1'
       AND a.`connect_to`=b.`id`
       AND NOT EXISTS ( SELECT d.`blocked_userid`
       FROM `jos_community_blocklist` AS d
       WHERE d.`userid` = '126'
       AND d.`blocked_userid` = a.`connect_to`) 
       ORDER BY a.`connection_id` DESC
115. SELECT *
       FROM jos_community_videos
       WHERE id = '117'
116. SELECT *
       FROM jos_community_videos
       WHERE id = '116'
117. SELECT a.*
       FROM `jos_community_photos` AS a
       INNER JOIN `jos_community_photos_albums` AS b
       ON a.`albumid` = b.`id`
       WHERE b.`type` = 'user'
       AND a.`permissions`='0'
       AND a.`published`='1'
       ORDER BY a.`created` DESC
       LIMIT 20
118. 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 `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`='96'
119. SELECT count(*) 
       FROM `jos_community_connection` AS a, `jos_users` AS b
       WHERE a.`connect_from`='96'
       AND b.block=0 
       AND a.`status`='1'
       AND a.`connect_to`=b.`id`
       AND NOT EXISTS ( SELECT d.`blocked_userid`
       FROM `jos_community_blocklist` AS d
       WHERE d.`userid` = '96'
       AND d.`blocked_userid` = a.`connect_to`) 
       ORDER BY a.`connection_id` DESC
120. 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 `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`='73'
121. SELECT count(*) 
       FROM `jos_community_connection` AS a, `jos_users` AS b
       WHERE a.`connect_from`='73'
       AND b.block=0 
       AND a.`status`='1'
       AND a.`connect_to`=b.`id`
       AND NOT EXISTS ( SELECT d.`blocked_userid`
       FROM `jos_community_blocklist` AS d
       WHERE d.`userid` = '73'
       AND d.`blocked_userid` = a.`connect_to`) 
       ORDER BY a.`connection_id` DESC
122. 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 `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`='123'
123. SELECT count(*) 
       FROM `jos_community_connection` AS a, `jos_users` AS b
       WHERE a.`connect_from`='123'
       AND b.block=0 
       AND a.`status`='1'
       AND a.`connect_to`=b.`id`
       AND NOT EXISTS ( SELECT d.`blocked_userid`
       FROM `jos_community_blocklist` AS d
       WHERE d.`userid` = '123'
       AND d.`blocked_userid` = a.`connect_to`) 
       ORDER BY a.`connection_id` DESC
124. SELECT `id`
       FROM `jos_menu`
       WHERE `link` LIKE '%option=com_community&view=photos%'
       AND `published`='1'
       AND `menutype`!='jomsocial'
       AND `type`='component'
125. SELECT DISTINCT a.*
       FROM `jos_community_events` AS a 
       LEFT JOIN `jos_community_groups` AS g
       ON g.`id` = a.`contentid`
       WHERE a.`published`='1'
       AND (g.`approvals` = '0' OR g.`approvals` IS NULL)
       AND a.`enddate` > '2019-10-22 16:19:43'
       ORDER BY a.`startdate` ASC
       LIMIT 0, 5
126. SELECT COUNT(DISTINCT(a.`id`))
       FROM `jos_community_events` AS a 
       LEFT JOIN `jos_community_groups` AS g
       ON g.`id` = a.`contentid`
       WHERE a.`published`='1'
       AND (g.`approvals` = '0' OR g.`approvals` IS NULL)
       AND a.`enddate` > '2019-10-22 16:19:43'
127. SELECT COUNT(DISTINCT(a.`id`))
       FROM `jos_community_events` AS a 
       LEFT JOIN `jos_community_groups` AS g
       ON g.`id` = a.`contentid`
       WHERE a.`published`='1' 
       AND (g.`approvals` = '0' OR g.`approvals` IS NULL)
       AND a.`enddate` > '2019-10-22 16:19:43'
128. SELECT `id`
       FROM `jos_menu`
       WHERE `link` LIKE '%option=com_community&view=events%'
       AND `published`='1'
       AND `menutype`!='jomsocial'
       AND `type`='component'
129. SELECT *
       FROM jos_community_events
       WHERE id = '1'
130. SELECT id
       FROM jos_core_acl_aro
       WHERE section_value='users'
       AND value='0'
131. SELECT m.*,n.`name`
       FROM `jos_community_blocklist` m
       LEFT JOIN `jos_users` n
       ON m.`blocked_userid`=n.`id`
       WHERE m.`userid`='0'
       AND m.`blocked_userid`!=0
132. SELECT a.*,  TO_DAYS('2019-10-22 23:19:43') -  TO_DAYS( DATE_ADD(a.`created`, INTERVAL 7 HOUR ) ) AS _daydiff
       FROM `jos_community_activities` AS a   
       WHERE  `archived`=0
       GROUP BY a.`id`
       ORDER BY a.`created` DESC
       LIMIT 240
133. SELECT a.* 
       FROM `jos_community_wall` AS a 
       WHERE  (  a.`type`='events'
       AND  a.`contentid` IN (76,75,74,73,72,71,70,69,68,67,66,65,64,63,62,61,60,59,58,57,56,55,54,52,53,51,50,49,48,47,46,45,44,43,42,41,40,39,38,37,36,35,34,33,32,31,30,29,28,27,26,25,24,23,22,21,20,19,18,17,16,15,14,13,12,11,10,9,8,6,7,5,4,3,2,1)  )  OR  (  a.`type`='profile.avatar.upload'
       AND  a.`contentid` IN (102,238,165,175)  )  OR  (  a.`type`='profile.status'
       AND  a.`contentid` IN (1131,1128,1127,1126,1125,1124,1123,1122,1121,1120,1119,1118,1117,1116,1115,1114,1113,1112,1111,1110,1109,1108,1107,1104,1103,1102,1101,1100,1099,1097,1059,1057,1056,1055,1054,1047,1029,991,608)  )  OR  (  a.`type`='videos'
       AND  a.`contentid` IN (122,121,120,118,117,116,115,114,113,112,111,110,109,108,107,106,105,104,103,102,101,100,99,98,97,96,95,94,93,91,90,89,88,87,86,85,84,83,82,81,80,79,78,77,76,75,74,73,72,71,70,69,68,67,66,65,64,63,62,61,60,59,58,57,56,55,54,53,52,51,50,49,48,47,46,45,44,43,42,41,39,36,32,28,27,24,21)  )  OR  (  a.`type`='photos.album'
       AND  a.`contentid` IN (17,15)  )  OR  (  a.`type`='photos.wall.create'
       AND  a.`contentid` IN (959,958,957,955,773,772,771,746,733)  ) 
       ORDER BY `id` DESC
134. SELECT a.* 
       FROM `jos_community_likes` AS a 
       WHERE  (  a.`element`='events'
       AND  a.`uid` IN (76,75,74,73,72,71,70,69,68,67,66,65,64,63,62,61,60,59,58,57,56,55,54,52,53,51,50,49,48,47,46,45,44,43,42,41,40,39,38,37,36,35,34,33,32,31,30,29,28,27,26,25,24,23,22,21,20,19,18,17,16,15,14,13,12,11,10,9,8,6,7,5,4,3,2,1)  )  OR  (  a.`element`='profile.avatar.upload'
       AND  a.`uid` IN (102,238,165,175)  )  OR  (  a.`element`='profile.status'
       AND  a.`uid` IN (1131,1128,1127,1126,1125,1124,1123,1122,1121,1120,1119,1118,1117,1116,1115,1114,1113,1112,1111,1110,1109,1108,1107,1104,1103,1102,1101,1100,1099,1097,1059,1057,1056,1055,1054,1047,1029,991,608)  )  OR  (  a.`element`='videos'
       AND  a.`uid` IN (122,121,120,118,117,116,115,114,113,112,111,110,109,108,107,106,105,104,103,102,101,100,99,98,97,96,95,94,93,91,90,89,88,87,86,85,84,83,82,81,80,79,78,77,76,75,74,73,72,71,70,69,68,67,66,65,64,63,62,61,60,59,58,57,56,55,54,53,52,51,50,49,48,47,46,45,44,43,42,41,39,36,32,28,27,24,21)  )  OR  (  a.`element`='photos.album'
       AND  a.`uid` IN (17,15)  )  OR  (  a.`element`='photos.wall.create'
       AND  a.`uid` IN (959,958,957,955,773,772,771,746,733)  )
135. 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 `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`='1852'
136. SELECT count(*) 
       FROM `jos_community_connection` AS a, `jos_users` AS b
       WHERE a.`connect_from`='1852'
       AND b.block=0 
       AND a.`status`='1'
       AND a.`connect_to`=b.`id`
       AND NOT EXISTS ( SELECT d.`blocked_userid`
       FROM `jos_community_blocklist` AS d
       WHERE d.`userid` = '1852'
       AND d.`blocked_userid` = a.`connect_to`) 
       ORDER BY a.`connection_id` DESC
137. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
138. SELECT *
       FROM jos_community_events
       WHERE id = '76'
139. SELECT *
       FROM jos_community_events
       WHERE id = '76'
140. 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 `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`='1817'
141. SELECT count(*) 
       FROM `jos_community_connection` AS a, `jos_users` AS b
       WHERE a.`connect_from`='1817'
       AND b.block=0 
       AND a.`status`='1'
       AND a.`connect_to`=b.`id`
       AND NOT EXISTS ( SELECT d.`blocked_userid`
       FROM `jos_community_blocklist` AS d
       WHERE d.`userid` = '1817'
       AND d.`blocked_userid` = a.`connect_to`) 
       ORDER BY a.`connection_id` DESC
142. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
143. SELECT *
       FROM jos_community_events
       WHERE id = '75'
144. SELECT *
       FROM jos_community_events
       WHERE id = '75'
145. 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 `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`='1796'
146. SELECT count(*) 
       FROM `jos_community_connection` AS a, `jos_users` AS b
       WHERE a.`connect_from`='1796'
       AND b.block=0 
       AND a.`status`='1'
       AND a.`connect_to`=b.`id`
       AND NOT EXISTS ( SELECT d.`blocked_userid`
       FROM `jos_community_blocklist` AS d
       WHERE d.`userid` = '1796'
       AND d.`blocked_userid` = a.`connect_to`) 
       ORDER BY a.`connection_id` DESC
147. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
148. SELECT *
       FROM jos_community_events
       WHERE id = '74'
149. SELECT *
       FROM jos_community_events
       WHERE id = '74'
150. 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 `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`='1789'
151. SELECT count(*) 
       FROM `jos_community_connection` AS a, `jos_users` AS b
       WHERE a.`connect_from`='1789'
       AND b.block=0 
       AND a.`status`='1'
       AND a.`connect_to`=b.`id`
       AND NOT EXISTS ( SELECT d.`blocked_userid`
       FROM `jos_community_blocklist` AS d
       WHERE d.`userid` = '1789'
       AND d.`blocked_userid` = a.`connect_to`) 
       ORDER BY a.`connection_id` DESC
152. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
153. SELECT *
       FROM jos_community_events
       WHERE id = '73'
154. SELECT *
       FROM jos_community_events
       WHERE id = '73'
155. 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 `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`='1793'
156. SELECT count(*) 
       FROM `jos_community_connection` AS a, `jos_users` AS b
       WHERE a.`connect_from`='1793'
       AND b.block=0 
       AND a.`status`='1'
       AND a.`connect_to`=b.`id`
       AND NOT EXISTS ( SELECT d.`blocked_userid`
       FROM `jos_community_blocklist` AS d
       WHERE d.`userid` = '1793'
       AND d.`blocked_userid` = a.`connect_to`) 
       ORDER BY a.`connection_id` DESC
157. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
158. SELECT *
       FROM jos_community_events
       WHERE id = '72'
159. SELECT *
       FROM jos_community_events
       WHERE id = '72'
160. 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 `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`='1788'
161. SELECT count(*) 
       FROM `jos_community_connection` AS a, `jos_users` AS b
       WHERE a.`connect_from`='1788'
       AND b.block=0 
       AND a.`status`='1'
       AND a.`connect_to`=b.`id`
       AND NOT EXISTS ( SELECT d.`blocked_userid`
       FROM `jos_community_blocklist` AS d
       WHERE d.`userid` = '1788'
       AND d.`blocked_userid` = a.`connect_to`) 
       ORDER BY a.`connection_id` DESC
162. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
163. SELECT *
       FROM jos_community_events
       WHERE id = '71'
164. SELECT *
       FROM jos_community_events
       WHERE id = '71'
165. 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 `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`='1791'
166. SELECT count(*) 
       FROM `jos_community_connection` AS a, `jos_users` AS b
       WHERE a.`connect_from`='1791'
       AND b.block=0 
       AND a.`status`='1'
       AND a.`connect_to`=b.`id`
       AND NOT EXISTS ( SELECT d.`blocked_userid`
       FROM `jos_community_blocklist` AS d
       WHERE d.`userid` = '1791'
       AND d.`blocked_userid` = a.`connect_to`) 
       ORDER BY a.`connection_id` DESC
167. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
168. SELECT *
       FROM jos_community_events
       WHERE id = '70'
169. SELECT *
       FROM jos_community_events
       WHERE id = '70'
170. 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 `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`='1794'
171. SELECT count(*) 
       FROM `jos_community_connection` AS a, `jos_users` AS b
       WHERE a.`connect_from`='1794'
       AND b.block=0 
       AND a.`status`='1'
       AND a.`connect_to`=b.`id`
       AND NOT EXISTS ( SELECT d.`blocked_userid`
       FROM `jos_community_blocklist` AS d
       WHERE d.`userid` = '1794'
       AND d.`blocked_userid` = a.`connect_to`) 
       ORDER BY a.`connection_id` DESC
172. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
173. SELECT *
       FROM jos_community_events
       WHERE id = '69'
174. SELECT *
       FROM jos_community_events
       WHERE id = '69'
175. 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 `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`='1795'
176. SELECT count(*) 
       FROM `jos_community_connection` AS a, `jos_users` AS b
       WHERE a.`connect_from`='1795'
       AND b.block=0 
       AND a.`status`='1'
       AND a.`connect_to`=b.`id`
       AND NOT EXISTS ( SELECT d.`blocked_userid`
       FROM `jos_community_blocklist` AS d
       WHERE d.`userid` = '1795'
       AND d.`blocked_userid` = a.`connect_to`) 
       ORDER BY a.`connection_id` DESC
177. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
178. SELECT *
       FROM jos_community_events
       WHERE id = '68'
179. SELECT *
       FROM jos_community_events
       WHERE id = '68'
180. 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 `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`='1784'
181. SELECT count(*) 
       FROM `jos_community_connection` AS a, `jos_users` AS b
       WHERE a.`connect_from`='1784'
       AND b.block=0 
       AND a.`status`='1'
       AND a.`connect_to`=b.`id`
       AND NOT EXISTS ( SELECT d.`blocked_userid`
       FROM `jos_community_blocklist` AS d
       WHERE d.`userid` = '1784'
       AND d.`blocked_userid` = a.`connect_to`) 
       ORDER BY a.`connection_id` DESC
182. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
183. SELECT *
       FROM jos_community_events
       WHERE id = '67'
184. SELECT *
       FROM jos_community_events
       WHERE id = '67'
185. 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 `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`='1787'
186. SELECT count(*) 
       FROM `jos_community_connection` AS a, `jos_users` AS b
       WHERE a.`connect_from`='1787'
       AND b.block=0 
       AND a.`status`='1'
       AND a.`connect_to`=b.`id`
       AND NOT EXISTS ( SELECT d.`blocked_userid`
       FROM `jos_community_blocklist` AS d
       WHERE d.`userid` = '1787'
       AND d.`blocked_userid` = a.`connect_to`) 
       ORDER BY a.`connection_id` DESC
187. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
188. SELECT *
       FROM jos_community_events
       WHERE id = '66'
189. SELECT *
       FROM jos_community_events
       WHERE id = '66'
190. 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 `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`='1792'
191. SELECT count(*) 
       FROM `jos_community_connection` AS a, `jos_users` AS b
       WHERE a.`connect_from`='1792'
       AND b.block=0 
       AND a.`status`='1'
       AND a.`connect_to`=b.`id`
       AND NOT EXISTS ( SELECT d.`blocked_userid`
       FROM `jos_community_blocklist` AS d
       WHERE d.`userid` = '1792'
       AND d.`blocked_userid` = a.`connect_to`) 
       ORDER BY a.`connection_id` DESC
192. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
193. SELECT *
       FROM jos_community_events
       WHERE id = '65'
194. SELECT *
       FROM jos_community_events
       WHERE id = '65'
195. 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 `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`='1790'
196. SELECT count(*) 
       FROM `jos_community_connection` AS a, `jos_users` AS b
       WHERE a.`connect_from`='1790'
       AND b.block=0 
       AND a.`status`='1'
       AND a.`connect_to`=b.`id`
       AND NOT EXISTS ( SELECT d.`blocked_userid`
       FROM `jos_community_blocklist` AS d
       WHERE d.`userid` = '1790'
       AND d.`blocked_userid` = a.`connect_to`) 
       ORDER BY a.`connection_id` DESC
197. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
198. SELECT *
       FROM jos_community_events
       WHERE id = '64'
199. SELECT *
       FROM jos_community_events
       WHERE id = '64'
200. 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 `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`='1779'
201. SELECT count(*) 
       FROM `jos_community_connection` AS a, `jos_users` AS b
       WHERE a.`connect_from`='1779'
       AND b.block=0 
       AND a.`status`='1'
       AND a.`connect_to`=b.`id`
       AND NOT EXISTS ( SELECT d.`blocked_userid`
       FROM `jos_community_blocklist` AS d
       WHERE d.`userid` = '1779'
       AND d.`blocked_userid` = a.`connect_to`) 
       ORDER BY a.`connection_id` DESC
202. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
203. SELECT *
       FROM jos_community_events
       WHERE id = '63'
204. SELECT *
       FROM jos_community_events
       WHERE id = '63'
205. 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 `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`='1786'
206. SELECT count(*) 
       FROM `jos_community_connection` AS a, `jos_users` AS b
       WHERE a.`connect_from`='1786'
       AND b.block=0 
       AND a.`status`='1'
       AND a.`connect_to`=b.`id`
       AND NOT EXISTS ( SELECT d.`blocked_userid`
       FROM `jos_community_blocklist` AS d
       WHERE d.`userid` = '1786'
       AND d.`blocked_userid` = a.`connect_to`) 
       ORDER BY a.`connection_id` DESC
207. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
208. SELECT *
       FROM jos_community_events
       WHERE id = '62'
209. SELECT *
       FROM jos_community_events
       WHERE id = '62'
210. 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 `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`='1782'
211. SELECT count(*) 
       FROM `jos_community_connection` AS a, `jos_users` AS b
       WHERE a.`connect_from`='1782'
       AND b.block=0 
       AND a.`status`='1'
       AND a.`connect_to`=b.`id`
       AND NOT EXISTS ( SELECT d.`blocked_userid`
       FROM `jos_community_blocklist` AS d
       WHERE d.`userid` = '1782'
       AND d.`blocked_userid` = a.`connect_to`) 
       ORDER BY a.`connection_id` DESC
212. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
213. SELECT *
       FROM jos_community_events
       WHERE id = '61'
214. SELECT *
       FROM jos_community_events
       WHERE id = '61'
215. 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 `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`='1781'
216. SELECT count(*) 
       FROM `jos_community_connection` AS a, `jos_users` AS b
       WHERE a.`connect_from`='1781'
       AND b.block=0 
       AND a.`status`='1'
       AND a.`connect_to`=b.`id`
       AND NOT EXISTS ( SELECT d.`blocked_userid`
       FROM `jos_community_blocklist` AS d
       WHERE d.`userid` = '1781'
       AND d.`blocked_userid` = a.`connect_to`) 
       ORDER BY a.`connection_id` DESC
217. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
218. SELECT *
       FROM jos_community_events
       WHERE id = '60'
219. SELECT *
       FROM jos_community_events
       WHERE id = '60'
220. 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 `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`='1797'
221. SELECT count(*) 
       FROM `jos_community_connection` AS a, `jos_users` AS b
       WHERE a.`connect_from`='1797'
       AND b.block=0 
       AND a.`status`='1'
       AND a.`connect_to`=b.`id`
       AND NOT EXISTS ( SELECT d.`blocked_userid`
       FROM `jos_community_blocklist` AS d
       WHERE d.`userid` = '1797'
       AND d.`blocked_userid` = a.`connect_to`) 
       ORDER BY a.`connection_id` DESC
222. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
223. SELECT *
       FROM jos_community_events
       WHERE id = '59'
224. SELECT *
       FROM jos_community_events
       WHERE id = '59'
225. 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 `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`='1783'
226. SELECT count(*) 
       FROM `jos_community_connection` AS a, `jos_users` AS b
       WHERE a.`connect_from`='1783'
       AND b.block=0 
       AND a.`status`='1'
       AND a.`connect_to`=b.`id`
       AND NOT EXISTS ( SELECT d.`blocked_userid`
       FROM `jos_community_blocklist` AS d
       WHERE d.`userid` = '1783'
       AND d.`blocked_userid` = a.`connect_to`) 
       ORDER BY a.`connection_id` DESC
227. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
228. SELECT *
       FROM jos_community_events
       WHERE id = '58'
229. SELECT *
       FROM jos_community_events
       WHERE id = '58'
230. 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 `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`='1780'
231. SELECT count(*) 
       FROM `jos_community_connection` AS a, `jos_users` AS b
       WHERE a.`connect_from`='1780'
       AND b.block=0 
       AND a.`status`='1'
       AND a.`connect_to`=b.`id`
       AND NOT EXISTS ( SELECT d.`blocked_userid`
       FROM `jos_community_blocklist` AS d
       WHERE d.`userid` = '1780'
       AND d.`blocked_userid` = a.`connect_to`) 
       ORDER BY a.`connection_id` DESC
232. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
233. SELECT *
       FROM jos_community_events
       WHERE id = '57'
234. SELECT *
       FROM jos_community_events
       WHERE id = '57'
235. 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 `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`='1785'
236. SELECT count(*) 
       FROM `jos_community_connection` AS a, `jos_users` AS b
       WHERE a.`connect_from`='1785'
       AND b.block=0 
       AND a.`status`='1'
       AND a.`connect_to`=b.`id`
       AND NOT EXISTS ( SELECT d.`blocked_userid`
       FROM `jos_community_blocklist` AS d
       WHERE d.`userid` = '1785'
       AND d.`blocked_userid` = a.`connect_to`) 
       ORDER BY a.`connection_id` DESC
237. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
238. SELECT *
       FROM jos_community_events
       WHERE id = '56'
239. SELECT *
       FROM jos_community_events
       WHERE id = '56'
240. 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 `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`='1777'
241. SELECT count(*) 
       FROM `jos_community_connection` AS a, `jos_users` AS b
       WHERE a.`connect_from`='1777'
       AND b.block=0 
       AND a.`status`='1'
       AND a.`connect_to`=b.`id`
       AND NOT EXISTS ( SELECT d.`blocked_userid`
       FROM `jos_community_blocklist` AS d
       WHERE d.`userid` = '1777'
       AND d.`blocked_userid` = a.`connect_to`) 
       ORDER BY a.`connection_id` DESC
242. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
243. SELECT *
       FROM jos_community_events
       WHERE id = '55'
244. SELECT *
       FROM jos_community_events
       WHERE id = '55'
245. 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 `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`='1773'
246. SELECT count(*) 
       FROM `jos_community_connection` AS a, `jos_users` AS b
       WHERE a.`connect_from`='1773'
       AND b.block=0 
       AND a.`status`='1'
       AND a.`connect_to`=b.`id`
       AND NOT EXISTS ( SELECT d.`blocked_userid`
       FROM `jos_community_blocklist` AS d
       WHERE d.`userid` = '1773'
       AND d.`blocked_userid` = a.`connect_to`) 
       ORDER BY a.`connection_id` DESC
247. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
248. SELECT *
       FROM jos_community_events
       WHERE id = '54'
249. SELECT *
       FROM jos_community_events
       WHERE id = '54'
250. 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 `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`='1771'
251. SELECT count(*) 
       FROM `jos_community_connection` AS a, `jos_users` AS b
       WHERE a.`connect_from`='1771'
       AND b.block=0 
       AND a.`status`='1'
       AND a.`connect_to`=b.`id`
       AND NOT EXISTS ( SELECT d.`blocked_userid`
       FROM `jos_community_blocklist` AS d
       WHERE d.`userid` = '1771'
       AND d.`blocked_userid` = a.`connect_to`) 
       ORDER BY a.`connection_id` DESC
252. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
253. SELECT *
       FROM jos_community_events
       WHERE id = '52'
254. SELECT *
       FROM jos_community_events
       WHERE id = '52'
255. 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 `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`='1772'
256. SELECT count(*) 
       FROM `jos_community_connection` AS a, `jos_users` AS b
       WHERE a.`connect_from`='1772'
       AND b.block=0 
       AND a.`status`='1'
       AND a.`connect_to`=b.`id`
       AND NOT EXISTS ( SELECT d.`blocked_userid`
       FROM `jos_community_blocklist` AS d
       WHERE d.`userid` = '1772'
       AND d.`blocked_userid` = a.`connect_to`) 
       ORDER BY a.`connection_id` DESC
257. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
258. SELECT *
       FROM jos_community_events
       WHERE id = '53'
259. SELECT *
       FROM jos_community_events
       WHERE id = '53'
260. 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 `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`='1766'
261. SELECT count(*) 
       FROM `jos_community_connection` AS a, `jos_users` AS b
       WHERE a.`connect_from`='1766'
       AND b.block=0 
       AND a.`status`='1'
       AND a.`connect_to`=b.`id`
       AND NOT EXISTS ( SELECT d.`blocked_userid`
       FROM `jos_community_blocklist` AS d
       WHERE d.`userid` = '1766'
       AND d.`blocked_userid` = a.`connect_to`) 
       ORDER BY a.`connection_id` DESC
262. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
263. SELECT *
       FROM jos_community_events
       WHERE id = '51'
264. SELECT *
       FROM jos_community_events
       WHERE id = '51'
265. 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 `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`='1765'
266. SELECT count(*) 
       FROM `jos_community_connection` AS a, `jos_users` AS b
       WHERE a.`connect_from`='1765'
       AND b.block=0 
       AND a.`status`='1'
       AND a.`connect_to`=b.`id`
       AND NOT EXISTS ( SELECT d.`blocked_userid`
       FROM `jos_community_blocklist` AS d
       WHERE d.`userid` = '1765'
       AND d.`blocked_userid` = a.`connect_to`) 
       ORDER BY a.`connection_id` DESC
267. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
268. SELECT *
       FROM jos_community_events
       WHERE id = '50'
269. SELECT *
       FROM jos_community_events
       WHERE id = '50'
270. 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 `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`='1767'
271. SELECT count(*) 
       FROM `jos_community_connection` AS a, `jos_users` AS b
       WHERE a.`connect_from`='1767'
       AND b.block=0 
       AND a.`status`='1'
       AND a.`connect_to`=b.`id`
       AND NOT EXISTS ( SELECT d.`blocked_userid`
       FROM `jos_community_blocklist` AS d
       WHERE d.`userid` = '1767'
       AND d.`blocked_userid` = a.`connect_to`) 
       ORDER BY a.`connection_id` DESC
272. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
273. SELECT *
       FROM jos_community_events
       WHERE id = '49'
274. SELECT *
       FROM jos_community_events
       WHERE id = '49'
275. 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 `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`='1769'
276. SELECT count(*) 
       FROM `jos_community_connection` AS a, `jos_users` AS b
       WHERE a.`connect_from`='1769'
       AND b.block=0 
       AND a.`status`='1'
       AND a.`connect_to`=b.`id`
       AND NOT EXISTS ( SELECT d.`blocked_userid`
       FROM `jos_community_blocklist` AS d
       WHERE d.`userid` = '1769'
       AND d.`blocked_userid` = a.`connect_to`) 
       ORDER BY a.`connection_id` DESC
277. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
278. SELECT *
       FROM jos_community_events
       WHERE id = '48'
279. SELECT *
       FROM jos_community_events
       WHERE id = '48'
280. SELECT COUNT(1)
       FROM `jos_community_activities`
281. SELECT COUNT(1)
       FROM `jos_community_activities`
282. SELECT DISTINCT(a.`id`)
       FROM `jos_users` AS a 
       INNER JOIN `jos_session` AS b 
       ON a.`id`=b.`userid`
       WHERE a.`block`='0'
       AND `client_id` != '1'
       ORDER BY b.`time` DESC
       LIMIT 20
283. SELECT id
       FROM jos_core_acl_aro
       WHERE section_value='users'
       AND value='0'
284. SELECT p.*, l.country,
                                             CASE WHEN CHAR_LENGTH( p.alias )
                                             THEN CONCAT_WS( ':', p.id, p.alias )
                                             ELSE p.id
                                             END AS slug
                                            
       FROM jos_joomleague_project AS p
                                            
       LEFT JOIN jos_joomleague_league AS l
       ON p.league_id = l.id
                                            
       WHERE p.id='20'
       LIMIT 0, 1
285. SELECT extension
       FROM jos_joomleague_project
       WHERE id='20'
286. SELECT t.params
                                       
       FROM jos_joomleague_template_config AS t
                                       
       INNER JOIN jos_joomleague_project AS p
       ON p.id=t.project_id
                                       
       WHERE t.template='ranking'
                                       
       AND p.id='20'
287. SELECT t.params
                                       
       FROM jos_joomleague_template_config AS t
                                       
       INNER JOIN jos_joomleague_project AS p
       ON p.id=t.project_id
                                       
       WHERE t.template='ranking'
                                       
       AND p.id='20'
288. SELECT p.*, l.country,
                                             CASE WHEN CHAR_LENGTH( p.alias )
                                             THEN CONCAT_WS( ':', p.id, p.alias )
                                             ELSE p.id
                                             END AS slug
                                            
       FROM jos_joomleague_project AS p
                                            
       LEFT JOIN jos_joomleague_league AS l
       ON p.league_id = l.id
                                            
       WHERE p.id='20'
       LIMIT 0, 1
289. SELECT  tl.id AS projectteamid,
                                                                     tl.division_id,
                                                                     tl.standard_playground,
                                                                     tl.admin,
                                                                     tl.start_points,
                                                                     tl.points_finally,
                                                                     tl.neg_points_finally,
                                                                     tl.matches_finally,
                                                                     tl.won_finally,
                                                                     tl.draws_finally,
                                                                     tl.lost_finally,
                                                                     tl.homegoals_finally,
                                                                     tl.guestgoals_finally,
                                                                     tl.diffgoals_finally,
                                                                     tl.info,
                                                                     tl.reason,
                                                                     tl.team_id,
                                                                     tl.checked_out,
                                                                     tl.checked_out_time,
                                                                     tl.is_in_score,
                                                                     tl.picture AS projectteam_picture,
                                                                     t.picture AS team_picture,
                                                                     IF((ISNULL(tl.picture) OR (tl.picture="")),
                                                                             (IF((ISNULL(t.picture) OR (t.picture="")), c.logo_small , t.picture)) , t.picture) AS picture,
                                                                     tl.project_id,
     
                                                                     t.id,t.name,
                                                                     t.short_name,
                                                                     t.middle_name,
                                                                     t.notes,
                                                                     t.club_id,
     
                                                                     u.username,
                                                                     u.email,
     
                                                                     c.email AS club_email,
                                                                     c.logo_small,
                                                                     c.logo_middle,
                                                                     c.logo_big,
                                                                     c.country,
                                                                     c.website,
     
                                                                     d.name AS division_name,
                                                                     d.shortname AS division_shortname,
                                                                     d.parent_id AS parent_division_id,
     
                                                                     plg.name AS playground_name,
                                                                     plg.short_name AS playground_short_name,
     
                                                                     CASE WHEN CHAR_LENGTH(p.alias) THEN CONCAT_WS(':',p.id,p.alias) ELSE p.id END AS project_slug,
                                                                     CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':',t.id,t.alias) ELSE t.id END AS team_slug,
                                                                     CASE WHEN CHAR_LENGTH(d.alias) THEN CONCAT_WS(':',d.id,d.alias) ELSE d.id END AS division_slug,
                                                                     CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':',c.id,c.alias) ELSE c.id END AS club_slug
     
                                                    
       FROM jos_joomleague_project_team tl
                                                            
       LEFT JOIN jos_joomleague_team t
       ON tl.team_id=t.id
                                                            
       LEFT JOIN jos_users u
       ON tl.admin=u.id
                                                            
       LEFT JOIN jos_joomleague_club c
       ON t.club_id=c.id
                                                            
       LEFT JOIN jos_joomleague_division d
       ON d.id=tl.division_id
                                                            
       LEFT JOIN jos_joomleague_playground plg
       ON plg.id=tl.standard_playground
                                                            
       LEFT JOIN jos_joomleague_project AS p
       ON p.id=tl.project_id
     
                                                    
       WHERE tl.project_id=20
290. SELECT p.*, l.country,
                                             CASE WHEN CHAR_LENGTH( p.alias )
                                             THEN CONCAT_WS( ':', p.id, p.alias )
                                             ELSE p.id
                                             END AS slug
                                            
       FROM jos_joomleague_project AS p
                                            
       LEFT JOIN jos_joomleague_league AS l
       ON p.league_id = l.id
                                            
       WHERE p.id='20:-'
       LIMIT 0, 1
291. SELECT r.id, r.roundcode
       FROM jos_joomleague_round AS r
                                                             
       WHERE r.id =161
292. SELECT *
       FROM jos_joomleague_round 
       WHERE id = '161'   
       AND project_id = '20'
293. SELECT  m.*,
                             DATE_FORMAT(m.time_present,"%H:%i") time_present,
                             playground.name AS playground_name,
                             playground.short_name AS playground_short_name,
                             tt1.project_id, d1.name AS divhome, d2.name AS divaway,
                             CASE WHEN CHAR_LENGTH(t1.alias)
       AND CHAR_LENGTH(t2.alias) THEN CONCAT_WS(':',m.id,CONCAT_WS("_",t1.alias,t2.alias)) ELSE m.id END AS slug
                    
       FROM jos_joomleague_match AS m
                            
       INNER JOIN jos_joomleague_round AS r
       ON m.round_id=r.id
                            
       LEFT JOIN jos_joomleague_project_team AS tt1
       ON m.projectteam1_id=tt1.id
                            
       LEFT JOIN jos_joomleague_project_team AS tt2
       ON m.projectteam2_id=tt2.id
                            
       LEFT JOIN jos_joomleague_team AS t1
       ON t1.id=tt1.team_id
                            
       LEFT JOIN jos_joomleague_team AS t2
       ON t2.id=tt2.team_id
                            
       LEFT JOIN jos_joomleague_division AS d1
       ON tt1.division_id=d1.id
                            
       LEFT JOIN jos_joomleague_division AS d2
       ON tt2.division_id=d2.id
                            
       LEFT JOIN jos_joomleague_playground AS playground
       ON playground.id=m.playground_id
       WHERE m.published=1
                                                               
       AND r.id=161
                                                               
       AND r.project_id=20
       GROUP BY m.id
       ORDER BY m.match_date ASC,m.match_number
294. SELECT COUNT(*)
       FROM jos_joomleague_match AS m 
       INNER JOIN jos_joomleague_project_team AS tt1
       ON m.projectteam1_id=tt1.id 
       INNER JOIN jos_joomleague_project_team AS tt2
       ON m.projectteam2_id=tt2.id 
       WHERE m.id=595
       AND (tt1.admin=0 OR tt2.admin=0)
295. SELECT COUNT(*)
       FROM jos_joomleague_match AS m 
       INNER JOIN jos_joomleague_project_team AS tt1
       ON m.projectteam1_id=tt1.id 
       INNER JOIN jos_joomleague_project_team AS tt2
       ON m.projectteam2_id=tt2.id 
       WHERE m.id=596
       AND (tt1.admin=0 OR tt2.admin=0)
296. SELECT  tl.id AS projectteamid,
                                                                     tl.division_id,
                                                                     tl.standard_playground,
                                                                     tl.admin,
                                                                     tl.start_points,
                                                                     tl.points_finally,
                                                                     tl.neg_points_finally,
                                                                     tl.matches_finally,
                                                                     tl.won_finally,
                                                                     tl.draws_finally,
                                                                     tl.lost_finally,
                                                                     tl.homegoals_finally,
                                                                     tl.guestgoals_finally,
                                                                     tl.diffgoals_finally,
                                                                     tl.info,
                                                                     tl.reason,
                                                                     tl.team_id,
                                                                     tl.checked_out,
                                                                     tl.checked_out_time,
                                                                     tl.is_in_score,
                                                                     tl.picture AS projectteam_picture,
                                                                     t.picture AS team_picture,
                                                                     IF((ISNULL(tl.picture) OR (tl.picture="")),
                                                                             (IF((ISNULL(t.picture) OR (t.picture="")), c.logo_small , t.picture)) , t.picture) AS picture,
                                                                     tl.project_id,
     
                                                                     t.id,t.name,
                                                                     t.short_name,
                                                                     t.middle_name,
                                                                     t.notes,
                                                                     t.club_id,
     
                                                                     u.username,
                                                                     u.email,
     
                                                                     c.email AS club_email,
                                                                     c.logo_small,
                                                                     c.logo_middle,
                                                                     c.logo_big,
                                                                     c.country,
                                                                     c.website,
     
                                                                     d.name AS division_name,
                                                                     d.shortname AS division_shortname,
                                                                     d.parent_id AS parent_division_id,
     
                                                                     plg.name AS playground_name,
                                                                     plg.short_name AS playground_short_name,
     
                                                                     CASE WHEN CHAR_LENGTH(p.alias) THEN CONCAT_WS(':',p.id,p.alias) ELSE p.id END AS project_slug,
                                                                     CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':',t.id,t.alias) ELSE t.id END AS team_slug,
                                                                     CASE WHEN CHAR_LENGTH(d.alias) THEN CONCAT_WS(':',d.id,d.alias) ELSE d.id END AS division_slug,
                                                                     CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':',c.id,c.alias) ELSE c.id END AS club_slug
     
                                                    
       FROM jos_joomleague_project_team tl
                                                            
       LEFT JOIN jos_joomleague_team t
       ON tl.team_id=t.id
                                                            
       LEFT JOIN jos_users u
       ON tl.admin=u.id
                                                            
       LEFT JOIN jos_joomleague_club c
       ON t.club_id=c.id
                                                            
       LEFT JOIN jos_joomleague_division d
       ON d.id=tl.division_id
                                                            
       LEFT JOIN jos_joomleague_playground plg
       ON plg.id=tl.standard_playground
                                                            
       LEFT JOIN jos_joomleague_project AS p
       ON p.id=tl.project_id
     
                                                    
       WHERE tl.project_id=20
297. SELECT p.*, l.country,
                                             CASE WHEN CHAR_LENGTH( p.alias )
                                             THEN CONCAT_WS( ':', p.id, p.alias )
                                             ELSE p.id
                                             END AS slug
                                            
       FROM jos_joomleague_project AS p
                                            
       LEFT JOIN jos_joomleague_league AS l
       ON p.league_id = l.id
                                            
       WHERE p.id='20:-'
       LIMIT 0, 1
298. SELECT r.id, r.roundcode
       FROM jos_joomleague_round AS r
                                                             
       WHERE r.id =161
299. SELECT *
       FROM jos_joomleague_round 
       WHERE id = '161'   
       AND project_id = '20'
300. SELECT  m.*,
                             DATE_FORMAT(m.time_present,"%H:%i") time_present,
                             playground.name AS playground_name,
                             playground.short_name AS playground_short_name,
                             tt1.project_id, d1.name AS divhome, d2.name AS divaway,
                             CASE WHEN CHAR_LENGTH(t1.alias)
       AND CHAR_LENGTH(t2.alias) THEN CONCAT_WS(':',m.id,CONCAT_WS("_",t1.alias,t2.alias)) ELSE m.id END AS slug
                    
       FROM jos_joomleague_match AS m
                            
       INNER JOIN jos_joomleague_round AS r
       ON m.round_id=r.id
                            
       LEFT JOIN jos_joomleague_project_team AS tt1
       ON m.projectteam1_id=tt1.id
                            
       LEFT JOIN jos_joomleague_project_team AS tt2
       ON m.projectteam2_id=tt2.id
                            
       LEFT JOIN jos_joomleague_team AS t1
       ON t1.id=tt1.team_id
                            
       LEFT JOIN jos_joomleague_team AS t2
       ON t2.id=tt2.team_id
                            
       LEFT JOIN jos_joomleague_division AS d1
       ON tt1.division_id=d1.id
                            
       LEFT JOIN jos_joomleague_division AS d2
       ON tt2.division_id=d2.id
                            
       LEFT JOIN jos_joomleague_playground AS playground
       ON playground.id=m.playground_id
       WHERE m.published=1
                                                               
       AND r.id=161
                                                               
       AND r.project_id=20
       GROUP BY m.id
       ORDER BY m.match_date ASC,m.match_number
301. SELECT COUNT(*)
       FROM jos_joomleague_match AS m 
       INNER JOIN jos_joomleague_project_team AS tt1
       ON m.projectteam1_id=tt1.id 
       INNER JOIN jos_joomleague_project_team AS tt2
       ON m.projectteam2_id=tt2.id 
       WHERE m.id=595
       AND (tt1.admin=0 OR tt2.admin=0)
302. SELECT COUNT(*)
       FROM jos_joomleague_match AS m 
       INNER JOIN jos_joomleague_project_team AS tt1
       ON m.projectteam1_id=tt1.id 
       INNER JOIN jos_joomleague_project_team AS tt2
       ON m.projectteam2_id=tt2.id 
       WHERE m.id=596
       AND (tt1.admin=0 OR tt2.admin=0)
303. SELECT  tl.id AS projectteamid,
                                                                     tl.division_id,
                                                                     tl.standard_playground,
                                                                     tl.admin,
                                                                     tl.start_points,
                                                                     tl.points_finally,
                                                                     tl.neg_points_finally,
                                                                     tl.matches_finally,
                                                                     tl.won_finally,
                                                                     tl.draws_finally,
                                                                     tl.lost_finally,
                                                                     tl.homegoals_finally,
                                                                     tl.guestgoals_finally,
                                                                     tl.diffgoals_finally,
                                                                     tl.info,
                                                                     tl.reason,
                                                                     tl.team_id,
                                                                     tl.checked_out,
                                                                     tl.checked_out_time,
                                                                     tl.is_in_score,
                                                                     tl.picture AS projectteam_picture,
                                                                     t.picture AS team_picture,
                                                                     IF((ISNULL(tl.picture) OR (tl.picture="")),
                                                                             (IF((ISNULL(t.picture) OR (t.picture="")), c.logo_small , t.picture)) , t.picture) AS picture,
                                                                     tl.project_id,
     
                                                                     t.id,t.name,
                                                                     t.short_name,
                                                                     t.middle_name,
                                                                     t.notes,
                                                                     t.club_id,
     
                                                                     u.username,
                                                                     u.email,
     
                                                                     c.email AS club_email,
                                                                     c.logo_small,
                                                                     c.logo_middle,
                                                                     c.logo_big,
                                                                     c.country,
                                                                     c.website,
     
                                                                     d.name AS division_name,
                                                                     d.shortname AS division_shortname,
                                                                     d.parent_id AS parent_division_id,
     
                                                                     plg.name AS playground_name,
                                                                     plg.short_name AS playground_short_name,
     
                                                                     CASE WHEN CHAR_LENGTH(p.alias) THEN CONCAT_WS(':',p.id,p.alias) ELSE p.id END AS project_slug,
                                                                     CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':',t.id,t.alias) ELSE t.id END AS team_slug,
                                                                     CASE WHEN CHAR_LENGTH(d.alias) THEN CONCAT_WS(':',d.id,d.alias) ELSE d.id END AS division_slug,
                                                                     CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':',c.id,c.alias) ELSE c.id END AS club_slug
     
                                                    
       FROM jos_joomleague_project_team tl
                                                            
       LEFT JOIN jos_joomleague_team t
       ON tl.team_id=t.id
                                                            
       LEFT JOIN jos_users u
       ON tl.admin=u.id
                                                            
       LEFT JOIN jos_joomleague_club c
       ON t.club_id=c.id
                                                            
       LEFT JOIN jos_joomleague_division d
       ON d.id=tl.division_id
                                                            
       LEFT JOIN jos_joomleague_playground plg
       ON plg.id=tl.standard_playground
                                                            
       LEFT JOIN jos_joomleague_project AS p
       ON p.id=tl.project_id
     
                                                    
       WHERE tl.project_id=20
304. SELECT params
       FROM jos_advancedmodules
       WHERE moduleid = 17
305. SELECT time, visits, guests, members, bots 
       FROM jos_vvcounter_logs 
       WHERE '1=1' 
       AND time > 1571677200
306. SELECT session_id, time, guest, DATA 
       FROM jos_session 
       WHERE '1=1' 
       AND time >= 1571760913
307. SELECT time, visits, guests, members, bots 
       FROM jos_vvcounter_logs 
       WHERE '1=1' 
       AND time <= 1571677200
308. SELECT time, visits, guests, members, bots 
       FROM jos_vvcounter_logs 
       WHERE '1=1' 
       AND time > 1571590800 
       AND time <= 1571677200
309. SELECT time, visits, guests, members, bots 
       FROM jos_vvcounter_logs 
       WHERE '1=1' 
       AND time > 1571504400 
       AND time <= 1571677200
310. SELECT time, visits, guests, members, bots 
       FROM jos_vvcounter_logs 
       WHERE '1=1' 
       AND time > 1570899600 
       AND time <= 1571504400
311. SELECT time, visits, guests, members, bots 
       FROM jos_vvcounter_logs 
       WHERE '1=1' 
       AND time > 1569862800 
       AND time <= 1571677200
312. SELECT time, visits, guests, members, bots 
       FROM jos_vvcounter_logs 
       WHERE '1=1' 
       AND time > 1567270800 
       AND time <= 1569862800
313. SELECT bid, imageurl, custombannercode
       FROM jos_banner
       WHERE showBanner = '1'
       AND (bid IN (13))
       ORDER BY bid