trwiki:Pages in Vikiproje Bilim Tarihi in draft categories

SQL

USE trwiki_p;
SELECT DISTINCT article.page_id, article.page_title,article.page_len, (CASE WHEN articlecat.cl_to="Bilim_tarihi_taslakları" THEN "True" WHEN articlecat.cl_to LIKE "%taslak%" THEN "False" END)
FROM page talk
INNER JOIN page article ON
  talk.page_title = article.page_title
INNER JOIN categorylinks talkcat ON
  talkcat.cl_from = talk.page_id AND talk.page_namespace = 1 AND talkcat.cl_to LIKE "Vikiproje_Bilim_tarihi%" 
INNER JOIN categorylinks articlecat ON
  articlecat.cl_from = article.page_id AND article.page_namespace = 0 AND articlecat.cl_to LIKE "%taslak%";

SQL

Checking query status...