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 = 'extreme-lumberjacks-show'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
Extreme Lumberjacks show set to tour coast to coast. Come see us this week in Salt Lake City, Utah at I.A.F.E. For further booking information visit www.fusiontalentgroup.com and speak with Andrew Pogson
