SELECT
cf4you.paymentamount AS payamount_main,
cf4you.cashflow4you_no AS cashflow4you_no,
cf4youcf.cf_1173,
cf4youcf.cashflow4youid,
cf4you.paymentdate,
so.cf_914,
so.cf_1265
FROM
its4you_cashflow4you AS cf4you
INNER JOIN
its4you_cashflow4youcf AS cf4youcf
ON cf4you.cashflow4youid = cf4youcf.cashflow4youid
INNER JOIN
vtiger_salesordercf AS so
ON cf4you.relationid = so.salesorderid
WHERE
cf4you.cashflow4you_cash = 'MERCADOPAGO'
AND so.cf_928 = 'Pagado'
AND (cf4youcf.cf_3271 IS NOT NULL)
AND (cf4youcf.cf_3271) = ''
AND cf4you.paymentdate BETWEEN '2025-02-26' AND '2025-03-19';
string(121) "
7
"
Autenticado con éxito. UID: 7
TOTAL: 0
FIN