******** ERROR propietariostable.onopen(-1)
SQL Error: select u.id,
    u.tipou,
    if (u.tipou = 'D','ph ph-house-line','ph ph-car') AS imagen,

    concat(u.denominacion,' (uf ', u.codigo, ')') as unidad,
    (select group_concat(if(tipou='X', 'CB', tipou), denominacion) from Unidades where uf = u.id and tipou not in('D', 'O')) as asociadas,
    (select group_concat(if(tipou='X', 'CB', tipou), denominacion) from Unidades where id = u.uf and tipou not in('D', 'O')) as asociada,
    round(u.porcentajea,5) as porcentajea,
    round(u.porcentajeb,5) as porcentajeb,
    round(u.porcentajec,5) as porcentajec,
    round(u.porcentajed,5) as porcentajed,

    /** VERY SLOW **/
    (select concat ('<span class="persona">',
    group_concat(ifnull(cmcont.nombre,''),' 
    ',ifnull(cmcont.apellido,''),'
    ',concat(if(ifnull(cmcont.telefono,'')='', '', concat('<i class="ph ph-device-mobile" data-popup=tooltip  title=', char(34), cmcont.telefono ,char(34), '></i>'))),'
    ',concat(if(ifnull(cmcont.telefono2,'')='', '', concat('<i class="ph ph-device-mobile" data-popup=tooltip  title=', char(34), cmcont.telefono2 ,char(34), '></i>'))),'
    ',concat(if(ifnull(cmcont.email,'')='', '', concat('<i class="ph ph-envelope" data-popup=tooltip  title=', char(34), cmcont.email ,char(34), '></i>')))
    
    separator '</span><span><br> '))
    from
        icrel cross join cmcont on icrel.contacto = cmcont.id
    where 
        icrel.tipo = 'titular' and icrel.unidad = u.id and icrel.estado = 'Activo') as titulares,

        
    /** VERY SLOW **/
    (select concat ('<span class="persona">',
    group_concat(ifnull(cmcont.nombre,''),'
    ',ifnull(cmcont.apellido,''),'
    ',concat('<i class="ph ph-device-mobile" data-popup=tooltip  title=', char(34), cmcont.telefono ,char(34), '></i>'),'
    ',concat('<i class="ph ph-envelope" data-popup=tooltip  title=', char(34), cmcont.email ,char(34), '></i>')
    separator '</span><span><br> '))
    from 
        icrel cross join cmcont on icrel.contacto = cmcont.id 
    where 
        icrel.tipo = 'contacto principal' and icrel.unidad = u.id and icrel.estado = 'Activo') as contactoprincipal,

    /** VERY SLOW **/
    (select concat ('<span class="persona">',
    group_concat(ifnull(cmcont.nombre,''),'
    ',ifnull(cmcont.apellido,''),'
    ',concat('<i class="ph ph-device-mobile" data-popup=tooltip  title=', char(34), cmcont.telefono ,char(34), '></i>'),'
    ',concat('<i class="ph ph-envelope" data-popup=tooltip  title=', char(34), cmcont.email ,char(34), '></i>')
    separator '</span><span><br> '))
    from 
        icrel cross join cmcont on icrel.contacto = cmcont.id 
    where 
        icrel.tipo = 'Inquilino' and icrel.unidad = u.id and icrel.estado = 'Activo') as inquilino,


    u.estado as estado,
    (select sum(ifnull(importe,0) - ifnull(pagos,0)) from trans where unidadId = u.id
        and ('' = 'basico' 
            or (fecha between '' and '') 
            or (fecha > '' and descripcion in ('Su pago', 'Ajuste'))
        )
    ) as saldoexpensas,
    
    u.completado as propietario_completoformulario,
    u.completadoinquilino as inquilino_completoformulario,
    
   /* 
    if(ifnull(u.ultimoingreso,'')!='', datediff(current_date(), u.ultimoingreso), '') as propietario_hacecuantoingreso,
    if(ifnull(u.ultimoingresoinquilino,'')!='', datediff(current_date(), u.ultimoingresoinquilino), '') as inquilino_hacecuantoingreso,
    
    time(u.ultimoingreso) as propietario_horaultimoingreso,
    time(u.ultimoingresoinquilino) as inquilino_horaultimoingreso,
    */
    
    u.inhabilitareserva as inhabilitadoparareservar
 

from
    Unidades as u 
where 
    u.emprendimientoid = 'qbajo'
    and (u.estado != 'BORRAR' or u.estado is null)
    and (u.tipou = 'D' or u.uf is null or u.uf = 0)

    /** si es propietario o inquilino solo busco entre las unidades en las cuales se relaciona el usuario **/
    and (
        'Superusuario' not in ('Propietario' , 'Inquilino')
        or
        (select count(*) from icrel where icrel.unidad = u.id and icrel.estado in ('Activo', 'Futuro') and icrel.contacto = '') >= 1 
    )
        
    /** busco el texto escrito por apellido o denominacion de unidad **/
    and (
            (select count(*) from icrel where icrel.unidad = u.id and icrel.estado in ('Activo', 'Futuro') and icrel.apellido like '%') > 0
            or
            u.denominacion like '%%'
        )

order by 
    u.tipou desc,u.torre, cast(u.piso as unsigned),u.departamento
Unknown column 'u.porcentajea' in 'field list'
 SQLSTATE 42S22

CONTEXT:
_module=unidades4  <i><small>String</small></i>
formulario=  <i><small>String</small></i>
anchoscolumnas=60,65,70,70,90,70,70,70,130,120,110,130,130,110,130,120,110  <i><small>String</small></i>
ingreso=hoy a las    <i><small>String</small></i>
columnas=Codigo,Denominacion,Torre,Piso,Departamento,%A,%B,%C,Propietario 1,Email Prop1,Email2 Prop1,Email3 Prop1,Telefono Prop1,Propietario 2,Email Prop2,Telefono Prop2,Inquilino,Email Inquilino,Telefono Inquilino  <i><small>String</small></i>
<b>component</b>


<b>request_</b>
     _c=unidades4/propietarios  <i><small>String</small></i>
     _v=1260  <i><small>String</small></i>
     _x=onopen  <i><small>String</small></i>
     _mv=939  <i><small>String</small></i>
     _h=Cz19hARxT5FipF72MKoM  <i><small>String</small></i>
     _sessionid=Cz19hARxT5FipF72MKoM  <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_posesiones=0  <i><small>Long</small></i>
     u_proyecto=[qbajo@emprendimientos4.emprendimiento]
     u_totalproyectos=4  <i><small>Long</small></i>


<b><red>s_</red></b>
     s_usuario=[103485@consorcios4.persona]
     s_loggedin=yes  <i><small>String</small></i>
     s_perfil=Superusuario  <i><small>String</small></i>
     s_verreservaamenitie=S  <i><small>String</small></i>
     s_idcontacto=  <i><small>String</small></i>
     s_phpurl=https://qbajo.flexaconsorcios.com/consorcios3/  <i><small>String</small></i>
     s_unidadrel=  <i><small>String</small></i>
     proyecto=qbajo  <i><small>String</small></i>
     s_estadoperfil=Activo  <i><small>String</small></i>
     s_idunidad=null
     s_mudanza=157177  <i><small>Integer</small></i>
     s_unidad=null
     s_idusuario=103485  <i><small>Integer</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>