Untitled query #51396

Fork of Autopatrolled actifs les 30 derniers jours by Pa2chant.bis

This query is marked as a draft This query has been published by Lofhi.

SQL

USE frwiki_p;
SELECT distinct(u.user_name)
FROM 
recentchanges AS rc
INNER JOIN `actor` AS a ON rc.rc_actor = a.actor_id
INNER JOIN `user` AS u ON a.actor_user = u.user_id
where rc.rc_actor IN
(SELECT distinct user_id 
FROM user
WHERE user_editcount >= 500
AND (DATEDIFF(NOW(),user_registration)) >= 90)

and rc.rc_timestamp >= DATE_FORMAT(NOW() - INTERVAL 30 DAY,'%Y%m%d%H%i%s') 
    AND rc.rc_type in (0,1);
    
 SELECT distinct user_id 
FROM user
WHERE user_editcount >= 500
AND (DATEDIFF(NOW(),user_registration)) >= 90);

SQL

Checking query status...