SELECT 
        so.salesorderid,
        so.cf_906,
        so.cf_1265,
        so.cf_928,
        cf4you.paymentdate
    FROM 
        vtiger_salesordercf AS so
    INNER JOIN 
        its4you_cashflow4you AS cf4you
        ON so.salesorderid = cf4you.relationid
    WHERE 
        so.cf_906 BETWEEN '2017-04-01' AND '2024-12-01'
        AND so.cf_1265 >= '2025-01-01'
        AND so.cf_928 = 'Pagado'
        AND cf4you.paymentdate IS NOT NULL;

<br>ID: 4061587. Fecha de Pago: 2022-12-21
<br>ID: 7125879. Fecha de Pago: 2024-11-29
<br>ID: 7125879. Fecha de Pago: 2025-01-05
<br>ID: 7377945. Fecha de Pago: 2024-10-28
<br>ID: 7377956. Fecha de Pago: 2024-10-28
<br>ID: 7440425. Fecha de Pago: 2025-03-25
<br>ID: 7487059. Fecha de Pago: 2024-10-29
<br>ID: 7896599. Fecha de Pago: 2025-11-24
<br>FIN