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-shawn-farquhar-world-champion-of-magic'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
Disney Cruise Line presents Shawn Farquhar World Champion of Magic
This week our very own Shawn Farquhar performs Disney Cruise Lines beautiful brand new ship, the Disney Fantasy. Shawn Farquhar has been a crowd fav on NCL Cruise Line, Royal Carribean Cruise Line, Holland America, and of course always in constant demand from Disney Cruise Line.
