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 = 'pig-races-casting-call-for-mc-host'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
Aces Flying Pig Races is casting a "Hambassador" for the 2027 tour season proudly presented by FUSION Talent Group. This is a unique entertainment show that is wildly successful coast to coast.
We're seeking someone that not only has personality in front of crowds but has a clean driving record, loves animals, and has a talent for common sense and unique problem solving.
If you know someone that wants to join the "herd" reach out to FUSION Talent Group and speak with Andrew Pogson aka Freddy Fusion. info@fusiontalentgroup.com
