select a.id, a.date_added, a.active,
b.title, b.description, b.genre, b.page_seo_url,
group_concat(convert(f.category_id,char(8))) as BlogCategoryID
from blog a
left join blog_details b on (a.id = b.blog_id and b.language = 1)
left join blog_gallery c on (a.id = c.table_id)
left join media_library d on c.media_library_id = d.id
left join blog_category_rel e on e.blog_id = a.id
left join blog_category_details f on (e.category_id = f.category_id and f.language = 1)
where a.active = 1
and b.page_seo_url = 'new-design-of-the-freddy-fusion-science-magic-mobile-stage-will-be-announced-shortly--bookings-through-andrew-pogson-of-fusion-talent-group'
group by a.id
New design of the Freddy Fusion Science Magic Mobile stage will be announced shortly. Bookings through Andrew Pogson of FUSION Talent Group
We are launching a brand new design of the Freddy Fusion Science Magic Shows Mobile Stage. We've been beyond pleased with the wrap but with over 10 years in action it's time for an update. For booking inquires contact Andrew Pogson or Allyson Urban to discuss. As well we have added a few new surprises for our touring theatre show of Freddy Fusion along with a number of other products for different markets.
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 '))
left join blog_category_details f on (e.category_id = f.category_id' at line 5