Top 10 duplicate Questions

0

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

select top 10000
 PL.RelatedPostId as [Post Link],
 count(*) as "Number of duplicates"

from PostLinks PL
 join Posts P on P.Id = PL.RelatedPostId
 join PostTags PQ on P.Id = PQ.PostId

where LinkTypeId=3

group by PL.RelatedPostId
order by count(*) desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results