select a.id, a.date_added, a.active,
b.title, b.description, b.genre, b.page_seo_url,
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-dogs-represented-by-fusion-talent-group--agent-andrew-pogson'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
Extreme Dogs represented by FUSION Talent Group, agent Andrew Pogson
FUSION Talent Group is proud to present Extreme Dogs as part of their line up of world class headline entertainers. You might see this dog show headlining theatres, NFL halftime shows, and festivals around North America.
Showcasing some of the finest canine athletes that compete on a world championship level. Promoting animal rescue and showing with a little investment in time and some love what amazing things can happen. For more information on booking Extreme Dogs at your event, call 519-275-1070 and speak with Andrew Pogson