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--presented-by-andrew-pogson-of-fusion-talent-group'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
Stunt Dog Show,Extreme Dogs, presented by Andrew Pogson of Fusion Talent Group
Fusion Talent Group proudly presents Extreme Dogs, the premier touring Stunt Dog show touring both Canada, and the United States. Extreme Dog Sports is an emerging market in the fair and festival industry along with Extreme Dogs being the most sought after headliner for NFL,NBA,CFL and major halftime shows. IF you want the best, Extreme Dogs IS the best. contact Andrew Pogson of Fusion Talent Group
