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 = 'pig-races-presented-by-andrew-pogson-of-fusion-talent-group---aces-flying-pig-races'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
Pig Races presented by Andrew Pogson of FUSION Talent Group. Aces FLYING Pig Races
They said "when pigs fly"! Well, they're here and are kicking off the 2023 season with a bang. Aces Flying Pig Races are set to tour coast to coast at fairs and festivals. Come meet some of your favourite loveable characters. Presented by Andrew Pogson of FUSION Talent Group. www.acesflyingpigraces.com