trwiki:SM, SL, KM in Vikiproje Bilim Tarihi

SQL

USE trwiki_p;
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
  article.page_id IN (SELECT page_id 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") AND
  cl_to  LIKE "Vikiproje_Bilim_tarihi%";
  
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
  article.page_id IN (SELECT page_id 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") AND
  cl_to  LIKE "Vikiproje_Bilim_tarihi%";
SQL

Checking query status...
