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 = 'holland-america-cruise-line-proudly-presents-magician-and-illusionist-neil-croswell'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
Holland America Cruise Line proudly presents Magician and Illusionist Neil Croswell
Holland America Cruise Line proudly presents Magician and Illusionist Neil Croswell to perform on their Alaska Cruise this summer. Canadian Magician Neil Croswell is set to perform his magic and illusion show for the Alaska Cruise summer run until the begining of Oct. Featured headline performer this was a perfect choice for Holland America to choose for this contract.
