SELECT COUNT(*) as num FROM jobs a,employer b ,city c where a.jobs_emp_id = b.emp_id and jobs_status = 'A' and c.city_skey =a.jobs_state and ( DATE_FORMAT(jobs_start_view,'%Y-%m-%d') <= '2026-06-11' and DATE_FORMAT(jobs_end_view,'%Y-%m-%d') >= '2026-06-11' )and ( (b.emp_name like '%Heming way's Hotel%' ))