عينات تدريب

SQL

SELECT 
    REPLACE(p.page_title, "_", " ") AS title,
    REPLACE(linktarget.lt_title, "_", " ") AS stub,
    REPLACE(REPLACE(REPLACE(GROUP_CONCAT(categorylinks.cl_to), "_", " "),"بوابة ",""),"/مقالات متعلقة","") AS categorys
FROM page AS p
JOIN categorylinks ON p.page_id = categorylinks.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 "بذرة_%"
AND categorylinks.cl_to IN (
SELECT page.page_title 
FROM page
WHERE page.page_is_redirect = 0
AND page.page_namespace = 14
)
AND linktarget.lt_title IN (
SELECT page.page_title 
FROM page
WHERE page.page_is_redirect = 0
AND page.page_namespace = 10
)
GROUP BY p.page_title
SQL

Checking query status...
