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 = 'britainsgottalent-will-be-showcasing-one-of-our-own--darcyoake'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
#BritainsGotTalent will be showcasing one of our own #DarcyOake.
Magician Illusionist Darcy Oake has been well on his way to becoming a star in Magic. With a strong reputation for being an original magician, an ethical magician, and a creator of mindblowing magic.
Being a Canadian Magician with many cross Canada Magic and Illusion tours under his belt, he is now spreading his wings. Performing his Magic and illusion show in Asia, and now producing his illusion show on Holland America Cruise Line and other cruise lines. With starring in a New York Time Square show titled Time Scare and in Las Vegas at Circus Circus. Recent Magic and Illusion shows in Paris he is now going to be a star on Britain's Got Talent. Though being a Canadian Magician he is already reported to be the best magician on Britain's Got Talent. We're beyond excited to have Darcy Oake already raising eye brows. Congrats Darcy Oake
