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--contact-andrew-pogson-freddy-fusion-for-more-information'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
Casting Call. Contact Andrew Pogson Freddy Fusion for more information
Casting Call for the Kid's Pedal Tractor Pull show. Seeking and MC/ HOST to travel throughout different parts of Canada and the United States presenting a fantastic attraction at fairs. The Kid's Pedal Tractor Pull is a proud tradition at major events nation wide. Whether the Houston Livestock and Rodeo, Calgary Stampede, LA County Fair, Del Mar Fair or small events in between.
You need to be willing to travel, set up, and work with a happy go lucky attitude with the public. All expenses are covered.
For more information write Andrew@fusiontalentgroup and or call 519-275-1070 to speak with Andrew Pogson / Freddy Fusion
