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 = 'top-10-best-cruise-lines'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
Well, the results are in. Top 10 cruise lines. We at FUSION Talent Group enjoy working with each and everyone but it's always nice to see with strategic sessions to produce and match the top acts of the world to meet the number 1-10 in the industry.