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 = '01155 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '011 ' AND GRP = '01155 ')) ORDER BY I.Seq OFFSET 75 ROWS FETCH NEXT 15 ROWS ONLY
Workstation, High PerformanceMHW-WZ4G4-HEN4 Z4 G4 Management Workstation la workstation ad elevate prestazioni ideale per lesecuzione delle applicazioni software dei sistemi di sicurezza offerte da Bosch Workstation Z4G4 ad elevate prestazioni con microarchitettura Intel di ultima generazione...Dettagli
Mini Qube 4 Bay client with on-board Intel 730 GPU, Intel Core 12th GenCLIENT-QUBE-i5-2MO Mini Qube 4 Bay client with onboard Intel 730 GPU Intel Core 12th Gen i5 10 Cores 16GB RAM 2 x 1Gbe 1 x DP with HDMI adaptor 1x HDMI Win 10 PRO 250GB SSD 250W PSU 5 Year NBD Warranty Includes 1 x Power Cable and KeyboardMouse set...Dettagli
Mini Qube 4 Bay client with on-board Intel 770 GPU, Intel Core 12th GenCLIENT-QUBE-i7-2MO Mini Qube 4 Bay client with onboard Intel 770 GPU Intel Core 12th Gen i7 10 Cores 16GB RAM 2 x 1Gbe 1 x DP with HDMI adaptor 1x HDMI Win 10 PRO 250GB SSD 250W PSU 5 Year NBD Warranty Includes 1 x Power Cable and KeyboardMouse set...Dettagli
4x Monitor upgrade T1000 4x miniDP Outputs (SSM Only)QUBE4MONUPGRADET1000 4x Monitor upgrade Must be ordered with Client Qube Nvidia T1000 4x miniDP Outputs SSM Only Takes ClientQubei5 or i7 to 4 monitor out total Complete with Mini Display Port to full size Display Port adapters...Dettagli
HIKCENTRAL-WORKSTATION/I3 128CH NON ESPANDIBILEHIKCENTRAL-WORKSTATION/I3 HIKCENTRAL-WORKSTATION/I3 128CH NON ESPANDIBILE ...Dettagli