بيانات تدريب ويكي أخبار

SQL

SELECT
    REPLACE(p.page_title, "_", " ") AS title,
    REPLACE(linktarget.lt_title, "_", " ") AS type
FROM page AS p
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 linktarget.lt_title IN (
SELECT template.page_title FROM page AS template
JOIN categorylinks ON template.page_id = categorylinks.cl_from
WHERE cl_to = "قوالب_عرض_الأخبار_حسب_الموضوع"
AND template.page_is_redirect = 0
AND template.page_namespace = 10
)

SQL

Checking query status...