$sql = SELECT `R`.`date`, `R`.`value` AS `rainfall`, `E`.`dischargeStart`, `E`.`dischargeEnd`, `E`.`status`, `L`.`river` FROM `Rainfall` AS `R` LEFT JOIN `EDM_Harvest` AS `E` ON `R`.`date` BETWEEN DATE(`E`.`dischargeStart`) AND DATE(`E`.`dischargeEnd`) LEFT JOIN ( SELECT DATE(`datetime`) AS `dt`, AVG(`value`) AS `river` FROM `RiverLevel` GROUP BY DATE(`datetime`) ) AS `L` ON `R`.`date` = DATE(`L`.`dt`) WHERE (`R`.`date` >= "2025-01-01") AND ((TIMESTAMPDIFF(MINUTE, `E`.`dischargeStart`, `E`.`dischargeEnd`) > 30) OR (TIMESTAMPDIFF(MINUTE, `E`.`dischargeStart`, `E`.`dischargeEnd`) IS NULL) ) ORDER BY `R`.`date`

	Trigger rainfall (mm)	River level factor	Indicated	Actual	Hits	Indicateds Hit rate (%)	Actuals Hit rate (%)
			138	94	74	53.62	78.72	Show blank rows

Date	Rainfall	River	Indicated	Actual
2025-01-01	11.09	0.43	1
2025-01-04	12.31	0.4	2	1
2025-01-05	24.28	0.76	3	2
2025-01-06	5.87	0.64	4	3
2025-01-08	6.94	0.47	5	4
2025-01-20	11.82	0.44	6	5
2025-01-22	4.88	0.44	7
2025-01-23	10.98	0.55	8	6
2025-01-24	12.66	0.62	9	7
2025-01-26	35.97	0.83	10	8
2025-01-27	8.32	0.76	11	9
2025-01-28	3.97	0.6	12	10
2025-01-31	4.1	0.46	13
2025-02-10	5.86	0.47	14
2025-02-15	4.78	0.41	15
2025-02-19	8.76	0.41	16
2025-02-20	15.26	0.64	17	11
2025-02-21	6.7	0.55	18
2025-02-23	22.25	0.58	19	12
2025-02-24	16.8	0.81	20	13
2025-02-25	4.68	0.6	21	14
2025-02-26	19.35	0.77	22	15
2025-02-26	19.35	0.77	23	16
2025-02-27	0	0.53		17
2025-03-21	5.62	0.39	24
2025-04-18	19.73	0.39	25
2025-04-19	13.29	0.45	26	18
2025-04-22	8.46	0.36	27
2025-04-23	4.98	0.43	28
2025-05-21	25.23	0.39	29	19
2025-06-05	9.65	0.36	30
2025-06-06	3.69	0.36	31
2025-06-12	9.95	0.35	32
2025-07-19	5.41	0.3	33
2025-07-20	10.39	0.33	34
2025-07-27	4.19	0.3	35
2025-07-31	4.87	0.31	36
2025-08-27	8.56	0.3	37
2025-08-28	4.83	0.29	38
2025-08-29	16.24	0.34	39	20
2025-08-30	22.28	0.36	40	21
2025-09-01	4.74	0.29	41
2025-09-02	14.53	0.3	42
2025-09-03	20.29	0.4	43	22
2025-09-03	20.29	0.4	44	23
2025-09-04	8.35	0.34	45
2025-09-07	11.2	0.33	46	24
2025-09-09	14.76	0.31	47
2025-09-10	23.48	0.47	48
2025-09-14	7.68	0.33	49
2025-09-17	5.24	0.32	50
2025-09-17	5.24	0.32	51	25
2025-09-28	8.15	0.3	52
2025-10-03	16.49	0.33	53
2025-10-19	30.38	0.42	54	26
2025-10-22	12.87	0.37	55	27
2025-10-23	5.43	0.44	56
2025-10-30	5.07	0.3	57
2025-10-31	7.06	0.33	58
2025-11-04	12.64	0.37	59
2025-11-05	4.7	0.47	60
2025-11-07	12.64	0.4	61
2025-11-09	12.88	0.39	62
2025-11-10	8.32	0.58	63
2025-11-11	9.67	0.46	64
2025-11-12	8.26	0.57	65
2025-11-13	4.87	0.43	66
2025-11-14	13.06	0.51	67	28
2025-11-15	0.06	0.46		29
2025-11-22	34.74	0.61	68	30
2025-11-23	22.03	0.69	69	31
2025-11-24	4.16	0.48	70	32
2025-11-29	12.43	0.47	71	33
2025-12-01	36.27	0.78	72	34
2025-12-02	4.53	0.58	73	35
2025-12-03	0.3	0.47		36
2025-12-04	15.37	0.62	74	37
2025-12-05	24.89	0.67	75	38
2025-12-06	1.17	0.58		39
2025-12-07	10.47	0.59	76	40
2025-12-08	13.54	0.54	77	41
2025-12-08	13.54	0.54	78	42
2025-12-08	13.54	0.54	79	43
2025-12-09	21.98	0.94	80	44
2025-12-10	0	0.53		45
2025-12-12	8.57	0.5	81
2025-12-16	15.73	0.68	82	46
2025-12-17	14.54	0.5	83	47
2025-12-17	14.54	0.5	84	48
2025-12-17	14.54	0.5	85	49
2025-12-18	30.66	1.07	86	50
2025-12-19	0.03	0.58		51
2025-12-20	4.91	0.51	87	52
2025-12-21	7.84	0.54	88
2026-01-08	19.29	0.47	89	53
2026-01-09	9.14	0.53	90	54
2026-01-11	12.29	0.48	91
2026-01-13	10.63	0.51	92	55
2026-01-15	15.91	0.59	93	56
2026-01-16	1.82	0.5		57
2026-01-17	9	0.51	94	58
2026-01-18	7.38	0.51	95	59
2026-01-19	0.88	0.57		60
2026-01-20	10.71	0.6	96	61
2026-01-21	11.09	0.69	97	62
2026-01-22	16.25	0.7	98	63
2026-01-23	2.86	0.64		64
2026-01-24	6.34	0.65	99	65
2026-01-25	1.04	0.6		66
2026-01-26	6.9	0.54	100	67
2026-01-26	6.9	0.54	101	68
2026-01-27	13.13	1.23	102	69
2026-01-28	0.76	0.62		70
2026-01-29	5.68	0.56	103
2026-01-30	7.79	0.61	104	71
2026-01-31	0.84	0.55		72
2026-01-31	0.84	0.55		73
2026-02-01	9.71	0.57	105	74
2026-02-02	0.46	0.54		75
2026-02-05	15.25	0.55	106	76
2026-02-06	2.47	0.59		77
2026-02-07	6.16	0.55	107
2026-02-08	23.67	0.69	108	78
2026-02-09	11.66	0.69	109	79
2026-02-10	6.69	0.65	110	80
2026-02-11	3.65	0.59	111	81
2026-02-12	3.64	0.56	112	82
2026-02-12	3.64	0.56	113	83
2026-02-13	12.71	0.59	114	84
2026-02-14	0.61	0.57		85
2026-02-15	14.32	0.63	115	86
2026-02-16	0.09	0.56		87
2026-02-18	15.1	0.57	116	88
2026-02-19	2.77	0.58		89
2026-02-26	4.75	0.45	117
2026-02-27	14.54	0.59	118
2026-02-28	5.31	0.59	119	90
2026-03-01	5.18	0.52	120	91
2026-03-09	6.8	0.45	121
2026-03-10	4.7	0.44	122
2026-03-12	10.53	0.47	123
2026-03-13	2.66	0.56		92
2026-04-05	0.4	0.37		93
2026-04-14	9.23	0.36	124
2026-04-15	9.27	0.41	125
2026-05-02	8.2	0.35	126
2026-05-14	4.55	0.34	127
2026-05-17	6.32	0.35	128
2026-05-18	5.72	0.35	129
2026-05-19	10.7	0.39	130
2026-06-01	27.3	0.36	131
2026-06-02	5.8	0.41	132	94
2026-06-03	6.8	0.36	133
2026-06-04	5.1	0.35	134
2026-06-06	15	0.38	135
2026-06-08	6.6	0.35	136
2026-06-10	6.2	0.33	137
2026-06-25	4.29	0.32	138