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 = 'six-appeal-wins-world-championship-in-moscow---named-a-cappella-sextet-of-the-year'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
Six Appeal Wins World Championship in Moscow & Named A Cappella Sextet of the Year
Vocal band SIX APPEAL wins big in Moscow, becoming International Grand Champions at the Spring A Cappella Competition. They were also just named Sextet of the Year at the 2018 A Cappella Music Awards. As part of FUSION Talent Group and headlining on Disney Cruise Line, we couldn't be more thrilled and proud of the boys.
For more information on booking Six Appeal, contact Andrew Pogson at www.fusiontalentgroup.com Perfect for special events, cruise line entertainment and corporate events throughout North America.