SELECT 
        cf4you.paymentamount AS payamount_main,
        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 = 'WEBPAY' 
        AND so.cf_928 = 'Pagado' 
        AND (cf4youcf.cf_3271 IS NOT NULL) 
        AND (cf4youcf.cf_3271) = '' 
        AND cf4you.paymentdate BETWEEN '2025-01-01' AND '2025-01-22';
<br />
<b>Warning</b>:  file_get_contents(): Peer certificate CN=`*.odoo.com' did not match expected CN=`perfectpoolcl-odoo-erp-testing-konos-18254795.dev.odoo.com' in <b>/home/perfectcrm/public_html/Odoo/Conciliar_Pagos_CRM_Odoo_v2.php</b> on line <b>79</b><br />
<br />
<b>Warning</b>:  file_get_contents(): Failed to enable crypto in <b>/home/perfectcrm/public_html/Odoo/Conciliar_Pagos_CRM_Odoo_v2.php</b> on line <b>79</b><br />
<br />
<b>Warning</b>:  file_get_contents(https://perfectpoolcl-odoo-erp-testing-konos-18254795.dev.odoo.com//xmlrpc/2/common): failed to open stream: operation failed in <b>/home/perfectcrm/public_html/Odoo/Conciliar_Pagos_CRM_Odoo_v2.php</b> on line <b>79</b><br />
Error: No se pudo conectar a https://perfectpoolcl-odoo-erp-testing-konos-18254795.dev.odoo.com//xmlrpc/2/common