SELECT count(0) FROM (SELECT a.id, DATE_FORMAT(a.cap_time, ‘%Y-%m-%d %H:%i:%s’) AS capTime, a.camera_name AS cameraName, a.worker_name AS workerName, a.id_card AS idCard, a.cooperator_name AS participating, a.group_name AS groupName, a.profession_name AS professionName, a.alg_type AS algType, s.common_name AS commonName, a.pic_url AS picUrl, a.deal_status AS dealStatus FROM eyeaidb.d_project_alarm_info a, eyeaidb.s_alg_info s WHERE a.alg_type = s.alg_type AND a.project_id = 3428 AND a.company_id = 5 AND (a.cap_time >= DATE_FORMAT(NOW(), ‘%Y-%m-%d’) AND a.cap_time < DATE_FORMAT(DATE_ADD(NOW(), INTERVAL 1 DAY), ‘%Y-%m-%d’)) AND a.alg_type IN (2, 1, 17) AND a.camera_id IN (40, 277, 300, 122, 123, 100)) table_count;
