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-headline-entertainer-performing-on-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 headline entertainer performing on Disney Cruise Line
Disney Cruise Line is proud to present Dale K comedy hypnotist this week as part of their star line up. Also joining Dale K is our own as well Charles Peachock. A fantastic comedy juggler with an amazing show of visual juggling.
Dale K has been a top headliner for years making him a Disney Cruise Line favourite. Whether it be the Disney Magic, Disney Dream, Disney Fantasy or in this case the Disney Wonder. Guests are already tweeting about how great the show is.
