صفحات مستخدمين أنشئت خلال اربع شهور الماضية تحتوي علي روابط خارجية

SQL

SELECT
  CONCAT('مستخدم:', a.page_title) AS "الصفحة"

FROM revision AS r
INNER JOIN actor ON actor.actor_id = r.rev_actor
INNER JOIN page AS a ON a.page_id = r.rev_page AND a.page_namespace = 2
INNER JOIN externallinks ON a.page_id = externallinks.el_from
WHERE r.rev_parent_id = 0
AND r.rev_timestamp > DATE_SUB(NOW(), INTERVAL 4 MONTH)
AND a.page_title NOT LIKE "%/%"
AND externallinks.el_to_domain_index NOT LIKE "%wmflabs%"
AND externallinks.el_to_domain_index NOT LIKE "%wikipedia%"
AND externallinks.el_to_domain_index NOT LIKE "%toolforge%"
AND externallinks.el_to_domain_index NOT LIKE "%mediawiki%"
AND externallinks.el_to_domain_index NOT LIKE "%wmcloud%"
AND externallinks.el_to_domain_index NOT LIKE "%wikimedia%"
AND externallinks.el_to_domain_index NOT LIKE "%wikidata%"
GROUP BY a.page_id
ORDER BY r.rev_timestamp DESC;

SQL

Checking query status...