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
TUBO ABS ROSSO d. 25 mm 3MTTUBOABS0250M TUBO ABS ROSSO d 25 mm 3MT...Dettagli
MANICOTTO D. 25 mm ABS ROSSOSASO100250RS MANICOTTO D 25 mm ABS ROSSO...Dettagli
FERMATUBO PP RED D.25mmSTS25REDK FERMATUBO PP RED D25mm...Dettagli
TAPPO CALOTTA D. 25 mm ABS ROSSOSACA700250RS TAPPO CALOTTA D 25 mm ABS ROSSO...Dettagli
TI A 90° D.25 mm ABS ROSSOSATE400250RS TI A 90 D25 mm ABS ROSSO...Dettagli
ASD Config Programming full access (only in combination with Basic LicenLICASDPROG ASD Config Programming full access only in combination with Basic Licen...Dettagli
TUBO PE ROSSO D.e. 10 mm rotolo 25 mtMPE1008025M-R TUBO PE ROSSO De 10 mm rotolo 25 mt...Dettagli