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 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '011 ')) ORDER BY I.Seq OFFSET 1725 ROWS FETCH NEXT 15 ROWS ONLY
14" Extreme cold housing w Heater & IRPFH610E-IR Custodia in alluminio con riscaldamento IP 67 IK10 NRMA 4X T range 6555 alimentazione 220VAC consumo 350W...Dettagli
14? Ultra-wide Field Housing w HeaterPFH610L-H Custodia in alluminio con vetro panoramico adatto ad ottiche molto grandangolari con riscaldamento e ventilazione IP 67 IK10 NRMA 4X T range 4060 alimentazione 220VAC consumo 350W...Dettagli
Custodia anticorrosionePFH610A Custodia in alluminio IP 67 IK10 NEMA 4X T range 3060...Dettagli
14? Ultra-wide Field Housing w Heater (POE+)PFH610L-H-POE Custodia in alluminio con vetro panoramico adatto ad ottiche molto grandangolari con riscaldamento e ventilazione IP 67 IK10 NRMA 4X T range 4060 alimentazione PoE...Dettagli
VARIO i2 lenti di ricambio - 80°H x 30°VVAR-I2-LENS-8030 VARIO i2 lenti di ricambio 80H x 30V...Dettagli
Wireless AC1200 Dual Band Range Extender, 1 GE port and external antennaDAP-1620 Wireless AC1200 Dual Band Range Extender with one GE port and external antenna Compact Wall Plug design External antenna design 2x2 11ac Technology Up to 1200 Mbps data rate Complying with the IEEE 80211 ac draft a n g and b WPS WiFi Protected S...Dettagli