Get Connected!
- Connect and expand your network
- View profiles and add new friends
- Share your photos and videos
- Create your own group or join others
On Proofform |
Join Proofform |
Get Help |
Follow Us |
| Articles Groups Photos Videos Links Gifts |
Sign up Terms Privacy Policy About us |
Help & FAQs Safety Tips Sitemap Privacy Settings Privacy Policy |
Facebook |
Copyright © 2009-2012 Proofform Team Inc. All Rights Reserved
Performed SQL enquiries
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 jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content WHERE jf_content.language_id=1 AND jf_content.published=1 AND jf_content.reference_id IN(283,285,236,269,284,286,239,273,287,295,270,291,132,271,272,274,290,282,233,242,275,276,277,278,279,280,281) AND jf_content.reference_table='menu'
SELECT template FROM jos_templates_menu WHERE client_id = 0 AND (menuid = 0 OR menuid = 236) ORDER BY menuid DESC LIMIT 0, 1
SELECT * FROM jos_community_config WHERE name = 'config'
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.`events` as _events, 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_mailq` WHERE `status`='0' LIMIT 0,100
SELECT `position` FROM `jos_community_apps` WHERE `apps`='giftexchangesend' AND `userid`='0'
SELECT `id` FROM `jos_community_apps` WHERE `apps`='giftexchangesend' AND `userid`='0'
SELECT `params` FROM `jos_community_apps` WHERE `id`=''
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 jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content WHERE jf_content.language_id=1 AND jf_content.published=1 AND jf_content.reference_id IN(167,278,1,273,279,290) AND jf_content.reference_table='modules'
SELECT * from `jos_community_users` WHERE `userid`='0' AND (`status_access` <= 10) 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 jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content WHERE jf_content.language_id=1 AND jf_content.published=1 AND jf_content.reference_id IN(236) AND jf_content.reference_table='menu'
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 jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content WHERE jf_content.language_id=1 AND jf_content.published=1 AND jf_content.reference_id IN(236) AND jf_content.reference_table='menu'
SELECT `id` FROM `jos_menu` WHERE `link` LIKE '%option=com_community&view=register%' AND `published`='1' AND `menutype`!='jomsocial' AND `type`='component'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content WHERE jf_content.language_id=1 AND jf_content.published=1 AND jf_content.reference_id IN(287) AND jf_content.reference_table='menu'
SELECT COUNT(*) FROM `jos_users` WHERE `block`='0'
SELECT * FROM `jos_users` WHERE `block`='0' ORDER BY `registerDate` DESC LIMIT 48
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content WHERE jf_content.language_id=1 AND jf_content.published=1 AND jf_content.reference_id IN(1846,1841,1838,1837,1831,1825,1824,1823,1822,1821,1820,1819,1818,1817,1816,1815,1814,1813,1812,1811,1810,1809,1808,1807,1806,1802,1801,1800,1799,1798,1797,1796,1795,1794,1793,1791,1789,1788,1787,1786,1785,1784,1783,1782,1781,1780,1779,1778) AND jf_content.reference_table='users'
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.`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 (1846,1841,1838,1837,1831,1825,1824,1823,1822,1821,1820,1819,1818,1817,1816,1815,1814,1813,1812,1811,1810,1809,1808,1807,1806,1802,1801,1800,1799,1798,1797,1796,1795,1794,1793,1791,1789,1788,1787,1786,1785,1784,1783,1782,1781,1780,1779,1778)
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content WHERE jf_content.language_id=1 AND jf_content.published=1 AND jf_content.reference_id IN(1778,1779,1780,1781,1782,1783,1784,1785,1786,1787,1788,1789,1791,1793,1794,1795,1796,1797,1798,1799,1800,1801,1802,1806,1807,1808,1809,1810,1811,1812,1813,1814,1815,1816,1817,1818,1819,1820,1821,1822,1823,1824,1825,1831,1837,1838,1841,1846) AND jf_content.reference_table='users'
SELECT COUNT(*) FROM `jos_users` WHERE `block`='0'
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='10'
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='9'
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='8'
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='7'
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` 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 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, 16
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` = '3496'
SELECT COUNT(*) FROM `jos_community_wall` WHERE `type` = 'videos' AND `published` = '1' AND `contentid` = '3495'
SELECT COUNT(*) FROM `jos_community_wall` WHERE `type` = 'videos' AND `published` = '1' AND `contentid` = '3494'
SELECT COUNT(*) FROM `jos_community_wall` WHERE `type` = 'videos' AND `published` = '1' AND `contentid` = '3493'
SELECT COUNT(*) FROM `jos_community_wall` WHERE `type` = 'videos' AND `published` = '1' AND `contentid` = '3492'
SELECT COUNT(*) FROM `jos_community_wall` WHERE `type` = 'videos' AND `published` = '1' AND `contentid` = '3491'
SELECT COUNT(*) FROM `jos_community_wall` WHERE `type` = 'videos' AND `published` = '1' AND `contentid` = '3489'
SELECT COUNT(*) FROM `jos_community_wall` WHERE `type` = 'videos' AND `published` = '1' AND `contentid` = '3488'
SELECT COUNT(*) FROM `jos_community_wall` WHERE `type` = 'videos' AND `published` = '1' AND `contentid` = '3487'
SELECT COUNT(*) FROM `jos_community_wall` WHERE `type` = 'videos' AND `published` = '1' AND `contentid` = '3486'
SELECT COUNT(*) FROM `jos_community_wall` WHERE `type` = 'videos' AND `published` = '1' AND `contentid` = '3485'
SELECT COUNT(*) FROM `jos_community_wall` WHERE `type` = 'videos' AND `published` = '1' AND `contentid` = '3484'
SELECT COUNT(*) FROM `jos_community_wall` WHERE `type` = 'videos' AND `published` = '1' AND `contentid` = '3479'
SELECT COUNT(*) FROM `jos_community_wall` WHERE `type` = 'videos' AND `published` = '1' AND `contentid` = '3478'
SELECT COUNT(*) FROM `jos_community_wall` WHERE `type` = 'videos' AND `published` = '1' AND `contentid` = '3477'
SELECT COUNT(*) FROM `jos_community_wall` WHERE `type` = 'videos' AND `published` = '1' AND `contentid` = '3476'
SELECT `id` FROM `jos_menu` WHERE `link` LIKE '%option=com_community&view=videos%' AND `published`='1' AND `menutype`!='jomsocial' AND `type`='component'
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.`events` as _events, 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`='63'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content WHERE jf_content.language_id=1 AND jf_content.published=1 AND jf_content.reference_id IN(63) AND jf_content.reference_table='users'
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` > '2012-05-20 00:12:38' AND ((a.`parent`='0' && a.`repeat`='') || (a.`parent`!= 0 && a.`repeat` IS NOT NULL)) 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` > '2012-05-20 00:12:38' AND ((a.`parent`='0' && a.`repeat`='') || (a.`parent`!= 0 && a.`repeat` IS NOT NULL))
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` > '2012-05-20 00:12:38' AND ((a.`parent`='0' && a.`repeat`='') || (a.`parent`!= 0 && a.`repeat` IS NOT NULL))
SELECT `id` FROM `jos_menu` WHERE `link` LIKE '%option=com_community&view=events%' AND `published`='1' AND `menutype`!='jomsocial' AND `type`='component'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content WHERE jf_content.language_id=1 AND jf_content.published=1 AND jf_content.reference_id IN(295) AND jf_content.reference_table='menu'
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('2012-05-20 00:12:38') - TO_DAYS( DATE_ADD(a.`created`, INTERVAL 1 HOUR ) ) as _daydiff FROM `jos_community_activities` as a WHERE 1 AND `archived`=0 AND ( (a.`group_access`='0') OR (a.`groupid` IN ('' ) ) ) AND ( (a.`event_access`='0') OR (a.`eventid` IN ('' ) ) ) AND (a.`access` <= 10) GROUP BY a.`id` ORDER BY a.`created` DESC, a. `id` DESC LIMIT 160
SELECT a.* FROM `jos_community_wall` as a WHERE ( a.`type`='walls' AND a.`contentid` IN (22883,22882,22881,22880,22879,22878,22877,22876,22875,22874,22873,22872,22871,22870,22869,22868,22867,22866,22865,22864,22863,22862,22861,22860,22859,22858,22857,22856,22855,22854,22853,22852,22851,22849,22848,22847,22846,22845,22841,22840,22839,22838,22837,22836,22835,22834,22833,22832,22831,22830,22829,22828,22827,22826,22825,22824,22823,22822,22821,22820,22819) ) OR ( a.`type`='events' AND a.`contentid` IN (103,102,101,100,99,98,97,96,95,94,93,92,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,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) ) OR ( a.`type`='events.wall' AND a.`contentid` IN (22743) ) ORDER BY `id` DESC
SELECT a.* FROM `jos_community_likes` as a WHERE ( a.`element`='walls' AND a.`uid` IN (22883,22882,22881,22880,22879,22878,22877,22876,22875,22874,22873,22872,22871,22870,22869,22868,22867,22866,22865,22864,22863,22862,22861,22860,22859,22858,22857,22856,22855,22854,22853,22852,22851,22849,22848,22847,22846,22845,22841,22840,22839,22838,22837,22836,22835,22834,22833,22832,22831,22830,22829,22828,22827,22826,22825,22824,22823,22822,22821,22820,22819) ) OR ( a.`element`='groups.discussion.reply' AND a.`uid` IN (75) ) OR ( a.`element`='events' AND a.`uid` IN (103,102,101,100,99,98,97,96,95,94,93,92,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,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) ) OR ( a.`element`='events.wall' AND a.`uid` IN (22743) )
SELECT `name` FROM `jos_plugins` WHERE `element`='article' AND `folder`='community'
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.`events` as _events, 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`='1350'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content WHERE jf_content.language_id=1 AND jf_content.published=1 AND jf_content.reference_id IN(1350) AND jf_content.reference_table='users'
SELECT `name` FROM `jos_plugins` WHERE `element`='article' AND `folder`='community'
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.`events` as _events, 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`='1725'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content WHERE jf_content.language_id=1 AND jf_content.published=1 AND jf_content.reference_id IN(1725) AND jf_content.reference_table='users'
SELECT `name` FROM `jos_plugins` WHERE `element`='article' AND `folder`='community'
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.`events` as _events, 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`='1650'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content WHERE jf_content.language_id=1 AND jf_content.published=1 AND jf_content.reference_id IN(1650) AND jf_content.reference_table='users'
SELECT `name` FROM `jos_plugins` WHERE `element`='article' AND `folder`='community'
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.`events` as _events, 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`='1487'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content WHERE jf_content.language_id=1 AND jf_content.published=1 AND jf_content.reference_id IN(1487) AND jf_content.reference_table='users'
SELECT `name` FROM `jos_plugins` WHERE `element`='article' AND `folder`='community'
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.`events` as _events, 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`='457'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content WHERE jf_content.language_id=1 AND jf_content.published=1 AND jf_content.reference_id IN(457) AND jf_content.reference_table='users'
SELECT `name` FROM `jos_plugins` WHERE `element`='article' AND `folder`='community'
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.`events` as _events, 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`='1043'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content WHERE jf_content.language_id=1 AND jf_content.published=1 AND jf_content.reference_id IN(1043) AND jf_content.reference_table='users'
SELECT `name` FROM `jos_plugins` WHERE `element`='article' AND `folder`='community'
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.`events` as _events, 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`='1431'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content WHERE jf_content.language_id=1 AND jf_content.published=1 AND jf_content.reference_id IN(1431) AND jf_content.reference_table='users'
SELECT `name` FROM `jos_plugins` WHERE `element`='article' AND `folder`='community'
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.`events` as _events, 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`='1613'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content WHERE jf_content.language_id=1 AND jf_content.published=1 AND jf_content.reference_id IN(1613) AND jf_content.reference_table='users'
SELECT `name` FROM `jos_plugins` WHERE `element`='article' AND `folder`='community'
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.`events` as _events, 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`='1465'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content WHERE jf_content.language_id=1 AND jf_content.published=1 AND jf_content.reference_id IN(1465) AND jf_content.reference_table='users'
SELECT `name` FROM `jos_plugins` WHERE `element`='article' AND `folder`='community'
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.`events` as _events, 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`='1387'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content WHERE jf_content.language_id=1 AND jf_content.published=1 AND jf_content.reference_id IN(1387) AND jf_content.reference_table='users'
SELECT `name` FROM `jos_plugins` WHERE `element`='article' AND `folder`='community'
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.`events` as _events, 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`='1764'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content WHERE jf_content.language_id=1 AND jf_content.published=1 AND jf_content.reference_id IN(1764) AND jf_content.reference_table='users'
SELECT `name` FROM `jos_plugins` WHERE `element`='article' AND `folder`='community'
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.`events` as _events, 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`='473'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content WHERE jf_content.language_id=1 AND jf_content.published=1 AND jf_content.reference_id IN(473) AND jf_content.reference_table='users'
SELECT `name` FROM `jos_plugins` WHERE `element`='article' AND `folder`='community'
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.`events` as _events, 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`='1663'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content WHERE jf_content.language_id=1 AND jf_content.published=1 AND jf_content.reference_id IN(1663) AND jf_content.reference_table='users'
SELECT `name` FROM `jos_plugins` WHERE `element`='article' AND `folder`='community'
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.`events` as _events, 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`='194'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content WHERE jf_content.language_id=1 AND jf_content.published=1 AND jf_content.reference_id IN(194) AND jf_content.reference_table='users'
SELECT `name` FROM `jos_plugins` WHERE `element`='article' AND `folder`='community'
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.`events` as _events, 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`='1417'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content WHERE jf_content.language_id=1 AND jf_content.published=1 AND jf_content.reference_id IN(1417) AND jf_content.reference_table='users'
SELECT `name` FROM `jos_plugins` WHERE `element`='article' AND `folder`='community'
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.`events` as _events, 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`='418'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content WHERE jf_content.language_id=1 AND jf_content.published=1 AND jf_content.reference_id IN(418) AND jf_content.reference_table='users'
SELECT `name` FROM `jos_plugins` WHERE `element`='article' AND `folder`='community'
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.`events` as _events, 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`='507'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content WHERE jf_content.language_id=1 AND jf_content.published=1 AND jf_content.reference_id IN(507) AND jf_content.reference_table='users'
SELECT `name` FROM `jos_plugins` WHERE `element`='article' AND `folder`='community'
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.`events` as _events, 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`='1547'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content WHERE jf_content.language_id=1 AND jf_content.published=1 AND jf_content.reference_id IN(1547) AND jf_content.reference_table='users'
SELECT `name` FROM `jos_plugins` WHERE `element`='article' AND `folder`='community'
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.`events` as _events, 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`='519'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content WHERE jf_content.language_id=1 AND jf_content.published=1 AND jf_content.reference_id IN(519) AND jf_content.reference_table='users'
SELECT `name` FROM `jos_plugins` WHERE `element`='article' AND `folder`='community'
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.`events` as _events, 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`='979'
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content WHERE jf_content.language_id=1 AND jf_content.published=1 AND jf_content.reference_id IN(979) AND jf_content.reference_table='users'
SELECT COUNT(1) FROM `jos_community_activities` WHERE 1
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 a.`id`, a.`link`, a.name as name, a.`parent`, false as script FROM `jos_menu` AS a LEFT JOIN `jos_menu` AS b ON b.`id`=a.`parent` AND b.`published`='1' WHERE a.`published`='1' AND a.`menutype`='jomsocial' AND a.`access`='0' ORDER BY a.`ordering`
SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value FROM jos_jf_content AS jf_content WHERE jf_content.language_id=1 AND jf_content.published=1 AND jf_content.reference_id IN(275,269,276,273,277,270,278,271,279,272,280,274,281,290) AND jf_content.reference_table='menu'
SELECT j_user_id FROM jos_jfbconnect_user_map WHERE fb_user_id=''
Performed SQL enquiries
SELECT * FROM jos_jstats_configuration
Performed SQL enquiries
Performed SQL enquiries
Performed SQL enquiries
Performed SQL enquiries
SELECT * FROM jos_jstats_ipaddresses AS a WHERE a.ip = '644592615'
SELECT c.* FROM jos_jstats_clients AS c LEFT OUTER JOIN jos_jstats_visits AS v ON c.client_id = v.client_id WHERE v.ip = '644592615' AND (c.visitor_id = 0 OR c.visitor_id IS NULL);
Performed SQL enquiries
Performed SQL enquiries
Performed SQL enquiries
Performed SQL enquiries
select * from `jos_jstats_configuration` where description like 'ext_%' and value = '1'
Performed SQL enquiries
Performed SQL enquiries
Performed SQL enquiries
Performed SQL enquiries
Performed SQL enquiries
Performed SQL enquiries
Performed SQL enquiries
Performed SQL enquiries
Performed SQL enquiries
Performed SQL enquiries
SELECT v.visit_id FROM jos_jstats_visits as v WHERE v.client_id = 55649 AND v.ip = 644592615 AND v.changed_at >= 1337382760
Performed SQL enquiries
INSERT INTO jos_jstats_visits (client_id, joomla_userid, changed_at, ip) VALUES ( 55649, 0, 1337469160, 644592615 )
Performed SQL enquiries
Performed SQL enquiries
Performed SQL enquiries
Performed SQL enquiries
SELECT page_id, page_title FROM jos_jstats_pages WHERE page = '/index.php' LIMIT 1
INSERT INTO `jos_jstats_impressions` (`page_id`, `visit_id`, `timestamp`) VALUES (74,83407,1337469160)
Performed SQL enquiries
Performed SQL enquiries
Performed SQL enquiries
Performed SQL enquiries
Performed SQL enquiries