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 2460 ROWS FETCH NEXT 15 ROWS ONLY
Pannello guidacavi 1U, Nero RAL9005WPN-ACM-102-B Panello guidacavi orizzontale in plastica standard 19 da 1 unit 5 anelli Colore RAL9005 nero Dimensioni mm 483x42...Dettagli
5 Port Unmanaged Switch with 5 x 10/100/1000BaseT(X) portsDIS-100G-5W 5 Port Unmanaged Switch with 5 x 101001000BaseTX ports...Dettagli
32 inch FHD LED monitorUML-324-90 Monitor professionale per sala controllo dimensione 32 risoluzione 1080p 1920x1080 169 167 milioni di colori retroilluminazione 50000 ore luminanza 500 cdmq contrasto 30001 angolo visione orizzontaleverticale 178 Fedele riproduzione dei colori antiim...Dettagli
Ups monofase serie SWAP ON-LINE DIGIT, 2000VA, 1800WSWO-D2000 Ups monofase serie swap online digit doppia conversione sinusoidale potenza nominale va 2000 potenza attiva w 1800 stabilizzazione 001 banco batteria 4x12v 9Ah dimensioni mm lxpxh 190x452x341 peso kg 215...Dettagli
Wall AdaptorSBD-110GP1 Wall Adaptor Core Aluminum Cap Plastic Dimensions 1401x132mm Weight 190g 042lb Mount Screw Size TR20...Dettagli
Wall AdaptorSBO-090GP Wall Mount Aluminum RAL9003 Indoor use only Compatible with QNVC8083R9083R white...Dettagli
Wall MountSBP-140WMW Pole Mount Core Aluminum Cap Plastic Dimensions 1871x505mm Weight 370g 082lb Mount Screw Size TR20 Camera TR30 Steel Strap white Suported products PNVA6081RA9081R XNV8082R9082R XNV6083R8083R8093R9083RXNV6123R XNV6083Z8083Z XNV6083RZ8083RZ9083RZPNDA...Dettagli
Wall AdaptorSBD-137WMA Pole Mount Core Aluminum Cap Plastic Dimensions 1471x505mm Weight 340g 075lb Mount Screw Size TR20 Camera TR30 Steel Strap white Supported products QNVC8083RC9083R QNVC8011RC8012C9011R
QND6012R122R172R182R1 QND7012R22R82R QNE8011R21R...Dettagli