select * from cvslove.dllg.edu_event where is_view='y' and date_s<='2025-07-17' and date_e>='2025-07-17' and isCommon='y' and partnerView like '%y%' and (isOpen='y' or isOPen='a') order by priority, num