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-starring-viktoria-grimmy-and-michael-dubois'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
Circus Dubois starring Viktoria Grimmy and Michael Dubois.
Circus Dubois formed together by Michael Dubois and Viktoria Grimmy is an action packed show featuring ariel, whips, juggling, slackwire and contortion. Each of the stars are extemely talented and well respected in their field. Theatrical in their presentation with attention to detail have made them extremely popular in the performing arts market, headlining theaters on major cruise lines, and making appearances at festivals across the globe. Circus Dubois is keen on offering diversity to their clients whether be in the corporate events world creating custom corporate packages, to the fair and festival market offering an intimate 1 ring circus tent. A strong business sense to offer the highest caliber of product and a fair price to their customers.
FUSION Talent Group is proud to represent Michael Dubois, Viktoria Grimmy as Circus Dubois in the Cruise Line and resort market, the Fair and Festival industry and Performing Arts and Theatres. For more information contact Andrew Pogson at Fusion Talent group www.fusiontalentgroup.com