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-presents--comedy-hypnotist-dale-k'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
Disney Cruise Line presents. Comedy Hypnotist Dale K
Disney Cruise Line presents on the brand new Disney Fantasy headline entertainer Dale K. His comedy hypnosis show has been seen around the globe and is the best hyptotist pretty much living today.
