SELECT *
FROM jos2_session
WHERE session_id = 'j86pc1pol60tjh6pgs7bjro8m2'
DELETE
FROM jos2_session
WHERE ( time < '1246655743' )
SELECT *
FROM jos2_session
WHERE session_id = 'j86pc1pol60tjh6pgs7bjro8m2'
INSERT INTO `jos2_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'j86pc1pol60tjh6pgs7bjro8m2','1246662943','','0','1','0' )
SELECT *
FROM jos2_components
WHERE parent = 0
SELECT folder AS type, element AS name, params
FROM jos2_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT t.*
FROM jos2_ambrasubs_config AS t
SELECT m.*, c.`option` AS component
FROM jos2_menu AS m
LEFT JOIN jos2_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT m.*, c.`option` AS component
FROM jos2_menu AS m
LEFT JOIN jos2_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT template
FROM jos2_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 133)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT *
FROM jos2_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.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='0'
SELECT value
FROM jos2_myblog_config
WHERE name='all'
SELECT count(*)
FROM jos2_components
WHERE `option`='com_jomcomment'
SELECT VERSION()
SELECT id
FROM jos2_menu
WHERE `link` LIKE '%option=com_community&view=frontpage%'
AND `published`=1
SELECT id
FROM jos2_menu
WHERE `link` LIKE '%option=com_community&view=profile%'
AND `published`=1
SELECT id
FROM jos2_menu
WHERE `link` LIKE '%option=com_community&view=frontpage%'
AND `published`=1
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=0&view=profile'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&task=uploadAvatar&view=profile'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&task=edit&view=profile'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&task=editDetails&view=profile'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&task=privacy&view=profile'
SELECT id
FROM jos2_menu
WHERE `link` LIKE '%option=com_community&view=friends%'
AND `published`=1
SELECT id
FROM jos2_menu
WHERE `link` LIKE '%option=com_community&view=frontpage%'
AND `published`=1
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=0&view=friends'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&view=friends'
SELECT id
FROM jos2_menu
WHERE `link` LIKE '%option=com_community&view=search%'
AND `published`=1
SELECT id
FROM jos2_menu
WHERE `link` LIKE '%option=com_community&view=frontpage%'
AND `published`=1
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&view=search'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&task=advancesearch&view=search'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&task=invite&view=friends'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&task=sent&view=friends'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&task=pending&view=friends'
SELECT id
FROM jos2_menu
WHERE `link` LIKE '%option=com_community&view=apps%'
AND `published`=1
SELECT id
FROM jos2_menu
WHERE `link` LIKE '%option=com_community&view=frontpage%'
AND `published`=1
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&view=apps'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&task=browse&view=apps'
SELECT id
FROM jos2_menu
WHERE `link` LIKE '%option=com_community&view=groups%'
AND `published`=1
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=134&lang=en&task=mygroups&userid=0&view=groups'
SELECT id
FROM jos2_menu
WHERE `link` LIKE '%option=com_community&view=photos%'
AND `published`=1
SELECT id
FROM jos2_menu
WHERE `link` LIKE '%option=com_community&view=frontpage%'
AND `published`=1
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&task=myphotos&userid=0&view=photos'
SELECT id
FROM jos2_menu
WHERE `link` LIKE '%option=com_community&view=videos%'
AND `published`=1
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=140&lang=en&task=myvideos&userid=0&view=videos'
SELECT id
FROM jos2_menu
WHERE `link` LIKE '%option=com_community&view=inbox%'
AND `published`=1
SELECT id
FROM jos2_menu
WHERE `link` LIKE '%option=com_community&view=frontpage%'
AND `published`=1
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&view=inbox'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&task=sent&view=inbox'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&task=write&view=inbox'
SELECT id
FROM jos2_menu
WHERE link LIKE '%option=com_myblog%'
AND published='1'
AND `id`='133'
SELECT id
FROM jos2_menu
WHERE (type='component' OR type='components')
AND link='index.php?option=com_myblog'
AND published='1'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_myblog&Itemid=18&lang=en&task=adminhome'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_myblog&Itemid=18&lang=en'
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.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='0'
SELECT *
FROM `jos2_users`
WHERE `block`='0'
ORDER BY `registerDate` DESC
LIMIT 41
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.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='215'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='211'
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.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='206'
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.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='210'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='170'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='167'
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.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='166'
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.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='165'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='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.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='161'
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.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='160'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='159'
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.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='157'
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.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='156'
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.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='155'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='154'
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.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='133'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='135'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='134'
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.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='131'
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.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='132'
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.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='136'
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.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='137'
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.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='138'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='139'
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.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='140'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='141'
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.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='142'
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.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='143'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='144'
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.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='145'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='146'
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.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='147'
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.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='148'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='149'
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.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='150'
SELECT a.`userid` AS _userid , a.`status` AS _status , a.`points` AS _points, a.`posted_on` AS _posted_on, a.`avatar` AS _avatar , a.`thumb` AS _thumb , a.`invite` AS _invite, a.`params` AS _cparams, a.`view` AS _view, a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='151'
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.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='152'
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.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='130'
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.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='129'
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.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='128'
SELECT DISTINCT(a.id)
FROM `jos2_users` AS a
INNER JOIN `jos2_session` AS b
ON a.id=b.userid
WHERE a.block='0'
AND client_id != '1'
ORDER BY b.time DESC
LIMIT 20
SELECT *
FROM `jos2_community_photos`
WHERE 1
AND `permissions`='0'
ORDER BY created DESC
LIMIT 20
SELECT *
FROM jos2_community_users
WHERE `userid`='0'
ORDER BY `posted_on` DESC
LIMIT 1
SELECT COUNT(*)
FROM `jos2_users`
WHERE `block`='0'
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.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='63'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&view=profile'
SELECT id
FROM jos2_menu
WHERE `link` LIKE '%option=com_community&view=register%'
AND `published`=1
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=84&lang=en&view=register'
SELECT id
FROM jos2_menu
WHERE `link` LIKE '%option=com_community&view=reset%'
AND `published`=1
SELECT id
FROM jos2_menu
WHERE `link` LIKE '%option=com_community&view=frontpage%'
AND `published`=1
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_user&Itemid=133&lang=en&view=reset'
SELECT id
FROM jos2_menu
WHERE `link` LIKE '%option=com_community&view=remind%'
AND `published`=1
SELECT id
FROM jos2_menu
WHERE `link` LIKE '%option=com_community&view=frontpage%'
AND `published`=1
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_user&Itemid=133&lang=en&view=remind'
SELECT a.*, TO_DAYS('2009-07-03 23:15:44') - TO_DAYS( DATE_ADD(a.`created`, INTERVAL 0 HOUR ) ) AS 'daydiff'
FROM jos2_community_activities AS a
WHERE `archived`=0
ORDER BY a.`created` DESC
LIMIT 100
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=63&view=profile'
SELECT name
FROM jos2_plugins
WHERE `element`='myblog'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=77&view=profile'
SELECT name
FROM jos2_plugins
WHERE `element`='myarticles'
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.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.*
FROM jos2_community_users AS a
LEFT JOIN jos2_users u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN jos2_session s
ON s.`userid`=a.`userid`
WHERE a.`userid`='77'
SELECT name
FROM jos2_plugins
WHERE `element`='slideshare'
SELECT name
FROM jos2_plugins
WHERE `element`='feeds'
SELECT name
FROM jos2_plugins
WHERE `element`='groups'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=62&view=profile'
SELECT *
FROM jos2_community_groups AS a
WHERE a.`published`='1'
AND ( a.thumb != 'components/com_community/assets/group_thumb.jpg'
AND a.avatar != 'components/com_community/assets/group.jpg' )
ORDER BY a.created DESC
LIMIT 0 , 5
SELECT COUNT(*)
FROM jos2_community_groups AS a
WHERE a.published='1'
AND ( a.thumb != 'components/com_community/assets/group_thumb.jpg'
AND a.avatar != 'components/com_community/assets/group.jpg' )
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=134&groupid=18&lang=en&task=viewgroup&view=groups'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=134&groupid=17&lang=en&task=viewgroup&view=groups'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=134&groupid=16&lang=en&task=viewgroup&view=groups'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=134&groupid=15&lang=en&task=viewgroup&view=groups'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=134&groupid=14&lang=en&task=viewgroup&view=groups'
SELECT *
FROM jos2_community_videos AS a
WHERE a.`published`='1'
AND a.`status`='ready'
ORDER BY a.created DESC
LIMIT 9
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=140&lang=en&task=video&userid=77&videoid=4&view=videos'
SELECT name, link,id
FROM jos2_menu
WHERE id = '140'
AND published='1'
SELECT oldurl
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=140&lang=en&task=video&userid=77&view=videos'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=140&lang=en&task=video&userid=77&videoid=4&view=videos'
SELECT name, link,id
FROM jos2_menu
WHERE id = '140'
AND published='1'
SELECT oldurl
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=140&lang=en&task=video&userid=77&view=videos'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=140&lang=en&task=video&userid=77&videoid=5&view=videos'
SELECT name, link,id
FROM jos2_menu
WHERE id = '140'
AND published='1'
SELECT oldurl
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=140&lang=en&task=video&userid=77&view=videos'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=140&lang=en&task=video&userid=77&videoid=5&view=videos'
SELECT name, link,id
FROM jos2_menu
WHERE id = '140'
AND published='1'
SELECT oldurl
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=140&lang=en&task=video&userid=77&view=videos'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=140&lang=en&task=video&userid=77&videoid=6&view=videos'
SELECT name, link,id
FROM jos2_menu
WHERE id = '140'
AND published='1'
SELECT oldurl
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=140&lang=en&task=video&userid=77&view=videos'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=140&lang=en&task=video&userid=77&videoid=6&view=videos'
SELECT name, link,id
FROM jos2_menu
WHERE id = '140'
AND published='1'
SELECT oldurl
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=140&lang=en&task=video&userid=77&view=videos'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&albumid=1&lang=en&task=photo&userid=63&view=photos'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&view=photos'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=140&view=profile'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=145&view=profile'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=150&view=profile'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=146&view=profile'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=155&view=profile'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=142&view=profile'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=206&view=profile'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=161&view=profile'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=132&view=profile'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=159&view=profile'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=156&view=profile'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=138&view=profile'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=211&view=profile'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=135&view=profile'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=143&view=profile'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=157&view=profile'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=151&view=profile'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=133&view=profile'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=170&view=profile'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&userid=137&view=profile'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=133&lang=en&task=browse&view=search'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=140&lang=en&view=videos'
SELECT id, title, module, position, content, showtitle, control, params
FROM jos2_modules AS m
LEFT JOIN jos2_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
AND ( mm.menuid = 133 OR mm.menuid = 0 )
ORDER BY position, ordering
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=139&lang=en&view=frontpage'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=171&id=101&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=5&id=5&lang=en&layout=blog&view=section'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=142&lang=en'
SELECT name, link,id
FROM jos2_menu
WHERE id = '142'
AND published='1'
SELECT oldurl
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=142&lang=en&url=Idea-Bank'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=150&lang=en'
SELECT name, link,id
FROM jos2_menu
WHERE id = '150'
AND published='1'
SELECT oldurl
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=150&lang=en&url=Industry ProFiles'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=166&lang=en'
SELECT name, link,id
FROM jos2_menu
WHERE id = '166'
AND published='1'
SELECT oldurl
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=166&lang=en&url=Showcase'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=167&lang=en'
SELECT name, link,id
FROM jos2_menu
WHERE id = '167'
AND published='1'
SELECT oldurl
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=167&Tricks=&lang=en&url=Tips '
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=134&lang=en&view=groups'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=156&lang=en'
SELECT name, link,id
FROM jos2_menu
WHERE id = '156'
AND published='1'
SELECT oldurl
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=156&lang=en&url=Submit Idea'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=157&lang=en'
SELECT name, link,id
FROM jos2_menu
WHERE id = '157'
AND published='1'
SELECT oldurl
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=157&lang=en&url=Submit Industry ProFile'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=158&lang=en'
SELECT name, link,id
FROM jos2_menu
WHERE id = '158'
AND published='1'
SELECT oldurl
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=158&lang=en&url=Submit Showcase'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=159&lang=en'
SELECT name, link,id
FROM jos2_menu
WHERE id = '159'
AND published='1'
SELECT oldurl
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=159&Tricks=&lang=en&url=Submit Tips '
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_docman&Itemid=160&lang=en'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=170&id=101&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_contact&Itemid=8&id=1&lang=en&view=contact'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=147&id=940&lang=en&layout=blog&view=category'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=165&id=117&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_user&Itemid=51&lang=en&view=login'
SELECT *
FROM jos2_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 1
AND catid = 23
ORDER BY sticky DESC, ordering
LIMIT 0, 1
UPDATE jos2_banner
SET impmade = impmade + 1
WHERE bid = 6
INSERT INTO jos2_bannertrack ( track_type, banner_id, track_date )
VALUES ( 1, 6, '2009-07-03' )
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_banners&bid=6&lang=en&task=click'
SELECT *
FROM jos2_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 1
AND catid = 26
ORDER BY sticky DESC, ordering
LIMIT 0, 1
UPDATE jos2_banner
SET impmade = impmade + 1
WHERE bid = 8
INSERT INTO jos2_bannertrack ( track_type, banner_id, track_date )
VALUES ( 1, 8, '2009-07-03' )
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_banners&bid=8&lang=en&task=click'
SELECT *
FROM `jos2_acajoom_xonfig`
SELECT *
FROM `jos2_acajoom_lists`
WHERE `id` IN ( 1 )
AND `published` = 1
SELECT Listing.id AS `Listing.listing_id`,
Listing.title AS `Listing.title`,
Listing.introtext AS `Listing.summary`,
Listing.images AS `Listing.images`,
Listing.hits AS `Listing.hits`,
Listing.sectionid AS `Listing.section_id`,
Listing.catid AS `Listing.cat_id`,
Listing.created_by AS `Listing.user_id`,
Listing.created_by_alias AS `Listing.author_alias`,
Listing.created AS `Listing.created`,
Listing.access AS `Listing.access`,
Listing.state AS `Listing.state`,
Listing.publish_up AS `Listing.publish_up`,
Listing.state AS `Listing.publish_down`,
Listing.metakey AS `Listing.metakey`,
Listing.metadesc AS `Listing.metadesc`,
'com_content' AS `Listing.extension`,
Section.id AS `Section.section_id`,
Section.title AS `Section.title`,
Category.id AS `Category.cat_id`,
Category.title AS `Category.title`,
Category.image AS `Listing.category_image`,
Directory.id AS `Directory.dir_id`,
Directory.DESC AS `Directory.title`,
Directory.title AS `Directory.slug`,
Criteria.id AS `Criteria.criteria_id`,
Criteria.criteria AS `Criteria.criteria`,
Criteria.tooltips AS `Criteria.tooltips`,
Criteria.weights AS `Criteria.weights`,
Criteria.state AS `Criteria.state`,
`Field`.featured AS `Listing.featured`,
User.id AS `User.user_id`,
User.name AS `User.name`,
User.username AS `User.username`,
User.email AS `User.email`,
IF((sum(Rating.ratings_sum-Review.author*Rating.ratings_sum)/sum(Rating.ratings_qty-Review.author*Rating.ratings_qty))>0,1,0) AS `Review.user_rating_exists`,
CASE WHEN CHAR_LENGTH(Listing.alias) THEN Listing.alias ELSE "" END AS `Listing.slug`,
CASE WHEN CHAR_LENGTH(Category.alias) THEN Category.alias ELSE Category.title END AS `Category.slug`,
CASE WHEN CHAR_LENGTH(Section.alias) THEN Section.alias ELSE Section.title END AS `Section.slug`,
sum(Review.author*(Rating.ratings_sum/Rating.ratings_qty)) AS `Review.editor_rating`,
IF(sum(Review.author*(Rating.ratings_sum/Rating.ratings_qty))>0,1,0) AS `Review.editor_rating_exists`,
(sum(Rating.ratings_sum-Review.author*Rating.ratings_sum)/sum(Rating.ratings_qty-Review.author*Rating.ratings_qty)) AS `Review.user_rating`,
IF((sum(Rating.ratings_sum-Review.author*Rating.ratings_sum)/sum(Rating.ratings_qty-Review.author*Rating.ratings_qty))>0,1,0) AS `Review.user_rating_exists`,
(count(Review.id)-sum(Review.author)) AS `Review.review_count`,
IF ((count(Review.id)-sum(Review.author))>0,1,0) AS `Review.review_count_exists`
FROM jos2_content AS Listing
LEFT JOIN jos2_jreviews_content AS FIELD
ON FIELD.contentid = Listing.id
LEFT JOIN jos2_sections AS Section
ON Listing.sectionid = Section.id
LEFT JOIN jos2_categories AS Category
ON Listing.catid = Category.id
INNER JOIN jos2_jreviews_categories AS JreviewsCategory
ON Listing.catid = JreviewsCategory.id
AND JreviewsCategory.`option` = 'com_content'
LEFT JOIN jos2_jreviews_directories AS Directory
ON JreviewsCategory.dirid = Directory.id
LEFT JOIN jos2_jreviews_criteria AS Criteria
ON JreviewsCategory.criteriaid = Criteria.id
LEFT JOIN jos2_users AS User
ON User.id = Listing.created_by
LEFT JOIN jos2_jreviews_comments AS Review
ON Listing.id = Review.pid
AND Review.published = 1
AND Review.mode = 'com_content'
LEFT JOIN jos2_jreviews_ratings AS Rating
ON Review.id = Rating.reviewid
WHERE 1 = 1
AND (
Listing.state = 1
AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2009-07-03 23:15" )
AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2009-07-03 23:15" )
AND Listing.access <= 0
AND Listing.catid > 0
AND JreviewsCategory.dirid IN (2)
AND featured > 0
)
GROUP BY Listing.id
ORDER BY RAND(754084579)
LIMIT 5
SELECT COUNT(DISTINCT Listing.id)
FROM jos2_content AS Listing
LEFT JOIN jos2_jreviews_content AS FIELD
ON FIELD.contentid = Listing.id
LEFT JOIN jos2_sections AS Section
ON Listing.sectionid = Section.id
LEFT JOIN jos2_categories AS Category
ON Listing.catid = Category.id
INNER JOIN jos2_jreviews_categories AS JreviewsCategory
ON Listing.catid = JreviewsCategory.id
AND JreviewsCategory.`option` = 'com_content'
LEFT JOIN jos2_jreviews_directories AS Directory
ON JreviewsCategory.dirid = Directory.id
LEFT JOIN jos2_jreviews_criteria AS Criteria
ON JreviewsCategory.criteriaid = Criteria.id
LEFT JOIN jos2_users AS User
ON User.id = Listing.created_by
LEFT JOIN jos2_jreviews_comments AS Review
ON Listing.id = Review.pid
AND Review.published = 1
AND Review.mode = 'com_content'
LEFT JOIN jos2_jreviews_ratings AS Rating
ON Review.id = Rating.reviewid
WHERE 1 = 1
AND (
Listing.state = 1
AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2009-07-03 23:15" )
AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2009-07-03 23:15" )
AND Listing.access <= 0
AND Listing.catid > 0
AND JreviewsCategory.dirid IN (2)
AND featured > 0
)
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=133&lang=en&url=menu/lang*@*en/view*@*frontpage/page*@*1/limit*@*5/'
SELECT name, link,id
FROM jos2_menu
WHERE id = '133'
AND published='1'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_content&catid=950&id=108&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=150&lang=en&url=industry-profiles/individuals/festival-organisers_c950_m150/'
SELECT name, link,id
FROM jos2_menu
WHERE id = '150'
AND published='1'
SELECT oldurl
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=150&lang=en&url=industry-profiles/individuals/festival-organisers_c950_m150'
SELECT Listing.id AS `Listing.listing_id`,
Listing.title AS `Listing.title`,
Listing.introtext AS `Listing.summary`,
Listing.images AS `Listing.images`,
Listing.hits AS `Listing.hits`,
Listing.sectionid AS `Listing.section_id`,
Listing.catid AS `Listing.cat_id`,
Listing.created_by AS `Listing.user_id`,
Listing.created_by_alias AS `Listing.author_alias`,
Listing.created AS `Listing.created`,
Listing.access AS `Listing.access`,
Listing.state AS `Listing.state`,
Listing.publish_up AS `Listing.publish_up`,
Listing.state AS `Listing.publish_down`,
Listing.metakey AS `Listing.metakey`,
Listing.metadesc AS `Listing.metadesc`,
'com_content' AS `Listing.extension`,
Section.id AS `Section.section_id`,
Section.title AS `Section.title`,
Category.id AS `Category.cat_id`,
Category.title AS `Category.title`,
Category.image AS `Listing.category_image`,
Directory.id AS `Directory.dir_id`,
Directory.DESC AS `Directory.title`,
Directory.title AS `Directory.slug`,
Criteria.id AS `Criteria.criteria_id`,
Criteria.criteria AS `Criteria.criteria`,
Criteria.tooltips AS `Criteria.tooltips`,
Criteria.weights AS `Criteria.weights`,
Criteria.state AS `Criteria.state`,
`Field`.featured AS `Listing.featured`,
User.id AS `User.user_id`,
User.name AS `User.name`,
User.username AS `User.username`,
User.email AS `User.email`,
IF((sum(Rating.ratings_sum-Review.author*Rating.ratings_sum)/sum(Rating.ratings_qty-Review.author*Rating.ratings_qty))>0,1,0) AS `Review.user_rating_exists`,
CASE WHEN CHAR_LENGTH(Listing.alias) THEN Listing.alias ELSE "" END AS `Listing.slug`,
CASE WHEN CHAR_LENGTH(Category.alias) THEN Category.alias ELSE Category.title END AS `Category.slug`,
CASE WHEN CHAR_LENGTH(Section.alias) THEN Section.alias ELSE Section.title END AS `Section.slug`,
sum(Review.author*(Rating.ratings_sum/Rating.ratings_qty)) AS `Review.editor_rating`,
IF(sum(Review.author*(Rating.ratings_sum/Rating.ratings_qty))>0,1,0) AS `Review.editor_rating_exists`,
(sum(Rating.ratings_sum-Review.author*Rating.ratings_sum)/sum(Rating.ratings_qty-Review.author*Rating.ratings_qty)) AS `Review.user_rating`,
IF((sum(Rating.ratings_sum-Review.author*Rating.ratings_sum)/sum(Rating.ratings_qty-Review.author*Rating.ratings_qty))>0,1,0) AS `Review.user_rating_exists`,
(count(Review.id)-sum(Review.author)) AS `Review.review_count`,
IF ((count(Review.id)-sum(Review.author))>0,1,0) AS `Review.review_count_exists`
FROM jos2_content AS Listing
LEFT JOIN jos2_jreviews_content AS FIELD
ON FIELD.contentid = Listing.id
LEFT JOIN jos2_sections AS Section
ON Listing.sectionid = Section.id
LEFT JOIN jos2_categories AS Category
ON Listing.catid = Category.id
INNER JOIN jos2_jreviews_categories AS JreviewsCategory
ON Listing.catid = JreviewsCategory.id
AND JreviewsCategory.`option` = 'com_content'
LEFT JOIN jos2_jreviews_directories AS Directory
ON JreviewsCategory.dirid = Directory.id
LEFT JOIN jos2_jreviews_criteria AS Criteria
ON JreviewsCategory.criteriaid = Criteria.id
LEFT JOIN jos2_users AS User
ON User.id = Listing.created_by
LEFT JOIN jos2_jreviews_comments AS Review
ON Listing.id = Review.pid
AND Review.published = 1
AND Review.mode = 'com_content'
LEFT JOIN jos2_jreviews_ratings AS Rating
ON Review.id = Rating.reviewid
WHERE 1 = 1
AND (
Listing.state = 1
AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2009-07-03 23:15" )
AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2009-07-03 23:15" )
AND Listing.access <= 0
AND Listing.catid > 0
AND JreviewsCategory.dirid IN (1)
AND featured > 0
)
GROUP BY Listing.id
ORDER BY RAND(1634369000)
LIMIT 5
SELECT COUNT(DISTINCT Listing.id)
FROM jos2_content AS Listing
LEFT JOIN jos2_jreviews_content AS FIELD
ON FIELD.contentid = Listing.id
LEFT JOIN jos2_sections AS Section
ON Listing.sectionid = Section.id
LEFT JOIN jos2_categories AS Category
ON Listing.catid = Category.id
INNER JOIN jos2_jreviews_categories AS JreviewsCategory
ON Listing.catid = JreviewsCategory.id
AND JreviewsCategory.`option` = 'com_content'
LEFT JOIN jos2_jreviews_directories AS Directory
ON JreviewsCategory.dirid = Directory.id
LEFT JOIN jos2_jreviews_criteria AS Criteria
ON JreviewsCategory.criteriaid = Criteria.id
LEFT JOIN jos2_users AS User
ON User.id = Listing.created_by
LEFT JOIN jos2_jreviews_comments AS Review
ON Listing.id = Review.pid
AND Review.published = 1
AND Review.mode = 'com_content'
LEFT JOIN jos2_jreviews_ratings AS Rating
ON Review.id = Rating.reviewid
WHERE 1 = 1
AND (
Listing.state = 1
AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2009-07-03 23:15" )
AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2009-07-03 23:15" )
AND Listing.access <= 0
AND Listing.catid > 0
AND JreviewsCategory.dirid IN (1)
AND featured > 0
)
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=133&lang=en&url=menu/lang*@*en/view*@*frontpage/page*@*1/limit*@*5/'
SELECT name, link,id
FROM jos2_menu
WHERE id = '133'
AND published='1'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_content&catid=932&id=102&lang=en&view=article'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=142&lang=en&url=idea-bank/festival-organisers/ideas4events_c932_m142/'
SELECT name, link,id
FROM jos2_menu
WHERE id = '142'
AND published='1'
SELECT oldurl
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_jreviews&Itemid=142&lang=en&url=idea-bank/festival-organisers/ideas4events_c932_m142'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_content&id=99&lang=en&tmpl=component&view=article'
SELECT oldurl, dateadd
FROM jos2_redirection
WHERE newurl = 'index.php?option=com_community&lang=en&view=groups'