عينات تدريب

SQL

SELECT 
    REPLACE(p.page_title, "_", " "), AS page_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 "بذرة_%"
GROUP BY p.page_title
limit 100;
SQL

Checking query status...
