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 = 'best-dog-show---extreme-dogs-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
Best Dog Show. Extreme Dogs presented by Andrew Pogson of FUSION Talent Group
FUSION Talent Group is beyond proud of the hard work and dedication of this hard working star trainers and canine athletes for this stunt dog show production. Extreme Dogs tours coast to coast presenting world champion dogs promoting animal rescue and responsible pet ownership.
The Best Stunt Dog Show you'll find in the industry hands down and is the most sought after production in its class. Highlighting the extreme dog sports of high jump, agility, dock diving and the high flying fast paced action of frisbee freestyle.
For more information on bringing the best dog show Extreme Dogs to your next event email Andrew Pogson at email@example.com