The Fusion Blog

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 = 'nick-diffatte-new-up-and-coming-comedy-magician--corporate-entertainers--cruiseline-agencies--nick-diffatte' group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url limit 1