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 ' AND I.GRP = '01153 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '011 ' AND GRP = '01153 ')) ORDER BY I.Seq OFFSET 405 ROWS FETCH NEXT 15 ROWS ONLY
SPEED termica ibrida 336*256 50mm con temperaturaTPC-SD8420-TB50 SPEED termica ibrida 336256 50mm con temperatura...Dettagli
IP VandalDome camera, 1/2" 2.17M CMOS, 4.1~16.4mm mot., WDR, ICRXNV-6085 Wisenet X con DSP Wisenet 5 network antivandalo dome camera da esterno eXtraLUX sensore da 12 2MP 60fps 0004 LuxF094 Color 00004 LuxF094 BW 41 164mm motorized varifocal lens optical 4x 1000262 triplo codec H265H264MJPEG with WiseStream II Multiple ...Dettagli
IP VandalDome camera Wisenet X 2MP, 5.2~62.4mm mot, WDR, IK10, IP67XNV-6120 Wisenet X con DSP Wisenet 5 network antivandalo dome camera da esterno 2MP 60fps Full HD1080p ottica zoom da 52 624mm 12x 5458530 triplo codec H265H264MJPEG con WiseStream II Multiple streaming 150dB WDR True Day Night ICR Advanced Video Analytics ...Dettagli