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-dog-show-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
Extreme Dogs Dog Show presented by Andrew Pogson of FUSION Talent Group
Extreme Dogs is the premier touring dog show in the nation. A show that features world champion canine athletes that showcases amazing skills in agility, frisbee freestyle, high jump and dock diving. Almost all of our dogs are rescued from shelters and showing with a little bit of time and love what amazing things can occur with such amazing dogs at heart. For more booking information speak with Andrew Pogson at FUSION Talent Group about bringing Extreme Dogs to you event.