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 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ')) ORDER BY I.Seq OFFSET 5880 ROWS FETCH NEXT 15 ROWS ONLY
Adattatore ad angolo, 137x127x116mm (BxHxP)UC08C Adattatore ad angolo 137x127x116mm BxHxP...Dettagli
Supporto da parete completo di box di giunzione per Minidome, 126,7x126,4x228,4mm (BxHxP)JB07/WM03G Supporto da parete completo di box di giunzione per Minidome 1267x1264x2284mm BxHxP...Dettagli
Telecamera bullet AI access ANPR da interno/esterno IP67 antivandalo IK10, sensore CMOS 1/1.8", risoNBV410TADET Telecamera bullet AI access ANPR da interno/esterno IP67 antivandalo IK10, sensore CMOS 1/1.8", riso ...Dettagli
Single channel isolated PoE Splitter. Output: 12VDC, 2.0A (Max), 24VDC, 1.0AACE704 Single channel isolated PoE Splitter Output 12VDC 20A Max 24VDC 10A...Dettagli
4MP Lite AI IR Fixed focal Dome Network CameraIPC-HDBW3441F-AS-M Dettagli
BULLET OTTICA FISSA WDR 130dB 4IN1 4KDS-2CE16U7T-ITF(3.6) Bullet Turbo HDTVI 8MP 4 in 1 TVICVIAHDCVBS di tipo DayNight con filtro IR meccanico WDR130dB in contenitore per esterno IP67 illuminatore EXIR 20 integrato sino a 30m sensore 8MP Progressive Scan CMOS sensibilit 0003 Lux F12 con AGC attivo 0 Lux con...Dettagli