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 = '011130 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '011 ' AND GRP = '011130 ')) ORDER BY I.Seq OFFSET 105 ROWS FETCH NEXT 15 ROWS ONLY
DSS Data Migration Service (Per day)DSS-DATA-MIGRATION DSS Data Migration Service Per day...Dettagli
VDP Device Upagrade License from DSSEXP to DSSProDSSEXP-PRO-VDP Dettagli
Video Ch Upagrade License from DSSEXP to DSSProDSSEXP-PRO-VIDEO Dettagli
BVMS Plus 10.1, License Subsystem expansionMBV-XSUBPLU-101 La licenza elettronica permette di aggiungere n 1 sottosistema al software BVMS Plus ver 101 Per sottosistema si intendeun impianto indipendete realizzato con BVMS LitePlusProfessional eo DIVAR IP AIO sempre collegato al sistema Enterprise pur rimane...Dettagli
BVMS Plus 10.1, License Intrusion panel expansionMBV-XINTPLU-101 La licenza elettronica permette di aggiungere n 1 centrale intrusione serie BG al software BVMS Plus base ver 101...Dettagli
BVMS Lite 10.1, License Keyboard expansionMBV-XKBDLIT-101 La licenza elettronica permette di aggiungere n 1 tastiera alla workstation con software BVMS Lite base ver 101 Per tastiera si intende un Joystick Bosch con funzioni speciali quali KBDUXF KBDDIGITAL o KBDUNIVERSAL...Dettagli