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
Kit SE230KG + E/V NA ½"KG003 Kit SE230KG EV NA ...Dettagli
Segnalatore catalitico gas Gpl con allarme acusticoSE221KG Dettagli
Rivelatore IP44 catalitico per GplSE192KG Dettagli
Segnalatore catalitico gas CH4 con allarme acusticoSE221KM Dettagli
Rivel. gas LIFE da incasso - per Gpl - biancoSE503KG Rivel gas LIFE da incasso per Gpl bianco...Dettagli
Kit SE230KG + E/V NA ¾"KG004 Kit SE230KG EV NA ...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 Beta - SE330KM + E/V NA ½"KM051 Kit Beta SE330KM EV NA ...Dettagli
Sensore remoto per SE230/SE233 - catalitico per CH4SE296KM Sensore remoto per SE230SE233 catalitico per CH4...Dettagli
Rivel. gas LIFE da incasso - per CH4 - argentoSE505KM Rivel gas LIFE da incasso per CH4 argento...Dettagli
Kit SE230KG + E/V NA 1"KG005 Kit SE230KG EV NA 1...Dettagli
Kit Beta - SE330KG + E/V NA 1"KG053 Kit Beta SE330KG EV NA 1...Dettagli
Kit SE230KM + E/V NA ½"KM001 Kit SE230KM EV NA ...Dettagli
Kit SE230KM + E/V NA ¾"KM002 Kit SE230KM EV NA ...Dettagli