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 5190 ROWS FETCH NEXT 15 ROWS ONLY
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
Bullet PTZ IP 5Megapixel, 4G, Wifi integrato. Sensore 1/2.8? CMOS Sony SIPT4509WL Bullet PTZ IP 5Megapixel 4G Wifi integrato Sensore 128” CMOS Sony Starvis Obiettivo motorizzato autofocus 4947mm Connessione 4G Movimento motorizzato orizzontale 300 Movimento motorizzato verticale 60 4 led IR con portata 60m Slot SD card Microfono ...Dettagli