trwiki:Pages 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
  cl_to  LIKE "Vikiproje_Bilim_tarihi%";
 
SELECT CONCAT("[[",trp.page_title,"| ]]") FROM trwiki_p.page_assessments AS trpa
                   INNER JOIN trwiki_p.page trp ON trpa.pa_page_id=trp.page_id AND trpa.pa_project_id=78
                   WHERE trp.page_namespace = 0;

SQL

Checking query status...