General stats arwiki 2017

SQL

use arwiki_p;


/*select log_action, COUNT(*) 
from logging 
where log_timestamp BETWEEN 20170101000000 AND 20171231235959 
group by log_action;
*/


SELECT  page_namespace , COUNT(*) AS "عدد المقالات"
FROM revision r
join page p on p.page_id=r.rev_page
WHERE p.page_is_redirect=0 and r.rev_timestamp between 20170101000000 and 20171231235959 and r.rev_parent_id=0
group by page_namespace
ORDER BY COUNT(*) DESC;

SELECT COUNT(user_name)
FROM user 
WHERE user_registration BETWEEN 20170101000000 AND 20170101000000;
SQL

Checking query status...
