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 = 'xtreme-dogs-at-the-national-western-stockshow'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
Xtreme Dogs of the National Western Stockshow in Denver Colorado teams up with Extreme Dogs of FUSION Talent Group to produce one heck of an areana. Assembling the "dream team" of world champion trainers , movie and circus trainers audiences left wanting more after this 75 action packed journey.
For more information on Extreme Dogs at your event, contact Andrew Pogson aka Freddy Fusion for halftime shows, arena shows, special events, pet expos, corporate events, NFL halftime, NBA halftime shows.