Geri alınan onaylı değişiklikler

SQL

SELECT DISTINCT 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, ct.ct_tag_id AS Tag /*, p.page_len*/ 
FROM revision r, page p, actor a, logging l, flaggedrevs f, user u, change_tag ct, recentchanges rc, change_tag_def ctd, comment co/*, 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 ct.ct_rc_id = rc.rc_id
AND ctd.ctd_id = ct.ct_tag_id
AND r.rev_page = p.page_id
AND r.rev_id = f.fr_rev_id
AND f.fr_user = u.user_id
AND ct.ct_rev_id = r.rev_id 
AND u.user_name = a.actor_name
/*AND (ct.ct_tag_id = 109 OR ct.ct_tag_id = 116 OR ct.ct_tag_id = 12 OR ct.ct_tag_id = 4)
-- AND r.rev_comment_id = c.comment_id
/*
AND rc.rc_source = 'mw.edit'
AND ctd.ctd_name IN ( 'mw-reverted'
  				 'mw-reverted', 
                 'mw-manual-revert', 
                 'mw-undo'
                )
*/
AND NOT (f.fr_flags LIKE "auto%")
AND r.rev_comment_id = co.comment_id
AND co.comment_text REGEXP "(alındı)" 
-- 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...
