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 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ')) ORDER BY I.Seq OFFSET 2580 ROWS FETCH NEXT 15 ROWS ONLY
4TB SATA HDD.1 PACK.Vess A3120.With 3120 Drive carrier. Enterprise.F40A31200000003 4TB SATA HDD1 PACKVess A3120With 3120 Drive carrier Enterprise...Dettagli
4TB SATA HDD.Promise.1 PACK.Vess A7000.Enterprise.F40000000000051 4TB SATA HDDPromise1 PACKVess A7000Enterprise...Dettagli
Pre-tested 4TB 3.5" 7200 rpm SATA HDD w/ Drive.Vess A6000.EnterpriseF40000000000058 Pretested 4TB 35 7200 rpm SATA HDD w Drive Carrier Promise1 PACKVess A6000Enterprise...Dettagli
D5000x controller with 2-port 10GSFP+F29VD5820000002 D5000x controller with 2port 10GSFP...Dettagli
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