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 = 'extreme-dogs-trick-dog-show-presented-by-fusion-talent-group-and-andrew-pogson-aka-freddy-fusion'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
Extreme Dogs Trick Dog Show presented by FUSION Talent Group and Andrew Pogson aka Freddy Fusion
FUSION Talent Group is proud to present Extreme Dogs. This high flying, high energy thrill show will get your audience ramped up with excitement from beginging to end. With a cast of world champion level trainers and their canine sidekicks, kids of all ages will be talking about this for years to come.
For further information, contact FUSION Talent Group and speak with Allyson Urban or Andrew Pogson aka Freddy Fusion