All Star African Adventure!!

Planning a trip to take a group of ten All-Stars to East Africa and the Third World is no small thing, especially when you consider that there could be difficulties and trouble around every corner, no matter how well prepared you are!

Not everyone sees things from the same perspective and where a seasoned visitor to Africa would see need, poverty and an opportunity to help; it’s very easy for caring parents to dwell on the dangers, of which there are plenty!

Building for the Future at Ferndale

Starting Sporting Marvels wasn’t easy. And neither was establishing ourselves within comprehensive school life and the respective PE departments of our pilot schools. While Phil, Sporting Marvels Founder & Chairman, knew what he wanted the Marvels to be, he didn’t exactly know what he wanted them to do. He had to work that one out on route!

Becky's Our Longest Serving Marvel Ever!

The 2012/13 school year sees Sporting Marvels Director of Operations, Becky Davies, reach a major landmark, and become the longest serving schools worker in Sporting Marvels history!

It was June 2006 that Becky, daughter of Sporting Marvels trustee and Rhondda rugby coaching legend, Chris Jones, sat in Phil’s office trying her utmost to convince him of her desire to work for Sporting Marvels!

All Star Fancy Dress Party

It was a Christmas to remember at Sporting Marvels this year, and one of the highlights was definitely the ‘All-Star Christmas Fancy Dress Party’!

With the dynamic duo of Smithy and Couchy donning their comic book costumes as Flash and Popeye, and former Marvel Ashleigh Parfitt as Desperate Dan there were plenty of points awarded for effort! Despite a great showing from Smithy & Couchy, they were definitely outclassed by the amazing Jody Barnes, whose appearance as Paramount Pictures Lara Croft: the Tomb Raider, nearly had the Rhondda Leader thinking that Angelina Jolie was in town, at Ystrad Labour Club!

Feedback from the Classroom

A key ingredient of the Mighty Marvels programme in the primary and junior schools is what we call the “Royal Law” lesson where we teach the children about Jesus’ command that we “love our neighbour”.

When the Marv’s explain that Sporting Marvels is our way of loving our neighbour, the kids can’t wait to express their thanks and gratitude, and their letters of appreciation come thick and fast!

Here’s a selection from those received from the pupils of three of our partner schools - Cwmclydach, YGG Bodringallt and Penygraig - and to save on space, Sporting Marvels is abbreviated to “SM”…..

Head Teacher Appraisals: Like Music To Our Ears!

With preparations for what’ll be our tenth school year in full swing, we thought that our readers might like to take a look at some of the great things the Head Teachers at our partner primary schools said about us in their 2011/12 appraisals.

As you’ll see, the feedback is quite amazing and all positive!!

To have such positive affirmation speaks volumes for the esteem in which we are held by the schools, and it’s obvious they value and appreciate both what we do for the kids and also, how we do it!

Page 1 of 5

Start
Prev
1
2
3
4
5
Next
End

Profile Information

Application 0.000 seconds (+0.000); 0.43 MB (+0.430) - afterLoad

Application 0.623 seconds (+0.623); 5.78 MB (+5.345) - afterInitialise

Application 0.669 seconds (+0.046); 6.71 MB (+0.931) - afterRoute

Application 1.413 seconds (+0.744); 17.46 MB (+10.753) - afterDispatch

Application 1.466 seconds (+0.052); 17.99 MB (+0.531) - beforeRenderModule mod_roknavmenu ()

Application 1.524 seconds (+0.058); 19.65 MB (+1.656) - afterRenderModule mod_roknavmenu ()

Application 1.558 seconds (+0.034); 19.65 MB (+0.006) - beforeRenderModule mod_roknavmenu (side menu)

Application 1.563 seconds (+0.005); 19.68 MB (+0.029) - afterRenderModule mod_roknavmenu (side menu)

Application 1.564 seconds (+0.000); 19.65 MB (-0.027) - beforeRenderModule mod_custom (Find us on Facebook)

Application 1.567 seconds (+0.004); 19.66 MB (+0.008) - afterRenderModule mod_custom (Find us on Facebook)

Application 1.568 seconds (+0.000); 19.66 MB (-0.002) - beforeRenderModule mod_custom (Sporting Marvels In Focus)

Application 1.569 seconds (+0.002); 19.67 MB (+0.005) - afterRenderModule mod_custom (Sporting Marvels In Focus)

Application 1.569 seconds (+0.000); 19.66 MB (-0.002) - beforeRenderModule mod_custom (Virgin Money Giving)

Application 1.571 seconds (+0.002); 19.67 MB (+0.005) - afterRenderModule mod_custom (Virgin Money Giving)

Application 1.571 seconds (+0.000); 19.67 MB (-0.002) - beforeRenderModule mod_custom (SMTV)

Application 1.573 seconds (+0.002); 19.67 MB (+0.005) - afterRenderModule mod_custom (SMTV)

Application 1.573 seconds (+0.000); 19.68 MB (+0.005) - beforeRenderModule mod_rokstories (Banners)

Application 1.622 seconds (+0.048); 20.08 MB (+0.404) - afterRenderModule mod_rokstories (Banners)

Application 1.624 seconds (+0.002); 20.14 MB (+0.059) - afterRender

Memory Usage

18.65 MB (19,557,744 Bytes)

24 Queries Logged

SELECT `data`
FROM `smj17_session`
WHERE `session_id` = 'm506969c6d7hdbf8q17f473ja6'
DELETE
FROM `smj17_session`
WHERE `time` < 1369466823
SELECT `session_id`
  FROM `smj17_session`
  WHERE `session_id` = 'm506969c6d7hdbf8q17f473ja6'
  LIMIT 0, 1
INSERT INTO `smj17_session` (`session_id`, `client_id`, `time`)
VALUES ('m506969c6d7hdbf8q17f473ja6', 0, 1369467723)
SELECT extension_id AS "id", element AS "option", params, enabled
  FROM smj17_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_users'
SELECT id, rules
FROM `smj17_viewlevels`
SELECT folder AS type, element AS name, params
  FROM smj17_extensions
  WHERE enabled >= 1
  AND type ='plugin'
  AND state >= 0
  AND access IN (1,1)
  ORDER BY ordering
SELECT *
  FROM smj17_languages
  WHERE published=1
  ORDER BY ordering ASC
SELECT extension_id AS "id", element AS "option", params, enabled
  FROM smj17_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_languages'
SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,m.language,e.element as component
  FROM smj17_menu AS m
  LEFT JOIN smj17_extensions AS e
  ON m.component_id = e.extension_id
  WHERE m.published = 1
  AND m.parent_id > 0
  AND m.client_id = 0
  AND m.access IN (1,1)
  ORDER BY m.lft
SELECT extension_id AS "id", element AS "option", params, enabled
  FROM smj17_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_content'
SELECT id, home, template, s.params
  FROM smj17_template_styles as s
  LEFT JOIN smj17_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 = 1
SELECT a.rules
FROM smj17_assets AS a
WHERE a.id = 1
SELECT b.rules
  FROM smj17_assets AS a
  LEFT JOIN smj17_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.name = 'com_content'
  ORDER BY b.lft
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.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 ) 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 smj17_content AS a
  LEFT JOIN smj17_categories AS c
  ON c.id = a.catid
  LEFT JOIN smj17_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN smj17_users AS uam
  ON uam.id = a.modified_by
  LEFT JOIN smj17_contact_details AS contact
  on contact.user_id = a.created_by
  LEFT JOIN smj17_categories as parent
  ON parent.id = c.parent_id
  LEFT JOIN smj17_content_rating AS v
  ON a.id = v.content_id
  LEFT
  OUTER JOIN (SELECT cat.id as id
  FROM smj17_categories AS cat JOIN smj17_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 smj17_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 <= '2013-05-25 07:42:04')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-05-25 07:42:04')
  AND a.language in ('en-GB','*')
  AND (contact.language in ('en-GB','*') OR contact.language IS NULL)
  ORDER BY c.lft, fp.ordering, a.created DESC
  LIMIT 0, 6
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.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 ) 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 smj17_content AS a
  LEFT JOIN smj17_categories AS c
  ON c.id = a.catid
  LEFT JOIN smj17_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN smj17_users AS uam
  ON uam.id = a.modified_by
  LEFT JOIN smj17_contact_details AS contact
  on contact.user_id = a.created_by
  LEFT JOIN smj17_categories as parent
  ON parent.id = c.parent_id
  LEFT JOIN smj17_content_rating AS v
  ON a.id = v.content_id
  LEFT
  OUTER JOIN (SELECT cat.id as id
  FROM smj17_categories AS cat JOIN smj17_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 smj17_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 <= '2013-05-25 07:42:04')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-05-25 07:42:04')
  AND a.language in ('en-GB','*')
  AND (contact.language in ('en-GB','*') OR contact.language IS NULL)
  ORDER BY c.lft, fp.ordering, a.created DESC
SELECT id, home, template, s.params
  FROM smj17_template_styles as s
  LEFT JOIN smj17_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 = 1
SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
  FROM smj17_categories as c
  LEFT JOIN smj17_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 smj17_categories AS cat JOIN smj17_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=82
  AND badcats.id is null
  AND (c.id=s.id OR c.language in ('en-GB','*'))
  GROUP BY c.id
  ORDER BY c.lft
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM smj17_modules AS m
  LEFT JOIN smj17_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN smj17_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 <= '2013-05-25 07:42:04')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2013-05-25 07:42:04')
  AND m.access IN (1,1)
  AND m.client_id = 0
  AND (mm.menuid = 435 OR mm.menuid <= 0)
  AND m.language IN ('en-GB','*')
  ORDER BY m.position, m.ordering
SELECT template
  FROM smj17_template_styles
  WHERE home = 1
  AND client_id = 0
SELECT template
  FROM smj17_template_styles
  WHERE home = 1
  AND client_id = 0
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.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 ) 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 smj17_content AS a
  LEFT JOIN smj17_content_frontpage AS fp
  ON fp.content_id = a.id
  LEFT JOIN smj17_categories AS c
  ON c.id = a.catid
  LEFT JOIN smj17_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN smj17_users AS uam
  ON uam.id = a.modified_by
  LEFT JOIN smj17_contact_details AS contact
  on contact.user_id = a.created_by
  LEFT JOIN smj17_categories as parent
  ON parent.id = c.parent_id
  LEFT JOIN smj17_content_rating AS v
  ON a.id = v.content_id
  LEFT
  OUTER JOIN (SELECT cat.id as id
  FROM smj17_categories AS cat JOIN smj17_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 = 85
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-05-25 07:42:04')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-05-25 07:42:04')
  ORDER BY a.created DESC
  LIMIT 0, 10
SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
  FROM smj17_categories as c
  LEFT JOIN smj17_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 smj17_categories AS cat JOIN smj17_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=85
  AND badcats.id is null
  AND (c.id=s.id OR c.language in ('en-GB','*'))
  GROUP BY c.id
  ORDER BY c.lft
UPDATE `smj17_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1369467723;s:18:\"session.timer.last\";i:1369467723;s:17:\"session.timer.now\";i:1369467723;s:22:\"session.client.browser\";s:9:\"CCBot/2.0\";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;}}', `time` = 1369467724
WHERE `session_id` = 'm506969c6d7hdbf8q17f473ja6'

18 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

3 × SELECT extension_id AS "id", element AS "option", params, enabled FROM smj17_extensions
2 × SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug FROM smj17_categories as c LEFT JOIN smj17_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 smj17_categories AS cat JOIN smj17_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
2 × SELECT template FROM smj17_template_styles
2 × 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.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 ) 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 smj17_content AS a LEFT JOIN smj17_categories AS c ON c.id = a.catid LEFT JOIN smj17_users AS ua ON ua.id = a.created_by LEFT JOIN smj17_users AS uam ON uam.id = a.modified_by LEFT JOIN smj17_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN smj17_categories as parent ON parent.id = c.parent_id LEFT JOIN smj17_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM smj17_categories AS cat JOIN smj17_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
2 × SELECT id, home, template, s.params FROM smj17_template_styles as s LEFT JOIN smj17_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
1 × SELECT id, rules FROM `smj17_viewlevels
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM smj17_modules AS m LEFT JOIN smj17_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN smj17_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
1 × SELECT `session_id` FROM `smj17_session`
1 × 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.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 ) 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 smj17_content AS a LEFT JOIN smj17_content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN smj17_categories AS c ON c.id = a.catid LEFT JOIN smj17_users AS ua ON ua.id = a.created_by LEFT JOIN smj17_users AS uam ON uam.id = a.modified_by LEFT JOIN smj17_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN smj17_categories as parent ON parent.id = c.parent_id LEFT JOIN smj17_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM smj17_categories AS cat JOIN smj17_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
1 × SELECT folder AS type, element AS name, params FROM smj17_extensions
1 × SELECT b.rules FROM smj17_assets AS a LEFT JOIN smj17_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,m.language,e.element as component FROM smj17_menu AS m LEFT JOIN smj17_extensions AS e ON m.component_id = e.extension_id
1 × SELECT `data` FROM `smj17_session`
1 × SELECT a.rules FROM smj17_assets AS a
1 × SELECT * FROM smj17_languages

OTHER Tables:

1 × UPDATE `smj17_session` SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1369467723;s:18:\"session.timer.last\";i:1369467723;s:17:\"session.timer.now\";i:1369467723;s:22:\"session.client.browser\";s:9:\"CCBot/2.0\";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;}}', `time` = 1369467724
1 × INSERT INTO `smj17_session` (`session_id`, `client_id`, `time`) VALUES ('m506969c6d7hdbf8q17f473ja6', 0, 1369467723
1 × DELETE FROM `smj17_session`