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 = '010 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '010 ')) ORDER BY I.Seq OFFSET 1200 ROWS FETCH NEXT 15 ROWS ONLY
4MP Wisenet HD+ Outdoor DomeHCV-7010RA Minidome da esterno 4MP WiseNet HD CMOS PS QHD 2560 x 1440 25fps over coax BNC AHD CVBS per installazione DWDR ottica fissa 28mm 20m IR range ICR distmax 500m motion detec Coax Ctrl IP66 IK1012 Vdc...Dettagli
5MP Starlight HDCVI IR Eyeball CameraHAC-HDBW2501F-A-S2 Dettagli
MIDSPAN, 95WNPD-9501A Midspan singola porta 95W High POE AC...Dettagli
Custodia da esterno per telec. fissa, compatibile con TNB-9000, 220VacSHB-9000H Custodia da esterno per telecamera fissa compatibile con TNB9000 Riscaldatore e ventilatore incorporati IP66 220VAC Bianca...Dettagli
HD-TVI/HDCVI/AHD UTP Active ReceiverTTA111HDR HDTVIHDCVIAHD UTP Active Receiver...Dettagli
DTS-01 (TABLE TOP STAND FOR 32" - 65")DST-01 DTS01 TABLE TOP STAND FOR 32 65...Dettagli
STAFFA DA MURO E SOFFITTODS-2272ZJ-KL(WHITE) Staffa da Muro e Soffitto per DS2CD6825G0CIS e DS2CD6825G0CIVS...Dettagli
DVR 16CH 4K 8HDD RAIDDS-8116HTHI-K8 INGRESSI VIDEO 16 canali 4in1 16 IP VIDEO COMPRESSIONE VIDEO H265H265H264H264 COMPRESSIONE AUDIO G711U USCITE VIDEO 2HDMI 1VGA 1CVBSINGRESSIUSCITE AUDIO 162 RISOLUZIONE DI REGISTRAZIONE TVI IP 8MP12fps 5MP20fps 4MP18fps 3MP25fps 1080P25fps IP 8MP ...Dettagli