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 = 'murray-hatfield--proudly-represented-by-andrew-pogson-of-fusion-talent-group-hits-the-road-on-the-spring-tour-in-california'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
Murray Hatfield, proudly represented by Andrew Pogson of FUSION Talent Group hits the road on the spring tour in California
the Man, the Myth, the LEGEND! Murray Hatfield hits the road for his Spring kick off tour in California. This performer has toured the globe along with his national tour that he presented coast to coast for an annual event for over 20 years. A true legend, and a true gentleman in the industry.
For more information bringing Murray Hatfield to your next event speak with Andrew Pogson
