ملخصات تعديلاتي

SQL

/*use arwiki_p;
SELECT
  rev_comment,
SUM(CASE WHEN DATE(rev_timestamp) > (NOW() - INTERVAL 2 MONTH) THEN 1 ELSE 0 END) AS recent_editcount,
  COUNT(*)
FROM revision_userindex
WHERE rev_user_text = 'Mr. Ibrahem'
GROUP BY rev_comment
ORDER BY recent_editcount DESC
#ORDER BY COUNT(*) DESC
LIMIT 200;

use enwiki_p;
SELECT
  rev_comment,
SUM(CASE WHEN DATE(rev_timestamp) > (NOW() - INTERVAL 2 MONTH) THEN 1 ELSE 0 END) AS recent_editcount,
  COUNT(*)
FROM revision_userindex
WHERE rev_user_text = 'Mr. Ibrahem'
GROUP BY rev_comment
ORDER BY recent_editcount DESC
#ORDER BY COUNT(*) DESC
LIMIT 200;
*
use wikidatawiki_p;
SELECT
  rev_comment,
SUM(CASE WHEN DATE(rev_timestamp) > (NOW() - INTERVAL 900 MONTH) THEN 1 ELSE 0 END) AS recent_editcount,
  COUNT(*)
FROM revision_userindex
WHERE rev_user_text = 'Mr. Ibrahem'
and rev_comment like "%wbsetlabel-add:1|ar%"
GROUP BY rev_comment
ORDER BY recent_editcount DESC
#ORDER BY COUNT(*) DESC
LIMIT 200;
*/
use wikidatawiki_p;
SELECT rev_comment ,COUNT(*)
   #SUM(CASE WH'EN DATE(rev_timestamp) > (NOW() - INTERVAL 200 MONTH) THEN 1 ELSE 0 END) AS recent_editcount
   #, 
FROM revision_userindex
WHERE rev_user_text = 'Mr.Ibrahembot'
#And rev_comment like   "%wbsetlabel-add:1%"
     #"%العناكب البحرية%"
GROUP BY rev_comment
ORDER BY COUNT(*); #DESC
#ORDER BY COUNT(*) DESC
#LIMIT 250;
SQL

Checking query status...
