Saturday:
Day Games: 8am - 4pm
(Night Games will return in the spring)
Sunday:
Day Games: 8am-4pm
Weekdays:
Games are available during the week days by booking a private group of 15 people or more.
$25.00 All-Day Admission from 8:00am - 4:00pm
Airsoft Rental Package: $55.00 - Admission, Full Metal AEG Airsoft Rifle, 1000 High Quality bbs, Rental Mask, BDU Jacket
Note: There are no half-day rental package discounts available for individuals/walk-ons
'Private Group' means your group stays exclusive. You won't play against other groups or walk-on players, We assign you to one of our Game Co-Ordinators, and you'll play on the different fields.
Note: Private Groups must be booked at least 1 week in advance.
Full Day Private Groups are required to have a minimum of 15 players*, and take place from 9:00am- 4:00pm.
$20.00 All-Day Admission from 8:00am - 4:00pm
Half Day Private Groups are required to have a minimum of 15 players*, and can be booked from either 9:00am - 12:30pm, or 12:30 - 4:00pm
$15.00 Half Day Admission
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!

The players from Jericho loved this idea when we all discussed it on facebook and on this web site recently, so here it is. Our southern california airsoft swap meet, where players can come and set up their stuff to sell, and/or play airsoft, too!!
session.counter ⇒ 8
session.timer.start ⇒ 1337449715
session.timer.last ⇒ 1337450015
session.timer.now ⇒ 1337450040
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 ⇒ 1337450040
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.079 seconds (+0.078); 7.81 MB (+6.964) - afterInitialiseApplication 0.101 seconds (+0.022); 9.52 MB (+1.708) - afterRouteApplication 0.210 seconds (+0.109); 14.22 MB (+4.700) - afterDispatchApplication 0.325 seconds (+0.115); 19.68 MB (+5.456) - beforeRenderModule mod_roknavmenu ()Application 0.352 seconds (+0.026); 21.16 MB (+1.483) - afterRenderModule mod_roknavmenu ()Application 0.355 seconds (+0.003); 21.13 MB (-0.029) - beforeRenderModule mod_roknavmenu ()Application 0.363 seconds (+0.008); 21.48 MB (+0.355) - afterRenderModule mod_roknavmenu ()Application 0.376 seconds (+0.013); 21.55 MB (+0.061) - beforeRenderModule mod_roknavmenu ()Application 0.381 seconds (+0.006); 21.87 MB (+0.321) - afterRenderModule mod_roknavmenu ()Application 0.414 seconds (+0.033); 23.21 MB (+1.347) - beforeRenderModule mod_login (Login Form)Application 0.420 seconds (+0.006); 23.31 MB (+0.094) - afterRenderModule mod_login (Login Form)Application 0.434 seconds (+0.014); 23.34 MB (+0.037) - beforeRenderModule mod_rokminievents (Upcoming Events)Application 0.441 seconds (+0.007); 23.70 MB (+0.352) - afterRenderModule mod_rokminievents (Upcoming Events)Application 0.456 seconds (+0.015); 23.71 MB (+0.018) - beforeRenderModule mod_roknewspager (FP RokNewsPager)Application 0.492 seconds (+0.036); 24.21 MB (+0.501) - afterRenderModule mod_roknewspager (FP RokNewsPager)Application 0.505 seconds (+0.013); 24.24 MB (+0.029) - beforeRenderModule mod_roktabs (FP RokTabs)Application 0.508 seconds (+0.003); 24.39 MB (+0.147) - afterRenderModule mod_roktabs (FP RokTabs)Application 0.565 seconds (+0.057); 22.96 MB (-1.432) - afterRender22.97 MB (24,083,080 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 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' 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 c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
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
LEFT JOIN `jericho_content` AS i
ON i.`catid` = c.id
AND i.state = 1
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.category.2' OR a.parent_id=0)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lftSELECT 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 = 2
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-19 17:54:00')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-19 17:54:00')
AND a.language in ('en-GB','*')
AND (contact.language in ('en-GB','*') OR contact.language IS NULL)
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 c.lft, fp.ordering, a.created
LIMIT 0, 4SELECT 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 = 2
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-19 17:54:00')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-19 17:54:00')
AND a.language in ('en-GB','*')
AND (contact.language in ('en-GB','*') OR contact.language IS NULL)
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 c.lft, fp.ordering, a.createdSELECT 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:00')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-19 17:54:00')
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:00')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-19 17:54:00')
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:8;s:19:\"session.timer.start\";i:1337449715;s:18:\"session.timer.last\";i:1337450015;s:17:\"session.timer.now\";i:1337450040;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:1337450040;}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` = '1337450040'
WHERE `session_id` = '13128b31a7d94b0e05194cf87a0683fd'5 × SELECT alias
FROM jericho_content4 × 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 contact3 × SELECT template
FROM jericho_template_styles2 × 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 `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 *
FROM `jericho_users`1 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
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 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 `data`
FROM `jericho_session`1 × UPDATE `jericho_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:8;s:19:\"session.timer.start\";i:1337449715;s:18:\"session.timer.last\";i:1337450015;s:17:\"session.timer.now\";i:1337450040;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:1337450040;}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` = '1337450040'1 × SHOW FULL COLUMNS
FROM `jericho_users