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 = '100th-international-plowing-match'
group by a.id, b.title, b.description, b.genre,d.file_name,b.page_seo_url
limit 1
Fusion Talent Group was proud to provide the "Kid's Pedal Tractor Pull" and the "Magic Bean" Agriculture Magic show at the 100th International Plowing Match in Sept. This event draws 100's of thousands of people from across the globe.
