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 = '01157 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '011 ' AND GRP = '01157 ')) ORDER BY I.Seq OFFSET 1245 ROWS FETCH NEXT 15 ROWS ONLY
Plastic/Aluminum Wall mount for outdoor domesSBP-137WMW1 PlasticAluminum Wall mount for outdoor domes Compatible with QNV6010R6020R6030R6070R7010R7020R7030R7080R XNP6040H XNV601060208020R8030R8040R HCV6080R6070R7010R7020R7030R7070R SNVL5083RL6083RSCV50825082R50835083R50856023R6083R White...Dettagli
Plastic/Aluminum Wall mount for outdoor domesSBP-137WM1 PlasticAluminum Wall mount for outdoor domes Compatible with QNV6010R6020R6030R6070R7010R7020R7030R7080R XNP6040H XNV601060208020R8030R8040R HCV6080R6070R7010R7020R7030R7070R SNVL5083RL6083RSCV50825082R50835083R50856023R6083R Ivory...Dettagli
Custodia controsoffitto per telecamere Dome e PTZSHP-1680FW Custodia controsoffitto per telecamere Dome e PTZ Compatibile con XNP6120H XNV61206120R6085 XND60856085V Bianca...Dettagli
Tastiera USB di controllo da tavolo con joystick a 3 assi per controlloDS-1005KI Tastiera USB di controllo da tavolo con joystick a 3 assi per controllo di registratori VMS Compatibile con sistemi operativi Windows 7VistaXP2003 Tasti funzione su tastiera 2 tasti supplementari su joystick Alimentazione direttamente da USB temperat...Dettagli
1-METER SERVICE/MONITOR CABLE FOR FLEXIDOME XT SERIES.S1460 Cavo coassiale per telecamera FlexiDome e Dinion IP 40005000...Dettagli
Unità di conversion RS232/16 OUT BiphaseLTC8786/50 Unit di conversione RS23216 uscite Biphase alimentazione 230 VAC 5060Hz...Dettagli
POWER SUPPLY.BOX.Vess A3340s.350WF29VA3420000009 POWER SUPPLYBOXVess A3340s350W...Dettagli
Drive carrier with dummy.BOX.Vess A3120F29A31220000004 Drive carrier with dummyBOXVess A3120...Dettagli
6TB SATA HDD.1 PACK.Vess A3120.With 3120 Drive carrier. Enterprise.F40A31200000002 6TB SATA HDD1 PACKVess A3120With 3120 Drive carrier Enterprise...Dettagli
Pre-tested and qualified 8TB 7200-RPM dual-ported 12Gb SAS hard diskF40E58F00010011 Pretested and qualified 8TB 7200RPM dualported 12Gb SAS hard disk drive premounted in VTrak drive carrier Single Pack...Dettagli
Pre-tested and qualified 4TB 7200-RPM dual-ported 12GbF40VR3600010001 Pretested and qualified 4TB 7200RPM dualported 12Gb SAS hard disk drive premounted in R3000 drive carrier Single Pack...Dettagli