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)) ORDER BY I.Seq OFFSET 17940 ROWS FETCH NEXT 15 ROWS ONLY
BAT 300 AJAX READY - INCLUDES: 2 RELAY AJAX, POWER SUPPLY - 24/12 ADAPTER CABLE FPUB300A BAT 300 AJAX READY - INCLUDES: 2 RELAY AJAX, POWER SUPPLY - 24/12 ADAPTER CABLE ...Dettagli
Pump 6000 Pro Plus WIDE AJAX READY (Fluid bag Pump 4000 ml + 2 Relay included)FPU6000PPH Pump 6000 Pro Plus WIDE AJAX READY (Fluid bag Pump 4000 ml + 2 Relay included) ...Dettagli
Modular 200 AJAX READY (Fluid bag Modular 500 ml + 2 Relay + Transmitter included + side riser)FPU03ESM200AT Modular 200 AJAX READY (Fluid bag Modular 500 ml + 2 Relay + Transmitter included + side riser) ...Dettagli
Modular 300 HIKVISION READY (Fluid bag Modular 500 ml + 2 Relay included)FPU03ESM300H Modular 300 HIKVISION READY (Fluid bag Modular 500 ml + 2 Relay included) ...Dettagli
Modular 300 AJAX READY (Fluid bag Modular 500 ml + 2 Relay + Transmitter included + side rider)FPU03ESM300AT Modular 300 AJAX READY (Fluid bag Modular 500 ml + 2 Relay + Transmitter included + side rider) ...Dettagli
Modular 200 HIKVISION READY( Fluid bag Modular 500 ml + 2 Relay included)FPU03ESM200H Modular 200 HIKVISION READY( Fluid bag Modular 500 ml + 2 Relay included) ...Dettagli
RISOLUZIONE 4k - 3840 x 2160, FRAME RATE 20 fps @ 3840 x 2160, SENSORE NERADS-2CD2686G2-IZS(2.8-12)(B RISOLUZIONE 4k - 3840 x 2160, FRAME RATE 20 fps @ 3840 x 2160, SENSORE NERA ...Dettagli
Tastiera Digit nera con led bluDIGITBLU Tastiera Digit nera con led blu ...Dettagli
Tastiera Digit bianca con led bianchiDIGIT Tastiera Digit bianca con led bianchi ...Dettagli
Box metallico per Centrale a 8 zone espandibile a 80 completa di GSM digitale e vocale20.600.587 Box metallico per Centrale a 8 zone espandibile a 80 completa di GSM digitale e vocale ...Dettagli