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!

Once a year, instead of playing all these complicate mission based, objective games, we take a day to simply play all the simpler games we have, such as domination, Screw you Over, etc, on a massive scale, with 100's of players. we get sponsors involved, and we give away free guns, bbs, pistols, and many more free giveaways. It's just one big happy, fun, BIG GAME!!
...session.counter ⇒ 2
session.timer.start ⇒ 1329425324
session.timer.last ⇒ 1329425324
session.timer.now ⇒ 1329425325
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 ⇒ 75d30cea92e1c85ad66d082585cb8a94
link ⇒ http://jerichoairsoft.com/index.php/en/2-uncategorised/37-2012-events-to-be-announced-soon
expiry ⇒ 1329425325
Application 0.000 seconds (+0.000); 0.52 MB (+0.523) - afterLoadApplication 0.224 seconds (+0.224); 4.84 MB (+4.316) - afterInitialiseApplication 0.305 seconds (+0.081); 5.79 MB (+0.954) - afterRouteApplication 0.506 seconds (+0.201); 8.48 MB (+2.684) - afterDispatchApplication 0.756 seconds (+0.250); 11.68 MB (+3.201) - beforeRenderModule mod_roknavmenu ()Application 1.062 seconds (+0.306); 15.70 MB (+4.017) - afterRenderModule mod_roknavmenu ()Application 1.065 seconds (+0.003); 15.68 MB (-0.018) - beforeRenderModule mod_roknavmenu ()Application 1.117 seconds (+0.051); 15.76 MB (+0.086) - afterRenderModule mod_roknavmenu ()Application 1.172 seconds (+0.056); 15.80 MB (+0.037) - beforeRenderModule mod_roknavmenu ()Application 1.210 seconds (+0.037); 15.87 MB (+0.065) - afterRenderModule mod_roknavmenu ()Application 1.257 seconds (+0.048); 15.80 MB (-0.061) - beforeRenderModule mod_envolve_chat (Envolve Chat)Application 1.273 seconds (+0.016); 15.83 MB (+0.028) - afterRenderModule mod_envolve_chat (Envolve Chat)Application 1.273 seconds (+0.000); 15.83 MB (-0.000) - beforeRenderModule mod_login (Login Form)Application 1.281 seconds (+0.008); 15.89 MB (+0.058) - afterRenderModule mod_login (Login Form)Application 1.281 seconds (+0.000); 15.89 MB (+0.003) - beforeRenderModule mod_rokminievents (Upcoming Events)Application 1.402 seconds (+0.122); 17.31 MB (+1.421) - afterRenderModule mod_rokminievents (Upcoming Events)Application 1.403 seconds (+0.000); 17.30 MB (-0.012) - beforeRenderModule mod_onlineusers (Online Users)Application 1.449 seconds (+0.047); 17.47 MB (+0.167) - afterRenderModule mod_onlineusers (Online Users)Application 1.450 seconds (+0.000); 17.47 MB (+0.001) - beforeRenderModule mod_roknewspager (FP RokNewsPager)Application 1.590 seconds (+0.141); 17.87 MB (+0.404) - afterRenderModule mod_roknewspager (FP RokNewsPager)Application 1.591 seconds (+0.000); 17.86 MB (-0.011) - beforeRenderModule mod_ofblikebox (Optimized FB Like Box)Application 1.591 seconds (+0.001); 17.88 MB (+0.014) - afterRenderModule mod_ofblikebox (Optimized FB Like Box)Application 1.591 seconds (+0.000); 17.87 MB (-0.003) - beforeRenderModule mod_jomsocialconnect (JomSocial Connect)Application 1.630 seconds (+0.038); 18.20 MB (+0.329) - afterRenderModule mod_jomsocialconnect (JomSocial Connect)Application 1.630 seconds (+0.000); 18.20 MB (-0.000) - beforeRenderModule mod_custom (Red vs Blue)Application 1.636 seconds (+0.006); 18.21 MB (+0.005) - afterRenderModule mod_custom (Red vs Blue)Application 1.636 seconds (+0.000); 18.21 MB (+0.001) - beforeRenderModule mod_roktabs (FP RokTabs)Application 1.692 seconds (+0.056); 18.41 MB (+0.201) - beforeRenderModule mod_latestmembers (Latest Members)Application 1.799 seconds (+0.107); 18.67 MB (+0.255) - afterRenderModule mod_latestmembers (Latest Members)Application 1.830 seconds (+0.031); 18.50 MB (-0.167) - afterRenderModule mod_roktabs (FP RokTabs)Application 1.830 seconds (+0.000); 18.49 MB (-0.012) - beforeRenderModule mod_search (Search)Application 1.837 seconds (+0.007); 18.51 MB (+0.020) - afterRenderModule mod_search (Search)Application 2.055 seconds (+0.218); 18.59 MB (+0.079) - afterRender18.6 MB (19,500,984 Bytes)SELECT `data`
FROM `jericho_session`
WHERE `session_id` = 'e8b09e15704b2409e26a4c8024760de5'DELETE
FROM `jericho_session`
WHERE `time` < '1329424725'SELECT folder AS type, element AS name, params
FROM jericho_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY orderingSELECT *
FROM jericho_languages
WHERE published=1
ORDER BY ordering ASCSELECT extension_id AS id, element AS "option", params, enabled
FROM jericho_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'SELECT extension_id AS id, element AS "option", params, enabled
FROM jericho_extensions
WHERE `type` = 'component'
AND `element` = 'com_kunena'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 extension_id AS id, element AS "option", params, enabled
FROM jericho_extensions
WHERE `type` = 'component'
AND `element` = 'com_rokcandy'SELECT *
FROM jericho_rokcandy
WHERE published=1SELECT id, home, template, s.params
FROM jericho_template_styles as s
LEFT JOIN jericho_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1SELECT extension_id AS id, element AS "option", params, enabled
FROM jericho_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'SELECT extension_id AS id, element AS "option", params, enabled
FROM jericho_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'SELECT a.rules
FROM jericho_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.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 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_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
INNER JOIN jericho_content_frontpage AS fp
ON fp.content_id = a.id
WHERE a.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-16 20:48:45')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-16 20:48:45')
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 DESC
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_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
INNER JOIN jericho_content_frontpage AS fp
ON fp.content_id = a.id
WHERE a.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-16 20:48:45')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-16 20:48:45')
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 DESCSELECT 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) 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
AND (c.id=s.id OR c.language in ('en-GB','*'))
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 id, home, template, params
FROM jericho_template_styles
WHERE client_id = 0SELECT id, home, template, params
FROM jericho_template_styles
WHERE client_id = 0SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jericho_modules AS m
LEFT JOIN jericho_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jericho_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2012-02-16 20:48:45')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2012-02-16 20:48:45')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 101 OR mm.menuid <= 0)
AND m.language IN ('en-GB','*')
ORDER BY m.position, m.orderingSELECT template
FROM jericho_template_styles
WHERE home = 1
AND client_id = 0SHOW 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 *
FROM jericho_kunena_configSELECT template
FROM jericho_template_styles
WHERE home = 1
AND client_id = 0SELECT template
FROM jericho_template_styles
WHERE home = 1
AND client_id = 0select count(*)
from jericho_extensions as a
where a.element = 'com_eventlist'select count(*)
from jericho_extensions as a
where a.element = 'com_jevents'select count(*)
from jericho_extensions as a
where a.element = 'com_community'select count(*)
from jericho_extensions as a
where a.element = 'com_rsevents'SELECT DISTINCT a.*
FROM `jericho_community_events` AS a
WHERE a.`published`='1'
AND a.`catid`='1'
AND a.`type`='profile'
AND a.`contentid`=0
AND a.`enddate` > '2012-02-16 20:48:46'
ORDER BY a.`startdate` ASC
LIMIT 0, 10SELECT COUNT(DISTINCT(a.`id`))
FROM `jericho_community_events` AS a
WHERE a.`published`='1'
AND a.`catid`='1'
AND a.`type`='profile'
AND a.`contentid`=0
AND a.`enddate` > '2012-02-16 20:48:46'SELECT COUNT(DISTINCT(a.`id`))
FROM `jericho_community_events` AS a
WHERE a.`published`='1'
AND a.`catid`='1'
AND a.`type`='profile'
AND a.`contentid`=0
AND a.`enddate` > '2012-02-16 20:48:46'SHOW FULL COLUMNS
FROM `jericho_community_events`SELECT `id`
FROM `jericho_menu`
WHERE `link` LIKE '%option=com_community&view=events%'
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_events
WHERE `id` = '6'SELECT *
FROM jericho_community_events
WHERE `id` = '7'SELECT DISTINCT(a.`id`)
FROM `jericho_users` AS a
INNER JOIN `jericho_session` AS b
ON a.`id`=b.`userid`
WHERE a.`block`='0'
AND `client_id` != '1'
ORDER BY b.`time` DESC
LIMIT 10SELECT `session_id`, `username`, `userid`
FROM `jericho_session`
WHERE `client_id` = '0'
AND `guest` = '0'
GROUP BY `userid`SELECT count(`session_id`) AS guests
FROM `jericho_session`
WHERE `client_id` = '0'
AND `guest` = '1'SELECT `id`
FROM `jericho_menu`
WHERE `link` LIKE '%option=com_community&view=search%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'SELECT 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-02-16 20:48:45')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-16 20:48:45')
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) 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
AND (c.id=s.id OR c.language in ('en-GB','*'))
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=40SHOW 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=38SELECT alias
FROM jericho_content
WHERE id=36SELECT alias
FROM jericho_content
WHERE id=35SELECT alias
FROM jericho_content
WHERE id=33SELECT 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-02-16 20:48:45')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-16 20:48:45')
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 ASCSELECT 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 = 10
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-16 20:48:45')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-16 20:48:45')
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, 3SELECT *
FROM `jericho_users` AS a
INNER JOIN `jericho_community_users` AS b
ON a.`id` = b.`userid`
WHERE a.`block` = '0'
ORDER BY a.`registerDate` DESC
LIMIT 14SELECT 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 (393,392,390,388,382,381,380,378,377,375,373,372,371,370)SELECT `id`
FROM `jericho_menu`
WHERE `link` LIKE '%option=com_community&view=profile%'
AND `published`='1'
AND `menutype`!='jomsocial'
AND `type`='component'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) 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=10
AND badcats.id is null
AND (c.id=s.id OR c.language in ('en-GB','*'))
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=1UPDATE `jericho_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1329425324;s:18:\"session.timer.last\";i:1329425324;s:17:\"session.timer.now\";i:1329425325;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:\"75d30cea92e1c85ad66d082585cb8a94\";s:16:\"com_mailto.links\";a:1:{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:1329425325;}}}'
, `time` = '1329425327'
WHERE `session_id` = 'e8b09e15704b2409e26a4c8024760de5'6 × SELECT alias
FROM jericho_content5 × SELECT extension_id AS id, element AS "option", params, enabled
FROM jericho_extensions4 × SELECT `id`
FROM `jericho_menu`4 × select count(*)
from jericho_extensions as a3 × 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 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) 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.rgt3 × SELECT template
FROM jericho_template_styles2 × SELECT id, home, template, params
FROM jericho_template_styles2 × SELECT *
FROM jericho_community_events2 × 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_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 COUNT(DISTINCT(a.`id`))
FROM `jericho_community_events` AS a1 × 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 *
FROM `jericho_users` AS a
INNER JOIN `jericho_community_users` 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
INNER JOIN `jericho_session` AS b
ON a.`id`=b.`userid`1 × SELECT `session_id`, `username`, `userid`
FROM `jericho_session`1 × SELECT id, rules
FROM `jericho_viewlevels1 × SELECT count(`session_id`) AS guests
FROM `jericho_session`1 × SELECT *
FROM `jericho_users`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.`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 *
FROM jericho_rokcandy1 × SELECT id, home, template, s.params
FROM jericho_template_styles as s
LEFT JOIN jericho_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × 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 *
FROM jericho_languages1 × SELECT folder AS type, element AS name, params
FROM jericho_extensions1 × SELECT a.rules
FROM jericho_assets AS a1 × 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 *
FROM jericho_kunena_confi1 × SELECT `data`
FROM `jericho_session`1 × SELECT *
FROM jericho_community_config1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jericho_modules AS m
LEFT JOIN jericho_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jericho_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT DISTINCT a.*
FROM `jericho_community_events` AS a1 × SHOW FULL COLUMNS
FROM `jericho_users1 × UPDATE `jericho_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1329425324;s:18:\"session.timer.last\";i:1329425324;s:17:\"session.timer.now\";i:1329425325;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:\"75d30cea92e1c85ad66d082585cb8a94\";s:16:\"com_mailto.links\";a:1:{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:1329425325;}}}' , `time` = '1329425327'1 × SHOW FULL COLUMNS
FROM `jericho_community_events1 × SHOW FULL COLUMNS
FROM `jericho_community_profiles1 × SHOW FULL COLUMNS
FROM `jericho_community_config1 × show tables like '%_kunena_users1 × DELETE
FROM `jericho_session`