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

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

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

1. SELECT *
     FROM jos_session
     WHERE session_id = '5986d689c782dc3c7f0b4f588dc88d32'
2. DELETE
     FROM jos_session
     WHERE ( time < '1566338937' )
3. SELECT *
     FROM jos_session
     WHERE session_id = '5986d689c782dc3c7f0b4f588dc88d32'
4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( '5986d689c782dc3c7f0b4f588dc88d32','1566362937','','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`='1935'
      ORDER BY `posted_on` DESC
      LIMIT 1
55. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1928'
      ORDER BY `posted_on` DESC
      LIMIT 1
56. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1940'
      ORDER BY `posted_on` DESC
      LIMIT 1
57. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1938'
      ORDER BY `posted_on` DESC
      LIMIT 1
58. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1918'
      ORDER BY `posted_on` DESC
      LIMIT 1
59. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1912'
      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`='1932'
      ORDER BY `posted_on` DESC
      LIMIT 1
62. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1914'
      ORDER BY `posted_on` DESC
      LIMIT 1
63. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1919'
      ORDER BY `posted_on` DESC
      LIMIT 1
64. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1941'
      ORDER BY `posted_on` DESC
      LIMIT 1
65. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1929'
      ORDER BY `posted_on` DESC
      LIMIT 1
66. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1911'
      ORDER BY `posted_on` DESC
      LIMIT 1
67. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1922'
      ORDER BY `posted_on` DESC
      LIMIT 1
68. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1913'
      ORDER BY `posted_on` DESC
      LIMIT 1
69. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1920'
      ORDER BY `posted_on` DESC
      LIMIT 1
70. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1931'
      ORDER BY `posted_on` DESC
      LIMIT 1
71. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1926'
      ORDER BY `posted_on` DESC
      LIMIT 1
72. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1934'
      ORDER BY `posted_on` DESC
      LIMIT 1
73. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1937'
      ORDER BY `posted_on` DESC
      LIMIT 1
74. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1936'
      ORDER BY `posted_on` DESC
      LIMIT 1
75. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1923'
      ORDER BY `posted_on` DESC
      LIMIT 1
76. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1916'
      ORDER BY `posted_on` DESC
      LIMIT 1
77. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1930'
      ORDER BY `posted_on` DESC
      LIMIT 1
78. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1927'
      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`='1933'
      ORDER BY `posted_on` DESC
      LIMIT 1
81. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1924'
      ORDER BY `posted_on` DESC
      LIMIT 1
82. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1917'
      ORDER BY `posted_on` DESC
      LIMIT 1
83. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1915'
      ORDER BY `posted_on` DESC
      LIMIT 1
84. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1942'
      ORDER BY `posted_on` DESC
      LIMIT 1
85. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1939'
      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`='126'
111. 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
112. SELECT *
       FROM jos_community_videos
       WHERE id = '117'
113. SELECT *
       FROM jos_community_videos
       WHERE id = '118'
114. SELECT *
       FROM jos_community_videos
       WHERE id = '120'
115. 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
116. 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'
117. 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
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`='123'
121. 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
122. SELECT `id`
       FROM `jos_menu`
       WHERE `link` LIKE '%option=com_community&view=photos%'
       AND `published`='1'
       AND `menutype`!='jomsocial'
       AND `type`='component'
123. 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-08-21 04:48:57'
       ORDER BY a.`startdate` ASC
       LIMIT 0, 5
124. 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-08-21 04:48:57'
125. 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-08-21 04:48:57'
126. SELECT `id`
       FROM `jos_menu`
       WHERE `link` LIKE '%option=com_community&view=events%'
       AND `published`='1'
       AND `menutype`!='jomsocial'
       AND `type`='component'
127. SELECT *
       FROM jos_community_events
       WHERE id = '1'
128. SELECT id
       FROM jos_core_acl_aro
       WHERE section_value='users'
       AND value='0'
129. 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
130. SELECT a.*,  TO_DAYS('2019-08-21 11:48:57') -  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
131. 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
132. 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)  )
133. 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'
134. 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
135. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
136. SELECT *
       FROM jos_community_events
       WHERE id = '76'
137. SELECT *
       FROM jos_community_events
       WHERE id = '76'
138. 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'
139. 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
140. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
141. SELECT *
       FROM jos_community_events
       WHERE id = '75'
142. SELECT *
       FROM jos_community_events
       WHERE id = '75'
143. 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'
144. 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
145. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
146. SELECT *
       FROM jos_community_events
       WHERE id = '74'
147. SELECT *
       FROM jos_community_events
       WHERE id = '74'
148. 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'
149. 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
150. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
151. SELECT *
       FROM jos_community_events
       WHERE id = '73'
152. SELECT *
       FROM jos_community_events
       WHERE id = '73'
153. 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'
154. 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
155. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
156. SELECT *
       FROM jos_community_events
       WHERE id = '72'
157. SELECT *
       FROM jos_community_events
       WHERE id = '72'
158. 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'
159. 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
160. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
161. SELECT *
       FROM jos_community_events
       WHERE id = '71'
162. SELECT *
       FROM jos_community_events
       WHERE id = '71'
163. 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'
164. 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
165. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
166. SELECT *
       FROM jos_community_events
       WHERE id = '70'
167. SELECT *
       FROM jos_community_events
       WHERE id = '70'
168. 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'
169. 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
170. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
171. SELECT *
       FROM jos_community_events
       WHERE id = '69'
172. SELECT *
       FROM jos_community_events
       WHERE id = '69'
173. 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'
174. 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
175. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
176. SELECT *
       FROM jos_community_events
       WHERE id = '68'
177. SELECT *
       FROM jos_community_events
       WHERE id = '68'
178. 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'
179. 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
180. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
181. SELECT *
       FROM jos_community_events
       WHERE id = '67'
182. SELECT *
       FROM jos_community_events
       WHERE id = '67'
183. 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'
184. 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
185. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
186. SELECT *
       FROM jos_community_events
       WHERE id = '66'
187. SELECT *
       FROM jos_community_events
       WHERE id = '66'
188. 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'
189. 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
190. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
191. SELECT *
       FROM jos_community_events
       WHERE id = '65'
192. SELECT *
       FROM jos_community_events
       WHERE id = '65'
193. 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'
194. 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
195. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
196. SELECT *
       FROM jos_community_events
       WHERE id = '64'
197. SELECT *
       FROM jos_community_events
       WHERE id = '64'
198. 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'
199. 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
200. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
201. SELECT *
       FROM jos_community_events
       WHERE id = '63'
202. SELECT *
       FROM jos_community_events
       WHERE id = '63'
203. 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'
204. 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
205. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
206. SELECT *
       FROM jos_community_events
       WHERE id = '62'
207. SELECT *
       FROM jos_community_events
       WHERE id = '62'
208. 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'
209. 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
210. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
211. SELECT *
       FROM jos_community_events
       WHERE id = '61'
212. SELECT *
       FROM jos_community_events
       WHERE id = '61'
213. 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'
214. 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
215. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
216. SELECT *
       FROM jos_community_events
       WHERE id = '60'
217. SELECT *
       FROM jos_community_events
       WHERE id = '60'
218. 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'
219. 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
220. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
221. SELECT *
       FROM jos_community_events
       WHERE id = '59'
222. SELECT *
       FROM jos_community_events
       WHERE id = '59'
223. 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'
224. 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
225. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
226. SELECT *
       FROM jos_community_events
       WHERE id = '58'
227. SELECT *
       FROM jos_community_events
       WHERE id = '58'
228. 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'
229. 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
230. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
231. SELECT *
       FROM jos_community_events
       WHERE id = '57'
232. SELECT *
       FROM jos_community_events
       WHERE id = '57'
233. 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'
234. 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
235. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
236. SELECT *
       FROM jos_community_events
       WHERE id = '56'
237. SELECT *
       FROM jos_community_events
       WHERE id = '56'
238. 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'
239. 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
240. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
241. SELECT *
       FROM jos_community_events
       WHERE id = '55'
242. SELECT *
       FROM jos_community_events
       WHERE id = '55'
243. 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'
244. 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
245. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
246. SELECT *
       FROM jos_community_events
       WHERE id = '54'
247. SELECT *
       FROM jos_community_events
       WHERE id = '54'
248. 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'
249. 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
250. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
251. SELECT *
       FROM jos_community_events
       WHERE id = '52'
252. SELECT *
       FROM jos_community_events
       WHERE id = '52'
253. 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'
254. 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
255. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
256. SELECT *
       FROM jos_community_events
       WHERE id = '53'
257. SELECT *
       FROM jos_community_events
       WHERE id = '53'
258. 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'
259. 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
260. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
261. SELECT *
       FROM jos_community_events
       WHERE id = '51'
262. SELECT *
       FROM jos_community_events
       WHERE id = '51'
263. 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'
264. 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
265. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
266. SELECT *
       FROM jos_community_events
       WHERE id = '50'
267. SELECT *
       FROM jos_community_events
       WHERE id = '50'
268. 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'
269. 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
270. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
271. SELECT *
       FROM jos_community_events
       WHERE id = '49'
272. SELECT *
       FROM jos_community_events
       WHERE id = '49'
273. 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'
274. 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
275. SELECT `name`
       FROM `jos_plugins`
       WHERE `element`='events'
       AND `folder`='community'
276. SELECT *
       FROM jos_community_events
       WHERE id = '48'
277. SELECT *
       FROM jos_community_events
       WHERE id = '48'
278. SELECT COUNT(1)
       FROM `jos_community_activities`
279. SELECT COUNT(1)
       FROM `jos_community_activities`
280. 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
281. SELECT id
       FROM jos_core_acl_aro
       WHERE section_value='users'
       AND value='0'
282. 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
283. SELECT extension
       FROM jos_joomleague_project
       WHERE id='20'
284. 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'
285. 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'
286. 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
287. 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
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 r.id, r.roundcode
       FROM jos_joomleague_round AS r
                                                             
       WHERE r.id =161
290. SELECT *
       FROM jos_joomleague_round 
       WHERE id = '161'   
       AND project_id = '20'
291. 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
292. 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)
293. 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)
294. 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
295. 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
296. SELECT r.id, r.roundcode
       FROM jos_joomleague_round AS r
                                                             
       WHERE r.id =161
297. SELECT *
       FROM jos_joomleague_round 
       WHERE id = '161'   
       AND project_id = '20'
298. 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
299. 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)
300. 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)
301. 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
302. SELECT params
       FROM jos_advancedmodules
       WHERE moduleid = 17
303. SELECT time, visits, guests, members, bots 
       FROM jos_vvcounter_logs 
       WHERE '1=1' 
       AND time > 1566320400
304. SELECT session_id, time, guest, DATA 
       FROM jos_session 
       WHERE '1=1' 
       AND time >= 1566362625
305. SELECT time, visits, guests, members, bots 
       FROM jos_vvcounter_logs 
       WHERE '1=1' 
       AND time <= 1566320400
306. SELECT time, visits, guests, members, bots 
       FROM jos_vvcounter_logs 
       WHERE '1=1' 
       AND time > 1566234000 
       AND time <= 1566320400
307. SELECT time, visits, guests, members, bots 
       FROM jos_vvcounter_logs 
       WHERE '1=1' 
       AND time > 1566061200 
       AND time <= 1566320400
308. SELECT time, visits, guests, members, bots 
       FROM jos_vvcounter_logs 
       WHERE '1=1' 
       AND time > 1565456400 
       AND time <= 1566061200
309. SELECT time, visits, guests, members, bots 
       FROM jos_vvcounter_logs 
       WHERE '1=1' 
       AND time > 1564592400 
       AND time <= 1566320400
310. SELECT time, visits, guests, members, bots 
       FROM jos_vvcounter_logs 
       WHERE '1=1' 
       AND time > 1561914000 
       AND time <= 1564592400
311. SELECT bid, imageurl, custombannercode
       FROM jos_banner
       WHERE showBanner = '1'
       AND (bid IN (13))
       ORDER BY bid