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 = 'best-hypnotist-in-north-america-without-question-is-dale-k--represented-by-andrew-pogson'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
Best Hypnotist in North America without Question is Dale K, represented by Andrew Pogson
Dale K is without a doubt the best hypnotist in North America. Headliner for Disney Cruise Line, Atlantis Resort and Casino in the Bahamas along with being the most sought after Comedy Hypnotist for Campus Activities and Corporate events coast to coast. For more information on booking Dale K, speak with Andrew Pogson of FUSION Talent Group