select * from product_nongsarodetail_new as a
left join product_nongsaro_new as b
on a.ns_id = b.registration
where b.company = '(주)동방아그로' and ( a.disease_weed_name like '%들불병%' )
order by b.company desc;
농민의 친근한 이웃으로,
든든한 동반자로
A Friendly neighbor or a reliable companion to farmers