RE: Leeching Arseholes!

Here's an old query I used to use, you can tinker with the values to change things. It gets all posts pending rewards, that are undervalued with long content, low rep, filters out non English (or tries)! and does not include anything flagged with @spaminator.

SELECT
    author, A.reputation_ui,'https://peakd.com'+ url, 
    left(body,500),
    pending_payout_value, 
    C.created, 
    LEN(body) as CharacterCount
FROM 
    Comments C
INNER JOIN Accounts A on C.author=A.name
WHERE
(
    NOT JSON_QUERY(C.json_metadata,'$.tags') LIKE('%"cn"%') 
    AND NOT JSON_QUERY(C.json_metadata,'$.tags') LIKE('%"ru"%')
    AND NOT JSON_QUERY(C.json_metadata,'$.tags') LIKE('%"kr"%') 
AND NOT JSON_QUERY(C.json_metadata,'$.tags') LIKE('%"es"%')
)
AND NOT category IN ('hive','porn')
AND depth = 0
AND NOT author IN ('slobberchops')
AND NOT active_votes LIKE('%"spaminator"%')
AND datediff(minute, C.created, GETDATE()) < 60*4
AND A.reputation_ui BETWEEN 25 AND 65
AND pending_payout_value > 0.0100
AND pending_payout_value < 3.0000 
AND LEN(body) > 4000
ORDER BY created desc