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 ' AND I.GRP = '01052 ' AND I.SBGRP = '01052108 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '010 ' AND GRP = '01052 ' AND SBGRP = '01052108 ')) ORDER BY I.Seq OFFSET 30 ROWS FETCH NEXT 15 ROWS ONLY
Convertitore Ethernet Over CoaxVHWHW Conver4tore Ethernet Over Coax per la conversione diun cavo coassiale preesistente in una dorsale EthernetLunghezza max coassiale 300m su RG59 o 500m suRG11 Banda passante 200Mbits...Dettagli
Trasmettitore/ricevitore UTP passivo HDUTP04 Trasmettitorericevitore UTP passivo quadricanalePermette la trasmissionericezione di 4 segnali video HD AHDTVICVI su 1 cavo CAT5 Consente la trasmissione di un segnale video a colori a 400 m e BW a 600 m 4 connettori BNC femmina 8 terminali autoblocc...Dettagli
HD-TVI/HDCVI/AHD UTP Active ReceiverTTA111HDT HDTVIHDCVIAHD UTP Active Receiver...Dettagli