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 1185 ROWS FETCH NEXT 15 ROWS ONLY
55'' Wall Mounted Digital SignageLDH55-SAI200 55 Wall Mounted Digital Signage...Dettagli
24-Ports PoE 10/100/1000Mbps with 4 x SFP ports - 24 x PoE 10/100/1000MbDGS-1210-28P 24Ports PoE 101001000Mbps with 4 x SFP ports 24 x PoE 101001000Mbps AutoNegotiating Ports 4 x SFP ports Port 14 8023at up to 30W Port 524 8023af up to 154W Switching Capacity 56 Gbps Advance power saving features Fanless design HalfFullDuplex...Dettagli
Box di giunzione stagnoper telecamereCompatibile con i modelli: BS-T44JB357WP Box di giunzione stagno
per telecamere
Compatibile con i modelli BST4411C BST4602CVZ BST4502CV BST3901CVPBZ BST3602CVPBZ BST3502CVPBZ In alluminio verniciato Diametro 135mm Spessore 50mm...Dettagli
Monitor 75" per meetboardIFP-7502 Monitor 75 per meetboard...Dettagli
Illuminatore IR per TNU-6320/KEU - 200m - 25 gradi - IP67SPI-50 Illuminatore IR per TNU6320KEU 200m 25 gradi IP67...Dettagli
Base Speed Dome SFP -Fibra ottica,Supporta modalita' single e multi modeSBP-303HF Base Speed Dome SFP Fibra ottica Supporta modalita single e multi mode compatibile con XNP6550RH6371RH6320H6250RH6320RH QNP6230H...Dettagli