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-for-a-touring-magic-show---contact-andrew-pogson-for-more-information'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
Casting Call for a touring magic Show. Contact Andrew Pogson for more information
FUSION Talent Group is Casting Male Talent for a touring show called the MAGIC BEAN. An agriculture magic show promoting our farmers at fairs and festivals coast to coast. Seeking someone with personality to interact with audiences of all ages, travel and set up gear. Teachers make for a great fit having the summer to travel. If you know of anyone that might be perfect, please contact Andrew Pogson at FUSION Talent Group andrew@fusiontalentgroup.com for more information.
