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 1050 ROWS FETCH NEXT 15 ROWS ONLY
14? Ultra-wide Field HousingPFH610L 14” Ultrawide Field Housing...Dettagli
14" Extreme cold housing w HeaterPFH610E Custodia in alluminio con riscaldamento IP 67 IK10 T range 6555 alimentazione 220VAC consumo 350W...Dettagli
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
Flexible Connecting Pipe for SDZW2000T-SLHB1000 Flexible Connecting Pipe for SDZW2000TSL...Dettagli
Battery for MPT200/210MPT200-BAT Battery for MPT200210...Dettagli
Dual-battery charger (for MPT310)MAE-C100 Dualbattery charger for MPT310...Dettagli
Wall mount bracket for SDZW2000T-SLPFB733W-SL Wall mount bracket for SDZW2000TSL...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
Monitor professionale LED 55", risoluzione Full HDPO-55H Monitor professionale LED da 55 risoluzione Full HD 1920x1080pixel luminosit 2500cdm2 Ingressi VGA HDMI DVI DisplayPort Montaggio a parete standard VESA Alimentazione 220Vac Dimensioni 1229x713x119 mm...Dettagli
Monitor professionale LED 15", risoluzione XGA, biancoX-15E-W Monitor professionale LED da 15 risoluzione 1024x768pixelluminosit 300cdm2 Ingressi VGA DVI HDMI e DisplayPort Ingresso audio 2 altoparlanti integrati Montaggio a parete standard VESA Alimentazione 220Vac Colore BIANCO...Dettagli