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.
If this is not possible, please rather write a query to list all questions
- longer than 300 words
- 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.