SELECT
  x1.ID,
  IFNULL(
    IF(x1.stat='p' and x1.deltastatus= 2 ,
      (
        select (count(p.ID))
        from personnel x, personnel p
        where
          p.lft between x.lft and x.rgt
          and
          p.stat='p'
          and
          p.deltastatus= 1 
          and
          x.rgt=x1.rgt- 1 
        group by x.id
      ),
      IF (x1.stat='p' and x1.deltastatus= 1 ,
        (
          select (count(p.ID))
          from personnel x, personnel p
          where
            p.lft between x.lft and x.rgt
            and
            p.stat='p'
            and
            x.rgt=x1.rgt- 1 
          group by x.id
        ), 0 
      )
    ), 0 
  ) + x1.Unrgt as RGTS,

  IFNULL(
    IF(x1.stat='p' and x1.deltastatus= 2 ,
      (
        select (count(p.ID))
        from personnel x, personnel p
        where
          p.lft between x.lft and x.rgt
          and
          p.stat='p'
          and
          p.deltastatus= 1 
          and
          x.lft=x1.lft+ 1 
          and x.rgt<>x1.rgt- 1 
        group by x.id
      ),
      IF(x1.stat='p' and x1.deltastatus= 1 ,
        (
          select (count(p.ID))
          from personnel x, personnel p
          where
            p.lft between x.lft and x.rgt
            and
            p.stat='p'
            and
            x.lft=x1.lft+ 1 
            and
            x.rgt<>x1.rgt- 1 
          group by x.id
        ), 0 
      )
    ), 0 
  ) + x1.Unlft
FROM personnel as x1