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 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '011 ')) ORDER BY I.Seq OFFSET 2205 ROWS FETCH NEXT 15 ROWS ONLY
Pre-tested and qualified 12TB 7200-RPM dual-ported 12Gb SAS hard diskF40VD5800010022 Pretested and qualified 12TB 7200RPM dualported 12Gb SAS hard disk drive premounted in VTrak drive carrier Single Pack...Dettagli
Pre-tested and qualified 4TB 7200-RPM dual-ported 12Gb SAS hard diskF40E58F00010010 Pretested and qualified 4TB 7200RPM dualported 12Gb SAS hard disk drive premounted in VTrak drive carrier Single Pack...Dettagli
10TB SATA HDD.1 PACK.Vess A3120.With 3120 Drive carrierF40A31200000023 10TB SATA HDD1 PACKVess A3120With 3120 Drive carrier...Dettagli
Vess R3600tiD 4-port 1G iSCSI, 12TBx16, 192 TBF40VR3600010127 Vess R3600tiD 4port 1G iSCSI 2port 10G BASET 3U DDR 8GBx1 Dual Controllers 12TBx16 192 TB no NAS and no data services...Dettagli