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 = 'extreme-dog-stunt-dog-show-is-on-and-national-tour-and-is-in-ontario-dog-show-during-march-break'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
Extreme Dog Stunt Dog Show is on and National Tour and is in Ontario Dog Show during March Break
Extreme Dogs Stunt Dog Show is proud to touch down in Sratford Ontario and London Ontario Canada as part of their coast to coast National Tour across both Canada and the United States. As proud ambassadors for promoting responsible pet ownership and dog rescue, this show as been seen LIVE by hundreds of thousands of peeople on an annual basis in every province and state. The best Dog show ever staring this incredible dogs and amazing Extreme Sport Canine Athletes.
