Read Database Error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group by CONCAT (YEAR(posts.releaseDateTime),'-', MONTH(posts.releaseDateTime)) ' at line 1

Write Database Error:

Last Query:
SELECT YEAR(posts.releaseDateTime) as PostYear, MONTH(posts.releaseDateTime) as PostMonth, count(posts.id) as PostCount , blogs.liveURL as blogURL FROM (pages as blogs inner join pages as posts on blogs.id=posts.page_id) inner join templates on posts.template_id=templates.id where templates.tag ='blogpost' and blogs.isArchived=0 and blogs.isEnabled = 1 and blogs.releaseDateTime <= NOW() and (blogs.expiryDateTime >= Now() or blogs.expiryDateTime = 0) and posts.isArchived=0 and posts.isEnabled = 1 and posts.releaseDateTime <= NOW() and (posts.expiryDateTime >= Now() or posts.expiryDateTime = 0) and blogs.id = group by CONCAT (YEAR(posts.releaseDateTime),'-', MONTH(posts.releaseDateTime)) order by posts.releaseDateTime desc

#0  Database->notify() called at [/home/living01/public_html/_core/class.database.php:132]
#1  Database->query(SELECT YEAR(posts.releaseDateTime) as PostYear, MONTH(posts.releaseDateTime) as PostMonth, count(posts.id) as PostCount  , blogs.liveURL as blogURL   FROM (pages as blogs inner join pages as posts on blogs.id=posts.page_id) inner join templates on posts.template_id=templates.id  where  templates.tag ='blogpost'  and blogs.isArchived=0 and blogs.isEnabled = 1 and blogs.releaseDateTime <= NOW() and (blogs.expiryDateTime >= Now() or blogs.expiryDateTime = 0) and posts.isArchived=0 and posts.isEnabled = 1 and posts.releaseDateTime <= NOW() and (posts.expiryDateTime >= Now() or posts.expiryDateTime = 0)  and blogs.id =   group by CONCAT (YEAR(posts.releaseDateTime),'-', MONTH(posts.releaseDateTime)) order by posts.releaseDateTime desc) called at [/home/living01/public_html/_core/class.database.php:288]
#2  Database->resulter(SELECT YEAR(posts.releaseDateTime) as PostYear, MONTH(posts.releaseDateTime) as PostMonth, count(posts.id) as PostCount  , blogs.liveURL as blogURL   FROM (pages as blogs inner join pages as posts on blogs.id=posts.page_id) inner join templates on posts.template_id=templates.id  where  templates.tag ='blogpost'  and blogs.isArchived=0 and blogs.isEnabled = 1 and blogs.releaseDateTime <= NOW() and (blogs.expiryDateTime >= Now() or blogs.expiryDateTime = 0) and posts.isArchived=0 and posts.isEnabled = 1 and posts.releaseDateTime <= NOW() and (posts.expiryDateTime >= Now() or posts.expiryDateTime = 0)  and blogs.id =   group by CONCAT (YEAR(posts.releaseDateTime),'-', MONTH(posts.releaseDateTime)) order by posts.releaseDateTime desc) called at [/home/living01/public_html/_core/class.database.php:199]
#3  Database->getRows(SELECT YEAR(posts.releaseDateTime) as PostYear, MONTH(posts.releaseDateTime) as PostMonth, count(posts.id) as PostCount  , blogs.liveURL as blogURL   FROM (pages as blogs inner join pages as posts on blogs.id=posts.page_id) inner join templates on posts.template_id=templates.id  where  templates.tag ='blogpost'  and blogs.isArchived=0 and blogs.isEnabled = 1 and blogs.releaseDateTime <= NOW() and (blogs.expiryDateTime >= Now() or blogs.expiryDateTime = 0) and posts.isArchived=0 and posts.isEnabled = 1 and posts.releaseDateTime <= NOW() and (posts.expiryDateTime >= Now() or posts.expiryDateTime = 0)  and blogs.id =   group by CONCAT (YEAR(posts.releaseDateTime),'-', MONTH(posts.releaseDateTime)) order by posts.releaseDateTime desc) called at [/home/living01/public_html/_siteapp/logic/class.blog.php:439]
#4  Blog->blogArchive() called at [/home/living01/public_html/_siteapp/controllers/controller.blogpost.php:23]
#5  require(/home/living01/public_html/_siteapp/controllers/controller.blogpost.php) called at [/home/living01/public_html/_siteapp/templates/desktop/template.blogpost.php:3]
#6  include(/home/living01/public_html/_siteapp/templates/desktop/template.blogpost.php) called at [/home/living01/public_html/_siteapp/logic/class.render.php:325]
#7  Render::template(blogpost) called at [/home/living01/public_html/_siteapp/logic/class.render.php:308]
#8  Render::populate(Array ([id] => 419,[name] => Murphy's frustration with the Ireland management,[template_id] => 7,[page_id] => 404,[dataCache] => {"pagedata":{"title_1":{"id":"832","tableName":"page_titles","idColumnName":"id","columns":{"page_id":"419","content":"Murphy's frustration with the Ireland management","ref":"1","isApproved":"1","isLive":"1","createdDateTime":"2012-09-10 14:14:21"}},"textarea_1":{"id":"1180","tableName":"page_textareas","idColumnName":"id","columns":{"page_id":"419","contentHtml":"

Murphy describes his frustration the Ireland management as his suggestions for attacking ideas at the 2011 World Cup are left gathering dust<\/em>.<\/p>\r\n

\"Photos
\r\n
\r\nThe generic shapes I handed to Deccie are gathering dust somewhere. I drew up drills as well and offered other ideas that I feel should be in the playbook, but there seems to be a fear of over-complication.<\/p>\r\n

Roughly 10 moves are rolled out every game but we can be better. At Leicester, there are comtinuity plans for at least five phases; with Ireland, three is the maximum before it becomes pick and jam.<\/p>\r\n

I am not hearing much from the other experienced backs or young guys, plenty of whom are strong-minded individuals, so I feel the need to speak up. Again.<\/p>\r\n

Creating space is what I know best in rugby. My thinking is that I am nearly done and probably not going to start against Australia, so it shouldn’t sound like I’m trying to get the team to play around me. Let’s play complicated attacking rugby - the skill set is there.<\/p>\r\n

I see this week as a massive opportunity to improve our attacking approach, my ideas can be overruled and improved upon but the debate should be happening. Our half-backs should have a major say in this.<\/p>\r\n

\"Photos<\/p>\r\n

In France, an attacking style is bred into them from childhood. I've seen how they educate their youngest players. The ball is thrown in and they are just told to "play".<\/p>\r\n

After five minutes the whistle blows. They are shown the space that is not being used on the field. They are shown how the ball can be transferred into the wide-open prairies, coached how to pass and run lines from deep.<\/p>\r\n

Through repetition, the approach to attacking the gainline becomes rapid and eventually magical to witness.<\/p>\r\n

Once it clicks, you can never forget that philosophy. A natural running game, God, that would be amazing. I'd love to coach that into Irish kids' psyche some day. And not just the skinny ones.<\/p>\r\n

Taken from The Outsider, Chapter 6 - "Playbook"<\/em><\/p>\r\n


\r\n

Read other Living Rugby blogs<\/a> and other extracts from Geordan Murphy's book.<\/a><\/em><\/p>\r\n

Like the Living Rugby Facebook page<\/a> for more news, photos and videos.<\/em><\/p>\r\n