drop table #tempresults
SELECT [KenmerkId], [ClassId], COUNT(*) As num
into #TempResults
FROM ac.[Ken_Zoek]
GROUP BY [KenmerkId], [ClassId]
HAVING COUNT(*) > 1
ORDER BY 3 DESC
SELECT * FROM dbo.[Artikel] WHERE ClassId IN (SELECT ClassId FROM #TempResults)
delete kz from ac.ken_zoek kz inner join #tempresults t on kz.KenmerkId = t.KenmerkId and t.classid = kz.ClassId
where kz.RemovedByEtim = 1
select *from ac.ken_zoek kz inner join #tempresults t on kz.KenmerkId = t.KenmerkId and t.classid = kz.ClassId
where kz.private = 1
--3113 --1113
--3115 --1113
--4389 --1113
delete kz from ac.ken_zoek kz inner join #tempresults t on kz.KenmerkId = t.KenmerkId and t.classid = kz.ClassId
where kz.Private = 1
select * from #TempResults t
inner join ac.Art_klas_Vertaling akv on t.ClassId = akv.ClassId and akv.LanguageId = 1
inner join ac.Kenmerk_Vertaling kv on t.KenmerkId = kv.KenmerkId and kv.LanguageId = 1
order by t.ClassId