Posts identified as duplicates

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla

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

select count(dp.id)
from posts dp
  join postlinks pl on dp.id = pl.postid
  join posts op on op.id = pl.RelatedPostId
where
  dp.posttypeid = 1 -- Question post
  and pl.linktypeid = 3 -- duplicate
  and dp.tags like '%<r>%'

Enter Parameters

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