SQL
AخA
USE trwiki_p;
SELECT CONCAT("#[[",REPLACE(pl_title,"_"," "),"]]")
FROM pagelinks, page_assessments
WHERE pl_from = pa_page_id
AND pa_project_id=78
/*AND pl_from_namespace = 0*/
AND pl_namespace = 0
AND pl_title LIKE "%tarihi"
AND NOT EXISTS
(SELECT p1.page_title FROM page p1
WHERE p1.page_title = pl_title
AND pl_namespace = 0
AND p1.page_namespace = 0)
GROUP BY pl_title
ORDER BY pl_title ASC;
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.