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 2070 ROWS FETCH NEXT 15 ROWS ONLY
Hanging MountSBP-301HMW3 Aluminum Hanging Mount for Indoor Dome cameras Compatible with QNP6230 XNP6320 6321 HCP6230 6320 6320A SCP3371 SNP63206321620154305321L6233L52335300 SNV70827080R70805080R50803120 White...Dettagli
Attacco di fissaggio per telecamera (F134.1mmx83.5mm)ACM243 Attacco di fissaggio per telecamera F1341mmx835mm...Dettagli
UPS ON-LINE SU RACK/TOWER 6000 VA/W AUT. 7/10Min SENZA BYPASS MANUALESWO-D6000/7RK UPS ONLINE SU RACKTOWER 6000 VAW AUT 710Min SENZA BYPASS MANUALE...Dettagli