This is the time of year where we start planning our big events for the year. Within the next fee days, we'll be adding details of all our major events coming up this year. We can't really say too much right now, but there's one thing I can definitely guarantee...
...this year, we're planning for a bigger and better year than ever before, with bigger,faster, more milsim events than ever before.
Watch this space for details!
session.counter ⇒ 9
session.timer.start ⇒ 1337449715
session.timer.last ⇒ 1337450040
session.timer.now ⇒ 1337450066
session.client.browser ⇒ CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
registry ⇒ {}
id ⇒ 0
name ⇒
username ⇒
email ⇒
password ⇒
password_clear ⇒
usertype ⇒
block ⇒
sendEmail ⇒ 0
registerDate ⇒
lastvisitDate ⇒
activation ⇒
params ⇒
groups ⇒ Array
guest ⇒ 1
aid ⇒ 0
session.token ⇒ bb7b2e689c97570531c0e92ffefc0c40
link ⇒ http://jerichoairsoft.com/index.php/en/12-fp-roknewspager/33-were-open-on-black-friday
expiry ⇒ 1337449914
link ⇒ http://jerichoairsoft.com/index.php/en/12-fp-roknewspager/35-happy-new-year-2012
expiry ⇒ 1337449940
link ⇒ http://jerichoairsoft.com/index.php/en/12-fp-roknewspager/36-were-open-mlk-day
expiry ⇒ 1337449962
link ⇒ http://jerichoairsoft.com/index.php/en/12-fp-roknewspager/38-we-play-in-the-rain
expiry ⇒ 1337449989
link ⇒ http://jerichoairsoft.com/index.php/en/12-fp-roknewspager/40-red-vs-blue-feb-25th
expiry ⇒ 1337450015
link ⇒ http://jerichoairsoft.com/index.php/en/info/hours-of-operation
expiry ⇒ 1337450040
link ⇒ http://jerichoairsoft.com/index.php/en/info/prices-a-private-groups
expiry ⇒ 1337450040
link ⇒ http://jerichoairsoft.com/index.php/en/2-uncategorised/37-2012-events-to-be-announced-soon
expiry ⇒ 1337450066
link ⇒ http://jerichoairsoft.com/index.php/en/2-uncategorised/45-jericho-airsoft-swap-meet-april-14th
expiry ⇒ 1337450040
Application 0.000 seconds (+0.000); 0.85 MB (+0.849) - afterLoadApplication 0.174 seconds (+0.174); 7.82 MB (+6.967) - afterInitialiseApplication 0.214 seconds (+0.039); 9.32 MB (+1.504) - afterRouteApplication 0.325 seconds (+0.112); 13.49 MB (+4.168) - afterDispatchApplication 0.530 seconds (+0.204); 18.94 MB (+5.456) - beforeRenderModule mod_roknavmenu ()Application 0.570 seconds (+0.040); 20.45 MB (+1.503) - afterRenderModule mod_roknavmenu ()Application 0.573 seconds (+0.003); 20.42 MB (-0.029) - beforeRenderModule mod_roknavmenu ()Application 0.583 seconds (+0.010); 20.77 MB (+0.355) - afterRenderModule mod_roknavmenu ()Application 0.596 seconds (+0.013); 20.83 MB (+0.061) - beforeRenderModule mod_roknavmenu ()Application 0.604 seconds (+0.008); 21.15 MB (+0.320) - afterRenderModule mod_roknavmenu ()Application 0.642 seconds (+0.037); 22.76 MB (+1.605) - beforeRenderModule mod_login (Login Form)Application 0.648 seconds (+0.006); 22.85 MB (+0.094) - afterRenderModule mod_login (Login Form)Application 0.663 seconds (+0.015); 22.89 MB (+0.037) - beforeRenderModule mod_rokminievents (Upcoming Events)Application 0.671 seconds (+0.008); 23.24 MB (+0.352) - afterRenderModule mod_rokminievents (Upcoming Events)Application 0.687 seconds (+0.016); 23.26 MB (+0.017) - beforeRenderModule mod_roknewspager (FP RokNewsPager)Application 0.793 seconds (+0.106); 24.01 MB (+0.746) - afterRenderModule mod_roknewspager (FP RokNewsPager)Application 0.812 seconds (+0.019); 24.03 MB (+0.028) - beforeRenderModule mod_roktabs (FP RokTabs)Application 0.815 seconds (+0.003); 24.18 MB (+0.147) - afterRenderModule mod_roktabs (FP RokTabs)Application 0.868 seconds (+0.054); 22.48 MB (-1.699) - afterRender22.48 MB (23,574,560 Bytes)SELECT `data`
FROM `jericho_session`
WHERE `session_id` = '13128b31a7d94b0e05194cf87a0683fd'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 b.rules
FROM jericho_assets AS a
LEFT JOIN jericho_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content' OR a.parent_id=0)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftSELECT 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 a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM jericho_content AS a
LEFT JOIN jericho_categories AS c
on c.id = a.catid
LEFT JOIN jericho_users AS u
on u.id = a.created_by
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM jericho_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact
ON contact.user_id = a.created_by
LEFT JOIN jericho_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jericho_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM jericho_categories AS cat JOIN jericho_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 37
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-19 17:54:26')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-19 17:54:26')
AND (a.state = 1 OR a.state =2)SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM jericho_categories as c
LEFT JOIN jericho_categories AS s
ON (s.lft < c.lft
AND s.rgt > c.rgt
AND c.language in ('en-GB','*')) OR (s.lft >= c.lft
AND s.rgt <= c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM jericho_categories AS cat JOIN jericho_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=2
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT b.rules
FROM jericho_assets AS a
LEFT JOIN jericho_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.37' OR a.parent_id=0)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftSELECT a.id,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM jericho_content AS a
LEFT JOIN jericho_categories AS cc
ON cc.id = a.catid
WHERE a.catid = 2
AND a.state = 1
AND a.access = 1
AND (a.state = 1 OR a.state = -1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2012-05-19 17:54:26')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2012-05-19 17:54:26')
AND a.language in ('en-GB','*')
ORDER BY a.orderingUPDATE jericho_content
SET hits = hits + 1
WHERE id = 37SELECT 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 id, rules
FROM `jericho_viewlevels`SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM jericho_content AS a
LEFT JOIN jericho_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN jericho_categories AS c
ON c.id = a.catid
LEFT JOIN jericho_users AS ua
ON ua.id = a.created_by
LEFT JOIN jericho_users AS uam
ON uam.id = a.modified_by
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM jericho_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact
ON contact.user_id = a.created_by
LEFT JOIN jericho_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jericho_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM jericho_categories AS cat JOIN jericho_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 12
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-19 17:54:26')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-19 17:54:26')
GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls
ORDER BY a.id DESC
LIMIT 0, 5SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM jericho_categories as c
LEFT JOIN jericho_categories AS s
ON (s.lft < c.lft
AND s.rgt > c.rgt
AND c.language in ('en-GB','*')) OR (s.lft >= c.lft
AND s.rgt <= c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM jericho_categories AS cat JOIN jericho_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=12
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lftSELECT alias
FROM jericho_content
WHERE id=51SHOW FULL COLUMNS
FROM `jericho_users`SELECT *
FROM `jericho_users`
WHERE `id` = 42SELECT `g`.`id`,`g`.`title`
FROM `jericho_usergroups` AS g
INNER JOIN `jericho_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 42SELECT alias
FROM jericho_content
WHERE id=49SELECT alias
FROM jericho_content
WHERE id=48SELECT alias
FROM jericho_content
WHERE id=47SELECT alias
FROM jericho_content
WHERE id=44SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM jericho_content AS a
LEFT JOIN jericho_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN jericho_categories AS c
ON c.id = a.catid
LEFT JOIN jericho_users AS ua
ON ua.id = a.created_by
LEFT JOIN jericho_users AS uam
ON uam.id = a.modified_by
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM jericho_contact_details AS contact
WHERE contact.published = 1
GROUP BY contact.user_id, contact.language) AS contact
ON contact.user_id = a.created_by
LEFT JOIN jericho_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jericho_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM jericho_categories AS cat JOIN jericho_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 12
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-19 17:54:26')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-19 17:54:26')
GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls
ORDER BY a.ordering ASCUPDATE `jericho_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:9;s:19:\"session.timer.start\";i:1337449715;s:18:\"session.timer.last\";i:1337450040;s:17:\"session.timer.now\";i:1337450066;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\":0:{}}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:\"bb7b2e689c97570531c0e92ffefc0c40\";s:16:\"com_mailto.links\";a:9:{s:40:\"2fd7095e9ae762bfd6c5e6041934a2d76292042e\";O:8:\"stdClass\":2:{s:4:\"link\";s:86:\"http://jerichoairsoft.com/index.php/en/12-fp-roknewspager/33-were-open-
on-black-friday\";s:6:\"expiry\";i:1337449914;}s:40:\"cde36ce71b23f303cfa5aa18603c7e171b56b25b\";O:8:\"stdClass\":2:{s:4:\"link\";s:80:\"http://jerichoairsoft.com/index.php/en/12-fp-roknewspager/35-happy-new-year-2012\";s:6:\"expiry\";i:1337449940;}s:40:\"3f07508226ce4806cf97bb4928fbff7cbaf339d5\";O:8:\"stdClass\":2:{s:4:\"link\";s:78:\"http://jerichoairsoft.com/index.php/en/12-fp-roknewspager/36-were-open-mlk-day\";s:6:\"expiry\";i:1337449962;}s:40:\"7f29a05c2e046abbd4213b1705ec71400c6010aa\";O:8:\"stdClass\":2:{s:4:\"link\";s:80:\"http://jerichoairsoft.com/index.php/en/12-fp-roknewspager/38-we-play-in-the-rain\";s:6:\"expiry\";i:1337449989;}s:40:\"ece95eecf6f5f52c0317f3b7c3d9716b08e573fd\";O:8:\"stdClass\":2:{s:4:\"link\";s:81:\"http://jerichoairsoft.com/index.php/en/12-fp-roknewspager/40-red-vs-blue-feb-25th\";s:6:\"expiry\";i:1337450015;}s:40:\"dbacc4a64d963ae4c6451a6a62191501424939b0\";O:8:\"stdClass\":2:{s:4:\"link\";s:62:\"http://jerichoairsoft.com/index.php/en/info/hours-of-operation\";s:6:\"expiry\";i:1337450040;}s:40:\"20fa94ffdc247656e8be35806b2691854a2d287d\";O:8:\"stdClass\":2:{s:4:\"link\";s:67:\"http://jerichoairsoft.com/index.php/en/info/prices-a-private-groups\";s:6:\"expiry\";i:1337450040;}s:40:\"ddd1cbd520aebabcecb54b5d5877de239455b6c9\";O:8:\"stdClass\":2:{s:4:\"link\";s:90:\"http://jerichoairsoft.com/index.php/en/2-uncategorised/37-2012-events-to-be-announced-soon\";s:6:\"expiry\";i:1337450066;}s:40:\"ee4e7516aa0f31f61db9de581908a342a2ad6108\";O:8:\"stdClass\":2:{s:4:\"link\";s:94:\"http://jerichoairsoft.com/index.php/en/2-uncategorised/45-jericho-airsoft-swap-meet-april-14th\";s:6:\"expiry\";i:1337450040;}}}'
, `time` = '1337450066'
WHERE `session_id` = '13128b31a7d94b0e05194cf87a0683fd'5 × SELECT alias
FROM jericho_content3 × SELECT template
FROM jericho_template_styles2 × SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM jericho_content AS a
LEFT JOIN jericho_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN jericho_categories AS c
ON c.id = a.catid
LEFT JOIN jericho_users AS ua
ON ua.id = a.created_by
LEFT JOIN jericho_users AS uam
ON uam.id = a.modified_by
LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM jericho_contact_details AS contact2 × SELECT b.rules
FROM jericho_assets AS a
LEFT JOIN jericho_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt2 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM jericho_categories as c
LEFT JOIN jericho_categories AS s
ON (s.lft < c.lft
AND s.rgt > c.rgt
AND c.language in ('en-GB','*')) OR (s.lft >= c.lft
AND s.rgt <= c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM jericho_categories AS cat JOIN jericho_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt1 × SELECT *
FROM `jericho_users`1 × SELECT `g`.`id`,`g`.`title`
FROM `jericho_usergroups` AS g
INNER JOIN `jericho_user_usergroup_map` AS m
ON m.group_id = g.id1 × SELECT id, rules
FROM `jericho_viewlevels1 × SELECT a.id,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM jericho_content AS a
LEFT JOIN jericho_categories AS cc
ON cc.id = a.catid1 × 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 b.id
FROM jericho_usergroups AS a
LEFT JOIN jericho_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM jericho_content AS a
LEFT JOIN jericho_categories AS c
on c.id = a.catid
LEFT JOIN jericho_users AS u
on u.id = a.created_by
LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM jericho_contact_details AS contact1 × SELECT `data`
FROM `jericho_session`1 × UPDATE `jericho_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:9;s:19:\"session.timer.start\";i:1337449715;s:18:\"session.timer.last\";i:1337450040;s:17:\"session.timer.now\";i:1337450066;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\":0:{}}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:\"bb7b2e689c97570531c0e92ffefc0c40\";s:16:\"com_mailto.links\";a:9:{s:40:\"2fd7095e9ae762bfd6c5e6041934a2d76292042e\";O:8:\"stdClass\":2:{s:4:\"link\";s:86:\"http://jerichoairsoft.com/index.php/en/12-fp-roknewspager/33-were-open-
on-black-friday\";s:6:\"expiry\";i:1337449914;}s:40:\"cde36ce71b23f303cfa5aa18603c7e171b56b25b\";O:8:\"stdClass\":2:{s:4:\"link\";s:80:\"http://jerichoairsoft.com/index.php/en/12-fp-roknewspager/35-happy-new-year-2012\";s:6:\"expiry\";i:1337449940;}s:40:\"3f07508226ce4806cf97bb4928fbff7cbaf339d5\";O:8:\"stdClass\":2:{s:4:\"link\";s:78:\"http://jerichoairsoft.com/index.php/en/12-fp-roknewspager/36-were-open-mlk-day\";s:6:\"expiry\";i:1337449962;}s:40:\"7f29a05c2e046abbd4213b1705ec71400c6010aa\";O:8:\"stdClass\":2:{s:4:\"link\";s:80:\"http://jerichoairsoft.com/index.php/en/12-fp-roknewspager/38-we-play-in-the-rain\";s:6:\"expiry\";i:1337449989;}s:40:\"ece95eecf6f5f52c0317f3b7c3d9716b08e573fd\";O:8:\"stdClass\":2:{s:4:\"link\";s:81:\"http://jerichoairsoft.com/index.php/en/12-fp-roknewspager/40-red-vs-blue-feb-25th\";s:6:\"expiry\";i:1337450015;}s:40:\"dbacc4a64d963ae4c6451a6a62191501424939b0\";O:8:\"stdClass\":2:{s:4:\"link\";s:62:\"http://jerichoairsoft.com/index.php/en/info/hours-of-operation\";s:6:\"expiry\";i:1337450040;}s:40:\"20fa94ffdc247656e8be35806b2691854a2d287d\";O:8:\"stdClass\":2:{s:4:\"link\";s:67:\"http://jerichoairsoft.com/index.php/en/info/prices-a-private-groups\";s:6:\"expiry\";i:1337450040;}s:40:\"ddd1cbd520aebabcecb54b5d5877de239455b6c9\";O:8:\"stdClass\":2:{s:4:\"link\";s:90:\"http://jerichoairsoft.com/index.php/en/2-uncategorised/37-2012-events-to-be-announced-soon\";s:6:\"expiry\";i:1337450066;}s:40:\"ee4e7516aa0f31f61db9de581908a342a2ad6108\";O:8:\"stdClass\":2:{s:4:\"link\";s:94:\"http://jerichoairsoft.com/index.php/en/2-uncategorised/45-jericho-airsoft-swap-meet-april-14th\";s:6:\"expiry\";i:1337450040;}}}' , `time` = '1337450066'1 × SHOW FULL COLUMNS
FROM `jericho_users1 × UPDATE jericho_content
SET hits = hits + 1