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 = 'dale-k-comedy-hypnotist-set-to-headline-disney-cruise-line'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
Dale K comedy hypnotist set to headline Disney Cruise Line
Disney Cruise Line presents comedy hypnotist Dale K on the Disney Wonder this week. Ported out of Miami before heading to the west coast and then up to Alaska for the summer. Dale K has been one of Disney Cruise Lines favourite entertainers offering his comedy hypnosis show and making regular appearances on all four ships Disney Cruise Line has to offer. The Disney Magic, Disney Wonder, Disney Dream, and the Disney Fantasy.
