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 = 'disney-cruise-line-proudly-presents-comedy-magician-david-williamson'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
Disney Cruise Line proudly presents comedy Magician David Williamson
Disney Cruise Line proudly presents David Williamson. His unique comedy magic show has made David Williamson to be the finest comedy magician on the planet at the moment. With appearances in front of king's and queens there is no wonder why David Williamson is Disney Cruise Lines favorite entertainer. He will be performing a short two day run on the Disney Magic before the Disney Magic heads to the med for the summer.