session.counter ⇒ 52
session.timer.start ⇒ 1337451658
session.timer.last ⇒ 1337453731
session.timer.now ⇒ 1337453761
session.client.browser ⇒ CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
registry ⇒ {"com_kunena":{"redirect":null,"ActionBulk":"\/index.php\/en\/forum\/recent"}}
id ⇒ 0
name ⇒
username ⇒
email ⇒
password ⇒
password_clear ⇒
usertype ⇒
block ⇒
sendEmail ⇒ 0
registerDate ⇒
lastvisitDate ⇒
activation ⇒
params ⇒
groups ⇒ Array
guest ⇒ 1
aid ⇒ 0
session.token ⇒ 3e0eff0e813ebe7dcad65d2d080a9790
link ⇒ http://www.jerichoairsoft.com/index.php/en/fields/big-game-ao-map
expiry ⇒ 1337452327
link ⇒ http://www.jerichoairsoft.com/index.php/en/fields/military-vehicles
expiry ⇒ 1337452327
link ⇒ http://www.jerichoairsoft.com/index.php/en/fields/firebase
expiry ⇒ 1337452327
link ⇒ http://www.jerichoairsoft.com/index.php/en/info/location
expiry ⇒ 1337452327
link ⇒ http://www.jerichoairsoft.com/index.php/en/fields/trenches
expiry ⇒ 1337452327
link ⇒ http://www.jerichoairsoft.com/index.php/en/info/prices-a-private-groups/2-uncategorised/50-operation-covert-strike-ii
expiry ⇒ 1337452355
link ⇒ http://www.jerichoairsoft.com/index.php/en/info/prices-a-private-groups/2-uncategorised/45-jericho-airsoft-swap-meet-april-14th
expiry ⇒ 1337452355
link ⇒ http://www.jerichoairsoft.com/index.php/en/info/prices-a-private-groups
expiry ⇒ 1337452355
link ⇒ http://www.jerichoairsoft.com/index.php/en/info/prices-a-private-groups/2-uncategorised/37-2012-events-to-be-announced-soon
expiry ⇒ 1337452355
link ⇒ http://www.jerichoairsoft.com/index.php/en/info/hours-of-operation
expiry ⇒ 1337452355
view-136 ⇒ 1
view-226 ⇒ 1
view-282 ⇒ 1
view-299 ⇒ 1
view-311 ⇒ 1
view-370 ⇒ 1
view-371 ⇒ 1
view-372 ⇒ 1
view-373 ⇒ 1
view-375 ⇒ 1
view-377 ⇒ 1
view-378 ⇒ 1
view-380 ⇒ 1
view-381 ⇒ 1
view-382 ⇒ 1
view-388 ⇒ 1
view-390 ⇒ 1
view-393 ⇒ 1
view-video-1 ⇒ 1
view-394 ⇒ 1
view-397 ⇒ 1
view-42 ⇒ 1
view-event-6 ⇒ 1
Application 0.000 seconds (+0.000); 0.85 MB (+0.850) - afterLoadApplication 0.082 seconds (+0.082); 7.82 MB (+6.972) - afterInitialiseApplication 0.138 seconds (+0.056); 12.33 MB (+4.503) - afterRouteApplication 0.461 seconds (+0.323); 19.70 MB (+7.373) - afterDispatchApplication 0.577 seconds (+0.116); 25.01 MB (+5.310) - beforeRenderModule mod_roknavmenu ()Application 0.629 seconds (+0.052); 26.51 MB (+1.499) - afterRenderModule mod_roknavmenu ()Application 0.632 seconds (+0.003); 26.48 MB (-0.029) - beforeRenderModule mod_roknavmenu ()Application 0.661 seconds (+0.029); 26.83 MB (+0.355) - afterRenderModule mod_roknavmenu ()Application 0.704 seconds (+0.043); 26.89 MB (+0.062) - beforeRenderModule mod_roknavmenu ()Application 0.712 seconds (+0.008); 27.21 MB (+0.314) - afterRenderModule mod_roknavmenu ()Application 0.768 seconds (+0.056); 27.98 MB (+0.775) - beforeRenderModule mod_login (Login Form)Application 0.811 seconds (+0.043); 28.07 MB (+0.089) - afterRenderModule mod_login (Login Form)Application 0.935 seconds (+0.125); 27.32 MB (-0.756) - afterRender27.35 MB (28,677,304 Bytes)SELECT `data`
FROM `jericho_session`
WHERE `session_id` = 'f5b92762becc70c69d9447d48ac724fd'DELETE
FROM `jericho_session`
WHERE `time` < '1337453161'SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM jericho_menu AS m
LEFT JOIN jericho_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftSELECT `userid`
FROM `jericho_community_users`
WHERE `alias`='search'SELECT `userid`
FROM `jericho_community_users`
WHERE `alias`='search'SHOW FULL COLUMNS
FROM `jericho_community_config`SELECT *
FROM jericho_community_config
WHERE `name` = 'config'show tables like '%_kunena_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.`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 `jericho_community_users` as a
LEFT JOIN `jericho_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jericho_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'
WHERE a.`userid`='0'SHOW FULL COLUMNS
FROM `jericho_community_profiles`SELECT COUNT(DISTINCT(a.`id`))
FROM `jericho_users` AS a
LEFT JOIN `jericho_session` AS b
ON a.`id`=b.`userid`
WHERE a.`block`='0'
ORDER BY a.`registerDate` DESCSELECT distinct(a.`id`)
FROM `jericho_users` AS a
LEFT JOIN `jericho_session` AS b
ON a.`id`=b.`userid`
WHERE a.`block`='0'
ORDER BY a.`registerDate` DESC
LIMIT 0,20SELECT 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 `jericho_community_users` as a
LEFT JOIN `jericho_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jericho_session`s
ON s.`userid`=a.`userid`
WHERE a.`userid` IN (496,494,493,492,491,489,488,487,486,485,484,483,482,481,479,477,476,474,473,471)SELECT COUNT(*)
FROM `jericho_users`
WHERE `block`='0'SELECT `id`
FROM `jericho_menu`
WHERE `link` LIKE '%option=com_community&view=profile%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'SELECT `id`
FROM `jericho_menu`
WHERE `link` = 'index.php?option=com_community&view=frontpage'
AND `published`='1'
AND `type`='component'SELECT *
FROM `jericho_community_connection`
WHERE (`connect_from` = '0'
AND `connect_to` ='496') OR ( `connect_from` = '496'
AND `connect_to` ='0')SELECT *
FROM `jericho_community_connection`
WHERE (`connect_from` = '0'
AND `connect_to` ='494') OR ( `connect_from` = '494'
AND `connect_to` ='0')SELECT *
FROM `jericho_community_connection`
WHERE (`connect_from` = '0'
AND `connect_to` ='493') OR ( `connect_from` = '493'
AND `connect_to` ='0')SELECT *
FROM `jericho_community_connection`
WHERE (`connect_from` = '0'
AND `connect_to` ='492') OR ( `connect_from` = '492'
AND `connect_to` ='0')SELECT *
FROM `jericho_community_connection`
WHERE (`connect_from` = '0'
AND `connect_to` ='491') OR ( `connect_from` = '491'
AND `connect_to` ='0')SELECT *
FROM `jericho_community_connection`
WHERE (`connect_from` = '0'
AND `connect_to` ='489') OR ( `connect_from` = '489'
AND `connect_to` ='0')SELECT *
FROM `jericho_community_connection`
WHERE (`connect_from` = '0'
AND `connect_to` ='488') OR ( `connect_from` = '488'
AND `connect_to` ='0')SELECT *
FROM `jericho_community_connection`
WHERE (`connect_from` = '0'
AND `connect_to` ='487') OR ( `connect_from` = '487'
AND `connect_to` ='0')SELECT *
FROM `jericho_community_connection`
WHERE (`connect_from` = '0'
AND `connect_to` ='486') OR ( `connect_from` = '486'
AND `connect_to` ='0')SELECT *
FROM `jericho_community_connection`
WHERE (`connect_from` = '0'
AND `connect_to` ='485') OR ( `connect_from` = '485'
AND `connect_to` ='0')SELECT *
FROM `jericho_community_connection`
WHERE (`connect_from` = '0'
AND `connect_to` ='484') OR ( `connect_from` = '484'
AND `connect_to` ='0')SELECT *
FROM `jericho_community_connection`
WHERE (`connect_from` = '0'
AND `connect_to` ='483') OR ( `connect_from` = '483'
AND `connect_to` ='0')SELECT *
FROM `jericho_community_connection`
WHERE (`connect_from` = '0'
AND `connect_to` ='482') OR ( `connect_from` = '482'
AND `connect_to` ='0')SELECT *
FROM `jericho_community_connection`
WHERE (`connect_from` = '0'
AND `connect_to` ='481') OR ( `connect_from` = '481'
AND `connect_to` ='0')SELECT *
FROM `jericho_community_connection`
WHERE (`connect_from` = '0'
AND `connect_to` ='479') OR ( `connect_from` = '479'
AND `connect_to` ='0')SELECT *
FROM `jericho_community_connection`
WHERE (`connect_from` = '0'
AND `connect_to` ='477') OR ( `connect_from` = '477'
AND `connect_to` ='0')SELECT *
FROM `jericho_community_connection`
WHERE (`connect_from` = '0'
AND `connect_to` ='476') OR ( `connect_from` = '476'
AND `connect_to` ='0')SELECT *
FROM `jericho_community_connection`
WHERE (`connect_from` = '0'
AND `connect_to` ='474') OR ( `connect_from` = '474'
AND `connect_to` ='0')SELECT *
FROM `jericho_community_connection`
WHERE (`connect_from` = '0'
AND `connect_to` ='473') OR ( `connect_from` = '473'
AND `connect_to` ='0')SELECT *
FROM `jericho_community_connection`
WHERE (`connect_from` = '0'
AND `connect_to` ='471') OR ( `connect_from` = '471'
AND `connect_to` ='0')SELECT *
FROM `jericho_community_featured`
WHERE `type`='users'
ORDER BY `id` DESC
LIMIT 0,10SELECT `id`
FROM `jericho_menu`
WHERE `link` LIKE '%option=com_community&view=search%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'SELECT b.id
FROM jericho_usergroups AS a
LEFT JOIN jericho_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1Select `title`
from `jericho_usergroups`
where `id`='1'SELECT *
from `jericho_community_users`
WHERE `userid`='496'
AND (`status_access` <= 10)
ORDER BY `posted_on` DESC
LIMIT 1SELECT *
from `jericho_community_users`
WHERE `userid`='494'
AND (`status_access` <= 10)
ORDER BY `posted_on` DESC
LIMIT 1SELECT *
from `jericho_community_users`
WHERE `userid`='493'
AND (`status_access` <= 10)
ORDER BY `posted_on` DESC
LIMIT 1SELECT *
from `jericho_community_users`
WHERE `userid`='492'
AND (`status_access` <= 10)
ORDER BY `posted_on` DESC
LIMIT 1SELECT *
from `jericho_community_users`
WHERE `userid`='491'
AND (`status_access` <= 10)
ORDER BY `posted_on` DESC
LIMIT 1SELECT *
from `jericho_community_users`
WHERE `userid`='489'
AND (`status_access` <= 10)
ORDER BY `posted_on` DESC
LIMIT 1SELECT *
from `jericho_community_users`
WHERE `userid`='488'
AND (`status_access` <= 10)
ORDER BY `posted_on` DESC
LIMIT 1SELECT *
from `jericho_community_users`
WHERE `userid`='487'
AND (`status_access` <= 10)
ORDER BY `posted_on` DESC
LIMIT 1SELECT *
from `jericho_community_users`
WHERE `userid`='486'
AND (`status_access` <= 10)
ORDER BY `posted_on` DESC
LIMIT 1SELECT *
from `jericho_community_users`
WHERE `userid`='485'
AND (`status_access` <= 10)
ORDER BY `posted_on` DESC
LIMIT 1SELECT *
from `jericho_community_users`
WHERE `userid`='484'
AND (`status_access` <= 10)
ORDER BY `posted_on` DESC
LIMIT 1SELECT *
from `jericho_community_users`
WHERE `userid`='483'
AND (`status_access` <= 10)
ORDER BY `posted_on` DESC
LIMIT 1SELECT *
from `jericho_community_users`
WHERE `userid`='482'
AND (`status_access` <= 10)
ORDER BY `posted_on` DESC
LIMIT 1SELECT *
from `jericho_community_users`
WHERE `userid`='481'
AND (`status_access` <= 10)
ORDER BY `posted_on` DESC
LIMIT 1SELECT *
from `jericho_community_users`
WHERE `userid`='479'
AND (`status_access` <= 10)
ORDER BY `posted_on` DESC
LIMIT 1SELECT *
from `jericho_community_users`
WHERE `userid`='477'
AND (`status_access` <= 10)
ORDER BY `posted_on` DESC
LIMIT 1SELECT *
from `jericho_community_users`
WHERE `userid`='476'
AND (`status_access` <= 10)
ORDER BY `posted_on` DESC
LIMIT 1SELECT *
from `jericho_community_users`
WHERE `userid`='474'
AND (`status_access` <= 10)
ORDER BY `posted_on` DESC
LIMIT 1SELECT *
from `jericho_community_users`
WHERE `userid`='473'
AND (`status_access` <= 10)
ORDER BY `posted_on` DESC
LIMIT 1SELECT *
from `jericho_community_users`
WHERE `userid`='471'
AND (`status_access` <= 10)
ORDER BY `posted_on` DESC
LIMIT 1Select `title`
from `jericho_usergroups`
where `id`='1'SELECT a.`id`, a.`link`, a.title as name, a.`parent_id`, false as script
FROM `jericho_menu` AS a
LEFT JOIN `jericho_menu` AS b
ON b.`id`=a.`parent_id`
AND b.`published`='1'
WHERE a.`published`='1'
AND a.`menutype`='jomsocial'
AND a.`access`='0'
ORDER BY a.`lft`SELECT template
FROM jericho_template_styles
WHERE home = 1
AND client_id = 0SELECT template
FROM jericho_template_styles
WHERE home = 1
AND client_id = 0SELECT template
FROM jericho_template_styles
WHERE home = 1
AND client_id = 0SELECT `userid`
FROM `jericho_community_users`
WHERE `alias`='search'SELECT `userid`
FROM `jericho_community_users`
WHERE `alias`='search'UPDATE `jericho_session`
SET `data` = '__default|a:32:{s:15:\"session.counter\";i:52;s:19:\"session.timer.start\";i:1337451658;s:18:\"session.timer.last\";i:1337453731;s:17:\"session.timer.now\";i:1337453761;s:22:\"session.client.browser\";s:48:\"CCBot/1.0 (+http://www.commoncrawl.org/bot.html)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:10:\"com_kunena\";O:8:\"stdClass\":2:{s:8:\"redirect\";N;s:10:\"ActionBulk\";s:26:\"/index.php/en/forum/recent\";}}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"3e0eff0e813ebe7dcad65d2d080a9790\";s:16:\"com_mailto.links\";a:10:{s:40:\"9f040bbde333464f14572a90d1d34c6fe344be64\";O:8:\"stdClass\":2:{s:4:\"link\";s:65:\"http://www.jerichoairsoft.com/index.php/en/fields/big-game-ao-map\";s:6:\"expiry\";i:1337452327;}s:40:\"fcad74ff895dfdb84439184ddcaad3a38e768dbb\";O:8:\"stdClass\":2:{s:4:\"link\";s:67:\"http://www.jerichoairsoft.com/index.php/en/fields/military-vehicles\";s:6:\"expiry\";i:1337452327;}s:40:\"0a0a864a1d0f029e289904553ca9e7736470ec3f\";O:8:\"stdClass\":2:{s:4:\"link\";s:58:\"http://www.jerichoairsoft.com/index.php/en/fields/firebase\";s:6:\"expiry\";i:1337452327;}s:40:\"6863ef6c578003bc237f043ab205da830f5f2a08\";O:8:\"stdClass\":2:{s:4:\"link\";s:56:\"http://www.jerichoairsoft.com/index.php/en/info/location\";s:6:\"expiry\";i:1337452327;}s:40:\"2ce8b68b8c141b4c0375f412cd467667a05202f9\";O:8:\"stdClass\":2:{s:4:\"link\";s:58:\"http://www.jerichoairsoft.com/index.php/en/fields/trenches\";s:6:\"expiry\";i:1337452327;}s:40:\"05821ce0ae5c07e26af7fdc67f822b61b9dc1719\";O:8:\"stdClass\":2:{s:4:\"link\";s:117:\"http://www.jerichoairsoft.com/index.php/en/info/prices-a-private-groups/2-uncategorised/50-operation-covert-strike-ii\";s:6:\"expiry\";i:1337452355;}s:40:\"1ef3e40cecd7430d12dd7bdc6df629e9f035cd49\";O:8:\"stdClass\":2:{s:4:\"link\";s:127:\"http://www.jerichoairsoft.com/index.php/en/info/prices-a-private-groups/2-uncategorised/45-jericho-airsoft-swap-meet-april-14th\";s:6:\"expiry\";i:1337452355;}s:40:\"d8392552c977304daa3b2c755dc5cee106815196\";O:8:\"stdClass\":2:{s:4:\"link\";s:71:\"http://www.jerichoairsoft.com/index.php/en/info/prices-a-private-groups\";s:6:\"expiry\";i:1337452355;}s:40:\"b6f630e5c2b38ebc44117eae11ec055cc42367c8\";O:8:\"stdClass\":2:{s:4:\"link\";s:123:\"http://www.jerichoairsoft.com/index.php/en/info/prices-a-private-groups/2-uncategorised/37-2012-events-to-be-announced-soon\";s:6:\"expiry\";i:1337452355;}s:40:\"e12dd36ca3010ed0b595d2163ec1b82032b4dc30\";O:8:\"stdClass\":2:{s:4:\"link\";s:66:\"http://www.jerichoairsoft.com/index.php/en/info/hours-of-operation\";s:6:\"expiry\";i:1337452355;}}s:8:\"view-136\";b:1;s:8:\"view-226\";b:1;s:8:\"view-282\";b:1;s:8:\"view-299\";b:1;s:8:\"view-311\";b:1;s:8:\"view-370\";b:1;s:8:\"view-371\";b:1;s:8:\"view-372\";b:1;s:8:\"view-373\";b:1;s:8:\"view-375\";b:1;s:8:\"view-377\";b:1;s:8:\"view-378\";b:1;s:8:\"view-380\";b:1;s:8:\"view-381\";b:1;s:8:\"view-382\";b:1;s:8:\"view-388\";b:1;s:8:\"view-390\";b:1;s:8:\"view-393\";b:1;s:12:\"view-video-1\";b:1;s:8:\"view-394\";b:1;s:8:\"view-397\";b:1;s:7:\"view-42\";b:1;s:12:\"view-event-6\";b:1;}'
, `time` = '1337453762'
WHERE `session_id` = 'f5b92762becc70c69d9447d48ac724fd'20 × SELECT *
FROM `jericho_community_connection`20 × SELECT *
from `jericho_community_users`4 × SELECT `userid`
FROM `jericho_community_users`3 × SELECT `id`
FROM `jericho_menu`3 × SELECT template
FROM jericho_template_styles2 × Select `title`
from `jericho_usergroups`1 × SELECT a.`id`, a.`link`, a.title as name, a.`parent_id`, false as script
FROM `jericho_menu` AS a
LEFT JOIN `jericho_menu` AS b
ON b.`id`=a.`parent_id`
AND b.`published`='1'1 × SELECT *
FROM `jericho_community_featured`1 × SELECT b.id
FROM jericho_usergroups AS a
LEFT JOIN jericho_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT COUNT(*)
FROM `jericho_users`1 × SELECT *
FROM jericho_community_config1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM jericho_menu AS m
LEFT JOIN jericho_extensions AS e
ON m.component_id = e.extension_id1 × 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 `jericho_community_users` as a
LEFT JOIN `jericho_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jericho_session` s
ON s.`userid`=a.`userid`
AND s.`client_id` !='1'1 × SELECT COUNT(DISTINCT(a.`id`))
FROM `jericho_users` AS a
LEFT JOIN `jericho_session` AS b
ON a.`id`=b.`userid`1 × 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 `jericho_community_users` as a
LEFT JOIN `jericho_users` u
ON u.`id`=a.`userid`
LEFT
OUTER JOIN `jericho_session`s
ON s.`userid`=a.`userid`1 × SELECT distinct(a.`id`)
FROM `jericho_users` AS a
LEFT JOIN `jericho_session` AS b
ON a.`id`=b.`userid`1 × SELECT `data`
FROM `jericho_session`1 × UPDATE `jericho_session`
SET `data` = '__default|a:32:{s:15:\"session.counter\";i:52;s:19:\"session.timer.start\";i:1337451658;s:18:\"session.timer.last\";i:1337453731;s:17:\"session.timer.now\";i:1337453761;s:22:\"session.client.browser\";s:48:\"CCBot/1.0 (+http://www.commoncrawl.org/bot.html)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:10:\"com_kunena\";O:8:\"stdClass\":2:{s:8:\"redirect\";N;s:10:\"ActionBulk\";s:26:\"/index.php/en/forum/recent\";}}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"3e0eff0e813ebe7dcad65d2d080a9790\";s:16:\"com_mailto.links\";a:10:{s:40:\"9f040bbde333464f14572a90d1d34c6fe344be64\";O:8:\"stdClass\":2:{s:4:\"link\";s:65:\"http://www.jerichoairsoft.com/index.php/en/fields/big-game-ao-map\";s:6:\"expiry\";i:1337452327;}s:40:\"fcad74ff895dfdb84439184ddcaad3a38e768dbb\";O:8:\"stdClass\":2:{s:4:\"link\";s:67:\"http://www.jerichoairsoft.com/index.php/en/fields/military-vehicles\";s:6:\"expiry\";i:1337452327;}s:40:\"0a0a864a1d0f029e289904553ca9e7736470ec3f\";O:8:\"stdClass\":2:{s:4:\"link\";s:58:\"http://www.jerichoairsoft.com/index.php/en/fields/firebase\";s:6:\"expiry\";i:1337452327;}s:40:\"6863ef6c578003bc237f043ab205da830f5f2a08\";O:8:\"stdClass\":2:{s:4:\"link\";s:56:\"http://www.jerichoairsoft.com/index.php/en/info/location\";s:6:\"expiry\";i:1337452327;}s:40:\"2ce8b68b8c141b4c0375f412cd467667a05202f9\";O:8:\"stdClass\":2:{s:4:\"link\";s:58:\"http://www.jerichoairsoft.com/index.php/en/fields/trenches\";s:6:\"expiry\";i:1337452327;}s:40:\"05821ce0ae5c07e26af7fdc67f822b61b9dc1719\";O:8:\"stdClass\":2:{s:4:\"link\";s:117:\"http://www.jerichoairsoft.com/index.php/en/info/prices-a-private-groups/2-uncategorised/50-operation-covert-strike-ii\";s:6:\"expiry\";i:1337452355;}s:40:\"1ef3e40cecd7430d12dd7bdc6df629e9f035cd49\";O:8:\"stdClass\":2:{s:4:\"link\";s:127:\"http://www.jerichoairsoft.com/index.php/en/info/prices-a-private-groups/2-uncategorised/45-jericho-airsoft-swap-meet-april-14th\";s:6:\"expiry\";i:1337452355;}s:40:\"d8392552c977304daa3b2c755dc5cee106815196\";O:8:\"stdClass\":2:{s:4:\"link\";s:71:\"http://www.jerichoairsoft.com/index.php/en/info/prices-a-private-groups\";s:6:\"expiry\";i:1337452355;}s:40:\"b6f630e5c2b38ebc44117eae11ec055cc42367c8\";O:8:\"stdClass\":2:{s:4:\"link\";s:123:\"http://www.jerichoairsoft.com/index.php/en/info/prices-a-private-groups/2-uncategorised/37-2012-events-to-be-announced-soon\";s:6:\"expiry\";i:1337452355;}s:40:\"e12dd36ca3010ed0b595d2163ec1b82032b4dc30\";O:8:\"stdClass\":2:{s:4:\"link\";s:66:\"http://www.jerichoairsoft.com/index.php/en/info/hours-of-operation\";s:6:\"expiry\";i:1337452355;}}s:8:\"view-136\";b:1;s:8:\"view-226\";b:1;s:8:\"view-282\";b:1;s:8:\"view-299\";b:1;s:8:\"view-311\";b:1;s:8:\"view-370\";b:1;s:8:\"view-371\";b:1;s:8:\"view-372\";b:1;s:8:\"view-373\";b:1;s:8:\"view-375\";b:1;s:8:\"view-377\";b:1;s:8:\"view-378\";b:1;s:8:\"view-380\";b:1;s:8:\"view-381\";b:1;s:8:\"view-382\";b:1;s:8:\"view-388\";b:1;s:8:\"view-390\";b:1;s:8:\"view-393\";b:1;s:12:\"view-video-1\";b:1;s:8:\"view-394\";b:1;s:8:\"view-397\";b:1;s:7:\"view-42\";b:1;s:12:\"view-event-6\";b:1;}' , `time` = '1337453762'1 × SHOW FULL COLUMNS
FROM `jericho_community_profiles1 × show tables like '%_kunena_users1 × SHOW FULL COLUMNS
FROM `jericho_community_config1 × DELETE
FROM `jericho_session`