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 = '03 ' AND I.SBFAM = '041 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '03 ' AND SBFAM = '041 ')) ORDER BY I.Seq OFFSET 555 ROWS FETCH NEXT 15 ROWS ONLY
D800 Alloggiamento per moduli ausiliari IP65557.201.401 Dettagli
Ricambio cavetto ausiliario per programmazione moduli516.800.922 Dettagli
HVR800 Modulo relè per attivazione di carichi fino a 10mA (con FC410MIO)568.800.004 HVR800 Modulo rel per attivazione di carichi fino a 10mA con FC410MIO...Dettagli
FC440AIB Base avvisatore acustico con VID indirizzabile576.440.010 Dettagli