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 150 ROWS FETCH NEXT 15 ROWS ONLY
Sensore remoto Beta per SE330/SE333 - catalitico per CH4SE396KM Sensore remoto Beta per SE330SE333 catalitico per CH4...Dettagli
Rivel. gas LIFE da incasso - per CH4 - biancoSE503KM Rivel gas LIFE da incasso per CH4 bianco...Dettagli
Rilevatore CO e NO2 per autorimesse, uscita RS485S2400CO-ND Rilevatore MONOSSIDO DI CARBONIO E BIOSSIDO DI AZOTO per autorimesse sotterranee uscita seriale RS485 Campo di misura CO 0300 ppm NO2 030 ppm Progettato per soddisfare la nuova Normativa Europea per la rilevazione gas nelle autorimesse sotterranee il...Dettagli