SELECT I.Description, I.DescriptionHTML, I.Code, I.PackPiecesNr, I.Id, (SELECT TOP 1 II.FileName FROM Media II WHERE II.EntityId = I.Id AND II.Type = 'IMAGE' AND II.EntityName = 'Item' ORDER BY Seq) AS Image, Trolese_WebSite.dbo.getSEOUrlByContentId(I.Code,'IT',NULL,NULL,I.LevelCode,0) AS SEOURL, COUNT(*) OVER() AS totResults FROM Item I WHERE I.LevelCode = 'ITEM' AND I.State IN (50,60) AND I.FAM IS NOT NULL AND I.Enabled = 1 AND I.Visible = 1 AND I.Deleted <> 1 AND I.State IN ('50','60') AND ((1=1 AND I.FAM = '01 ' AND I.SBFAM = '011 ' AND I.GRP = '01157 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '011 ' AND GRP = '01157 ')) ORDER BY I.Seq OFFSET 1230 ROWS FETCH NEXT 15 ROWS ONLY
POWER SUPPLY.BOX.Vess A3340s.350WF29VA3420000009 POWER SUPPLYBOXVess A3340s350W...Dettagli
Drive carrier with dummy.BOX.Vess A3120F29A31220000004 Drive carrier with dummyBOXVess A3120...Dettagli
Pre-tested and qualified 8TB 7200-RPM dual-ported 12Gb SAS hard diskF40E58F00010011 Pretested and qualified 8TB 7200RPM dualported 12Gb SAS hard disk drive premounted in VTrak drive carrier Single Pack...Dettagli
Pre-tested and qualified 4TB 7200-RPM dual-ported 12GbF40VR3600010001 Pretested and qualified 4TB 7200RPM dualported 12Gb SAS hard disk drive premounted in R3000 drive carrier Single Pack...Dettagli
POWER SUPPLY.Promise.Vess A3340d.1U Redundant 350WF29VA3420000022 POWER SUPPLYPromiseVess A3340d1U Redundant 350W...Dettagli
4U/28-Bay 4-port 10GSFP+, total raw capacity 192TBF40VD5800010005 4U28Bay 4port 10GSFP RAID subsystem Dual Controllers with 24x 8TB 7200rpm 12G SAS HDD total raw capacity 192TB...Dettagli