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 1215 ROWS FETCH NEXT 15 ROWS ONLY
43'' Wall Mounted Digital SignageLDH43-SAI200 43 Wall Mounted Digital Signage...Dettagli
Cavo Patch Cat.6 U-UTP 3.0m VerdeWPC-PAT-6U030G Cavo patch Cat6 a coppie twistate non schermato 4 x 2 x AWG267 a 100 Ohm 2 connettori RJ45 Cappuccio pressofuso e serracavo Protezione antipiega ed antistrappo Lunghezza 30m Colore verde...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
PowerLine AV2 1000 HD Gigabit Starter KitDHP-601AV PowerLine AV2 1000 HD Gigabit Starter Kit Bundle Kit includes two 2 DHP600AV PowerLine AV2 1000 HD Gigabit Adapters Up to 1000Mbps PHY data rates1 One 101001000M Gigabit port IEEE1901 compliant 128bit AES Data Encryption Low power mode standby ...Dettagli
Adattatore supporto staffa per telecamere XNV-8081Z/6081Z/6081R/6081SBP-187HM Adattatore supporto staffa per telecamere XNV8081Z6081Z6081R6081...Dettagli
Housing and Mount for PVM camera TNB-6030SBP-300NM Housing and Mount for PVM camera TNB6030...Dettagli
Adattatore supporto staffa per XND-8081VZ/6081VZ/8081RV/6081RV/6081VSBP-167HM Adattatore supporto staffa per telecamere XND8081VZ6081VZ8081RV6081RV6081V...Dettagli