Required: One SEDE wizard (for a possibly impossible query)

by Whosaysbigcatsdon'twearhats   Last Updated January 13, 2018 17:24 PM

Disclaimer

I don't know how to write SEDE queries, so I'm afraid I have to ask you to do it for me. I don't even know what is possible and what is not, so please forgive my ignorance.

The possibly impossible query

I would like a query to find all questions which were closed as duplicate, matching some important conditions:

  • it must have been closed as duplicate while the score was not negative
  • it must have been closed as duplicate while the score was below 3
  • it now has a negative score
  • it is less than a year old

I don't know it SEDE has data showing the score of a duplicate at the time of closure, so please bear with me if my request is pie-chasing-moonbeams-across-the-sky.

Alternatively

If this is not possible, please rather write a query to list all questions

  • longer than 300 words
  • answered
  • closed as duplicate
  • with a negative score

I hope this will not be too much of a pain. I actually do have a good reason to require this data, which I may disclose sometime soon, depending on what the data suggests. Thank you for your patience.



Related Questions




Do people downvote duplicates?

Updated July 07, 2015 12:49 PM