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 = 'extreme-dogs--the-worlds-premier-touring-stunt-dog-show'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
Extreme Dogs, The Worlds Premier Touring Stunt Dog Show
FUSION Talent group proudly presents, Extreme Dogs Stunt Dog Show. Known as the Worlds Premier touing Stunt Dog show seen around the world with these amazing loveable Canines. Headlining NBA, NFL, CFL Halftime shows along with major festivals like the Houston Livestock Show and Rodeo, National Rodeo in Denver, San Diego County Fair, LA County Fair, the Calgary Stampede to name a few.
For more information, speak with Andrew Pogson for bringing Extreme Dogs to your next event
