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 = 'stunt-dog-show---extreme-dogs-march-break-program-in-london-and-stratford-ontario'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
Stunt Dog Show. Extreme Dogs March Break Program in London and Stratford Ontario
Get you tickets now for the Extreme Dogs Stunt Dog Show. Tickets are going fast. March 11th at Western Fairs Agriplex in London ON, and at the Rotary Complex, March 13th. Both Shows at 2pm geared for all ages with this High Flying action packed Canine Experience. These amazing dogs have been headline performers in NFL Halftime Shows, and major events across the country. Don't miss this rare opportunity as part of their coast to coast international touch down right in your home town.
