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
8TB SATA HDD.1 PACK.Vess A3120.With 3120 Drive carrier. Enterprise.F40A31200000001 8TB SATA HDD1 PACKVess A3120With 3120 Drive carrier Enterprise...Dettagli
D5000fx controller with 2-port 10GSFP+ and 8-port 16G FCF29VD5820000000 D5000fx controller with 2port 10GSFP and 8port 16G FC...Dettagli
800W Power Supply unit for E/D5800, E/D5600 platformF29E58F00000001 800W Power Supply unit for ED5800 ED5600 platform...Dettagli
8TB SATA HDD.Promise.1 PACK.Vess A7000.Enterprise.F40000000000053 8TB SATA HDDPromise1 PACKVess A7000Enterprise...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