trwiki:SM, SL, KM

SQL

USE trwiki_p;
SELECT page_id, page_title, page_len FROM page p
INNER JOIN categorylinks cl ON p.page_id = cl.cl_from
WHERE p.page_namespace = 0 AND 
cl.cl_to="Vikipedi_seçkin_maddeler";
  
SELECT page_id, page_title, page_len FROM page p
INNER JOIN categorylinks cl ON p.page_id = cl.cl_from
WHERE p.page_namespace = 0
AND cl.cl_to="Vikipedi_seçkin_listeler";
  
SELECT DISTINCT article.page_id, article.page_title,article.page_len
FROM page talk
INNER JOIN page article ON
  talk.page_title = article.page_title
INNER JOIN categorylinks ON
  cl_from = talk.page_id
WHERE
  talk.page_namespace = 1 AND
  article.page_namespace = 0 AND
  cl_to = "Vikipedi_kaliteli_maddeler";
SQL

Checking query status...
