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-aboard-luxury-cruise-lines-and-yachts'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
Casting Call for Musicians aboard Luxury Cruise Lines and Yachts.
FUSION Talent Group is currently casting musicians aboard Luxury Cruise Lines and Yachts touring the word. Solo, Duo, Trio and Party 5 piece Bands. Vocal pianists as well for specialty projects for both on land and on sea. Email a resume and headshot to andrew@fusiontalentgroup.com from www.fusiontalentgroup.com and speak with Andrew Pogson