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 = 'andrew-pogson-at-whoop-up-days-in-lethbridge-with-all-about-science-and-freddy-fusion'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
Andrew Pogson at Whoop up Days in Lethbridge with All About Science and Freddy Fusion
Andrew Pogson performs at Whoop up Days in Lethbridge Alberta https://lethbridgeherald.com/news/lethbridge-news/2022/08/30/magic-science-show-mesmerizes-whoop-up-crowds/
