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 ') OR EXISTS (SELECT * FROM ItemCategoryAssociation WHERE ItemCode = I.Code AND FAM = '01 ')) ORDER BY I.Seq OFFSET 2010 ROWS FETCH NEXT 15 ROWS ONLY
VARIO i2 lenti di ricambio - 80°H x 30°VVAR-I2-LENS-8030 VARIO i2 lenti di ricambio 80H x 30V...Dettagli
Wireless AC1200 Dual Band Range Extender, 1 GE port and external antennaDAP-1620 Wireless AC1200 Dual Band Range Extender with one GE port and external antenna Compact Wall Plug design External antenna design 2x2 11ac Technology Up to 1200 Mbps data rate Complying with the IEEE 80211 ac draft a n g and b WPS WiFi Protected S...Dettagli
Monitor professionale LED 55", risoluzione Full HDPO-55H Monitor professionale LED da 55 risoluzione Full HD 1920x1080pixel luminosit 2500cdm2 Ingressi VGA HDMI DVI DisplayPort Montaggio a parete standard VESA Alimentazione 220Vac Dimensioni 1229x713x119 mm...Dettagli
Monitor professionale LED 19", risoluzione SXGA, biancoX-19E-W Monitor professionale LED da 19 risoluzione 1280x1024pixelluminosit 250cdm2 Ingressi VGA DVI HDMI e DisplayPort Ingresso audio 2 altoparlanti integrati Montaggio a parete standard VESA Alimentazione 220Vac Colore BIANCO...Dettagli