SendNewPassword  Started!<br>

Logging to: /var/www/html/mioteamdata/logfiles/batch_sendnewpasswords_20240518.log<br>\n\rQuery database: 
SELECT 
ana.id as 'id',
rqs.id as 'req_id',
rqs.user_data,
rqs.data_type,
ana.CodiceCommunity, 
ana.UserID as 'UserID', 
ana.Cognome as 'UserCognome', 
ana.Nome as 'UserNome', 
com.NomeCommunity, 
com.Lingua,
adm.Adminid , 
adm.AdminUserID, 
adm.AdminCognome, 
adm.AdminNome, 
adm.AdminEmail

FROM change_password_request as rqs

LEFT JOIN anagrafica as ana on ana.id=rqs.anagrafica_id

RIGHT JOIN community as com on ana.CodiceCommunity=com.CodiceCommunity

RIGHT JOIN (select id as 'Adminid', CodiceCommunity as 'AdminCodiceCommunity', UserID as 'AdminUserID', Cognome as 'AdminCognome', Nome as 'AdminNome', email as 'AdminEmail'  
FROM `anagrafica` as tem where Cancellato='N') as adm
on adm.AdminUserID=com.MasterAdminID AND adm.AdminCodiceCommunity=com.CodiceCommunity 

WHERE ana.Cancellato='N'

ORDER BY ana.CodiceCommunity, ana.Cognome, ana.Nome   
<br>

Inizio loop utenti 2<br>Esaminati 0 utenti. Finito!<br>