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 = 'darcy-oake-magician-illusionist-on-britain-s-got-talent-does-it-again-in-the-semi-finals'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
Darcy Oake Magician Illusionist on Britain's Got Talent does it again in the semi finals
Darcy Oake has done it again on Britain's Got Talent with his magic and illusion show. Stunning the judges with a crazy vanish from a chair and re appearing as a camera guy. He is now in the semi finals and has a very good chance at winning according to Simon Cowell.
