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 = 'all-about-science-theatre-show-touring-the-nation---represented-by-fusion-talent-group--agent-andrew-pogson-aka-freddy-fusion'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
All About Science Theatre show touring the nation. Represented by FUSION Talent Group, Agent Andrew Pogson aka Freddy Fusion
All About Science sparks the imagination of youth coast to coast with this unique show ability to blend curriculum based science with highly visual and comedy interaction. Wildly popular at special events and school fundraisers, this is also a full theatrical production show for all ages. For more information on booking All About Science at your next event, call Andrew Pogson aka Freddy Fusion.