SQL
AخA
SELECT
REPLACE(p.page_title, "_", " "),
REPLACE(linktarget.lt_title, "_", " "),
REPLACE(REPLACE(REPLACE(GROUP_CONCAT(categorylinks.cl_to), "_", " "),"بوابة_",""),"/مقالات_متعلقة","")
FROM page AS p
JOIN categorylinks ON p.page_id = cl.cl_from
JOIN templatelinks ON p.page_id = templatelinks.tl_from
JOIN linktarget ON templatelinks.tl_target_id = linktarget.lt_id
WHERE p.page_is_redirect = 0
AND p.page_namespace = 0
AND categorylinks.cl_to LIKE "%/مقالات_متعلقة"
AND linktarget.lt_title LIKE "بذرة_%"
GROUP BY p.page_title
limit 100;
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.