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 = 'fairs-and-festivals-with-the-cutest-show-on-earth'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
Fairs and Festivals with the Cutest Show on Earth.
The Cutest Show on Earth is in full routing for the 2016 season. With already the 2016 Houston LiveStock Fair and Rodeo under their belt, they are now full swing at the Galveston County Fair and Rodeo. Performing the Wild West version of the Cutest Show on Earth they share the stage with the Magic Bean Agriculture Magic show. A show created by Andrew Pogson which some of you might know him as Freddy Fusion. The Magic Bean has been a huge success in the Fair and Festival marketplace all thanks to it's key ingredient of mixing education and pure fun. Andrew Pogson will be in charge of strategic partnerships this season with major fair and festival events like the California State Fair, Winnipeg's Red River Ex, Edmontons K Days, PEI's Old Home week, North Caroline State Fair, Oklahoma State Fair, Waco Heart of Texas Fair, LA County Fair, to name a few. Andrew Pogson has also created shows for Disney Cruise Line as a Disney Magician on the Disney Wonder, Disney Magic, Disney Dream, and Disney Fantasy. His career as a Disney magician under the brand of Freddy Fusion as been a strong partnership over the past 13 years. The Cutest Show on Earth is now a proud brand of FUSION Talent Group first created by Elisa Hays of Washington State. It's been a proud show hosted by the Washington State Fair for approx 20 years. A perfect addition to any event as it's geared to the key demographic of that 3-8 year old category. We're extremely excited for the future of the Cutest show on earth.
