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 1170 ROWS FETCH NEXT 15 ROWS ONLY
Cavo Patch Cat.5E U-UTP 0.5m NeroWPC-PAT-5U005BL Cavo patch Cat5e A coppie twistate non schermate 4 x 2 x AWG267 a 100 Ohm 2 connettori RJ45 50 gold plated Cappuccio pressofuso e serracavo Protezione antipiega ed antistrappo Lunghezza 05m Colore nero...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