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 ' AND I.GRP = '01052 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ' AND SBFAM = '010 ' AND GRP = '01052 ')) ORDER BY I.Seq OFFSET 1050 ROWS FETCH NEXT 15 ROWS ONLY
Ups monofase serie SWAP SIN, 2000VA ,1200WSWS-2000 Ups SWAP SINUSOIDALE 2000VA 1600WLa caratteristica principale del Gruppo di Continuit SWS2000 quella di avere una forma donda in uscita PERFETTAMENTE SINUSOIDALELUps dispone sul frontale di un Display LCD di colore blu il quale mostra la tensione di...Dettagli
UML-275-90 Monitor LED 4K, 27"UML-275-90 Monitor per sala controllo dimensione 27 risoluzione 4K 3840x2160 169 167 milioni di colori retroilluminazione 30000 ore luminanza 200 cdmc contrasto 10001 Fedele riproduzione dei colori antiimage retention ingressi HDMI DP Prevedere supporti accesso...Dettagli