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 1260 ROWS FETCH NEXT 15 ROWS ONLY
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
Pre-tested and qualified 8TB 7200-RPM dual-ported 12Gb SAS hard diskF40VR3600010003 Pretested and qualified 8TB 7200RPM dualported 12Gb SAS hard disk drive premounted in R3000 drive carrier Single Pack...Dettagli
6TB SATA HDD.1 PACK.Vess A3120.With 3120 Drive carrier. Enterprise.F40A31200000002 6TB SATA HDD1 PACKVess A3120With 3120 Drive carrier Enterprise...Dettagli
Pre-tested 6TB 3.5" 7200 rpm SATA HDD w/ Drive.Vess A6000.EnterpriseF40000000000057 Pretested 6TB 35 7200 rpm SATA HDD w Drive Carrier Promise1 PACKVess A6000Enterprise...Dettagli
Pre-tested and qualified 10TB 7200-RPM dual-ported 12Gb SAS hard diskF40VR3600010004 Pretested and qualified 10TB 7200RPM dualported 12Gb SAS hard disk drive premounted in R3000 drive carrier Single Pack...Dettagli
Pre-tested and qualified 6TB 7200-RPM dual-ported 12Gb SAS hard diskF40VR3600010002 Pretested and qualified 6TB 7200RPM dualported 12Gb SAS hard disk drive premounted in R3000 drive carrier Single Pack...Dettagli