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 = 'dock-diving-stunt-dog-show'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
FUSION Talent Group is proud to executive produce and team up with the Canine Stars Dog Dock Diving/ Stunt Dog show. The finest world champion dogs with Frisbee Agility, Dock Diving, High Jump and Diving makes this truly now one of the finest touring Dog Shows coast to coast.
