SQL
x
SELECT CONCAT("تصنيف:", REPLACE(p.page_title, "_", " ")) AS title
FROM page AS p
JOIN categorylinks ON p.page_title = categorylinks.cl_to
WHERE p.page_is_redirect = 0
AND p.page_namespace = 14
AND (p.page_title LIKE "%بيروفي%" OR p.page_title LIKE "%كونغولي%" OR p.page_title LIKE "%توغولي%")
GROUP BY p.page_title
HAVING COUNT(DISTINCT categorylinks.cl_from) > 1;
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.