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-and-imagination-expert'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
Dale K, Comedy Hypnotist and Imagination Expert has been one of the most sought after entertainers of his kind. Headliner of Atlantis in the Bahamas, Disney Cruise Line and every major college campus across the nation. He's our most requested hands down.
