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 1245 ROWS FETCH NEXT 15 ROWS ONLY
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
2TB SATA HDD.Promise.1 PACK.Vess A7000.EnterpriseF40000000000050 2TB SATA HDDPromise1 PACKVess A7000Enterprise...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
R3600 controller with 4-port 1G iSCSI, DDR 8GBx1F29VR3620000010 R3600 controller with 4port 1G iSCSI DDR 8GBx1...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