The Histon and Impington Golf Handicap Society ![]()
The T.H.I.G.H.S. golf society plays out of the Girton Golf Club based in Girton, Cambridge, UK. The society was formed in 1997 by Mick Woods, Steve Johnston and Tony Johnson.
T.H.I.G.H.S. weekend away at Le Touquet, May 2011 The society consists of around 20 members of varying handicaps. Every year the society plays for the T.H.I.G.H.S. Order of Merit trophy, a year-long competition played to its own handicapping system (maintained by this website), together with sundry other trophies. The winner is the person with the most money won in the season.

Leader board as at: Sat Mar 24th 2012 No. Name THIGHS
H/cap£ 1 J.Gregory 12.4 29.00 2 C.Norman 17.4 26.00 3 S.Johnston 12.2 23.00 4 J.Clough 8.3 14.00 5 G.Childerley 9.1 9.33 6 M.Soames 22.9 9.00 7 T.Johnson 12.0 7.66 8 F.Perkins 19.9 7.33 9 A.Benton 5.6 6.99 10 R.Heyes 1.8 6.50 11 G.Simons 18.8 5.00 12 R.Easton 24.4 4.00 P.Johnston 7.1 4.00 14 D.Sayward 15.0 3.50 K.Claydon 12.9 3.50 16 C.Mills 10.5 3.00 J.Clough 4.2 3.00 18 I.Rush (G) 9.8 2.50 19 R.Haslop 8.9 0.66 20 P.Hughes 16.0 0.00 A.Stevens 28.0 0.00 P.Vasey (G) 10.0 0.00 R.Orrell (G) 8.0 0.00 D.Jenkins 0.0 0.00 G.Bell 4.2 0.00 G.Dolling 11.8 0.00 I.Clark (G) 10.8 0.00 J.Kenyon 8.4 0.00 K.Andrews 6.8 0.00 M.Woods 18.0 0.00 N.Munns 10.0 0.00 N.Fenner 10.1 0.00 P.Biggs 11.3 0.00 P.Kenyon 13.8 0.00 S.Moore 16.0 0.00 S.Darling 18.0 0.00 Z.1 20.0 0.00 Z.2 18.0 0.00
session.counter ⇒ 1
session.timer.start ⇒ 1337476940
session.timer.last ⇒ 1337476940
session.timer.now ⇒ 1337476940
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 ⇒ 3a5a363c79015bfc12893046fd980c63
Application 0.002 seconds (+0.002); 0.73 MB (+0.729) - afterLoadApplication 0.286 seconds (+0.284); 6.12 MB (+5.387) - afterInitialiseApplication 0.306 seconds (+0.020); 6.63 MB (+0.517) - afterRouteApplication 0.518 seconds (+0.212); 10.53 MB (+3.898) - afterDispatchApplication 0.533 seconds (+0.016); 10.84 MB (+0.310) - beforeRenderModule mod_banners (Shop)Application 0.595 seconds (+0.062); 11.13 MB (+0.294) - afterRenderModule mod_banners (Shop)Application 0.596 seconds (+0.000); 11.13 MB (-0.008) - beforeRenderModule mod_banners (Book Store)Application 0.601 seconds (+0.005); 11.14 MB (+0.013) - afterRenderModule mod_banners (Book Store)Application 0.601 seconds (+0.000); 11.13 MB (-0.009) - beforeRenderModule mod_banners (Contribute)Application 0.607 seconds (+0.006); 11.14 MB (+0.013) - afterRenderModule mod_banners (Contribute)Application 0.608 seconds (+0.000); 11.14 MB (-0.008) - beforeRenderModule mod_menu (Results tables)Application 0.622 seconds (+0.014); 11.22 MB (+0.081) - afterRenderModule mod_menu (Results tables)Application 0.622 seconds (+0.000); 11.21 MB (-0.006) - beforeRenderModule mod_menu (Results admin)Application 0.623 seconds (+0.002); 11.22 MB (+0.006) - afterRenderModule mod_menu (Results admin)Application 0.623 seconds (+0.000); 11.21 MB (-0.005) - beforeRenderModule mod_menu (This Site)Application 0.636 seconds (+0.012); 11.28 MB (+0.067) - afterRenderModule mod_menu (This Site)Application 0.636 seconds (+0.000); 11.27 MB (-0.008) - beforeRenderModule mod_login (Login Form)Application 0.646 seconds (+0.010); 11.32 MB (+0.044) - afterRenderModule mod_login (Login Form)Application 0.646 seconds (+0.000); 11.32 MB (-0.000) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)Application 0.664 seconds (+0.018); 11.42 MB (+0.101) - afterRenderModule mod_breadcrumbs (Breadcrumbs)Application 0.664 seconds (+0.000); 11.41 MB (-0.004) - beforeRenderModule mod_search (Search)Application 0.671 seconds (+0.007); 11.44 MB (+0.024) - afterRenderModule mod_search (Search)Application 0.671 seconds (+0.000); 11.43 MB (-0.006) - beforeRenderModule mod_menu (Top)Application 0.680 seconds (+0.008); 11.44 MB (+0.014) - afterRenderModule mod_menu (Top)Application 0.694 seconds (+0.014); 11.55 MB (+0.105) - afterRender11.55 MB (12,115,536 Bytes)SELECT `data`
FROM `jos_session`
WHERE `session_id` = 'vo88f1epuoov8rbscq1u2ga3o4'SELECT `session_id`
FROM `jos_session`
WHERE `session_id` = 'vo88f1epuoov8rbscq1u2ga3o4'
LIMIT 0, 1INSERT INTO `jos_session`
(`session_id`, `client_id`, `time`)
VALUES
('vo88f1epuoov8rbscq1u2ga3o4', 0, '1337476940')SELECT extension_id AS id, element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'SELECT b.id
FROM jos_usergroups AS a
LEFT JOIN jos_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1SELECT id, rules
FROM `jos_viewlevels`SELECT folder AS type, element AS name, params
FROM jos_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY orderingSELECT extension_id AS id, element AS "option", params, enabled
FROM jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'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 jos_menu AS m
LEFT JOIN jos_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 jos_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'SELECT *
FROM jos_languages
WHERE published=1
ORDER BY ordering ASCSELECT id, home, template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_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 a.rules
FROM jos_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lftSELECT b.rules
FROM jos_assets AS a
LEFT JOIN jos_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 jos_content AS a
LEFT JOIN jos_categories AS c
ON c.id = a.catid
LEFT JOIN jos_users AS ua
ON ua.id = a.created_by
LEFT JOIN jos_users AS uam
ON uam.id = a.modified_by
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM jos_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 jos_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jos_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM jos_categories AS cat JOIN jos_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 jos_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-05-20 01:22:20')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-20 01:22:20')
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, 1SELECT 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 jos_content AS a
LEFT JOIN jos_categories AS c
ON c.id = a.catid
LEFT JOIN jos_users AS ua
ON ua.id = a.created_by
LEFT JOIN jos_users AS uam
ON uam.id = a.modified_by
LEFT JOIN (
SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM jos_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 jos_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jos_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM jos_categories AS cat JOIN jos_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 jos_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-05-20 01:22:20')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-20 01:22:20')
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 m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jos_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-05-20 01:22:20')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2012-05-20 01:22:20')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 435 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingSELECT *
FROM jos_banners
WHERE '2012-05-20 01:22:20' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM jos_banners as a
LEFT JOIN jos_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN jos_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 2
AND cl.state = 1
AND a.catid IN (15)
ORDER BY a.sticky DESC,a.orderingSELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM jos_banners as a
LEFT JOIN jos_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN jos_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 2
AND cl.state = 1
AND a.catid IN (15)
ORDER BY a.sticky DESC,a.ordering
LIMIT 0, 1UPDATE jos_banners
SET impmade = (impmade + 1)
WHERE id = 3SELECT *
FROM jos_banners
WHERE '2012-05-20 01:22:20' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM jos_banners as a
LEFT JOIN jos_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN jos_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 3
AND cl.state = 1
ORDER BY a.sticky DESC,a.orderingSELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM jos_banners as a
LEFT JOIN jos_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN jos_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 3
AND cl.state = 1
ORDER BY a.sticky DESC,a.ordering
LIMIT 0, 1UPDATE jos_banners
SET impmade = (impmade + 1)
WHERE id = 2SELECT *
FROM jos_banners
WHERE '2012-05-20 01:22:20' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM jos_banners as a
LEFT JOIN jos_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN jos_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 1
AND cl.state = 1
AND a.catid IN (15)
ORDER BY a.sticky DESC,a.orderingSELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM jos_banners as a
LEFT JOIN jos_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN jos_categories as cat
ON a.catid = cat.id
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.cid = 1
AND cl.state = 1
AND a.catid IN (15)
ORDER BY a.sticky DESC,a.ordering
LIMIT 0, 1UPDATE jos_banners
SET impmade = (impmade + 1)
WHERE id = 4UPDATE `jos_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1337476940;s:18:\"session.timer.last\";i:1337476940;s:17:\"session.timer.now\";i:1337476940;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:\"3a5a363c79015bfc12893046fd980c63\";}'
, `time` = '1337476940'
WHERE `session_id` = 'vo88f1epuoov8rbscq1u2ga3o4'6 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM jos_banners as a
LEFT JOIN jos_banner_clients AS cl
ON cl.id = a.cid
LEFT JOIN jos_categories as cat
ON a.catid = cat.id3 × SELECT extension_id AS id, element AS "option", params, enabled
FROM jos_extensions3 × SELECT *
FROM jos_banners2 × 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 jos_content AS a
LEFT JOIN jos_categories AS c
ON c.id = a.catid
LEFT JOIN jos_users AS ua
ON ua.id = a.created_by
LEFT JOIN jos_users AS uam
ON uam.id = a.modified_by
LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language
FROM jos_contact_details AS contact1 × SELECT a.rules
FROM jos_assets AS a1 × SELECT b.rules
FROM jos_assets AS a
LEFT JOIN jos_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, home, template, s.params
FROM jos_template_styles as s
LEFT JOIN jos_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN jos_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT *
FROM jos_languages1 × SELECT b.id
FROM jos_usergroups AS a
LEFT JOIN jos_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT `session_id`
FROM `jos_session`1 × SELECT id, rules
FROM `jos_viewlevels1 × SELECT folder AS type, element AS name, params
FROM jos_extensions1 × 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 jos_menu AS m
LEFT JOIN jos_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `data`
FROM `jos_session`3 × UPDATE jos_banners
SET impmade = (impmade + 1)1 × UPDATE `jos_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1337476940;s:18:\"session.timer.last\";i:1337476940;s:17:\"session.timer.now\";i:1337476940;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:\"3a5a363c79015bfc12893046fd980c63\";}' , `time` = '1337476940'1 × INSERT INTO `jos_session` (`session_id`, `client_id`, `time`)
VALUES ('vo88f1epuoov8rbscq1u2ga3o4', 0, '1337476940'