******** ERROR detallestabla.onopen(-1)
SQL Error: select 
    /**
    distinct u.denominacion as unidad, 
u.notas as notasunidad,
**/
if(t.descripcion like '%cesion%', '', t.descripcion) as concepto, 
    t.importe * -1 as importe,
    t.saldo * -1 as saldo,
    t.moneda as moneda,
    t.vencimiento
    
from emdoc d 
join emtrans t on d.id = t.documento
/**
join ocom as o on d.ocom = o.id
join rcom as r on d.ocom = r.operacioncomercial
join Unidades as u on r.unidadId = u.id
**/
where
    d.ocom = '' 
    /** o.estado not in ('Anulada', 'Inactiva') **/
    and t.descripcion not like 'FR %' 
    and t.descripcion not like '%FR' 
    and t.descripcion != 'SALDO'
    /**and (t.descripcion in ('Gastos funcionamiento', 'Gastos de equipamiento', 'Ingresos Brutos') or t.descripcion like '%Posesi%')**/
    and if(t.contabilidad is null,t.contabilidad is null,t.contabilidad != 'G')
    and d.tipo = 'ov'
    and t.tipo = 'M'
    /**and t.moneda = 'ARS'**/
    /** mostrar todos los saldos
    and     
        if(''= 1, 
            t.vencimiento < date_add('', interval '' day),
            t.vencimiento < date_add(current_date(), interval '' day)
         )
    and (
        (abs(t.saldo) > 10 and t.moneda = 'ARS') 
        or (abs(t.saldo) > 1 and t.moneda = 'UVA') 
        or (abs(t.saldo) > 1 and t.moneda = 'USD')
        )
    **/
    and d.estado = '+Emitida'
    /** and d.empresa = (select empresa from Emprendimientos where id = 'qbajo') **/
    and t.estado != "ANULADA" 
    and t.estado != "Anulada" 
    /** and d.ocom in (select id from ocom where estado !="ANULADA" and estado not like 'Reserva%' and estado not like 'Oferta%' **/ 
    /** and clase = 'Fiduciante A' **/ /** ) **/
    /** and u.tipou = 'D'     **/
    /** and u.id = '' **/
    and (
        t.vencimiento <= date_add(current_date(), INTERVAL  DAY)
        or abs(t.aplicaciones) > 100
    )


/** group by 2, t.vencimiento **/
order by t.vencimiento,t.id
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
    )


/** group by 2, t.vencimiento **/' at line 51
 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

******** 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

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=6164  <i><small>String</small></i>
     _x=onopen  <i><small>String</small></i>
     _mv=1010  <i><small>String</small></i>
     _h=Uej3i6K1LPo2asknNXTV  <i><small>String</small></i>
     _sessionid=Uej3i6K1LPo2asknNXTV  <i><small>String</small></i>
     _servername=miquartier.com.ar  <i><small>String</small></i>
     _url=https://miquartier.com.ar/miquartier/  <i><small>String</small></i>
     _gg=  <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=0  <i><small>Long</small></i>


<b><red>s_</red></b>
     s_usuario=[101447@consorcios4.persona]
     s_loggedin=yes  <i><small>String</small></i>
     s_perfil=  <i><small>String</small></i>
     s_idcontacto=101447  <i><small>Integer</small></i>
     s_phpurl=https://.miquartier.com.ar/consorcios3/  <i><small>String</small></i>
     s_unidadrel=  <i><small>String</small></i>
     s_idunidad=null
     s_mudanza=157176  <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=[2@emprendimientos4.emprendimiento]
     _e=uv1066_quartier  <i><small>String</small></i>