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 = '010 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '010 ')) ORDER BY I.Seq OFFSET 1140 ROWS FETCH NEXT 15 ROWS ONLY
Staffa da parete per telecamere serie PTZ19PFB731W Dettagli
5MP Starlight HDCVI IR Dome CameraHAC-HDBW2501E-S2 Dettagli
Ottica variabile 2.7~12mm Iris auto DC 4MpPLZ1040-D Ottica variabile 2712mm Iris auto DC 4Mp...Dettagli
Pannello guidacavi 1U, Nero RAL9005WPN-ACM-102-B Panello guidacavi orizzontale in plastica standard 19 da 1 unit 5 anelli Colore RAL9005 nero Dimensioni mm 483x42...Dettagli
UPS line da 1.000VA / 900W con display, 2 batterie da 12V 7AHPFM351-900 UPS line da 900W 1500VA...Dettagli
Custodia da esterno per telec. fissa, compatibile con TNB-9000, 220VacSHB-9000H Custodia da esterno per telecamera fissa compatibile con TNB9000 Riscaldatore e ventilatore incorporati IP66 220VAC Bianca...Dettagli
HD-TVI/HDCVI/AHD UTP Active ReceiverTTA111HDR HDTVIHDCVIAHD UTP Active Receiver...Dettagli
DTS-01 (TABLE TOP STAND FOR 32" - 65")DST-01 DTS01 TABLE TOP STAND FOR 32 65...Dettagli
DVR 16CH 4K 8HDD RAIDDS-8116HTHI-K8 INGRESSI VIDEO 16 canali 4in1 16 IP VIDEO COMPRESSIONE VIDEO H265H265H264H264 COMPRESSIONE AUDIO G711U USCITE VIDEO 2HDMI 1VGA 1CVBSINGRESSIUSCITE AUDIO 162 RISOLUZIONE DI REGISTRAZIONE TVI IP 8MP12fps 5MP20fps 4MP18fps 3MP25fps 1080P25fps IP 8MP ...Dettagli
STAFFA DA MURO E SOFFITTODS-2272ZJ-KL(WHITE) Staffa da Muro e Soffitto per DS2CD6825G0CIS e DS2CD6825G0CIVS...Dettagli