Top 10 duplicate Questions


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

Switch sites:
loading Hold tight while we fetch your results