Спортивный клуб "СМЕШ"

Подключайтесь к нам!

  • Расширяйте сеть общения
  • Добавляйте новых друзей
  • Делитесь Вашими фото и видео
  • Создавайте свои группы

Авторизация



Последние группы

Текущие мероприятия

Новые фото

  • Саша
  • MUTABOR
  • MUTABOR
  • MUTABOR
  • Саша
  • MUTABOR
  • MUTABOR
  • Саша
  • MUTABOR
  • MUTABOR
  • MUTABOR
  • MUTABOR
  • Саша
  • MUTABOR
  • MUTABOR
  • Фёдор Ярыгин
  • Саша
  • MUTABOR
  • Саша
  • MUTABOR

Кто онлайн

Недавняя активность

vkon11


kkfmf
КРАСНОДАРСКАЯ КРАЕВАЯ
ОБЩЕСТВЕННАЯ ОРГАНИЗАЦИЯ
"СПОРТИВНАЯ ФЕДЕРАЦИЯ
ПРОФЕССИОНАЛЬНОГО И
ЛЮБИТЕЛЬСКОГО
МИНИ-ФУТБОЛА
"ФУТЗАЛ"

Таблица

М Команда И В Н П О
1 Ruscon 8 6 1 1 19
2 Скайлайн 8 5 1 2 16
3 Черноморсервис 8 5 1 2 16
4 ГМУ 7 3 2 2 11
5 NLE 8 2 1 5 7

Расписание

04.01
09:00
Ru  11  -  2  Ч
04.01
10:00
Ч  1  -  8  С

Последние матчи

Осеннее первенство Новороссийска по мини-футболу. Тур 9
Ruscon  11  -  2  Черноморец
Черноморсе  1  -  8  Скайлайн

Меню пользователя

Счетчик посещений

mod_vvisit_countermod_vvisit_countermod_vvisit_countermod_vvisit_countermod_vvisit_countermod_vvisit_countermod_vvisit_counter
mod_vvisit_counterСегодня426
mod_vvisit_counterВчера653
mod_vvisit_counterЭта неделя2740
mod_vvisit_counterПрош. неделя7250
mod_vvisit_counterЭтот месяц9990
mod_vvisit_counterПрош. месяц46468
mod_vvisit_counterВсе дни6199136
YOU ARE HERE:

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

Application afterLoad: 0.000 seconds, 0.29 MB
Application afterInitialise: 0.014 seconds, 1.24 MB
Application afterRoute: 0.019 seconds, 1.78 MB
Application afterDispatch: 0.611 seconds, 6.19 MB
Application afterRender: 2.033 seconds, 22.93 MB

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

24139136

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

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'qon42d6bq1tmlvmtbn9r16sbi5'
  2. DELETE
      FROM jos_session
      WHERE ( time < '1576042719' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'qon42d6bq1tmlvmtbn9r16sbi5'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'qon42d6bq1tmlvmtbn9r16sbi5','1576066719','','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
      LEFT JOIN `jos_users`
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `jos_session`
      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
      LEFT JOIN `jos_users`
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `jos_session`
      ON s.`userid`=a.`userid`
      WHERE a.`userid` IN (1943,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)
  19. 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
  20. 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
  21. 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
  22. 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
  23. 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
  24. 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
  25. 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
  26. 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
  27. 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
  28. 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
  29. 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
  30. 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
  31. 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
  32. 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
  33. 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
  34. 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
  35. 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
  36. 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
  37. 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
  38. 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
  39. 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
  40. 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
  41. 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
  42. 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
  43. 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
  44. 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
  45. 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
  46. 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
  47. 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
  48. 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
  49. 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
  50. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1943'
      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` = '1943'
      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`='1919'
      ORDER BY `posted_on` DESC
      LIMIT 1
  55. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1930'
      ORDER BY `posted_on` DESC
      LIMIT 1
  56. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1926'
      ORDER BY `posted_on` DESC
      LIMIT 1
  57. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1936'
      ORDER BY `posted_on` DESC
      LIMIT 1
  58. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1932'
      ORDER BY `posted_on` DESC
      LIMIT 1
  59. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1925'
      ORDER BY `posted_on` DESC
      LIMIT 1
  60. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1917'
      ORDER BY `posted_on` DESC
      LIMIT 1
  61. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1913'
      ORDER BY `posted_on` DESC
      LIMIT 1
  62. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1941'
      ORDER BY `posted_on` DESC
      LIMIT 1
  63. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1912'
      ORDER BY `posted_on` DESC
      LIMIT 1
  64. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1914'
      ORDER BY `posted_on` DESC
      LIMIT 1
  65. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1923'
      ORDER BY `posted_on` DESC
      LIMIT 1
  66. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1934'
      ORDER BY `posted_on` DESC
      LIMIT 1
  67. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1939'
      ORDER BY `posted_on` DESC
      LIMIT 1
  68. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1933'
      ORDER BY `posted_on` DESC
      LIMIT 1
  69. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1942'
      ORDER BY `posted_on` DESC
      LIMIT 1
  70. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1916'
      ORDER BY `posted_on` DESC
      LIMIT 1
  71. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1921'
      ORDER BY `posted_on` DESC
      LIMIT 1
  72. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1929'
      ORDER BY `posted_on` DESC
      LIMIT 1
  73. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1935'
      ORDER BY `posted_on` DESC
      LIMIT 1
  74. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1922'
      ORDER BY `posted_on` DESC
      LIMIT 1
  75. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1918'
      ORDER BY `posted_on` DESC
      LIMIT 1
  76. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1920'
      ORDER BY `posted_on` DESC
      LIMIT 1
  77. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1928'
      ORDER BY `posted_on` DESC
      LIMIT 1
  78. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1943'
      ORDER BY `posted_on` DESC
      LIMIT 1
  79. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1915'
      ORDER BY `posted_on` DESC
      LIMIT 1
  80. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1924'
      ORDER BY `posted_on` DESC
      LIMIT 1
  81. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1931'
      ORDER BY `posted_on` DESC
      LIMIT 1
  82. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1927'
      ORDER BY `posted_on` DESC
      LIMIT 1
  83. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1938'
      ORDER BY `posted_on` DESC
      LIMIT 1
  84. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1940'
      ORDER BY `posted_on` DESC
      LIMIT 1
  85. SELECT *
      FROM `jos_community_users`
      WHERE `userid`='1937'
      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
      LEFT JOIN `jos_users`
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `jos_session`
      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 = '116'
  113. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friends` AS _friends,  a.`groups` AS _groups,  a.`friendcount` AS _friendcount,  a.`alias` AS _alias,  a.`profile_id` AS _profile_id,  a.`storage` AS _storage,  a.`watermark_hash` AS _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` AS _isonline, u.* 
      FROM `jos_community_users` AS
      LEFT JOIN `jos_users`
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `jos_session`
      ON s.`userid`=a.`userid`
      AND s.`client_id` !='1'
      WHERE a.`userid`='62'
  114. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='62'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '62'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
  115. SELECT *
      FROM jos_community_videos
      WHERE id = '121'
  116. SELECT *
      FROM jos_community_videos
      WHERE id = '118'
  117. SELECT a.*
      FROM `jos_community_photos` AS a
      INNER JOIN `jos_community_photos_albums` AS b
      ON a.`albumid` = b.`id`
      WHERE b.`type` = 'user'
      AND a.`permissions`='0'
      AND a.`published`='1'
      ORDER BY a.`created` DESC
      LIMIT 20
  118. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friends` AS _friends,  a.`groups` AS _groups,  a.`friendcount` AS _friendcount,  a.`alias` AS _alias,  a.`profile_id` AS _profile_id,  a.`storage` AS _storage,  a.`watermark_hash` AS _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` AS _isonline, u.* 
      FROM `jos_community_users` AS
      LEFT JOIN `jos_users`
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `jos_session`
      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
      LEFT JOIN `jos_users`
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `jos_session`
      ON s.`userid`=a.`userid`
      AND s.`client_id` !='1'
      WHERE a.`userid`='73'
  121. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='73'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '73'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
  122. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friends` AS _friends,  a.`groups` AS _groups,  a.`friendcount` AS _friendcount,  a.`alias` AS _alias,  a.`profile_id` AS _profile_id,  a.`storage` AS _storage,  a.`watermark_hash` AS _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` AS _isonline, u.* 
      FROM `jos_community_users` AS
      LEFT JOIN `jos_users`
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `jos_session`
      ON s.`userid`=a.`userid`
      AND s.`client_id` !='1'
      WHERE a.`userid`='123'
  123. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='123'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '123'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
  124. SELECT `id`
      FROM `jos_menu`
      WHERE `link` LIKE '%option=com_community&view=photos%'
      AND `published`='1'
      AND `menutype`!='jomsocial'
      AND `type`='component'
  125. SELECT DISTINCT a.*
      FROM `jos_community_events` AS
      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-12-11 12:18:39'
      ORDER BY a.`startdate` ASC
      LIMIT 0, 5
  126. SELECT COUNT(DISTINCT(a.`id`))
      FROM `jos_community_events` AS
      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-12-11 12:18:39'
  127. SELECT COUNT(DISTINCT(a.`id`))
      FROM `jos_community_events` AS
      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-12-11 12:18:39'
  128. SELECT `id`
      FROM `jos_menu`
      WHERE `link` LIKE '%option=com_community&view=events%'
      AND `published`='1'
      AND `menutype`!='jomsocial'
      AND `type`='component'
  129. SELECT *
      FROM jos_community_events
      WHERE id = '1'
  130. SELECT id
      FROM jos_core_acl_aro
      WHERE section_value='users'
      AND value='0'
  131. SELECT m.*,n.`name`
      FROM `jos_community_blocklist` m
      LEFT JOIN `jos_users` n
      ON m.`blocked_userid`=n.`id`
      WHERE m.`userid`='0'
      AND m.`blocked_userid`!=0
  132. SELECT a.*,  TO_DAYS('2019-12-11 19:18:39') -  TO_DAYS( DATE_ADD(a.`created`, INTERVAL 7 HOUR ) ) AS _daydiff
      FROM `jos_community_activities` AS a   
      WHERE  `archived`=0
      GROUP BY a.`id`
      ORDER BY a.`created` DESC
      LIMIT 240
  133. SELECT a.* 
      FROM `jos_community_wall` AS
      WHERE  (  a.`type`='events'
      AND  a.`contentid` IN (76,75,74,73,72,71,70,69,68,67,66,65,64,63,62,61,60,59,58,57,56,55,54,52,53,51,50,49,48,47,46,45,44,43,42,41,40,39,38,37,36,35,34,33,32,31,30,29,28,27,26,25,24,23,22,21,20,19,18,17,16,15,14,13,12,11,10,9,8,6,7,5,4,3,2,1)  )  OR  (  a.`type`='profile.avatar.upload'
      AND  a.`contentid` IN (102,238,165,175)  )  OR  (  a.`type`='profile.status'
      AND  a.`contentid` IN (1131,1128,1127,1126,1125,1124,1123,1122,1121,1120,1119,1118,1117,1116,1115,1114,1113,1112,1111,1110,1109,1108,1107,1104,1103,1102,1101,1100,1099,1097,1059,1057,1056,1055,1054,1047,1029,991,608)  )  OR  (  a.`type`='videos'
      AND  a.`contentid` IN (122,121,120,118,117,116,115,114,113,112,111,110,109,108,107,106,105,104,103,102,101,100,99,98,97,96,95,94,93,91,90,89,88,87,86,85,84,83,82,81,80,79,78,77,76,75,74,73,72,71,70,69,68,67,66,65,64,63,62,61,60,59,58,57,56,55,54,53,52,51,50,49,48,47,46,45,44,43,42,41,39,36,32,28,27,24,21)  )  OR  (  a.`type`='photos.album'
      AND  a.`contentid` IN (17,15)  )  OR  (  a.`type`='photos.wall.create'
      AND  a.`contentid` IN (959,958,957,955,773,772,771,746,733)  ) 
      ORDER BY `id` DESC
  134. SELECT a.* 
      FROM `jos_community_likes` AS
      WHERE  (  a.`element`='events'
      AND  a.`uid` IN (76,75,74,73,72,71,70,69,68,67,66,65,64,63,62,61,60,59,58,57,56,55,54,52,53,51,50,49,48,47,46,45,44,43,42,41,40,39,38,37,36,35,34,33,32,31,30,29,28,27,26,25,24,23,22,21,20,19,18,17,16,15,14,13,12,11,10,9,8,6,7,5,4,3,2,1)  )  OR  (  a.`element`='profile.avatar.upload'
      AND  a.`uid` IN (102,238,165,175)  )  OR  (  a.`element`='profile.status'
      AND  a.`uid` IN (1131,1128,1127,1126,1125,1124,1123,1122,1121,1120,1119,1118,1117,1116,1115,1114,1113,1112,1111,1110,1109,1108,1107,1104,1103,1102,1101,1100,1099,1097,1059,1057,1056,1055,1054,1047,1029,991,608)  )  OR  (  a.`element`='videos'
      AND  a.`uid` IN (122,121,120,118,117,116,115,114,113,112,111,110,109,108,107,106,105,104,103,102,101,100,99,98,97,96,95,94,93,91,90,89,88,87,86,85,84,83,82,81,80,79,78,77,76,75,74,73,72,71,70,69,68,67,66,65,64,63,62,61,60,59,58,57,56,55,54,53,52,51,50,49,48,47,46,45,44,43,42,41,39,36,32,28,27,24,21)  )  OR  (  a.`element`='photos.album'
      AND  a.`uid` IN (17,15)  )  OR  (  a.`element`='photos.wall.create'
      AND  a.`uid` IN (959,958,957,955,773,772,771,746,733)  )
  135. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friends` AS _friends,  a.`groups` AS _groups,  a.`friendcount` AS _friendcount,  a.`alias` AS _alias,  a.`profile_id` AS _profile_id,  a.`storage` AS _storage,  a.`watermark_hash` AS _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` AS _isonline, u.* 
      FROM `jos_community_users` AS
      LEFT JOIN `jos_users`
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `jos_session`
      ON s.`userid`=a.`userid`
      AND s.`client_id` !='1'
      WHERE a.`userid`='1852'
  136. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1852'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1852'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
  137. SELECT `name`
      FROM `jos_plugins`
      WHERE `element`='events'
      AND `folder`='community'
  138. SELECT *
      FROM jos_community_events
      WHERE id = '76'
  139. SELECT *
      FROM jos_community_events
      WHERE id = '76'
  140. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friends` AS _friends,  a.`groups` AS _groups,  a.`friendcount` AS _friendcount,  a.`alias` AS _alias,  a.`profile_id` AS _profile_id,  a.`storage` AS _storage,  a.`watermark_hash` AS _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` AS _isonline, u.* 
      FROM `jos_community_users` AS
      LEFT JOIN `jos_users`
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `jos_session`
      ON s.`userid`=a.`userid`
      AND s.`client_id` !='1'
      WHERE a.`userid`='1817'
  141. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1817'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1817'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
  142. SELECT `name`
      FROM `jos_plugins`
      WHERE `element`='events'
      AND `folder`='community'
  143. SELECT *
      FROM jos_community_events
      WHERE id = '75'
  144. SELECT *
      FROM jos_community_events
      WHERE id = '75'
  145. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friends` AS _friends,  a.`groups` AS _groups,  a.`friendcount` AS _friendcount,  a.`alias` AS _alias,  a.`profile_id` AS _profile_id,  a.`storage` AS _storage,  a.`watermark_hash` AS _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` AS _isonline, u.* 
      FROM `jos_community_users` AS
      LEFT JOIN `jos_users`
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `jos_session`
      ON s.`userid`=a.`userid`
      AND s.`client_id` !='1'
      WHERE a.`userid`='1796'
  146. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1796'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1796'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
  147. SELECT `name`
      FROM `jos_plugins`
      WHERE `element`='events'
      AND `folder`='community'
  148. SELECT *
      FROM jos_community_events
      WHERE id = '74'
  149. SELECT *
      FROM jos_community_events
      WHERE id = '74'
  150. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friends` AS _friends,  a.`groups` AS _groups,  a.`friendcount` AS _friendcount,  a.`alias` AS _alias,  a.`profile_id` AS _profile_id,  a.`storage` AS _storage,  a.`watermark_hash` AS _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` AS _isonline, u.* 
      FROM `jos_community_users` AS
      LEFT JOIN `jos_users`
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `jos_session`
      ON s.`userid`=a.`userid`
      AND s.`client_id` !='1'
      WHERE a.`userid`='1789'
  151. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1789'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1789'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
  152. SELECT `name`
      FROM `jos_plugins`
      WHERE `element`='events'
      AND `folder`='community'
  153. SELECT *
      FROM jos_community_events
      WHERE id = '73'
  154. SELECT *
      FROM jos_community_events
      WHERE id = '73'
  155. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friends` AS _friends,  a.`groups` AS _groups,  a.`friendcount` AS _friendcount,  a.`alias` AS _alias,  a.`profile_id` AS _profile_id,  a.`storage` AS _storage,  a.`watermark_hash` AS _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` AS _isonline, u.* 
      FROM `jos_community_users` AS
      LEFT JOIN `jos_users`
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `jos_session`
      ON s.`userid`=a.`userid`
      AND s.`client_id` !='1'
      WHERE a.`userid`='1793'
  156. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1793'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1793'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
  157. SELECT `name`
      FROM `jos_plugins`
      WHERE `element`='events'
      AND `folder`='community'
  158. SELECT *
      FROM jos_community_events
      WHERE id = '72'
  159. SELECT *
      FROM jos_community_events
      WHERE id = '72'
  160. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friends` AS _friends,  a.`groups` AS _groups,  a.`friendcount` AS _friendcount,  a.`alias` AS _alias,  a.`profile_id` AS _profile_id,  a.`storage` AS _storage,  a.`watermark_hash` AS _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` AS _isonline, u.* 
      FROM `jos_community_users` AS
      LEFT JOIN `jos_users`
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `jos_session`
      ON s.`userid`=a.`userid`
      AND s.`client_id` !='1'
      WHERE a.`userid`='1788'
  161. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1788'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1788'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
  162. SELECT `name`
      FROM `jos_plugins`
      WHERE `element`='events'
      AND `folder`='community'
  163. SELECT *
      FROM jos_community_events
      WHERE id = '71'
  164. SELECT *
      FROM jos_community_events
      WHERE id = '71'
  165. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friends` AS _friends,  a.`groups` AS _groups,  a.`friendcount` AS _friendcount,  a.`alias` AS _alias,  a.`profile_id` AS _profile_id,  a.`storage` AS _storage,  a.`watermark_hash` AS _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` AS _isonline, u.* 
      FROM `jos_community_users` AS
      LEFT JOIN `jos_users`
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `jos_session`
      ON s.`userid`=a.`userid`
      AND s.`client_id` !='1'
      WHERE a.`userid`='1791'
  166. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1791'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1791'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
  167. SELECT `name`
      FROM `jos_plugins`
      WHERE `element`='events'
      AND `folder`='community'
  168. SELECT *
      FROM jos_community_events
      WHERE id = '70'
  169. SELECT *
      FROM jos_community_events
      WHERE id = '70'
  170. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friends` AS _friends,  a.`groups` AS _groups,  a.`friendcount` AS _friendcount,  a.`alias` AS _alias,  a.`profile_id` AS _profile_id,  a.`storage` AS _storage,  a.`watermark_hash` AS _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` AS _isonline, u.* 
      FROM `jos_community_users` AS
      LEFT JOIN `jos_users`
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `jos_session`
      ON s.`userid`=a.`userid`
      AND s.`client_id` !='1'
      WHERE a.`userid`='1794'
  171. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1794'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1794'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
  172. SELECT `name`
      FROM `jos_plugins`
      WHERE `element`='events'
      AND `folder`='community'
  173. SELECT *
      FROM jos_community_events
      WHERE id = '69'
  174. SELECT *
      FROM jos_community_events
      WHERE id = '69'
  175. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friends` AS _friends,  a.`groups` AS _groups,  a.`friendcount` AS _friendcount,  a.`alias` AS _alias,  a.`profile_id` AS _profile_id,  a.`storage` AS _storage,  a.`watermark_hash` AS _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` AS _isonline, u.* 
      FROM `jos_community_users` AS
      LEFT JOIN `jos_users`
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `jos_session`
      ON s.`userid`=a.`userid`
      AND s.`client_id` !='1'
      WHERE a.`userid`='1795'
  176. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1795'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1795'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
  177. SELECT `name`
      FROM `jos_plugins`
      WHERE `element`='events'
      AND `folder`='community'
  178. SELECT *
      FROM jos_community_events
      WHERE id = '68'
  179. SELECT *
      FROM jos_community_events
      WHERE id = '68'
  180. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friends` AS _friends,  a.`groups` AS _groups,  a.`friendcount` AS _friendcount,  a.`alias` AS _alias,  a.`profile_id` AS _profile_id,  a.`storage` AS _storage,  a.`watermark_hash` AS _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` AS _isonline, u.* 
      FROM `jos_community_users` AS
      LEFT JOIN `jos_users`
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `jos_session`
      ON s.`userid`=a.`userid`
      AND s.`client_id` !='1'
      WHERE a.`userid`='1784'
  181. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1784'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1784'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
  182. SELECT `name`
      FROM `jos_plugins`
      WHERE `element`='events'
      AND `folder`='community'
  183. SELECT *
      FROM jos_community_events
      WHERE id = '67'
  184. SELECT *
      FROM jos_community_events
      WHERE id = '67'
  185. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friends` AS _friends,  a.`groups` AS _groups,  a.`friendcount` AS _friendcount,  a.`alias` AS _alias,  a.`profile_id` AS _profile_id,  a.`storage` AS _storage,  a.`watermark_hash` AS _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` AS _isonline, u.* 
      FROM `jos_community_users` AS
      LEFT JOIN `jos_users`
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `jos_session`
      ON s.`userid`=a.`userid`
      AND s.`client_id` !='1'
      WHERE a.`userid`='1787'
  186. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1787'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1787'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
  187. SELECT `name`
      FROM `jos_plugins`
      WHERE `element`='events'
      AND `folder`='community'
  188. SELECT *
      FROM jos_community_events
      WHERE id = '66'
  189. SELECT *
      FROM jos_community_events
      WHERE id = '66'
  190. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friends` AS _friends,  a.`groups` AS _groups,  a.`friendcount` AS _friendcount,  a.`alias` AS _alias,  a.`profile_id` AS _profile_id,  a.`storage` AS _storage,  a.`watermark_hash` AS _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` AS _isonline, u.* 
      FROM `jos_community_users` AS
      LEFT JOIN `jos_users`
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `jos_session`
      ON s.`userid`=a.`userid`
      AND s.`client_id` !='1'
      WHERE a.`userid`='1792'
  191. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1792'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1792'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
  192. SELECT `name`
      FROM `jos_plugins`
      WHERE `element`='events'
      AND `folder`='community'
  193. SELECT *
      FROM jos_community_events
      WHERE id = '65'
  194. SELECT *
      FROM jos_community_events
      WHERE id = '65'
  195. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friends` AS _friends,  a.`groups` AS _groups,  a.`friendcount` AS _friendcount,  a.`alias` AS _alias,  a.`profile_id` AS _profile_id,  a.`storage` AS _storage,  a.`watermark_hash` AS _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` AS _isonline, u.* 
      FROM `jos_community_users` AS
      LEFT JOIN `jos_users`
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `jos_session`
      ON s.`userid`=a.`userid`
      AND s.`client_id` !='1'
      WHERE a.`userid`='1790'
  196. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1790'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1790'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
  197. SELECT `name`
      FROM `jos_plugins`
      WHERE `element`='events'
      AND `folder`='community'
  198. SELECT *
      FROM jos_community_events
      WHERE id = '64'
  199. SELECT *
      FROM jos_community_events
      WHERE id = '64'
  200. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friends` AS _friends,  a.`groups` AS _groups,  a.`friendcount` AS _friendcount,  a.`alias` AS _alias,  a.`profile_id` AS _profile_id,  a.`storage` AS _storage,  a.`watermark_hash` AS _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` AS _isonline, u.* 
      FROM `jos_community_users` AS
      LEFT JOIN `jos_users`
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `jos_session`
      ON s.`userid`=a.`userid`
      AND s.`client_id` !='1'
      WHERE a.`userid`='1779'
  201. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1779'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1779'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
  202. SELECT `name`
      FROM `jos_plugins`
      WHERE `element`='events'
      AND `folder`='community'
  203. SELECT *
      FROM jos_community_events
      WHERE id = '63'
  204. SELECT *
      FROM jos_community_events
      WHERE id = '63'
  205. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friends` AS _friends,  a.`groups` AS _groups,  a.`friendcount` AS _friendcount,  a.`alias` AS _alias,  a.`profile_id` AS _profile_id,  a.`storage` AS _storage,  a.`watermark_hash` AS _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` AS _isonline, u.* 
      FROM `jos_community_users` AS
      LEFT JOIN `jos_users`
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `jos_session`
      ON s.`userid`=a.`userid`
      AND s.`client_id` !='1'
      WHERE a.`userid`='1786'
  206. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1786'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1786'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
  207. SELECT `name`
      FROM `jos_plugins`
      WHERE `element`='events'
      AND `folder`='community'
  208. SELECT *
      FROM jos_community_events
      WHERE id = '62'
  209. SELECT *
      FROM jos_community_events
      WHERE id = '62'
  210. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friends` AS _friends,  a.`groups` AS _groups,  a.`friendcount` AS _friendcount,  a.`alias` AS _alias,  a.`profile_id` AS _profile_id,  a.`storage` AS _storage,  a.`watermark_hash` AS _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` AS _isonline, u.* 
      FROM `jos_community_users` AS
      LEFT JOIN `jos_users`
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `jos_session`
      ON s.`userid`=a.`userid`
      AND s.`client_id` !='1'
      WHERE a.`userid`='1782'
  211. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1782'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1782'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
  212. SELECT `name`
      FROM `jos_plugins`
      WHERE `element`='events'
      AND `folder`='community'
  213. SELECT *
      FROM jos_community_events
      WHERE id = '61'
  214. SELECT *
      FROM jos_community_events
      WHERE id = '61'
  215. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friends` AS _friends,  a.`groups` AS _groups,  a.`friendcount` AS _friendcount,  a.`alias` AS _alias,  a.`profile_id` AS _profile_id,  a.`storage` AS _storage,  a.`watermark_hash` AS _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` AS _isonline, u.* 
      FROM `jos_community_users` AS
      LEFT JOIN `jos_users`
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `jos_session`
      ON s.`userid`=a.`userid`
      AND s.`client_id` !='1'
      WHERE a.`userid`='1781'
  216. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1781'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1781'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
  217. SELECT `name`
      FROM `jos_plugins`
      WHERE `element`='events'
      AND `folder`='community'
  218. SELECT *
      FROM jos_community_events
      WHERE id = '60'
  219. SELECT *
      FROM jos_community_events
      WHERE id = '60'
  220. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friends` AS _friends,  a.`groups` AS _groups,  a.`friendcount` AS _friendcount,  a.`alias` AS _alias,  a.`profile_id` AS _profile_id,  a.`storage` AS _storage,  a.`watermark_hash` AS _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` AS _isonline, u.* 
      FROM `jos_community_users` AS
      LEFT JOIN `jos_users`
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `jos_session`
      ON s.`userid`=a.`userid`
      AND s.`client_id` !='1'
      WHERE a.`userid`='1797'
  221. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1797'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1797'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
  222. SELECT `name`
      FROM `jos_plugins`
      WHERE `element`='events'
      AND `folder`='community'
  223. SELECT *
      FROM jos_community_events
      WHERE id = '59'
  224. SELECT *
      FROM jos_community_events
      WHERE id = '59'
  225. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friends` AS _friends,  a.`groups` AS _groups,  a.`friendcount` AS _friendcount,  a.`alias` AS _alias,  a.`profile_id` AS _profile_id,  a.`storage` AS _storage,  a.`watermark_hash` AS _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` AS _isonline, u.* 
      FROM `jos_community_users` AS
      LEFT JOIN `jos_users`
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `jos_session`
      ON s.`userid`=a.`userid`
      AND s.`client_id` !='1'
      WHERE a.`userid`='1783'
  226. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1783'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1783'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
  227. SELECT `name`
      FROM `jos_plugins`
      WHERE `element`='events'
      AND `folder`='community'
  228. SELECT *
      FROM jos_community_events
      WHERE id = '58'
  229. SELECT *
      FROM jos_community_events
      WHERE id = '58'
  230. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friends` AS _friends,  a.`groups` AS _groups,  a.`friendcount` AS _friendcount,  a.`alias` AS _alias,  a.`profile_id` AS _profile_id,  a.`storage` AS _storage,  a.`watermark_hash` AS _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` AS _isonline, u.* 
      FROM `jos_community_users` AS
      LEFT JOIN `jos_users`
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `jos_session`
      ON s.`userid`=a.`userid`
      AND s.`client_id` !='1'
      WHERE a.`userid`='1780'
  231. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1780'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1780'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
  232. SELECT `name`
      FROM `jos_plugins`
      WHERE `element`='events'
      AND `folder`='community'
  233. SELECT *
      FROM jos_community_events
      WHERE id = '57'
  234. SELECT *
      FROM jos_community_events
      WHERE id = '57'
  235. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friends` AS _friends,  a.`groups` AS _groups,  a.`friendcount` AS _friendcount,  a.`alias` AS _alias,  a.`profile_id` AS _profile_id,  a.`storage` AS _storage,  a.`watermark_hash` AS _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` AS _isonline, u.* 
      FROM `jos_community_users` AS
      LEFT JOIN `jos_users`
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `jos_session`
      ON s.`userid`=a.`userid`
      AND s.`client_id` !='1'
      WHERE a.`userid`='1785'
  236. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1785'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1785'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
  237. SELECT `name`
      FROM `jos_plugins`
      WHERE `element`='events'
      AND `folder`='community'
  238. SELECT *
      FROM jos_community_events
      WHERE id = '56'
  239. SELECT *
      FROM jos_community_events
      WHERE id = '56'
  240. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friends` AS _friends,  a.`groups` AS _groups,  a.`friendcount` AS _friendcount,  a.`alias` AS _alias,  a.`profile_id` AS _profile_id,  a.`storage` AS _storage,  a.`watermark_hash` AS _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` AS _isonline, u.* 
      FROM `jos_community_users` AS
      LEFT JOIN `jos_users`
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `jos_session`
      ON s.`userid`=a.`userid`
      AND s.`client_id` !='1'
      WHERE a.`userid`='1777'
  241. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1777'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1777'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
  242. SELECT `name`
      FROM `jos_plugins`
      WHERE `element`='events'
      AND `folder`='community'
  243. SELECT *
      FROM jos_community_events
      WHERE id = '55'
  244. SELECT *
      FROM jos_community_events
      WHERE id = '55'
  245. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friends` AS _friends,  a.`groups` AS _groups,  a.`friendcount` AS _friendcount,  a.`alias` AS _alias,  a.`profile_id` AS _profile_id,  a.`storage` AS _storage,  a.`watermark_hash` AS _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` AS _isonline, u.* 
      FROM `jos_community_users` AS
      LEFT JOIN `jos_users`
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `jos_session`
      ON s.`userid`=a.`userid`
      AND s.`client_id` !='1'
      WHERE a.`userid`='1773'
  246. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1773'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1773'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
  247. SELECT `name`
      FROM `jos_plugins`
      WHERE `element`='events'
      AND `folder`='community'
  248. SELECT *
      FROM jos_community_events
      WHERE id = '54'
  249. SELECT *
      FROM jos_community_events
      WHERE id = '54'
  250. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friends` AS _friends,  a.`groups` AS _groups,  a.`friendcount` AS _friendcount,  a.`alias` AS _alias,  a.`profile_id` AS _profile_id,  a.`storage` AS _storage,  a.`watermark_hash` AS _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` AS _isonline, u.* 
      FROM `jos_community_users` AS
      LEFT JOIN `jos_users`
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `jos_session`
      ON s.`userid`=a.`userid`
      AND s.`client_id` !='1'
      WHERE a.`userid`='1771'
  251. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1771'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1771'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
  252. SELECT `name`
      FROM `jos_plugins`
      WHERE `element`='events'
      AND `folder`='community'
  253. SELECT *
      FROM jos_community_events
      WHERE id = '52'
  254. SELECT *
      FROM jos_community_events
      WHERE id = '52'
  255. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friends` AS _friends,  a.`groups` AS _groups,  a.`friendcount` AS _friendcount,  a.`alias` AS _alias,  a.`profile_id` AS _profile_id,  a.`storage` AS _storage,  a.`watermark_hash` AS _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` AS _isonline, u.* 
      FROM `jos_community_users` AS
      LEFT JOIN `jos_users`
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `jos_session`
      ON s.`userid`=a.`userid`
      AND s.`client_id` !='1'
      WHERE a.`userid`='1772'
  256. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1772'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1772'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
  257. SELECT `name`
      FROM `jos_plugins`
      WHERE `element`='events'
      AND `folder`='community'
  258. SELECT *
      FROM jos_community_events
      WHERE id = '53'
  259. SELECT *
      FROM jos_community_events
      WHERE id = '53'
  260. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friends` AS _friends,  a.`groups` AS _groups,  a.`friendcount` AS _friendcount,  a.`alias` AS _alias,  a.`profile_id` AS _profile_id,  a.`storage` AS _storage,  a.`watermark_hash` AS _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` AS _isonline, u.* 
      FROM `jos_community_users` AS
      LEFT JOIN `jos_users`
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `jos_session`
      ON s.`userid`=a.`userid`
      AND s.`client_id` !='1'
      WHERE a.`userid`='1766'
  261. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1766'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1766'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
  262. SELECT `name`
      FROM `jos_plugins`
      WHERE `element`='events'
      AND `folder`='community'
  263. SELECT *
      FROM jos_community_events
      WHERE id = '51'
  264. SELECT *
      FROM jos_community_events
      WHERE id = '51'
  265. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friends` AS _friends,  a.`groups` AS _groups,  a.`friendcount` AS _friendcount,  a.`alias` AS _alias,  a.`profile_id` AS _profile_id,  a.`storage` AS _storage,  a.`watermark_hash` AS _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` AS _isonline, u.* 
      FROM `jos_community_users` AS
      LEFT JOIN `jos_users`
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `jos_session`
      ON s.`userid`=a.`userid`
      AND s.`client_id` !='1'
      WHERE a.`userid`='1765'
  266. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1765'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1765'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
  267. SELECT `name`
      FROM `jos_plugins`
      WHERE `element`='events'
      AND `folder`='community'
  268. SELECT *
      FROM jos_community_events
      WHERE id = '50'
  269. SELECT *
      FROM jos_community_events
      WHERE id = '50'
  270. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friends` AS _friends,  a.`groups` AS _groups,  a.`friendcount` AS _friendcount,  a.`alias` AS _alias,  a.`profile_id` AS _profile_id,  a.`storage` AS _storage,  a.`watermark_hash` AS _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` AS _isonline, u.* 
      FROM `jos_community_users` AS
      LEFT JOIN `jos_users`
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `jos_session`
      ON s.`userid`=a.`userid`
      AND s.`client_id` !='1'
      WHERE a.`userid`='1767'
  271. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1767'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1767'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
  272. SELECT `name`
      FROM `jos_plugins`
      WHERE `element`='events'
      AND `folder`='community'
  273. SELECT *
      FROM jos_community_events
      WHERE id = '49'
  274. SELECT *
      FROM jos_community_events
      WHERE id = '49'
  275. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friends` AS _friends,  a.`groups` AS _groups,  a.`friendcount` AS _friendcount,  a.`alias` AS _alias,  a.`profile_id` AS _profile_id,  a.`storage` AS _storage,  a.`watermark_hash` AS _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` AS _isonline, u.* 
      FROM `jos_community_users` AS
      LEFT JOIN `jos_users`
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `jos_session`
      ON s.`userid`=a.`userid`
      AND s.`client_id` !='1'
      WHERE a.`userid`='1769'
  276. SELECT count(*) 
      FROM `jos_community_connection` AS a, `jos_users` AS b
      WHERE a.`connect_from`='1769'
      AND b.block=0 
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `jos_community_blocklist` AS d
      WHERE d.`userid` = '1769'
      AND d.`blocked_userid` = a.`connect_to`) 
      ORDER BY a.`connection_id` DESC
  277. SELECT `name`
      FROM `jos_plugins`
      WHERE `element`='events'
      AND `folder`='community'
  278. SELECT *
      FROM jos_community_events
      WHERE id = '48'
  279. SELECT *
      FROM jos_community_events
      WHERE id = '48'
  280. SELECT COUNT(1)
      FROM `jos_community_activities`
  281. SELECT COUNT(1)
      FROM `jos_community_activities`
  282. SELECT DISTINCT(a.`id`)
      FROM `jos_users` AS
      INNER JOIN `jos_session` AS
      ON a.`id`=b.`userid`
      WHERE a.`block`='0'
      AND `client_id` != '1'
      ORDER BY b.`time` DESC
      LIMIT 20
  283. SELECT id
      FROM jos_core_acl_aro
      WHERE section_value='users'
      AND value='0'
  284. SELECT p.*, l.country,
                                            CASE WHEN CHAR_LENGTH( p.alias )
                                            THEN CONCAT_WS( ':', p.id, p.alias )
                                            ELSE p.id
                                            END AS slug
                                           
      FROM jos_joomleague_project AS p
                                           
      LEFT JOIN jos_joomleague_league AS l
      ON p.league_id = l.id
                                           
      WHERE p.id='20'
      LIMIT 0, 1
  285. SELECT extension
      FROM jos_joomleague_project
      WHERE id='20'
  286. SELECT t.params
                                      
      FROM jos_joomleague_template_config AS t
                                      
      INNER JOIN jos_joomleague_project AS p
      ON p.id=t.project_id
                                      
      WHERE t.template='ranking'
                                      
      AND p.id='20'
  287. SELECT t.params
                                      
      FROM jos_joomleague_template_config AS t
                                      
      INNER JOIN jos_joomleague_project AS p
      ON p.id=t.project_id
                                      
      WHERE t.template='ranking'
                                      
      AND p.id='20'
  288. SELECT p.*, l.country,
                                            CASE WHEN CHAR_LENGTH( p.alias )
                                            THEN CONCAT_WS( ':', p.id, p.alias )
                                            ELSE p.id
                                            END AS slug
                                           
      FROM jos_joomleague_project AS p
                                           
      LEFT JOIN jos_joomleague_league AS l
      ON p.league_id = l.id
                                           
      WHERE p.id='20'
      LIMIT 0, 1
  289. SELECT  tl.id AS projectteamid,
                                                                    tl.division_id,
                                                                    tl.standard_playground,
                                                                    tl.admin,
                                                                    tl.start_points,
                                                                    tl.points_finally,
                                                                    tl.neg_points_finally,
                                                                    tl.matches_finally,
                                                                    tl.won_finally,
                                                                    tl.draws_finally,
                                                                    tl.lost_finally,
                                                                    tl.homegoals_finally,
                                                                    tl.guestgoals_finally,
                                                                    tl.diffgoals_finally,
                                                                    tl.info,
                                                                    tl.reason,
                                                                    tl.team_id,
                                                                    tl.checked_out,
                                                                    tl.checked_out_time,
                                                                    tl.is_in_score,
                                                                    tl.picture AS projectteam_picture,
                                                                    t.picture AS team_picture,
                                                                    IF((ISNULL(tl.picture) OR (tl.picture="")),
                                                                            (IF((ISNULL(t.picture) OR (t.picture="")), c.logo_small , t.picture)) , t.picture) AS picture,
                                                                    tl.project_id,

                                                                    t.id,t.name,
                                                                    t.short_name,
                                                                    t.middle_name,
                                                                    t.notes,
                                                                    t.club_id,

                                                                    u.username,
                                                                    u.email,

                                                                    c.email AS club_email,
                                                                    c.logo_small,
                                                                    c.logo_middle,
                                                                    c.logo_big,
                                                                    c.country,
                                                                    c.website,

                                                                    d.name AS division_name,
                                                                    d.shortname AS division_shortname,
                                                                    d.parent_id AS parent_division_id,

                                                                    plg.name AS playground_name,
                                                                    plg.short_name AS playground_short_name,

                                                                    CASE WHEN CHAR_LENGTH(p.alias) THEN CONCAT_WS(':',p.id,p.alias) ELSE p.id END AS project_slug,
                                                                    CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':',t.id,t.alias) ELSE t.id END AS team_slug,
                                                                    CASE WHEN CHAR_LENGTH(d.alias) THEN CONCAT_WS(':',d.id,d.alias) ELSE d.id END AS division_slug,
                                                                    CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':',c.id,c.alias) ELSE c.id END AS club_slug

                                                   
      FROM jos_joomleague_project_team tl
                                                           
      LEFT JOIN jos_joomleague_team t
      ON tl.team_id=t.id
                                                           
      LEFT JOIN jos_users u
      ON tl.admin=u.id
                                                           
      LEFT JOIN jos_joomleague_club c
      ON t.club_id=c.id
                                                           
      LEFT JOIN jos_joomleague_division d
      ON d.id=tl.division_id
                                                           
      LEFT JOIN jos_joomleague_playground plg
      ON plg.id=tl.standard_playground
                                                           
      LEFT JOIN jos_joomleague_project AS p
      ON p.id=tl.project_id

                                                   
      WHERE tl.project_id=20
  290. SELECT p.*, l.country,
                                            CASE WHEN CHAR_LENGTH( p.alias )
                                            THEN CONCAT_WS( ':', p.id, p.alias )
                                            ELSE p.id
                                            END AS slug
                                           
      FROM jos_joomleague_project AS p
                                           
      LEFT JOIN jos_joomleague_league AS l
      ON p.league_id = l.id
                                           
      WHERE p.id='20:-'
      LIMIT 0, 1
  291. SELECT r.id, r.roundcode
      FROM jos_joomleague_round AS r
                                                            
      WHERE r.id =161
  292. SELECT *
      FROM jos_joomleague_round 
      WHERE id = '161'   
      AND project_id = '20'
  293. SELECT  m.*,
                            DATE_FORMAT(m.time_present,"%H:%i") time_present,
                            playground.name AS playground_name,
                            playground.short_name AS playground_short_name,
                            tt1.project_id, d1.name AS divhome, d2.name AS divaway,
                            CASE WHEN CHAR_LENGTH(t1.alias)
      AND CHAR_LENGTH(t2.alias) THEN CONCAT_WS(':',m.id,CONCAT_WS("_",t1.alias,t2.alias)) ELSE m.id END AS slug
                   
      FROM jos_joomleague_match AS m
                           
      INNER JOIN jos_joomleague_round AS r
      ON m.round_id=r.id
                           
      LEFT JOIN jos_joomleague_project_team AS tt1
      ON m.projectteam1_id=tt1.id
                           
      LEFT JOIN jos_joomleague_project_team AS tt2
      ON m.projectteam2_id=tt2.id
                           
      LEFT JOIN jos_joomleague_team AS t1
      ON t1.id=tt1.team_id
                           
      LEFT JOIN jos_joomleague_team AS t2
      ON t2.id=tt2.team_id
                           
      LEFT JOIN jos_joomleague_division AS d1
      ON tt1.division_id=d1.id
                           
      LEFT JOIN jos_joomleague_division AS d2
      ON tt2.division_id=d2.id
                           
      LEFT JOIN jos_joomleague_playground AS playground
      ON playground.id=m.playground_id
      WHERE m.published=1
                                                              
      AND r.id=161
                                                              
      AND r.project_id=20
      GROUP BY m.id
      ORDER BY m.match_date ASC,m.match_number
  294. SELECT COUNT(*)
      FROM jos_joomleague_match AS
      INNER JOIN jos_joomleague_project_team AS tt1
      ON m.projectteam1_id=tt1.id 
      INNER JOIN jos_joomleague_project_team AS tt2
      ON m.projectteam2_id=tt2.id 
      WHERE m.id=595
      AND (tt1.admin=0 OR tt2.admin=0)
  295. SELECT COUNT(*)
      FROM jos_joomleague_match AS
      INNER JOIN jos_joomleague_project_team AS tt1
      ON m.projectteam1_id=tt1.id 
      INNER JOIN jos_joomleague_project_team AS tt2
      ON m.projectteam2_id=tt2.id 
      WHERE m.id=596
      AND (tt1.admin=0 OR tt2.admin=0)
  296. SELECT  tl.id AS projectteamid,
                                                                    tl.division_id,
                                                                    tl.standard_playground,
                                                                    tl.admin,
                                                                    tl.start_points,
                                                                    tl.points_finally,
                                                                    tl.neg_points_finally,
                                                                    tl.matches_finally,
                                                                    tl.won_finally,
                                                                    tl.draws_finally,
                                                                    tl.lost_finally,
                                                                    tl.homegoals_finally,
                                                                    tl.guestgoals_finally,
                                                                    tl.diffgoals_finally,
                                                                    tl.info,
                                                                    tl.reason,
                                                                    tl.team_id,
                                                                    tl.checked_out,
                                                                    tl.checked_out_time,
                                                                    tl.is_in_score,
                                                                    tl.picture AS projectteam_picture,
                                                                    t.picture AS team_picture,
                                                                    IF((ISNULL(tl.picture) OR (tl.picture="")),
                                                                            (IF((ISNULL(t.picture) OR (t.picture="")), c.logo_small , t.picture)) , t.picture) AS picture,
                                                                    tl.project_id,

                                                                    t.id,t.name,
                                                                    t.short_name,
                                                                    t.middle_name,
                                                                    t.notes,
                                                                    t.club_id,

                                                                    u.username,
                                                                    u.email,

                                                                    c.email AS club_email,
                                                                    c.logo_small,
                                                                    c.logo_middle,
                                                                    c.logo_big,
                                                                    c.country,
                                                                    c.website,

                                                                    d.name AS division_name,
                                                                    d.shortname AS division_shortname,
                                                                    d.parent_id AS parent_division_id,

                                                                    plg.name AS playground_name,
                                                                    plg.short_name AS playground_short_name,

                                                                    CASE WHEN CHAR_LENGTH(p.alias) THEN CONCAT_WS(':',p.id,p.alias) ELSE p.id END AS project_slug,
                                                                    CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':',t.id,t.alias) ELSE t.id END AS team_slug,
                                                                    CASE WHEN CHAR_LENGTH(d.alias) THEN CONCAT_WS(':',d.id,d.alias) ELSE d.id END AS division_slug,
                                                                    CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':',c.id,c.alias) ELSE c.id END AS club_slug

                                                   
      FROM jos_joomleague_project_team tl
                                                           
      LEFT JOIN jos_joomleague_team t
      ON tl.team_id=t.id
                                                           
      LEFT JOIN jos_users u
      ON tl.admin=u.id
                                                           
      LEFT JOIN jos_joomleague_club c
      ON t.club_id=c.id
                                                           
      LEFT JOIN jos_joomleague_division d
      ON d.id=tl.division_id
                                                           
      LEFT JOIN jos_joomleague_playground plg
      ON plg.id=tl.standard_playground
                                                           
      LEFT JOIN jos_joomleague_project AS p
      ON p.id=tl.project_id

                                                   
      WHERE tl.project_id=20
  297. SELECT p.*, l.country,
                                            CASE WHEN CHAR_LENGTH( p.alias )
                                            THEN CONCAT_WS( ':', p.id, p.alias )
                                            ELSE p.id
                                            END AS slug
                                           
      FROM jos_joomleague_project AS p
                                           
      LEFT JOIN jos_joomleague_league AS l
      ON p.league_id = l.id
                                           
      WHERE p.id='20:-'
      LIMIT 0, 1
  298. SELECT r.id, r.roundcode
      FROM jos_joomleague_round AS r
                                                            
      WHERE r.id =161
  299. SELECT *
      FROM jos_joomleague_round 
      WHERE id = '161'   
      AND project_id = '20'
  300. SELECT  m.*,
                            DATE_FORMAT(m.time_present,"%H:%i") time_present,
                            playground.name AS playground_name,
                            playground.short_name AS playground_short_name,
                            tt1.project_id, d1.name AS divhome, d2.name AS divaway,
                            CASE WHEN CHAR_LENGTH(t1.alias)
      AND CHAR_LENGTH(t2.alias) THEN CONCAT_WS(':',m.id,CONCAT_WS("_",t1.alias,t2.alias)) ELSE m.id END AS slug
                   
      FROM jos_joomleague_match AS m
                           
      INNER JOIN jos_joomleague_round AS r
      ON m.round_id=r.id
                           
      LEFT JOIN jos_joomleague_project_team AS tt1
      ON m.projectteam1_id=tt1.id
                           
      LEFT JOIN jos_joomleague_project_team AS tt2
      ON m.projectteam2_id=tt2.id
                           
      LEFT JOIN jos_joomleague_team AS t1
      ON t1.id=tt1.team_id
                           
      LEFT JOIN jos_joomleague_team AS t2
      ON t2.id=tt2.team_id
                           
      LEFT JOIN jos_joomleague_division AS d1
      ON tt1.division_id=d1.id
                           
      LEFT JOIN jos_joomleague_division AS d2
      ON tt2.division_id=d2.id
                           
      LEFT JOIN jos_joomleague_playground AS playground
      ON playground.id=m.playground_id
      WHERE m.published=1
                                                              
      AND r.id=161
                                                              
      AND r.project_id=20
      GROUP BY m.id
      ORDER BY m.match_date ASC,m.match_number
  301. SELECT COUNT(*)
      FROM jos_joomleague_match AS
      INNER JOIN jos_joomleague_project_team AS tt1
      ON m.projectteam1_id=tt1.id 
      INNER JOIN jos_joomleague_project_team AS tt2
      ON m.projectteam2_id=tt2.id 
      WHERE m.id=595
      AND (tt1.admin=0 OR tt2.admin=0)
  302. SELECT COUNT(*)
      FROM jos_joomleague_match AS
      INNER JOIN jos_joomleague_project_team AS tt1
      ON m.projectteam1_id=tt1.id 
      INNER JOIN jos_joomleague_project_team AS tt2
      ON m.projectteam2_id=tt2.id 
      WHERE m.id=596
      AND (tt1.admin=0 OR tt2.admin=0)
  303. SELECT  tl.id AS projectteamid,
                                                                    tl.division_id,
                                                                    tl.standard_playground,
                                                                    tl.admin,
                                                                    tl.start_points,
                                                                    tl.points_finally,
                                                                    tl.neg_points_finally,
                                                                    tl.matches_finally,
                                                                    tl.won_finally,
                                                                    tl.draws_finally,
                                                                    tl.lost_finally,
                                                                    tl.homegoals_finally,
                                                                    tl.guestgoals_finally,
                                                                    tl.diffgoals_finally,
                                                                    tl.info,
                                                                    tl.reason,
                                                                    tl.team_id,
                                                                    tl.checked_out,
                                                                    tl.checked_out_time,
                                                                    tl.is_in_score,
                                                                    tl.picture AS projectteam_picture,
                                                                    t.picture AS team_picture,
                                                                    IF((ISNULL(tl.picture) OR (tl.picture="")),
                                                                            (IF((ISNULL(t.picture) OR (t.picture="")), c.logo_small , t.picture)) , t.picture) AS picture,
                                                                    tl.project_id,

                                                                    t.id,t.name,
                                                                    t.short_name,
                                                                    t.middle_name,
                                                                    t.notes,
                                                                    t.club_id,

                                                                    u.username,
                                                                    u.email,

                                                                    c.email AS club_email,
                                                                    c.logo_small,
                                                                    c.logo_middle,
                                                                    c.logo_big,
                                                                    c.country,
                                                                    c.website,

                                                                    d.name AS division_name,
                                                                    d.shortname AS division_shortname,
                                                                    d.parent_id AS parent_division_id,

                                                                    plg.name AS playground_name,
                                                                    plg.short_name AS playground_short_name,

                                                                    CASE WHEN CHAR_LENGTH(p.alias) THEN CONCAT_WS(':',p.id,p.alias) ELSE p.id END AS project_slug,
                                                                    CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':',t.id,t.alias) ELSE t.id END AS team_slug,
                                                                    CASE WHEN CHAR_LENGTH(d.alias) THEN CONCAT_WS(':',d.id,d.alias) ELSE d.id END AS division_slug,
                                                                    CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':',c.id,c.alias) ELSE c.id END AS club_slug

                                                   
      FROM jos_joomleague_project_team tl
                                                           
      LEFT JOIN jos_joomleague_team t
      ON tl.team_id=t.id
                                                           
      LEFT JOIN jos_users u
      ON tl.admin=u.id
                                                           
      LEFT JOIN jos_joomleague_club c
      ON t.club_id=c.id
                                                           
      LEFT JOIN jos_joomleague_division d
      ON d.id=tl.division_id
                                                           
      LEFT JOIN jos_joomleague_playground plg
      ON plg.id=tl.standard_playground
                                                           
      LEFT JOIN jos_joomleague_project AS p
      ON p.id=tl.project_id

                                                   
      WHERE tl.project_id=20
  304. SELECT params
      FROM jos_advancedmodules
      WHERE moduleid = 17
  305. SELECT time, visits, guests, members, bots 
      FROM jos_vvcounter_logs 
      WHERE '1=1' 
      AND time > 1575997200
  306. SELECT session_id, time, guest, DATA 
      FROM jos_session 
      WHERE '1=1' 
      AND time >= 1576066649
  307. SELECT time, visits, guests, members, bots 
      FROM jos_vvcounter_logs 
      WHERE '1=1' 
      AND time <= 1575997200
  308. SELECT time, visits, guests, members, bots 
      FROM jos_vvcounter_logs 
      WHERE '1=1' 
      AND time > 1575910800 
      AND time <= 1575997200
  309. SELECT time, visits, guests, members, bots 
      FROM jos_vvcounter_logs 
      WHERE '1=1' 
      AND time > 1575738000 
      AND time <= 1575997200
  310. SELECT time, visits, guests, members, bots 
      FROM jos_vvcounter_logs 
      WHERE '1=1' 
      AND time > 1575133200 
      AND time <= 1575738000
  311. SELECT time, visits, guests, members, bots 
      FROM jos_vvcounter_logs 
      WHERE '1=1' 
      AND time > 1575133200 
      AND time <= 1575997200
  312. SELECT time, visits, guests, members, bots 
      FROM jos_vvcounter_logs 
      WHERE '1=1' 
      AND time > 1572541200 
      AND time <= 1575133200
  313. SELECT bid, imageurl, custombannercode
      FROM jos_banner
      WHERE showBanner = '1'
      AND (bid IN (13))
      ORDER BY bid

Языковые файлы загружены

Диагностика непереведённых строк

Нет

Дизайнер непереведённых строк

Нет