******** ERROR cuentacorrienteusdtabla.onopen(-1)
SQL Error: select
    /** CUOTAS **/
    d.id as iddoc,
    t.id as idtctacte,
    t.vencimiento as fecha,
    concat(
        t.descripcion,
        ' ',
        ifnull(
            (
                select
                    group_concat(descripcion)
                from
                    emtransobra
                where
                    aplica = t.id
                    and tipo = 'V'
            ),
            ''
        )
    ) as descripcion,
    - t.importe as importe,
    t.moneda,
    t.id as orden
from
    emtransobra as t
    cross join emdocobra as d on t.documento = d.id
where
    t.moneda = 'USD'
    and t.estado != 'ANULADA'
    and t.tipo = 'M'
    /** vencimientos de OV **/
    and (
        t.vencimiento <= date_add(current_date(), INTERVAL  DAY)
        or abs(t.aplicaciones) > 100
    )
    /** anterior a los proximos dias ó ya pagado **/
    and (
        '' = 'FR'
        or (
            t.descripcion not like 'FR %'
            and t.descripcion not like '%FR'
        )
    )
    /**
    and (
        '' = ''
        or t.contabilidad not in ("")
    )
    **/
    and t.descripcion not like 'honorarios%'
    and t.documento in (
        select
            id
        from
            emdocobra
        where
            ocom = ''
            and tipo = 'OV'
    )
    /** vencimientos de OV **/
    /**
     and d.empresa = (select empresa from Emprendimientos where id = (select emprendimiento from ocom where id = ''))
     
     and (if(t.tipo='M', t.vencimiento, d.fechaemision) <= date_add(current_date(), INTERVAL 15 DAY) 
     or t.tipo='C' or t.saldo != t.importe)
     and d.contacto not in (select id from cmcont where razonsocial like '%CLIENTES%')
     and t.estado != 'ANULADA'
     **/
union
all
select
    /** CONCEPTOS DE RECIBOS **/
    d.id as iddoc,
    t.id as idtctacte,
    d.fechaemision as fecha,
    /** concat(d.descripcion, '<br>', group_concat(left(t.descripcion, 30))) as descripcion, **/
    d.descripcion as descripcion,
    sum(
        if(
            t.moneda = 'USD',
            t.importe,
            t.importe / (
                select
                    tipocambio
                from
                    emtransobra
                where
                    id = t.aplica
            )
        )
    ) as importe,
    /** t.moneda, **/
    'USD' as moneda,
    999999999999 as orden
from
    emtransobra as t
    cross join emdocobra as d on t.documento = d.id
where
    t.tipo = 'C'
    /** conceptos de RC **/
    and (
        '' = 'FR'
        or (
            t.descripcion not like 'FR %'
            and t.descripcion not like '%FR'
        )
    )
    and t.descripcion not like 'honorarios%'
    and (
        d.sucursal not in ('99', '98')
        or d.sucursal is null
    )
    and (
        t.aplica in (
            /** quien aplique a vencimientos de OV de la moneda y operacion **/
            select
                id
            from
                emtransobra as t3
            where
                t3.moneda = 'USD'
                and t3.documento in (
                    select
                        id
                    from
                        emdocobra
                    where
                        ocom = ''
                        and tipo = 'OV'
                )
        )
        or t.aplica in (
            /** quien aplique a vencimientos de facturas que apliquen a vencimientos de OV de la moneda y operacion **/
            select
                id
            from
                emtransobra as t4
            where
                t4.tipo = 'V'
                and t4.aplica in (
                    select
                        id
                    from
                        emtransobra as t3
                    where
                        t3.moneda = 'USD'
                        and t3.documento in (
                            select
                                id
                            from
                                emdoc
                            where
                                ocom = ''
                                and tipo = 'OV'
                        )
                )
        )
    )
group by
    d.id
order by
    fecha,
    orden
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
        or abs(t.aplicaciones) > 100
    )
    /** anterior a los proximos dia' at line 34
 SQLSTATE 42000

******** ERROR cuentacorrientetabla.onopen(-1)
SQL Error: select
    /** CUOTAS **/
    d.id as iddoc,
    t.id as idtctacte,
    t.vencimiento as fecha,
    concat(
        t.descripcion,
        ' ',
        ifnull(
            (
                select
                    group_concat(descripcion)
                from
                    emtransobra
                where
                    aplica = t.id
                    and tipo = 'V'
            ),
            ''
        )
    ) as descripcion,
    - t.importe as importe,
    t.moneda,
    t.id as orden
from
    emtransobra as t
    cross join emdocobra as d on t.documento = d.id
where
    t.moneda = ''
    and t.estado != 'ANULADA'
    and t.tipo = 'M'
    /** vencimientos de OV **/
    and (
        t.vencimiento <= date_add(current_date(), INTERVAL  DAY)
        or abs(t.aplicaciones) > 100
    )
    /** anterior a los proximos dias ó ya pagado **/
    and (
        '' = 'FR'
        or (
            t.descripcion not like 'FR %'
            and t.descripcion not like '%FR'
        )
    )
    /**
    and (
        '' = ''
        or t.contabilidad not in ("")
    )
    **/
    and t.descripcion not like 'honorarios%'
    and t.documento in (
        select
            id
        from
            emdocobra
        where
            ocom = ''
            and tipo = 'OV'
    )
    /** vencimientos de OV **/
    /**
     and d.empresa = (select empresa from Emprendimientos where id = (select emprendimiento from ocom where id = ''))
     
     and (if(t.tipo='M', t.vencimiento, d.fechaemision) <= date_add(current_date(), INTERVAL 15 DAY) 
     or t.tipo='C' or t.saldo != t.importe)
     and d.contacto not in (select id from cmcont where razonsocial like '%CLIENTES%')
     and t.estado != 'ANULADA'
     **/
union
all
select
    /** CONCEPTOS DE RECIBOS **/
    d.id as iddoc,
    t.id as idtctacte,
    d.fechaemision as fecha,
    /** concat(d.descripcion, '<br>', group_concat(left(t.descripcion, 30))) as descripcion, **/
    d.descripcion as descripcion,
    sum(
        if(
            t.moneda = '',
            t.importe,
            t.importe / (
                select
                    tipocambio
                from
                    emtransobra
                where
                    id = t.aplica
            )
        )
    ) as importe,
    /** t.moneda, **/
    '' as moneda,
    999999999999 as orden
from
    emtransobra as t
    cross join emdocobra as d on t.documento = d.id
where
    t.tipo = 'C'
    /** conceptos de RC **/
    and (
        '' = 'FR'
        or (
            t.descripcion not like 'FR %'
            and t.descripcion not like '%FR'
        )
    )
    and t.descripcion not like 'honorarios%'
    and (
        d.sucursal not in ('99', '98')
        or d.sucursal is null
    )
    and (
        t.aplica in (
            /** quien aplique a vencimientos de OV de la moneda y operacion **/
            select
                id
            from
                emtransobra as t3
            where
                t3.moneda = ''
                and t3.documento in (
                    select
                        id
                    from
                        emdocobra
                    where
                        ocom = ''
                        and tipo = 'OV'
                )
        )
        or t.aplica in (
            /** quien aplique a vencimientos de facturas que apliquen a vencimientos de OV de la moneda y operacion **/
            select
                id
            from
                emtransobra as t4
            where
                t4.tipo = 'V'
                and t4.aplica in (
                    select
                        id
                    from
                        emtransobra as t3
                    where
                        t3.moneda = ''
                        and t3.documento in (
                            select
                                id
                            from
                                emdoc
                            where
                                ocom = ''
                                and tipo = 'OV'
                        )
                )
        )
    )
group by
    d.id
order by
    fecha,
    orden
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
        or abs(t.aplicaciones) > 100
    )
    /** anterior a los proximos dia' at line 34
 SQLSTATE 42000

CONTEXT:
_module=unidades4  <i><small>String</small></i>
alquiler=null
idalquiler=null
saldo=null
cantidad=null
<b>component</b>


<b>request_</b>
     _c=unidades4/verunidad  <i><small>String</small></i>
     _v=6140  <i><small>String</small></i>
     _x=onopen  <i><small>String</small></i>
     _mv=956  <i><small>String</small></i>
     _h=rVCIOaU2JMre2OKyplHH  <i><small>String</small></i>
     _sessionid=rVCIOaU2JMre2OKyplHH  <i><small>String</small></i>
     _servername=miquartier.com.ar  <i><small>String</small></i>
     _url=https://miquartier.com.ar/miquartier/index.html  <i><small>String</small></i>


<b><red>u_</red></b>
     u_expensa=null  <i><small>String</small></i>
     u_posesiones=0  <i><small>Long</small></i>
     u_proyecto=[qbajo@emprendimientos4.emprendimiento]
     u_abierta=null  <i><small>String</small></i>
     u_totalproyectos=1  <i><small>Long</small></i>


<b><red>s_</red></b>
     s_usuario=[168891@consorcios4.persona]
     s_loggedin=yes  <i><small>String</small></i>
     s_abiertodesde=null
     s_perfil=null
     s_idcontacto=168891  <i><small>Integer</small></i>
     s_abiertohasta=null
     s_phpurl=https://.miquartier.com.ar/consorcios3/  <i><small>String</small></i>
     s_cerradohasta=2024-11-30  <i><small>Date</small></i>
     s_mesabierto=null
     s_expensasabiertas=null
     s_unidadrel=  <i><small>String</small></i>
     proyecto=qbajo  <i><small>String</small></i>
     s_idunidad=null
     s_cerradodesde=2024-11-01  <i><small>Date</small></i>
     s_mescerrado=2024-11  <i><small>String</small></i>
     s_mudanza=157177  <i><small>Integer</small></i>
     s_unidad=null
     s_idusuario=  <i><small>String</small></i>
     s_unidadestado=  <i><small>String</small></i>


<b><red>g_</red></b>
     g_expensa=null
     g_base=..  <i><small>String</small></i>
     g_proyecto=null
     _e=uv1066_quartier  <i><small>String</small></i>