Trappel =5

Trappel =4
SELECT * FROM cpanel, clients, plan WHERE cpanel.id_client = clients.ID and STATUS = 1 AND datefin_cpanel <= '2025-03-18' and datefin_cpanel > '2025-03-16' and ( cpanel.webedit_cpanel = 6 or cpanel.webedit_cpanel = 10 or cpanel.webedit_cpanel = 13 or cpanel.webedit_cpanel = 15 or cpanel.webedit_cpanel = 16 or cpanel.webedit_cpanel = 18 or cpanel.webedit_cpanel = 31 or cpanel.webedit_cpanel = 17 or cpanel.webedit_cpanel = 67 or cpanel.webedit_cpanel >= 110 ) and cpanel.webedit_cpanel = plan.Nomid and ( date_rappel < '2025-03-15' or date_rappel is NULL or date_rappel = '1970-01-01' ) and rappel < 4 order by clients.ID
Trappel =3
SELECT * FROM cpanel, clients, plan WHERE cpanel.id_client = clients.ID and STATUS = 1 AND datefin_cpanel <= '2025-03-30' and datefin_cpanel > '2025-03-18' and ( cpanel.webedit_cpanel = 6 or cpanel.webedit_cpanel = 10 or cpanel.webedit_cpanel = 13 or cpanel.webedit_cpanel = 15 or cpanel.webedit_cpanel = 16 or cpanel.webedit_cpanel = 18 or cpanel.webedit_cpanel = 31 or cpanel.webedit_cpanel = 17 or cpanel.webedit_cpanel = 67 or cpanel.webedit_cpanel >= 110 ) and cpanel.webedit_cpanel = plan.Nomid and ( date_rappel < '2025-03-15' or date_rappel is NULL or date_rappel = '1970-01-01' ) and rappel < 3 order by clients.ID
ID : 1965 CLIID :
mail client : POMME C Clef : IDKnyPs4v4KKNIahzFZm6IFQ8GB4qiwwj4XXKDP37aBKgbqTeD
UPDATE cpanel SET rappel = 3, date_rappel = '2025-03-15' WHERE id_cpanel = 2952

Mail to pommec@allit.be
CliID : 1965



Trappel =2
SELECT * FROM cpanel, clients, plan WHERE cpanel.id_client = clients.ID and STATUS = 1 AND datefin_cpanel <= '2025-04-14' and datefin_cpanel > '2025-03-30' and ( cpanel.webedit_cpanel = 6 or cpanel.webedit_cpanel = 10 or cpanel.webedit_cpanel = 13 or cpanel.webedit_cpanel = 15 or cpanel.webedit_cpanel = 16 or cpanel.webedit_cpanel = 18 or cpanel.webedit_cpanel = 31 or cpanel.webedit_cpanel = 17 or cpanel.webedit_cpanel = 67 or cpanel.webedit_cpanel >= 110 ) and cpanel.webedit_cpanel = plan.Nomid and ( date_rappel < '2025-03-15' or date_rappel is NULL or date_rappel = '1970-01-01' ) and rappel < 2 order by clients.ID
Trappel =1
SELECT * FROM cpanel, clients, plan WHERE cpanel.id_client = clients.ID and STATUS = 1 AND datefin_cpanel <= '2025-05-14' and datefin_cpanel > '2025-04-14' and ( cpanel.webedit_cpanel = 6 or cpanel.webedit_cpanel = 10 or cpanel.webedit_cpanel = 13 or cpanel.webedit_cpanel = 15 or cpanel.webedit_cpanel = 16 or cpanel.webedit_cpanel = 18 or cpanel.webedit_cpanel = 31 or cpanel.webedit_cpanel = 17 or cpanel.webedit_cpanel = 67 or cpanel.webedit_cpanel >= 110 ) and cpanel.webedit_cpanel = plan.Nomid and ( date_rappel < '2025-03-15' or date_rappel is NULL or date_rappel = '1970-01-01' ) and rappel < 1 order by clients.ID
Trappel =0
SELECT * FROM cpanel, clients, plan WHERE cpanel.id_client = clients.ID and STATUS = 1 AND datefin_cpanel <= '2025-03-15' and datefin_cpanel > '2025-05-14' and ( cpanel.webedit_cpanel = 6 or cpanel.webedit_cpanel = 10 or cpanel.webedit_cpanel = 13 or cpanel.webedit_cpanel = 15 or cpanel.webedit_cpanel = 16 or cpanel.webedit_cpanel = 18 or cpanel.webedit_cpanel = 31 or cpanel.webedit_cpanel = 17 or cpanel.webedit_cpanel = 67 or cpanel.webedit_cpanel >= 110 ) and cpanel.webedit_cpanel = plan.Nomid and ( date_rappel < '2025-03-15' or date_rappel is NULL or date_rappel = '1970-01-01' ) and rappel < 0 order by clients.ID