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 = 'march-break-with-extreme-dogs-stunt-dog-show'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
March Break with Extreme Dogs Stunt Dog show. TIckets now on sale for shows in London Ontario at Western Fairs Agriplex March 11th, and at the Stratford Rotary Complex March 13th
