but it would be better if you written a script instead of checking it manually.

I actually tried to get the posts writing this query but it didn't give me the accurate results.

SELECT
DISTINCT.comments.author,
COUNT(comments.permlink) AS [LINK],
SUM(comments.total_payout_value) AS [REWARDS],
COUNT(txvotes.voter) AS [BOT UPVOTES]
FROM comments
JOIN txvotes ON comments.id = txvotes.id
WHERE txvotes.voter IN ('booster', 'upme', 'upmewhale', 'boomerang', 'pushup', 'rocky1', 'postpromoter', 'mercurybot', 'sneaky-ninja', 'promobot', 'brupvoter', 'smartsteem', 'appreciator', 'therising', 'emperorofnaps', 'oceanwhale', 'inciter', 'buildawhale', 'estabond', 'jerrybanfield', 'tipu', 'speedvoter', 'bumper', 'lays', 'treeplanter', 'thundercurator', 'drotto', 'flagship', 'siditech', 'promotedpost', 'byresteem', 'moonbot', 'minnowpond', 'postdoctor', 'steemvote', 'withsmn', 'hottopic', 'echowhale', 'okankarol', 'danzy', 'hugewhale', 'upvotewhale', 'earthnation-bot', 'morwhale', 'coolbot', 'big-whale', 'friends-bot', 'steemlike', 'astrobot', 'microbot', 'queqtra', 'tisko', 'bidseption', 'talhadogan', 'postresteem', 'refresh', 'steemthat', 'blockgators', 'ottoman', 'cleansingpoetry', 'resteemyou', 'bestvote', 'resteemr', 'zerotoherobot', 'schoolofminnows', 'superbot', 'crystalhuman', 'growingpower', 'alphaprime', 'earnmoresteem', 'giftbox', 'highvote', 'jeryalex', 'fresteem', 'otobot', 'oceansbot', 'red-rose', 'botcoin', 'drewardsresteem', 'bidbot', 'gangvote', 'thehumanbot', 'minnowbooster')
AND created >= CONVERT(DATE,'2018-05-01') and created < CONVERT(DATE,'2018-06-01')
AND total_payout_value > 100
GROUP BY comments.author

Not sure what I am doing wrong here, may be you can guide me.