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 = 'casting-call-for-musicians'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
FUSION Talent Group is currently casting musicians for Luxury Cruise Lines and Yachts. Call all Solo, Duo, Trio and Party Bands. If you have passion and personality with love of travel, this is the opportunity of a lifetime. Speak with Andrew Pogson of FUSION Talent Group for more details. www.fusiontalentgroup.com
