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 ' AND I.GRP = '041105 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '03 ' AND SBFAM = '041 ' AND GRP = '041105 ')) ORDER BY I.Seq OFFSET 30 ROWS FETCH NEXT 15 ROWS ONLY
Sirena con lampeggiatore (Led Bianco) Wireless bi direzionale serire FirWS2020WE Sirena con lampeggiatore Led Bianco Wireless bi direzionale serire FireVibes montaggio a muro IP65 Colore bianco Potenza sonora 100dBA1m 4 livelli di volume 32 toni selezionabili 2 livelli di potenza per il led 22 coppie di canali Ridondanza a doppio...Dettagli