Send Mobile Notifications Started! Logging to:/var/www/log/sendmobilenotifications_20240519.log\r\nQuery database: SELECT ntf.id, ntf.fromid, ntf.userid, ntf.groupid, ntf.messaggio, ntf.tipo, di1.device_id, grp.T2device_id, grp.T2userid, ana.pending_notifications, grp.T2pending_notifications FROM notifiche as ntf LEFT JOIN anagrafica as ana ON ana.id=ntf.userid AND ana.Cancellato='N' LEFT JOIN device_id as di1 ON di1.anagrafica_id=ntf.userid AND di1.cancellato='N' LEFT JOIN ( SELECT gru.GruppoID as 'T2groupid', did.device_id as 'T2device_id', an2.id as 'T2userid', an2.pending_notifications+1 as 'T2pending_notifications' from groups_users as gru JOIN anagrafica as an2 ON gru.CodiceCommunity=an2.CodiceCommunity AND gru.UserID=an2.UserID JOIN device_id as did ON did.anagrafica_id=an2.id WHERE did.device_id<>'' AND did.cancellato='N' ) as grp ON grp.T2groupid=ntf.groupid WHERE ISNULL(grp.T2userid) OR ntf.fromid<>grp.T2userid; Inizio loop notifiche2 Esaminati utenti. Finito!