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 = 'lumberjack-show-with-extreme-lumberjacks'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
Extreme Lumberjacks is super excited to headline the Houston Livestock Show and Rodeo for the entire month of March. This kicks off the tour season which will take them coast to coast in both Canada and the United States.