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 = 'fusion-talent-group-proudly-presents-the-cutest-dog-show-on-earth--stunt-dog-show'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
FUSION Talent Group proudly presents the Cutest Dog Show on Earth, Stunt Dog Show
FUSION Talent Group proudly presents the Cutest Dog Show on Earth. Stunt Dog Show. Touring coast to coast in both Canada, and the United States, the Cutest Dog Show on Earth Stunt Dog Show is the worlds premier show of its kind. For more information email Andrew Pogson at www.fusiontalentgroup.com website
