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 = 'things-to-do-in-niagara-falls--greg-frewin-stars-in-his-own-production----cruise-line-representation-by-andrew-pogson'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
Things to do in Niagara Falls. Greg Frewin Stars in his own production. Cruise Line representation by Andrew Pogson
If you're looking for something to do for you next visit to Niagara Falls, look no further. GREG FREWIN is the of the greatest illusionists of our era performing right in the heart of Niagara Falls. Greg Frewin has won every major award, toured the globe but is now in his very own Greg Frewin Theatre (and gets to sleep in his own bed). This face paced visual experience showcases some of the most amazing dancers, exotic birds flying over your heads and yes even exotic tigers.
Fusion Talent Group is proud to have the priveledge to represent through agent Andrew Pogson when we can position him on cruise lines between his hectic schedule. Headlining Holland America and Disney Cruise line, Andrew Pogson strives to present him whenever possible.
For more information on attending Greg Frewins show, visit www.gregfrewintheatre.com to book tickets.