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 = 'canadian-pet-expo-headlines-the-extreme-dogs-stunt-dog-show'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
Canadian Pet Expo headlines the Extreme Dogs Stunt Dog Show.
FUSION Talent Group is proud to present the Extreme Dogs Stunt Dog Show in Toronto at the Canadian Pet Expo. This is a perfect way to spend Easter with the Family watching these incredbile dogs and canine athletes. Come say hi to the entire Extreme Dogs team,, See you there.