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 = '011 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '011 ')) ORDER BY I.Seq OFFSET 1830 ROWS FETCH NEXT 15 ROWS ONLY
Accoppiatore Duplex SC/SC, Multimodale OM2WPC-FA2-SC0201 Accoppiatore Duplex SCSC Multimodale OM2 Ferrula in zirconio ceramica Custodia in tecnopolimero Colore grigio...Dettagli
Tinted BubbleNDA-8000-TBL Cupola oscurata Flexidome IP 8000i...Dettagli
Soft ceiling support for in-ceilingNDA-8000-SP Supporto per soffitti sospesi Flexidome IP 8000i...Dettagli
FLEXIDOME IP 8000i 6MP HDR 12-40mm PTRZ IP66NDE-8503-RT FLEXIDOME IP starlight 8000i 6Mpx p30 Intelligent Video Analytics VCA double resolution True DayNight sensore CMOS 118 progressive scan gamma dinamica 120 dB HDR 107 dB misurato secondo IEC 626745 in modalit Extended Dynamic Mode movimento motorizzat...Dettagli
FLEXIDOME IP 8000i 2MP HDR 10-23mm PTRZ IP66NDE-8502-RT FLEXIDOME IP starlight 8000i 1080p60 Intelligent Video Analytics VCA double resolution True DayNight sensore CMOS 128 progressive scan gamma dinamica 146 dB HDR 108 dB misurato secondo IEC 626745 in modalit Extended Dynamic Mode max 30FPS movimento m...Dettagli