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 0 ROWS FETCH NEXT 15 ROWS ONLY
CURVA A 90° D. 25 mm ABS ROSSO (R.LARGO)SABE300250RS CURVA A 90 D 25 mm ABS ROSSO RLARGO...Dettagli
MANICOTTO D. 25 mm ABS ROSSOSASO100250RS MANICOTTO D 25 mm ABS ROSSO...Dettagli
FERMATUBO PP RED D.25mmSTS25REDK FERMATUBO PP RED D25mm...Dettagli
TUBO ABS ROSSO d. 25 mm 3MTTUBOABS0250M TUBO ABS ROSSO d 25 mm 3MT...Dettagli
TAPPO CALOTTA D. 25 mm ABS ROSSOSACA700250RS TAPPO CALOTTA D 25 mm ABS ROSSO...Dettagli
CAPILLARI KIT 25mm PER TUBO 10 Nr.1 Tee ridotto + Passaparete + GhieraCAPKIT2510SR CAPILLARI KIT 25mm PER TUBO 10 Nr1 Tee ridotto Passaparete Ghiera...Dettagli
Sampling hole clip red, hole Ø 3 mm, PA CLIP3.0PA Sampling hole clip red hole 3 mm PA 10 pcs...Dettagli
Sampling hole clip red, hole Ø 5 mm, PA CLIP5.0PA Sampling hole clip red hole 5 mm PA 10 pcs...Dettagli
Dongle for Securiton Applications (without license)ULM-DP Dongle for Securiton Applications without license...Dettagli
ASD Config Programming full access (only in combination with Basic LicenLICASDPROG ASD Config Programming full access only in combination with Basic Licen...Dettagli
Sampling hole clip red, hole Ø 3.5 mm, PA CLIP3.5PA Sampling hole clip red hole 35 mm PA 10 pcs...Dettagli