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 = 'national-stockshow-in-denver-presents-extreme-dogs-stunt-dog-show'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
National Stockshow in Denver presents Extreme Dogs Stunt Dog Show
The National Western Stockshow is the premier event kicking off in Denver throughout January. Featured as a ticketed event in a 5000 seat arena, Extreme Dogs Stunt Dog Show showcases the best of the best under one roof. These world champion Dog Trainers tour with Extreme Dogs Stunt Dog Show coast to coast promoting animal rescue and sparking the love you can create with your canine. A popular choice for NFL, NBA and CFL halftimeshows, these amazing canine athletes turn up the energy with crowds nationwide. For more information, speak with Andrew Pogson