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 = '01 ' AND I.SBFAM = '011 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '011 ')) ORDER BY I.Seq OFFSET 1560 ROWS FETCH NEXT 15 ROWS ONLY
Adesivo DAHUA AREA VIDEOSORVEGLIATA GRANDE16.05.DHADGRA.001802 Dettagli
Adesivo DAHUA AREA VIDEOSORVEGLIATA PICCOLO16.05.DHADPIC.001802 Dettagli
Patch pannel da 24 porte UTP CAT5EPFM973M-5EU-24 Dettagli
Patch pannel da 24 porte UTP CAT6PFM973M-6U-24 Dettagli