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-2023-tour-season-kicking-off-at-the-denver-livestock-show-and-rodeo-presented-by-andrew-pogson'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
Extreme Dogs 2023 tour season kicking off at the Denver Livestock Show and Rodeo presented by Andrew Pogson
FUSION Talent Group, and agent Andrew Pogson are proud to kick off the 2023 tour season with a bang starting January with the Denver Livestock Show and Rodeo. This ticketed arena event holds 4500 seats per show and is always a crowd highlight during the show. For more information speak with Andrew Pogson for further details at info@fusiontalentgroup.com
