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.Code LIKE 'URF-%' ORDER BY I.Seq OFFSET 0 ROWS FETCH NEXT 15 ROWS ONLY
SACCA DI RICAMBIO x UR-FOG FPU250PPFFFLXRC10 SACCA DI RICAMBIO x UR-FOG FPU250PP ...Dettagli
Mounting kit ActiveCloud for BAT300 (24V-12V adapter kit for lan not included)URCLWFT Mounting kit ActiveCloud for BAT300 (24V-12V adapter kit for lan not included) ...Dettagli
Serial Relay Board for Modular line - Provides 4 separate output signals
(Empty - Battery Error -URREM Serial Relay Board for Modular line - Provides 4 separate output signals
(Empty - Battery Error - ...Dettagli
Relay board for mounting with Active Cloud boardURREAC Relay board for mounting with Active Cloud board ...Dettagli
ACTIVE CLOUD LAN/WIFI BOARD WTH CABLES (WIFI AND ADAPTER CABLE OPT.)URCLWFKIT ACTIVE CLOUD LAN/WIFI BOARD WTH CABLES (WIFI AND ADAPTER CABLE OPT.) ...Dettagli
Side extra riser (for second extra board or horizontal mounting)SCOSSOC Side extra riser (for second extra board or horizontal mounting) ...Dettagli