SELECT *
FROM jos_session
WHERE session_id = 'qon42d6bq1tmlvmtbn9r16sbi5'
DELETE
FROM jos_session
WHERE ( time < '1576042719' )
SELECT *
FROM jos_session
WHERE session_id = 'qon42d6bq1tmlvmtbn9r16sbi5'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'qon42d6bq1tmlvmtbn9r16sbi5','1576066719','','0','1','0' )
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS type, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT MAX(time)
FROM jos_vvcounter_logs
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
SELECT *
FROM jos_community_config
WHERE name = 'config'
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 110)
ORDER BY menuid DESC
LIMIT 0, 1
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
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`groups` AS _groups, a.`friendcount` AS _friendcount, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='0'
SELECT *
FROM `jos_community_users`
WHERE `userid`='0'
ORDER BY `posted_on` DESC
LIMIT 1
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community&view=frontpage%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community&view=register%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'
SELECT COUNT(*)
FROM `jos_users`
WHERE `block`='0'
SELECT *
FROM `jos_users`
WHERE `block`='0'
ORDER BY `registerDate` DESC
LIMIT 32
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`friendcount` AS _friendcount, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session`s
ON s.`userid`=a.`userid`
WHERE a.`userid` IN (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)
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
SELECT COUNT(*)
FROM `jos_users`
WHERE `block`='0'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community&view=profile%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'
SELECT `id`
FROM `jos_menu`
WHERE `link` = 'index.php?option=com_community&view=frontpage'
AND `published`='1'
AND `type`='component'
SELECT *
FROM `jos_community_users`
WHERE `userid`='1919'
ORDER BY `posted_on` DESC
LIMIT 1
SELECT *
FROM `jos_community_users`
WHERE `userid`='1930'
ORDER BY `posted_on` DESC
LIMIT 1
SELECT *
FROM `jos_community_users`
WHERE `userid`='1926'
ORDER BY `posted_on` DESC
LIMIT 1
SELECT *
FROM `jos_community_users`
WHERE `userid`='1936'
ORDER BY `posted_on` DESC
LIMIT 1
SELECT *
FROM `jos_community_users`
WHERE `userid`='1932'
ORDER BY `posted_on` DESC
LIMIT 1
SELECT *
FROM `jos_community_users`
WHERE `userid`='1925'
ORDER BY `posted_on` DESC
LIMIT 1
SELECT *
FROM `jos_community_users`
WHERE `userid`='1917'
ORDER BY `posted_on` DESC
LIMIT 1
SELECT *
FROM `jos_community_users`
WHERE `userid`='1913'
ORDER BY `posted_on` DESC
LIMIT 1
SELECT *
FROM `jos_community_users`
WHERE `userid`='1941'
ORDER BY `posted_on` DESC
LIMIT 1
SELECT *
FROM `jos_community_users`
WHERE `userid`='1912'
ORDER BY `posted_on` DESC
LIMIT 1
SELECT *
FROM `jos_community_users`
WHERE `userid`='1914'
ORDER BY `posted_on` DESC
LIMIT 1
SELECT *
FROM `jos_community_users`
WHERE `userid`='1923'
ORDER BY `posted_on` DESC
LIMIT 1
SELECT *
FROM `jos_community_users`
WHERE `userid`='1934'
ORDER BY `posted_on` DESC
LIMIT 1
SELECT *
FROM `jos_community_users`
WHERE `userid`='1939'
ORDER BY `posted_on` DESC
LIMIT 1
SELECT *
FROM `jos_community_users`
WHERE `userid`='1933'
ORDER BY `posted_on` DESC
LIMIT 1
SELECT *
FROM `jos_community_users`
WHERE `userid`='1942'
ORDER BY `posted_on` DESC
LIMIT 1
SELECT *
FROM `jos_community_users`
WHERE `userid`='1916'
ORDER BY `posted_on` DESC
LIMIT 1
SELECT *
FROM `jos_community_users`
WHERE `userid`='1921'
ORDER BY `posted_on` DESC
LIMIT 1
SELECT *
FROM `jos_community_users`
WHERE `userid`='1929'
ORDER BY `posted_on` DESC
LIMIT 1
SELECT *
FROM `jos_community_users`
WHERE `userid`='1935'
ORDER BY `posted_on` DESC
LIMIT 1
SELECT *
FROM `jos_community_users`
WHERE `userid`='1922'
ORDER BY `posted_on` DESC
LIMIT 1
SELECT *
FROM `jos_community_users`
WHERE `userid`='1918'
ORDER BY `posted_on` DESC
LIMIT 1
SELECT *
FROM `jos_community_users`
WHERE `userid`='1920'
ORDER BY `posted_on` DESC
LIMIT 1
SELECT *
FROM `jos_community_users`
WHERE `userid`='1928'
ORDER BY `posted_on` DESC
LIMIT 1
SELECT *
FROM `jos_community_users`
WHERE `userid`='1943'
ORDER BY `posted_on` DESC
LIMIT 1
SELECT *
FROM `jos_community_users`
WHERE `userid`='1915'
ORDER BY `posted_on` DESC
LIMIT 1
SELECT *
FROM `jos_community_users`
WHERE `userid`='1924'
ORDER BY `posted_on` DESC
LIMIT 1
SELECT *
FROM `jos_community_users`
WHERE `userid`='1931'
ORDER BY `posted_on` DESC
LIMIT 1
SELECT *
FROM `jos_community_users`
WHERE `userid`='1927'
ORDER BY `posted_on` DESC
LIMIT 1
SELECT *
FROM `jos_community_users`
WHERE `userid`='1938'
ORDER BY `posted_on` DESC
LIMIT 1
SELECT *
FROM `jos_community_users`
WHERE `userid`='1940'
ORDER BY `posted_on` DESC
LIMIT 1
SELECT *
FROM `jos_community_users`
WHERE `userid`='1937'
ORDER BY `posted_on` DESC
LIMIT 1
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community&view=search%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'
SELECT *
FROM `jos_community_groups` AS a
WHERE a.`published`='1'
ORDER BY a.`created` DESC
LIMIT 0 , 5
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'
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'
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'
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'
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'
SELECT COUNT(*)
FROM `jos_community_groups` AS a
WHERE a.`published`='1'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community&view=groups%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'
SELECT *
FROM jos_community_groups
WHERE id = '6'
SELECT *
FROM jos_community_groups
WHERE id = '6'
SELECT *
FROM jos_community_groups
WHERE id = '5'
SELECT *
FROM jos_community_groups
WHERE id = '4'
SELECT *
FROM jos_community_groups
WHERE id = '3'
SELECT *
FROM jos_community_groups
WHERE id = '2'
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
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)
SELECT COUNT(*)
FROM `jos_community_wall`
WHERE `type` = 'videos'
AND `published` = '1'
AND `contentid` = '122'
SELECT COUNT(*)
FROM `jos_community_wall`
WHERE `type` = 'videos'
AND `published` = '1'
AND `contentid` = '121'
SELECT COUNT(*)
FROM `jos_community_wall`
WHERE `type` = 'videos'
AND `published` = '1'
AND `contentid` = '120'
SELECT COUNT(*)
FROM `jos_community_wall`
WHERE `type` = 'videos'
AND `published` = '1'
AND `contentid` = '118'
SELECT COUNT(*)
FROM `jos_community_wall`
WHERE `type` = 'videos'
AND `published` = '1'
AND `contentid` = '117'
SELECT COUNT(*)
FROM `jos_community_wall`
WHERE `type` = 'videos'
AND `published` = '1'
AND `contentid` = '116'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community&view=videos%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`groups` AS _groups, a.`friendcount` AS _friendcount, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='126'
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
SELECT *
FROM jos_community_videos
WHERE id = '116'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`groups` AS _groups, a.`friendcount` AS _friendcount, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='62'
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
SELECT *
FROM jos_community_videos
WHERE id = '121'
SELECT *
FROM jos_community_videos
WHERE id = '118'
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
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`groups` AS _groups, a.`friendcount` AS _friendcount, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='96'
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
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`groups` AS _groups, a.`friendcount` AS _friendcount, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='73'
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
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`groups` AS _groups, a.`friendcount` AS _friendcount, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='123'
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
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community&view=photos%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'
SELECT DISTINCT a.*
FROM `jos_community_events` AS a
LEFT JOIN `jos_community_groups` AS g
ON g.`id` = a.`contentid`
WHERE a.`published`='1'
AND (g.`approvals` = '0' OR g.`approvals` IS NULL)
AND a.`enddate` > '2019-12-11 12:18:39'
ORDER BY a.`startdate` ASC
LIMIT 0, 5
SELECT COUNT(DISTINCT(a.`id`))
FROM `jos_community_events` AS a
LEFT JOIN `jos_community_groups` AS g
ON g.`id` = a.`contentid`
WHERE a.`published`='1'
AND (g.`approvals` = '0' OR g.`approvals` IS NULL)
AND a.`enddate` > '2019-12-11 12:18:39'
SELECT COUNT(DISTINCT(a.`id`))
FROM `jos_community_events` AS a
LEFT JOIN `jos_community_groups` AS g
ON g.`id` = a.`contentid`
WHERE a.`published`='1'
AND (g.`approvals` = '0' OR g.`approvals` IS NULL)
AND a.`enddate` > '2019-12-11 12:18:39'
SELECT `id`
FROM `jos_menu`
WHERE `link` LIKE '%option=com_community&view=events%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'
SELECT *
FROM jos_community_events
WHERE id = '1'
SELECT id
FROM jos_core_acl_aro
WHERE section_value='users'
AND value='0'
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
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
SELECT a.*
FROM `jos_community_wall` AS a
WHERE ( a.`type`='events'
AND a.`contentid` IN (76,75,74,73,72,71,70,69,68,67,66,65,64,63,62,61,60,59,58,57,56,55,54,52,53,51,50,49,48,47,46,45,44,43,42,41,40,39,38,37,36,35,34,33,32,31,30,29,28,27,26,25,24,23,22,21,20,19,18,17,16,15,14,13,12,11,10,9,8,6,7,5,4,3,2,1) ) OR ( a.`type`='profile.avatar.upload'
AND a.`contentid` IN (102,238,165,175) ) OR ( a.`type`='profile.status'
AND a.`contentid` IN (1131,1128,1127,1126,1125,1124,1123,1122,1121,1120,1119,1118,1117,1116,1115,1114,1113,1112,1111,1110,1109,1108,1107,1104,1103,1102,1101,1100,1099,1097,1059,1057,1056,1055,1054,1047,1029,991,608) ) OR ( a.`type`='videos'
AND a.`contentid` IN (122,121,120,118,117,116,115,114,113,112,111,110,109,108,107,106,105,104,103,102,101,100,99,98,97,96,95,94,93,91,90,89,88,87,86,85,84,83,82,81,80,79,78,77,76,75,74,73,72,71,70,69,68,67,66,65,64,63,62,61,60,59,58,57,56,55,54,53,52,51,50,49,48,47,46,45,44,43,42,41,39,36,32,28,27,24,21) ) OR ( a.`type`='photos.album'
AND a.`contentid` IN (17,15) ) OR ( a.`type`='photos.wall.create'
AND a.`contentid` IN (959,958,957,955,773,772,771,746,733) )
ORDER BY `id` DESC
SELECT a.*
FROM `jos_community_likes` AS a
WHERE ( a.`element`='events'
AND a.`uid` IN (76,75,74,73,72,71,70,69,68,67,66,65,64,63,62,61,60,59,58,57,56,55,54,52,53,51,50,49,48,47,46,45,44,43,42,41,40,39,38,37,36,35,34,33,32,31,30,29,28,27,26,25,24,23,22,21,20,19,18,17,16,15,14,13,12,11,10,9,8,6,7,5,4,3,2,1) ) OR ( a.`element`='profile.avatar.upload'
AND a.`uid` IN (102,238,165,175) ) OR ( a.`element`='profile.status'
AND a.`uid` IN (1131,1128,1127,1126,1125,1124,1123,1122,1121,1120,1119,1118,1117,1116,1115,1114,1113,1112,1111,1110,1109,1108,1107,1104,1103,1102,1101,1100,1099,1097,1059,1057,1056,1055,1054,1047,1029,991,608) ) OR ( a.`element`='videos'
AND a.`uid` IN (122,121,120,118,117,116,115,114,113,112,111,110,109,108,107,106,105,104,103,102,101,100,99,98,97,96,95,94,93,91,90,89,88,87,86,85,84,83,82,81,80,79,78,77,76,75,74,73,72,71,70,69,68,67,66,65,64,63,62,61,60,59,58,57,56,55,54,53,52,51,50,49,48,47,46,45,44,43,42,41,39,36,32,28,27,24,21) ) OR ( a.`element`='photos.album'
AND a.`uid` IN (17,15) ) OR ( a.`element`='photos.wall.create'
AND a.`uid` IN (959,958,957,955,773,772,771,746,733) )
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`groups` AS _groups, a.`friendcount` AS _friendcount, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='1852'
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
SELECT `name`
FROM `jos_plugins`
WHERE `element`='events'
AND `folder`='community'
SELECT *
FROM jos_community_events
WHERE id = '76'
SELECT *
FROM jos_community_events
WHERE id = '76'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`groups` AS _groups, a.`friendcount` AS _friendcount, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='1817'
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
SELECT `name`
FROM `jos_plugins`
WHERE `element`='events'
AND `folder`='community'
SELECT *
FROM jos_community_events
WHERE id = '75'
SELECT *
FROM jos_community_events
WHERE id = '75'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`groups` AS _groups, a.`friendcount` AS _friendcount, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='1796'
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
SELECT `name`
FROM `jos_plugins`
WHERE `element`='events'
AND `folder`='community'
SELECT *
FROM jos_community_events
WHERE id = '74'
SELECT *
FROM jos_community_events
WHERE id = '74'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`groups` AS _groups, a.`friendcount` AS _friendcount, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='1789'
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
SELECT `name`
FROM `jos_plugins`
WHERE `element`='events'
AND `folder`='community'
SELECT *
FROM jos_community_events
WHERE id = '73'
SELECT *
FROM jos_community_events
WHERE id = '73'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`groups` AS _groups, a.`friendcount` AS _friendcount, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='1793'
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
SELECT `name`
FROM `jos_plugins`
WHERE `element`='events'
AND `folder`='community'
SELECT *
FROM jos_community_events
WHERE id = '72'
SELECT *
FROM jos_community_events
WHERE id = '72'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`groups` AS _groups, a.`friendcount` AS _friendcount, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='1788'
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
SELECT `name`
FROM `jos_plugins`
WHERE `element`='events'
AND `folder`='community'
SELECT *
FROM jos_community_events
WHERE id = '71'
SELECT *
FROM jos_community_events
WHERE id = '71'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`groups` AS _groups, a.`friendcount` AS _friendcount, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='1791'
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
SELECT `name`
FROM `jos_plugins`
WHERE `element`='events'
AND `folder`='community'
SELECT *
FROM jos_community_events
WHERE id = '70'
SELECT *
FROM jos_community_events
WHERE id = '70'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`groups` AS _groups, a.`friendcount` AS _friendcount, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='1794'
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
SELECT `name`
FROM `jos_plugins`
WHERE `element`='events'
AND `folder`='community'
SELECT *
FROM jos_community_events
WHERE id = '69'
SELECT *
FROM jos_community_events
WHERE id = '69'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`groups` AS _groups, a.`friendcount` AS _friendcount, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='1795'
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
SELECT `name`
FROM `jos_plugins`
WHERE `element`='events'
AND `folder`='community'
SELECT *
FROM jos_community_events
WHERE id = '68'
SELECT *
FROM jos_community_events
WHERE id = '68'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`groups` AS _groups, a.`friendcount` AS _friendcount, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='1784'
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
SELECT `name`
FROM `jos_plugins`
WHERE `element`='events'
AND `folder`='community'
SELECT *
FROM jos_community_events
WHERE id = '67'
SELECT *
FROM jos_community_events
WHERE id = '67'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`groups` AS _groups, a.`friendcount` AS _friendcount, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='1787'
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
SELECT `name`
FROM `jos_plugins`
WHERE `element`='events'
AND `folder`='community'
SELECT *
FROM jos_community_events
WHERE id = '66'
SELECT *
FROM jos_community_events
WHERE id = '66'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`groups` AS _groups, a.`friendcount` AS _friendcount, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='1792'
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
SELECT `name`
FROM `jos_plugins`
WHERE `element`='events'
AND `folder`='community'
SELECT *
FROM jos_community_events
WHERE id = '65'
SELECT *
FROM jos_community_events
WHERE id = '65'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`groups` AS _groups, a.`friendcount` AS _friendcount, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='1790'
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
SELECT `name`
FROM `jos_plugins`
WHERE `element`='events'
AND `folder`='community'
SELECT *
FROM jos_community_events
WHERE id = '64'
SELECT *
FROM jos_community_events
WHERE id = '64'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`groups` AS _groups, a.`friendcount` AS _friendcount, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='1779'
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
SELECT `name`
FROM `jos_plugins`
WHERE `element`='events'
AND `folder`='community'
SELECT *
FROM jos_community_events
WHERE id = '63'
SELECT *
FROM jos_community_events
WHERE id = '63'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`groups` AS _groups, a.`friendcount` AS _friendcount, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='1786'
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
SELECT `name`
FROM `jos_plugins`
WHERE `element`='events'
AND `folder`='community'
SELECT *
FROM jos_community_events
WHERE id = '62'
SELECT *
FROM jos_community_events
WHERE id = '62'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`groups` AS _groups, a.`friendcount` AS _friendcount, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='1782'
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
SELECT `name`
FROM `jos_plugins`
WHERE `element`='events'
AND `folder`='community'
SELECT *
FROM jos_community_events
WHERE id = '61'
SELECT *
FROM jos_community_events
WHERE id = '61'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`groups` AS _groups, a.`friendcount` AS _friendcount, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='1781'
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
SELECT `name`
FROM `jos_plugins`
WHERE `element`='events'
AND `folder`='community'
SELECT *
FROM jos_community_events
WHERE id = '60'
SELECT *
FROM jos_community_events
WHERE id = '60'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`groups` AS _groups, a.`friendcount` AS _friendcount, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='1797'
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
SELECT `name`
FROM `jos_plugins`
WHERE `element`='events'
AND `folder`='community'
SELECT *
FROM jos_community_events
WHERE id = '59'
SELECT *
FROM jos_community_events
WHERE id = '59'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`groups` AS _groups, a.`friendcount` AS _friendcount, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='1783'
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
SELECT `name`
FROM `jos_plugins`
WHERE `element`='events'
AND `folder`='community'
SELECT *
FROM jos_community_events
WHERE id = '58'
SELECT *
FROM jos_community_events
WHERE id = '58'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`groups` AS _groups, a.`friendcount` AS _friendcount, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='1780'
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
SELECT `name`
FROM `jos_plugins`
WHERE `element`='events'
AND `folder`='community'
SELECT *
FROM jos_community_events
WHERE id = '57'
SELECT *
FROM jos_community_events
WHERE id = '57'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`groups` AS _groups, a.`friendcount` AS _friendcount, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='1785'
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
SELECT `name`
FROM `jos_plugins`
WHERE `element`='events'
AND `folder`='community'
SELECT *
FROM jos_community_events
WHERE id = '56'
SELECT *
FROM jos_community_events
WHERE id = '56'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`groups` AS _groups, a.`friendcount` AS _friendcount, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='1777'
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
SELECT `name`
FROM `jos_plugins`
WHERE `element`='events'
AND `folder`='community'
SELECT *
FROM jos_community_events
WHERE id = '55'
SELECT *
FROM jos_community_events
WHERE id = '55'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`groups` AS _groups, a.`friendcount` AS _friendcount, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='1773'
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
SELECT `name`
FROM `jos_plugins`
WHERE `element`='events'
AND `folder`='community'
SELECT *
FROM jos_community_events
WHERE id = '54'
SELECT *
FROM jos_community_events
WHERE id = '54'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`groups` AS _groups, a.`friendcount` AS _friendcount, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='1771'
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
SELECT `name`
FROM `jos_plugins`
WHERE `element`='events'
AND `folder`='community'
SELECT *
FROM jos_community_events
WHERE id = '52'
SELECT *
FROM jos_community_events
WHERE id = '52'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`groups` AS _groups, a.`friendcount` AS _friendcount, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='1772'
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
SELECT `name`
FROM `jos_plugins`
WHERE `element`='events'
AND `folder`='community'
SELECT *
FROM jos_community_events
WHERE id = '53'
SELECT *
FROM jos_community_events
WHERE id = '53'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`groups` AS _groups, a.`friendcount` AS _friendcount, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='1766'
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
SELECT `name`
FROM `jos_plugins`
WHERE `element`='events'
AND `folder`='community'
SELECT *
FROM jos_community_events
WHERE id = '51'
SELECT *
FROM jos_community_events
WHERE id = '51'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`groups` AS _groups, a.`friendcount` AS _friendcount, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='1765'
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
SELECT `name`
FROM `jos_plugins`
WHERE `element`='events'
AND `folder`='community'
SELECT *
FROM jos_community_events
WHERE id = '50'
SELECT *
FROM jos_community_events
WHERE id = '50'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`groups` AS _groups, a.`friendcount` AS _friendcount, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='1767'
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
SELECT `name`
FROM `jos_plugins`
WHERE `element`='events'
AND `folder`='community'
SELECT *
FROM jos_community_events
WHERE id = '49'
SELECT *
FROM jos_community_events
WHERE id = '49'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friends` AS _friends, a.`groups` AS _groups, a.`friendcount` AS _friendcount, a.`alias` AS _alias, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, a.`search_email` AS _search_email, s.`userid` AS _isonline, u.*
FROM `jos_community_users` AS a
LEFT JOIN `jos_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jos_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='1769'
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
SELECT `name`
FROM `jos_plugins`
WHERE `element`='events'
AND `folder`='community'
SELECT *
FROM jos_community_events
WHERE id = '48'
SELECT *
FROM jos_community_events
WHERE id = '48'
SELECT COUNT(1)
FROM `jos_community_activities`
SELECT COUNT(1)
FROM `jos_community_activities`
SELECT DISTINCT(a.`id`)
FROM `jos_users` AS a
INNER JOIN `jos_session` AS b
ON a.`id`=b.`userid`
WHERE a.`block`='0'
AND `client_id` != '1'
ORDER BY b.`time` DESC
LIMIT 20
SELECT id
FROM jos_core_acl_aro
WHERE section_value='users'
AND value='0'
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
SELECT extension
FROM jos_joomleague_project
WHERE id='20'
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'
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'
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
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
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
SELECT r.id, r.roundcode
FROM jos_joomleague_round AS r
WHERE r.id =161
SELECT *
FROM jos_joomleague_round
WHERE id = '161'
AND project_id = '20'
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
SELECT COUNT(*)
FROM jos_joomleague_match AS m
INNER JOIN jos_joomleague_project_team AS tt1
ON m.projectteam1_id=tt1.id
INNER JOIN jos_joomleague_project_team AS tt2
ON m.projectteam2_id=tt2.id
WHERE m.id=595
AND (tt1.admin=0 OR tt2.admin=0)
SELECT COUNT(*)
FROM jos_joomleague_match AS m
INNER JOIN jos_joomleague_project_team AS tt1
ON m.projectteam1_id=tt1.id
INNER JOIN jos_joomleague_project_team AS tt2
ON m.projectteam2_id=tt2.id
WHERE m.id=596
AND (tt1.admin=0 OR tt2.admin=0)
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
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
SELECT r.id, r.roundcode
FROM jos_joomleague_round AS r
WHERE r.id =161
SELECT *
FROM jos_joomleague_round
WHERE id = '161'
AND project_id = '20'
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
SELECT COUNT(*)
FROM jos_joomleague_match AS m
INNER JOIN jos_joomleague_project_team AS tt1
ON m.projectteam1_id=tt1.id
INNER JOIN jos_joomleague_project_team AS tt2
ON m.projectteam2_id=tt2.id
WHERE m.id=595
AND (tt1.admin=0 OR tt2.admin=0)
SELECT COUNT(*)
FROM jos_joomleague_match AS m
INNER JOIN jos_joomleague_project_team AS tt1
ON m.projectteam1_id=tt1.id
INNER JOIN jos_joomleague_project_team AS tt2
ON m.projectteam2_id=tt2.id
WHERE m.id=596
AND (tt1.admin=0 OR tt2.admin=0)
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
SELECT params
FROM jos_advancedmodules
WHERE moduleid = 17
SELECT time, visits, guests, members, bots
FROM jos_vvcounter_logs
WHERE '1=1'
AND time > 1575997200
SELECT session_id, time, guest, DATA
FROM jos_session
WHERE '1=1'
AND time >= 1576066649
SELECT time, visits, guests, members, bots
FROM jos_vvcounter_logs
WHERE '1=1'
AND time <= 1575997200
SELECT time, visits, guests, members, bots
FROM jos_vvcounter_logs
WHERE '1=1'
AND time > 1575910800
AND time <= 1575997200
SELECT time, visits, guests, members, bots
FROM jos_vvcounter_logs
WHERE '1=1'
AND time > 1575738000
AND time <= 1575997200
SELECT time, visits, guests, members, bots
FROM jos_vvcounter_logs
WHERE '1=1'
AND time > 1575133200
AND time <= 1575738000
SELECT time, visits, guests, members, bots
FROM jos_vvcounter_logs
WHERE '1=1'
AND time > 1575133200
AND time <= 1575997200
SELECT time, visits, guests, members, bots
FROM jos_vvcounter_logs
WHERE '1=1'
AND time > 1572541200
AND time <= 1575133200
SELECT bid, imageurl, custombannercode
FROM jos_banner
WHERE showBanner = '1'
AND (bid IN (13))
ORDER BY bid