select a.id, a.date_added, a.active,
b.title, b.description, b.genre, b.page_seo_url,
d.file_name,
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 = 'comedy-juggler--josh-casey-6-show-theatre-tour'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
Comedy Juggler Josh Casey is throwing it down, or should I say throwing it up for a 6 show theatre tour March Break in Drayton Ontario, Cambridge Ontario and St Jacobs Ontario. Drayton Entertainment as been proud to present many FUSION Talent Group artists in partnership bringing worlld class headline entertainers to their theatre venues. Tickets on Sale and don't miss this show! Enjoy
