Jericho Airsoft has one more thing that no other field in Southern California has, and that's real, up-to-date, operational military vehicles, being used IN GAMES.
Jericho Airsoft has one more thing that no other field in Southern California has, and that's real, up-to-date, operational military vehicles, being used IN GAMES!!
On the last weekend of EVERY month, we utilise our military vehicles in massive scale scenarios, involving hundreds of players.
Jericho currently has many different vehicles, and all of them are 100% functional. Not only do we have them, but we actually use them. That's right... we actually use them in games, we transport players into , and out of the games, and use the vehicles 100% during the game. You can get into and out of the vehicles, commandeer them to stop and be used by your forces. You'll be able to get into a real military Humvee, and actually shoot the airsoft M249 from the turret!! We can deploy you in our APC, run you into enemy territory and drop you off, or medivac you to safety. We play many vehicle scenarios.

The photo on the right, is of people returning to base after a pilot rescue. There was a US pilot down in enemy territory. A successful rescue team were deployed, but during the rescue of the pilot and crew, enemy hostiles fled into a nearby Savanna with 2 dangerous compounds, able to be mixed to create a deadly WOMD.
USFORS were sent on a second objective to retreive the compounds or kill all the enemies, yet were highly outnumbered, and returned to base safely with the pilot and crew, to regroup and insert more troups for a second mission.
The turret of the Humvee is armed with an airsoft M249. This vehicle was used as a MEDIVAC vehicle, running medics to heal downed players.
The APC was used as a MEDIVAC for the Pilot and crew, as the medics atteded to the pilot during the mission.
So what vehicles do we have?
I'm glad you asked, as here's a photo of each vehicle, and what it is:

'Humvee'
The High Mobility Multipurpose Wheeled Vehicle (HMMWV or Humvee) is a military 4WD motor vehicle created by AM General. It has largely supplanted the roles formerly served by smaller Jeeps such as theM151 1/4 ton MUTT, the M561 "Gama Goat", their M718A1 and M792 ambulance versions, the CUCV, and other light trucks. Primarily used by the United States Armed Forces, it is also used by numerous other countries and organizations and even in civilian adaptations. The Hummer series was also inspired by the HMMWVs.

M1009 CUCV
M1009 - Utility version of the General Motors Chevy K5 Blazer 2nd edition. The M1009 is a utility rig built from a Blazer and could be used for command and control, as well as simple hack-around duties. It was often seen with radio sets installed, however the large square tube stock mounts prevented the rear seat from being lowered. The M1009 was rated for a 1,200 pound payload and a 3,000 pound towed load. It used the heaviest duty GM springs available for the chassis and the rear axle was a 10-bolt unit. It rolled on 10.00-15 tires, had 3.08 gears and a rear Gov-Lok.

M35 'Deuce-and-a-half'
The M35 family of trucks is a long-lived vehicle initially deployed by the United States Army, and subsequently utilized by many nations around the world. A truck in the 2½ ton weight class, it was one of many vehicles in US military service to have been referred to as the "deuce and a half." While the basic M35 cargo truck is rated to carry 5,000 pounds (2,300 kg) off road or 10,000 pounds (4,500 kg) on roads, they have been known to haul twice as much as rated. Trucks in this weight class are considered medium duty by the military and Department of Transportation. The M35 series formed the basis for a wide range of specialized vehicles.
M939 '5-ton'
The M939 series 5-ton 6x6 truck is a family of United States military logistical transportation trucks which was designed in the late 1980s and has been in service ever since. About 32,000 M939 series trucks are in service. The M939 series is an improved version of the older M809 Truck series of trucks.

'Ferret' Scout Tank
The Ferret armoured car, also commonly called the Ferret Scout car, is a British armoured fighting vehicle designed and built for reconnaissance purposes. The Ferret was produced between 1952 and 1971 by the UKcompany, Daimler. It was widely adopted by regiments in the British Army as well as Commonwealth countries throughout the period.
M1008 CUCV
M1008 - Basic General Motors Model K30903. The M1008 was the most numerous of the CUCV truck types. It was often seen with troop seats for eight in the bed. Some of the unique accoutrements to a CUCV are the military brush bars and tow hooks front and rear, as well as a pintle hitch. These trucks are rated to tow 3,000 pound cross country and were often used to tow the M101 3/4 ton trailer.
British FV432 APC
The FV432 is the armoured personnel carrier variant of the British Army's FV430 series of armoured fighting vehicles. Since its introduction in the 1960s it has been the most common variant, being used for transporting infantry on the battlefield. In the 1980s, almost 2,500 vehicles were in use, with around 1,500 now remaining in operation - mostly in supporting arms rather than front-line infantry service.
Although the FV432 Series was to have been phased out of service in favour of newer vehicles such as the Warrior and the CVR(T) series, they are now gradually being upgraded to extend their service through into the next decade.

Pierce Fire Engine
No, you're right... ...our Pierce Fire Engine isn't exactly a military vehicle. In fact, it was in use for civilian fire service. The military do still use Pierce fire Trucks, especially here in the US, on military bases, but that's no why we got it.
It's just awesome to own a fire truck, and go out across the park and hose people down with the siren blairing on a hot day.
Just in case all these awesome photos weren't enough, here's a photo gallery with photos of these vehicles in more detail, and in use in games....
Jericho Airsoft Large AO Map (Click on image for large printable map)
When we have big games, operations, and vehicle days, we combine all the fields from one side of the park, into one giant AO (Area of Operation). This makes for giant battles that are simply lot of fun to be involved in.

Imagine being holed up in a valley, with only a couple of bunkers to defend. All you have is this abandoned Firebase as your foot-hold in the territory, and you're surrounded by hostile enemies. Firebase is exactly that.

Awesome sandbag bunkers dug into the valley, and a huge double bunker with a tunnel in between them. Firebase has a lot of natural bush cover, combined with man made structures.

Trenches is one of the largest fields at the park, and really takes no explanation, as 'Trenches', is exactly what this field comprises of.
Whatever you choose to do, our network of trenches is definitely a workout, and never fails to amuse.

A huge network of trenches enable an interesting terrain to be involved in. Do you go over the top and take the next trench, or simply keep your head down and crawl?
Trenches still has a lot of ever evolving natural cover, so it allows for many different playing styles.
session.counter ⇒ 18
session.timer.start ⇒ 1337451658
session.timer.last ⇒ 1337452181
session.timer.now ⇒ 1337452327
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
sigcountarticles ⇒ 2
sigcount ⇒ 2
Application 0.000 seconds (+0.000); 0.85 MB (+0.849) - afterLoadApplication 0.082 seconds (+0.081); 7.81 MB (+6.963) - afterInitialiseApplication 0.105 seconds (+0.024); 9.52 MB (+1.708) - afterRouteApplication 0.288 seconds (+0.182); 14.58 MB (+5.064) - afterDispatchApplication 0.411 seconds (+0.123); 20.07 MB (+5.485) - beforeRenderModule mod_roknavmenu ()Application 0.437 seconds (+0.026); 21.57 MB (+1.496) - afterRenderModule mod_roknavmenu ()Application 0.440 seconds (+0.003); 21.52 MB (-0.042) - beforeRenderModule mod_roknavmenu ()Application 0.448 seconds (+0.008); 21.88 MB (+0.355) - afterRenderModule mod_roknavmenu ()Application 0.472 seconds (+0.024); 21.94 MB (+0.061) - beforeRenderModule mod_roknavmenu ()Application 0.492 seconds (+0.020); 22.24 MB (+0.305) - afterRenderModule mod_roknavmenu ()Application 0.524 seconds (+0.032); 22.28 MB (+0.037) - beforeRenderModule mod_login (Login Form)Application 0.540 seconds (+0.017); 22.37 MB (+0.094) - afterRenderModule mod_login (Login Form)Application 0.624 seconds (+0.083); 22.42 MB (+0.048) - afterRender22.48 MB (23,572,816 Bytes)SELECT `data`
FROM `jericho_session`
WHERE `session_id` = 'f5b92762becc70c69d9447d48ac724fd'DELETE
FROM `jericho_session`
WHERE `time` < '1337451727'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=11
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=11
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.11' 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 = 11
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-19 18:32:07')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-19 18:32:07')
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,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END DESC , a.createdSELECT 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 = 11
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-19 18:32:07')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-19 18:32:07')
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,
CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END DESC , 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 = 0UPDATE `jericho_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:18;s:19:\"session.timer.start\";i:1337451658;s:18:\"session.timer.last\";i:1337452181;s:17:\"session.timer.now\";i:1337452327;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:5:{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;}}}sigcountarticles|i:2;sigcount|i:2;'
, `time` = '1337452327'
WHERE `session_id` = 'f5b92762becc70c69d9447d48ac724fd'3 × 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.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 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 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 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:18;s:19:\"session.timer.start\";i:1337451658;s:18:\"session.timer.last\";i:1337452181;s:17:\"session.timer.now\";i:1337452327;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:5:{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;}}}sigcountarticles|i:2;sigcount|i:2;' , `time` = '1337452327'1 × DELETE
FROM `jericho_session`