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-dj-s-abroad-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 DJ's abroad Luxury Cruise Lines and Yachts
FUSION Talent Group is casting DJ's for international travel and appearances aboard luxury cruise lines and yachts. Submit headshot and resume to www.fusiontalentgroup.com and speak with Andrew Pogson. We look forward to the opportunity to work with you
