duplicate targets


Please login or register to vote for this query.

(click on this box to dismiss)

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

with duplicates as (
  select RelatedPostId as [target], count(*) as [count]
  from PostLinks
  where LinkTypeId = 3 
  group by RelatedPostId
  having count(*) >= 10

top 800 
target [Post Link], count, CreationDate, Score, ViewCount, Tags, AnswerCount, Title
from duplicates d
left join Posts q on d.target = q.Id
Tags like '%<sql>%' or
Tags like '%<sql-server>%' or
Tags like '%<mysql>%' or
Tags like '%<postgressql>%' or
Tags like '%<sqlite>%' 
order by count desc;

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results