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'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
Extreme Dogs has had an amazing tour season for 2019. Two teams sold out coast to coast proved to be rewarding in many respects performing in front on so many amazing audiences. Our loveable extreme dogs were highlights for many. Partnering with some of the largest events in the nation along with headlining a number of halftime shows in both the CFL and NFL. Our recent appearance for the Buffalo Bills was to a sell crowd of 71,000 people. Just last week was the San Francisco 49ers and the crowds roar on every catch was electrifying.