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 2595 ROWS FETCH NEXT 15 ROWS ONLY
Vess R3600iD 4-port 1G iSCSI, 3U, DDR 8GBx1F29VR36200M0000 Vess R3600iD 4port 1G iSCSI 3U DDR 8GBx1 Dual Controllers Chassis Only included drive carrier no NAS and no data services...Dettagli
Vess R3600iS 4-port 1G iSCSI, 3U, DDR 8GBx1 Single ControllersF29VR36200M0001 Vess R3600iS 4port 1G iSCSI 3U DDR 8GBx1 Single Controllers Chassis Only included drive carrier no NAS and no data services...Dettagli
Vess R3604fiS 4-port 1G iSCSI + 4-port 16GFC, 3U, DDR 8GBx1F29VR36200M0013 Vess R3604fiS 4port 1G iSCSI 4port 16GFC 3U DDR 8GBx1 Single Controllers Chassis Only included drive carrier no NAS and no data services...Dettagli