SQL on idwiki side #2

SQL

SELECT
	main.page_title AS title_id,
    ll.ll_title AS title_en,
    #cl_prio.cl_to AS priority,
    #cl_qual.cl_to AS quality,
	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
    # 		AND t_pl.pl_from_namespace = 0
    # 	WHERE t_lt.lt_title = main.page_title
    #) 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
    # 		AND t_pl.pl_from_namespace = 0
    # 	WHERE t_pl.pl_from = main.page_id
    #) AS total_outlink

FROM page AS talk

# inner join to cut table size
# focus to all possible priority
INNER JOIN categorylinks AS cl_prio ON
	cl_prio.cl_from = talk.page_id
    AND cl_prio.cl_to IN (
        'Artikel_matematika_sangat_penting',
        'Artikel_matematika_penting',
        'Artikel_matematika_cukup_penting',
        'Artikel_matematika_kurang_penting',
	    'Artikel_matematika_NA')
# focus to all possible quality for an article in main namespace
INNER JOIN categorylinks AS cl_qual ON
	cl_qual.cl_from = talk.page_id
    AND cl_qual.cl_to IN (
        'Artikel_matematika_kelas_AP',
        'Artikel_matematika_kelas_MP',
        'Artikel_matematika_kelas_AB',
        'Artikel_matematika_kelas_B',
        'Artikel_matematika_kelas_C',
        'Artikel_matematika_kelas_awal',
        'Artikel_matematika_kelas_rintisan',
        'Artikel_matematika_kelas_daftar',
        'Artikel_matematika_kelas_disambig',
    	'Artikel_matematika_kelas_pengalihan',
    	'Artikel_matematika_belum_dinilai')

# join to get the main article's ID
#INNER JOIN page AS main ON
#	main.page_namespace = 0
#    AND main.page_title = talk.page_title

# join because i need this data to help idwiki. left join is
# intentional, to get empty result if page isn't created yet 
LEFT JOIN langlinks AS ll ON
	 ll.ll_from = main.page_id
    AND ll.ll_lang = 'en'
SQL

Checking query status...
