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 = 'the-cutest-dog-show-on-earth-presented-by-andrew-pogson-of-fusion-talent-group'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
the Cutest Dog Show on Earth presented by Andrew Pogson of FUSION Talent Group
This is a fun addition to the roster. The Cutest Dog Show on Earth explores the wonder and fascination with our little canines. All rescue dogs to promote animal rescue and pet adoption while showcasing these amazing extreme dog stunts and tricks throughout the nation.
Whether for Performing Arts centers having a dog show part of their family series, or special events around the country, the Cutest Dog Show on Earth will melt the hearts of everyone with "mans best friend".