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 2805 ROWS FETCH NEXT 15 ROWS ONLY
PN 2.2.01.99.10100 - Custom Development ServiceCDS-SW PN 22019910100 Custom Development Service...Dettagli
Edge Storage with 1x1Tb HDDITSE0400-GN5A-B Dettagli
Ups monofase serie SWAP SIN, 1500VA, 900 WSWS-1500 Ups monofase online doppia conversione 1500VA 1200 WLa caratteristica principale del Gruppo di Continuit SWS1500 quella di avere una forma donda in uscita PERFETTAMENTE SINUSOIDALELUps dispone sul frontale di un Display LCD di colore blu il quale mo...Dettagli
5MP AI IR Bullet CameraQNO-C8083R 5MP AI IR Bullet Camera ...Dettagli
Staffa montaggio a Tavolo per DS-K1T671TM-3XF e DS-K1TA70MI-T, PESO 2,2kDS-DM0701BL Staffa montaggio a Tavolo per DSK1T671TM3XF e DSK1TA70MIT PESO 22kg DIMENSIONI 192mm195mm353 mm...Dettagli
Bullet IP 5MP, ottica 3.6 mm, IR 80 m, WDR, Starlight, 12Vdc/PoEIPC-HFW5541T-ASE Bullet IP 5MP ottica 36 mm IR 80 m WDR Starlight 12VdcPoE...Dettagli