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 1065 ROWS FETCH NEXT 15 ROWS ONLY
Base da Tavolo, compatibile con DS-D5045FL-BDS-DM5503B Base da Tavolo compatibile con DSD5045FLB...Dettagli
INGRESSI VIDEO 8 canali 4in1 + 2 IP VIDEO LOOP NO COMPRESSIONE VIDEO H.DS-8108HUHI-K8 INGRESSI VIDEO 8 canali 4in1 2 IP VIDEO LOOP NO COMPRESSIONE VIDEO H265H265H264H264 COMPRESSIONE AUDIO G711U USCITE VIDEO 2HDMI 1VGA 1CVBS INGRESSIUSCITE AUDIO 82 RISOLUZIONE DI REGISTRAZIONE TVI IP 4K8fps 5MP12fps 4MP15fps 3MP18fps 1080P25fps IP ...Dettagli
Capsula microfonica alta fedeltà HAP301 Capsula microfonica alta fedelt...Dettagli