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 ' AND I.GRP = '01157 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '011 ' AND GRP = '01157 ')) ORDER BY I.Seq OFFSET 2520 ROWS FETCH NEXT 15 ROWS ONLY
Staffa pendente per attacco di fissaggio telecam.(F128.8mmx767.00mm)ACM244 Staffa pendente per attacco di fissaggio telecamera F1288mmx76700mm...Dettagli
24W Ultra slim design with 17.5mm (1SU) width DC output voltage adjustaDIS-H30-24 24W Ultra slim design with 175mm 1SU width DC output voltage adjusta...Dettagli
Capsula microfonica alta fedeltà HAP120 Capsula microfonica alta fedelt...Dettagli
Cavo Patch Cat.6 U-UTP 5.0m RossoWPC-PAT-6U050R Cavo patch Cat6 a coppie twistate non schermato 4 x 2 x AWG267 a 100 Ohm 2 connettori RJ45 Cappuccio pressofuso e serracavo Protezione antipiega ed antistrappo Lunghezza 50m Colore rosso...Dettagli
PoE Midspan InjectorNPD-9501-E Midspan singola porta 95W High PoE AC 230Vac modello da esterno grado di protezione IP 67 range di temperatura 40C 60C non compatibile con AUTODOME IP 5100i...Dettagli