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 = 'rock-n-rolling-piano-ground-acts-presented-by-fusion-talent-group--andrew-pogson'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
Rock N Rolling Piano Ground Acts presented by FUSION Talent Group, Andrew Pogson
FUSION Talent ground is rolling out the Rock N Rolling Piano in their grounds and strolling artist line up. Both captivating and entertaining to enhance the guest experience but as well an amazing boost to media attention and sponsorship opportunity. Speak with agent Andrew Pogson of FUSION Talent Group for more details.
