« first day (1274 days earlier)      last day (818 days later) » 

Martin
Martin
3:36 AM
@Fmbalbuena Once you make v.PostId=p.Id it is not difficult to get the numbers of upvotes/downvotes: Upvotes and Downvotes for posts.
Once you have that, you can add some restrictions, like here: Upvotes and Downvotes for posts - restriction on score.
If you set both max and min to zero, I guess it could be what you wanted: data.stackexchange.com/mathoverflow/query/1545142/…
I ran the above examples on MathOverflow. (For testing queries, I usually avoid the biggest sites - some queries take a long time to run there.)
 
 
3 hours later…
rene
rene
6:55 AM
 
 
4 hours later…
Fmbalbuena
Fmbalbuena
11:20 AM
@Martin Then how to check every site
 
 
7 hours later…
Martin
Martin
6:45 PM
@Fmbalbuena Sorry, I tried a bit but I failed.
I tried to use this template - but I did not succeed.
Dec 20 '19 at 14:42, by rene
Nope. Don't worry, it is not much work. most of the query comes from my default template I have for that: https://data.stackexchange.com/stackoverflow/query/1004129/multi-db-template-with-hostname
 

« first day (1274 days earlier)      last day (818 days later) »