SQL
AخA
USE trwiki_p;
SELECT DISTINCT page_id, page_title, page_len FROM page p
INNER JOIN categorylinks cl ON p.page_id = cl.cl_from
WHERE p.page_namespace = 1 AND
cl.cl_to LIKE "Vikiproje_Bilim tarihi%değerlendirilmemiş-sınıf_sayfalar" AND
page_id IN (SELECT page_id FROM page p
INNER JOIN categorylinks cl ON p.page_id = cl.cl_from
WHERE p.page_namespace = 1 AND
cl.cl_to LIKE "Vikiproje_%C-sınıf_sayfalar")
GROUP BY page_id;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.