select 
    equipmentpars.equipmentid,
    equipmentlist.shifr,
    equipmentlist.naim,
    equipmentlist.oboz,
    equipmentpars.equipmentpardatetime
from equipmentpars
   left outer join equipment on (equipmentpars.equipmentid = equipment.id)
   left outer join equipmentlist on (equipment.equipmentlistid = equipmentlist.id)
   left outer join equipmentparslist on (equipmentpars.equipmentparslistid = equipmentparslist.id)
where 
   (
      (equipmentpars.equipmentpardatetime = 2012)
   )
order by equipmentlist.shifr, equipmentlist.naim, equipmentlist.oboz

where 
   (
      (extract(year from equipmentpars.equipmentpardatetime)=2013)
   )

BEGIN
  FOR
    select
        equipmentpars.equipmentid,
        equipmentlist.shifr,
        equipmentlist.naim,
        equipmentlist.oboz,
        equipmentparslist.equipmentpar,
        equipmentpars.equipmentparvalue,
        maxvalue(equipmentpars.equipmentpardatetime)
    from equipmentparslist
       right outer join equipmentpars on (equipmentparslist.id = equipmentpars.equipmentparslistid)
       left outer join equipment on (equipmentpars.equipmentid = equipment.id)
       left outer join equipmentlist on (equipment.equipmentlistid = equipmentlist.id)
    where
       (
          (equipmentpars.equipmentid = :IN_EQUIPMENTID )
       )
    group by equipmentpars.equipmentid
    INTO :EQUIPMENTID,
         :SHIFR,
         :NAIM,
         :OBOZ,
         :EQUIPMENTPAR,
         :EQUIPMENTPARVALUE,
         :BIRTHYEAR
  DO
  BEGIN
    SUSPEND;
  END
END