Geri alınan onaylı değişiklikler

SQL

SELECT CONCAT("# [[",p.page_title,"]]") AS Sayfa, CONCAT('[[Kullanıcı:',a.actor_name,'|',a.actor_name,']]') AS "Kullanıcı", CONCAT("# [[Özel:KalıcıBağ/",r.rev_id,"]]") AS KB, f.fr_flags AS Flag /*, p.page_len*/ 
FROM revision r, page p, actor a, logging l, flaggedrevs f, user u/*, categorylinks c*/
WHERE DATEDIFF(CURDATE(), f.fr_timestamp) < 15 /*AND 
p.page_title LIKE 'Değişiklik_süzgeci/%'   */ #'Silinmeye_aday_sayfalar/%' 'Şablon_tartışmaları/%' 'Kategori_tartışmaları/%'
AND p.page_namespace = 0 
/*
AND p.page_is_redirect = 0 */
AND r.rev_page = p.page_id
AND r.rev_id = f.fr_rev_id
AND f.fr_user = u.user_id
AND u.user_name = a.actor_name
AND NOT (f.fr_flags LIKE "auto%")
AND ( WHERE f.fr_timestamp<r.rev_timestamp
     AND r.rev_page = p.page_id
     AND r.rev_comment REGEXP "geri")

-- AND a.actor_id=l.log_actor
-- AND l.log_action IN ('approve', 'approve2', 'approve-i', 'approve2-i', 'revert') -- , 'unapprove', 'unapprove2', 'revert') 
-- AND l.log_action IN ('revert') 
-- AND r.rev_actor = 112050 /* 93947 112050 / 316819 16572 */
# LIMIT 10;
#ORDER BY page_len;
-- ORDER BY a.actor_name
LIMIT 10;
SQL

Checking query status...
