select A.c_title as title, A.date as date, A.time as time, A.c_location as location, B.c_city as city from can_companytw.shareholder_meeting A, can_system.city B where A.ticker='3673' and A.c_title is not null and A.c_title !='' and A.enable='1' and A.city=B.id