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 = '048 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '03 ' AND SBFAM = '048 ')) ORDER BY I.Seq OFFSET 105 ROWS FETCH NEXT 15 ROWS ONLY
Basic control board for advanced display ASD 535-3 and -4 HD version, coACB35CP Basic control board for advanced display ASD 5353 and 4 HD version co...Dettagli
Rotary Snap Lock for ASD 535 (Set 4pcs)RSL35 Rotary Snap Lock for ASD 535 Set 4pcs...Dettagli
Insect protection screen (Set 2pcs)IPS35 Insect protection screen Set 2pcs...Dettagli
Flex tube 21,2mm PA black 50m, FT 21 PAFT21PA Flex tube 212mm PA black 50m FT 21 PA...Dettagli
Screw-junction piece d=25mm, ABS red (10pcs)SJ25ABSRED Screwjunction piece d25mm ABS red 10pcs...Dettagli