<br/>===Start time =02:50:04pm===<br/>Database connected<br>Current date : 2025-12-12 14 50 04<br><br>Database name : microlabslive_summary<br><br><br><br>====Started at :'Friday 12th of December 2025 02:50:04 PM'<br><b> SFE KPI TREND Summary </B><br><br> sfe_trend_temp_holding drop query ==> DROP table if exists sfe_trend_temp_holding<br><br> create holding query ==> INSERT INTO sfe_trend_temp_holding
	SELECT 
		users.division AS divisionid,
		users.id,
		users.reports_to_id,
		daymonthyear.date1,
		SPACE(10) AS type1,
		0.00 AS fw_days,
		0.00 AS nca_days,
		0.00 AS jw_days,
		00000 AS dr_in_list,
		0000 AS listed_dr_met,
		0000 AS listed_f2f_calls,
		0000 AS all_f2f_calls,
		0000 AS virtual_doctor_calls,
		0000 AS chemist_f2f_calls,
		0000 AS chemist_virtual_calls,
		0000 AS chemist_calls_total,
		0000 AS d_detailing_calls,
		000 AS wrking_day,
		0.00 AS class_a_tcfa,
		0.00 AS class_b_tcfa,
		0.00 AS total_class_ab,
		role2profile.profileid AS profileid,
		patches.patchsapcode AS territorycode,
		patches.patchid,
		patches.hqid,
		0000000000 AS teamstrength,
		0000000000 AS actual_strength,
		0000000000 AS taxable_amt
	FROM 
		microlablive.users,
		microlablive.daymonthyear,
		microlablive.user2role,
		microlablive.role2profile,
		microlablive.patches
	WHERE 
		users.deleted = 0
		AND users.id = user2role.userid
		AND user2role.roleid = role2profile.roleid
		AND users.patch = patches.patchid
		AND daymonthyear.date1 BETWEEN '2025-12-01' AND '2025-12-31'
		AND users.deleted = 0 
		AND users.division IS NOT NULL 
		AND users.division != 0
	ORDER BY 
		role2profile.profileid DESC<br><br>====Started at :'Friday 12th of December 2025 02:50:08 PM'Query 12 Failed: Table 'microlabslive_summary.sfe_trend_temp_holding' doesn't exist