3

Browsing the WordPress community, there seems to be many questions on the same exact problem, such as: using .htaccess to redirect to HTTPS... Obviously, we are not searching (enough) prior to asking.

Is there data available on the most commonly asked duplicate questions, including the site and the subject and date?

Also, would there be data to show if there has been an increase/decrease in questions for certain subjects overtime, for example - as new scripting languages become popular, so we might expect to see an increase in duplicate questions, and just as WordPress becomes more accessible and understandable to new users (developers), so we would see a decrease in duplicate questions.

In fact, I've just noticed the Query Stack Overflow service. Can it be used for this, i.e. is there a query repository available to run such queries?

1
  • There is the theory that if a subject matures, more and more potential questions would be duplicates and the emphasis should move from asking questions to searching for existing answers. – Trilarion Jan 18 at 10:11
6

You can look at the PostLinks table. It holds links to duplicate questions (LinkType = 3).

From Database schema documentation for the public data dump and SEDE

  • LinkTypeId type of link
    1 = Linked (PostId contains a link to RelatedPostId)
    3 = Duplicate (PostId is a duplicate of RelatedPostId)

This query shows the top duplicate targets on Wordpress.se.

select relatedpostid as [Post Link]
     , count(*) [Number of duplicates]
from postlinks 
where linktypeid = 3
group by relatedpostid
order by count(*) desc 

enter image description here

Keep in mind SEDE is updated once a week on Sunday.
Use the fine SEDE Tutorial written by the admirable Monica Cellio.
Say "Hi" in SEDE chat.

1

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .