All-in-One WME titles.csv

SQL

USE ckbwiktionary_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(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 ;
SQL

Checking query status...
