select a.id, a.date_added, a.active,
b.title, b.description, b.genre, b.page_seo_url,
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 = 'fusion-talent-group-is-proud-to-present-andrew-pogson-aka-the-freddy-fusion-science-magic-show'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
FUSION Talent Group is proud to present Andrew Pogson aka the Freddy Fusion Science Magic show
the Freddy Fusion Science Magic Show has been on of the most sought after shows of its kind for special events nation wide. Sparking the imagination of our youth through magic to have a unique understanding of the subject of Science. Created by Andrew Pogson this show been to almost every major city coast to coast seeing hundreds of thousands of children. For more information of bringing Andrew Pogsons Freddy Fusion show to your event, inquire within.