SQL on idwiki side #2

SQL

SELECT
    CASE page_namespace
    	WHEN 3 THEN 'Pengguna'
        WHEN 5 THEN 'Wikipedia'
        WHEN 7 THEN 'Berkas'
        WHEN 9 THEN 'MediaWiki'
        WHEN 11 THEN 'Templat'
        WHEN 13 THEN 'Bantuan'
        WHEN 15 THEN 'Kategori'
        WHEN 101 THEN 'Portal'
        ELSE page_namespace
	END || ':' || page_title AS title

FROM page

INNER JOIN categorylinks AS cl
ON cl.cl_from = page.page_id

WHERE cl.cl_to IN (
  	'Artikel_matematika_kelas_proyek',
  	'Artikel_matematika_kelas_berkas',
	'Artikel_matematika_kelas_templat',
  	'Artikel_matematika_kelas_kategori',
  	'Artikel_matematika_kelas_portal'
)
SQL

Checking query status...
