Untitled query #60012

SQL

SELECT 
	COUNT(ptwiki_p.recentchanges.rc_id) AS num_contribs, ptwiki_p.actor.actor_name 
    from ptwiki_p.recentchanges, ptwiki_p.actor
WHERE
	rc_logid = 0 AND rc_actor != 0 and rc_type != 5
    and rc_bot = 0 and recentchanges.rc_actor = actor.actor_id
    and ptwiki_p.actor.actor_name = "201.76.121.159"
    --  and rc_user_text != "Salebot"
    --  and rc_user_text != "MediaWiki message delivery"
    --  and rc_user_text != "CommonsDelinker"

GROUP BY rc_actor
-- Having COUNT(1) > 4
ORDER BY num_contribs DESC
limit 500;
SQL

Checking query status...
