#In titles.csv

#eswiki,3677679,0,31858,474795

#With SQL queries

#eswiki,1878028,0,9858,543132

​

USE hewiki_p;

SELECT COUNT(*) AS Articles

FROM  page

WHERE page_namespace = 0

AND   page_is_redirect = 0;

​

SELECT COUNT(img_name) AS Files

FROM image;

​

SELECT

 count(distinct lt.lt_title) AS templates

FROM templatelinks AS t

INNER JOIN linktarget AS lt ON lt.lt_id = t.tl_target_id

LEFT JOIN page AS p ON p.page_namespace = lt.lt_namespace AND p.page_title = lt.lt_title

INNER JOIN page AS p2 ON t.tl_from = p2.page_id

WHERE p.page_is_redirect = 0 

  AND lt.lt_namespace = 10

  AND p2.page_namespace = 0;

​

​

SELECT

    count(cat_id) as  categories

FROM category ;