string(385) "select DISTINCT(ai.accountid), count(*) as total 
from vtiger_invoice as ai
 LEFT JOIN vtiger_invoicecf as aif on aif.invoiceid = ai.invoiceid 
 LEFT JOIN vtiger_accountscf as accf on ai.accountid = accf.accountid
 WHERE YEAR(aif.j_fechaemision) >=2023 and (accf.sales_sync!=1 OR accf.sales_sync is NULL) 
group by ai.accountid HAVING count(*) >=1 order by ai.accountid DESC limit 500;"
<br><br>