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 /*, p.page_len*/ 
FROM revision r, page p, actor a, logging l /*, categorylinks c*/
WHERE DATEDIFF(CURDATE(), r.rev_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 a.actor_id=l.log_actor
AND l.log_action IN ('approve', 'approve2', 'approve-i', 'approve2-i') -- , '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...
