duplicate targets

1

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla Meta

Q&A about the site for Joomla! administrators, users, developers and designers

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

select 
top 800 
target [Post Link], count, CreationDate, Score, ViewCount, Tags, AnswerCount, Title
from duplicates d
left join Posts q on d.target = q.Id
where 
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

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