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-dogs-is-set-to-roll-out-for-the-2023-tour-season---represented-by-andrew-pogson'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
Extreme Dogs is set to roll out for the 2023 tour season. represented by Andrew Pogson
Extreme Dogs attended and the Internation Association of Fairs with an overwhelming flow of bookings for the 2023 season. We're beyond thrilled for the support for so many of these world class events that we partner with. For more information, email or call Andrew Pogson for more details.