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 = 'agency-of-the-year-nominee'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
FUSION Talent Group is proud to have been nominated for agency of the year the the recent convention of British Columbia Fairs and Festivals. Cindy Savage attended with a showcase by Murray Hatfield. Murray Hatfield was awarded Canadian Magician of the year and with countless coast to coast Canadian tours over the years. We are proud to have him part of FUSION Talent Group as one of the finest illusiontist around. Between his Cruise Line, Corporate and Theatre performances, fairs will be lucky to have him attend to entertain.
