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-halftime-show'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
Extreme Dogs has had an amazing 2019 tour season. With two touring units in full sold out routing across the country, it's no wonder Extreme Dogs is the most sought after sport dog show out there - hitting major fairs like the Maryland State Fair, Utah State Fair, Montana Fair, San Diego County Fair, and Red River Ex to name a few. Along with that, we've been proud to present at both the CFL (Canadian Football League) and NFL as headline halftime show features.
In between show performances, our team has excelled in competing in major world championships, gaining 1st ranking positions.
2020 will be yet another growth year for Extreme Dogs and we're already excited for the extended list of new clients like Houston Livestock and Rodeo and Florida State Fair, as well as returning to awesome events like the San Antonio Stock Show & Rodeo and the National Western Stock Show in Denver.