SQL on idwiki side #2

SQL

SELECT
	main.page_title AS title_id,
    REPLACE(ll.ll_title,' ','_') AS title_en,
    main.page_len AS article_length

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_title = talk.page_title

LEFT JOIN langlinks AS ll
ON ll.ll_from = main.page_id
	
WHERE main.page_is_redirect = 0
	AND main.page_namespace = 0
	AND ll.ll_lang = 'en'
    
LIMIT 10
SQL

Checking query status...
