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 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ')) ORDER BY I.Seq OFFSET 5610 ROWS FETCH NEXT 15 ROWS ONLY
Hanging MountSBP-160HMW1 Adattatore supporto staffa per telecamere serie Wisenet X
XNDC6083RV7083RV8083RV9083RV XND6083RV8083RV8093RV9083RV PNDA6081RV9081RV XNVC6083R7083R8083R9083R XNF9013RV9010RV XND8082RV9082RV...Dettagli
Hanging MountSBP-180HMW1 Adattatore supporto staffa per telecamere serie Wisenet X
XNV6083R8083R8093R9083R XNV6083RZ8083RZ9083RZ XNV6123R PNVA6081R9081R XNV8082R9082R...Dettagli
PTZ Plus AdaptorSBP-156WA PTZ adaptor Compatible with XNP6400RW XNP8300RW XNP9300RW...Dettagli
Waterproof Back BoxSBV-180WW Waterproof Back Box for the white Vandal XCore and XPlus cameras
Compatible models include XNV6081R XNV8081R XNV6083R XNV8083R XNV8093R XNV9083R XNVC6083R XNVC7083R XNVC8083R XNVC9083R...Dettagli
Monitor Stand Compatible with SMT-4343, 3234, 3240SBM-4343 Monitor Stand Compatible with SMT4343 3234 3240...Dettagli
22" FHD MonitorSMT-2212 22 FHD LED Monitor Frameless Design Support up to 1920 x 1080 resolution Contrast ratio 30001 Viewing Angle HV 178178 Response Time 65ms Video Input HDMI and VGA...Dettagli
Road AI 3MP Alta velocità Global Shutter CameraTNO-7180RLP Road AI 3MP Alta velocità Global Shutter Camera ...Dettagli
55'' FHD Videowall DisplayLH55VMBUBGBXEN 55 FHD LED Samsung Videowall Display 1080p 1920x1080 Super Thin Bezel Bezel to Bezel 35mm 500nit 169 aspect ratio Contrast ratio 40001 Response time 8ms DVID 2xHDMI VGA Display Port VESA Compatible 600x400mm...Dettagli