SQL on idwiki side #1

SQL

SELECT
	main.page_title AS title_en,
    ll.ll_title AS title_id,
    cl.cl_to AS priority,
	main.page_is_redirect AS is_redirect,
    main.page_len AS article_length,
    talk.page_len AS talk_length,  #! excluding subpage(s)
    # main.page_touched AS last_touched	 #! not informative... i think
    (SELECT
     	# count unique(?) language of this article
     	COUNT(t_ll.ll_lang)
     	FROM langlinks AS t_ll
     	WHERE t_ll.ll_from = main.page_id
   	) AS total_lang,
    (SELECT 
	    # count unique(?) articles in main namespace, that linked to this article 
     	COUNT(t_pl.pl_from)
     	FROM pagelinks AS t_pl
     	INNER JOIN linktarget AS t_lt ON t_lt.lt_id = t_pl.pl_target_id AND t_lt.lt_namespace = 0
     	WHERE t_lt.lt_title = main.page_title t_pl.lt_namespace = 0
    ) AS total_inlink,
    (SELECT
     	# count unique(?) article in main namespace, that linked from this article
     	COUNT(t_pl.pl_target_id)
     	FROM pagelinks AS t_pl
     	INNER JOIN linktarget AS t_lt ON t_lt.lt_id = t_pl.pl_target_id AND t_lt.lt_namespace = 0
     	WHERE t_pl.pl_from = main.page_id AND t_pl.lt_namespace = 0
    ) AS total_outlink

FROM page AS talk
INNER JOIN categorylinks AS cl ON cl.cl_from = talk.page_id AND cl.cl_to IN (
  	'Top-priority_mathematics_articles',
	'High-priority_mathematics_articles',
    'Mid-priority_mathematics_articles')
	#'Low-priority_mathematics_articles'
    #'NA-priority_mathematics_articles',
    #'Unknown-priority_mathematics_articles')
#! todo: is it possible to combine this with its article quality?

INNER JOIN page AS main ON main.page_namespace = 0 AND main.page_title = talk.page_title
INNER JOIN langlinks AS ll ON ll.ll_from = main.page_id AND ll.ll_lang = 'id'


LIMIT 10;
SQL

Checking query status...
