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 = 'freddy-fusion-andrew-pogson'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
Freddy Fusion Andrew Pogson is back on the road hitting multi city tour dates in Texas, California, Wisconsin, Florida and across Canada. After multi dates aboard Disney Cruise Line during the winter season which makes for a wonderful way to get out of the Canadian winters. Make sure to visit www.freddyfusion.com for tour dates or inqire with Freddy Fusion Andrew Pogson direct on twitter, or Freddy Fusion Andrew Pogson on facebook.