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 = '06 ' AND I.SBFAM = '052 ' AND I.GRP = '052114 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '06 ' AND SBFAM = '052 ' AND GRP = '052114 ')) ORDER BY I.Seq OFFSET 15 ROWS FETCH NEXT 15 ROWS ONLY
Rivel. gas LIFE da incasso - per Gpl - argentoSE505KG Rivel gas LIFE da incasso per Gpl argento...Dettagli
Kit Beta - SE330KG + E/V NA ½"KG051 Kit Beta SE330KG EV NA ...Dettagli
Kit Beta - SE330KG + E/V NA ¾"KG052 Kit Beta SE330KG EV NA ...Dettagli
Kit Beta - SE330KM + E/V NA ¾"KM052 Kit Beta SE330KM EV NA ...Dettagli
Rivel. gas LIFE da incasso - per CH4 - antraciteSE504KM Rivel gas LIFE da incasso per CH4 antracite...Dettagli
Kit Beta - SE330KM + E/V NA 1"KM053 Kit Beta SE330KM EV NA 1...Dettagli
Rivelatore Exd ATEX catalitico per GplSE193KG Dettagli
Segnalatore catalitico gas Gpl con allarme acusticoSE221KG Dettagli
Segnalatore catalitico gas CH4 con allarme acusticoSE221KM Dettagli
Rivelatore IP44 catalitico per GplSE192KG Dettagli
Kit SE230KG + E/V NA ½"KG003 Kit SE230KG EV NA ...Dettagli
Rivel. gas LIFE da incasso - per Gpl - biancoSE503KG Rivel gas LIFE da incasso per Gpl bianco...Dettagli
Sensore remoto per SE230/SE233 - catalitico per GplSE296KG Sensore remoto per SE230SE233 catalitico per Gpl...Dettagli
Sensore remoto Beta per SE330/SE333 - catalitico per GplSE396KG Sensore remoto Beta per SE330SE333 catalitico per Gpl...Dettagli
Kit SE230KG + E/V NA ¾"KG004 Kit SE230KG EV NA ...Dettagli