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 = 'circus-dubois'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
Circus Dubois starring Michael Dubois an Viktoria Grimmy booked with FUSION Talent Group touring coast to coast. Whether you catch them headlining on Disney Cruise Line, the Performing Arts/ Theatres nationwide or the odd fair or festival, make sure to say hi as they're truly one of the nicest couples in the industry. For more information contact Andrew Pogson Freddy Fusion at www.fusiontalentgroup.com