/* #New 17.09.2014/J.Fes add for DS Item data */
SELECT I.*
FROM
  dbo.Objects_tbl DS
  INNER JOIN dbo.Objects_Ir_Rel_tbl DS_IR_REL ON (DS.Id = DS_IR_REL.ObjectId)
  INNER JOIN dbo.Objects_tbl IR ON (DS_IR_REL.IrId = IR.Id)
  INNER JOIN dbo.Objects_Ir_Rel_tbl IR_I_REL ON (IR.Id = IR_I_REL.ObjectId)
  INNER JOIN dbo.Objects_tbl I ON (IR_I_REL.IrId = I.Id)
WHERE
  IR.ObjectFromSiteID = '#SiteID#' AND
  IR.ObjectPuid IN ('#ObjectPuidList#') AND
  I.ObjectClass = 'I'
