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 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '011 ')) ORDER BY I.Seq OFFSET 5040 ROWS FETCH NEXT 15 ROWS ONLY
Collare da palo piccolo per sup.par.,per tel.e per sc.stagna(DaØ 80 a Ø1ACM263 Collare da palo piccolo per supporto da parete per telecamera e per scatola stagna Diampali da 80 a 1501400mmx1304mmx450mm...Dettagli
Tilt mount 20-deg, 148mmNDA-5080-TM Accessorio per installazione inclinata 20 delle telecamere FLEXIDOME IP 4000i5000i da interno ed esterno e FLEXIDOME panoramic 5100i...Dettagli
IP Flateye Camera, Max. 5MP, ottica fissa da 2.8mm,PoEQNE-8011R IP Flateye Camera Risoluzione Max 5Megapixel 2592 x 1944 ottica fissa da 28mm 015Lux Color 0Lux BW IR LED on Max 30fps5MP H265 H264 Streaming multipli Day Night WDR 120dB Defocus detection Directional detection Motion detection EnterExit Tampering ...Dettagli