Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
البربوشي
.
صفحات مستخدمين بها أرقام هواتف
Toggle Highlighting
SQL
SELECT CONCAT('# [[مستخدم:', a.log_actor, ']]') AS "الصفحة", actor.actor_name AS "منشئ الصفحة", r.rev_timestamp AS "تاريخ الإنشاء", a.page_len AS "حجم الصفحة", el_to_domain_index 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 12 MONTH) AND a.log_actor 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%" AND ( a.page_content LIKE "%00213%" OR a.page_content LIKE "%\+213%" -- الجزائر OR a.page_content LIKE "%00966%" OR a.page_content LIKE "%\+966%" -- السعودية OR a.page_content LIKE "%00962%" OR a.page_content LIKE "%\+962%" -- الأردن OR a.page_content LIKE "%0020%" OR a.page_content LIKE "%\+20%" -- مصر OR a.page_content LIKE "%021%" OR a.page_content LIKE "%\+21%" -- المغرب OR a.page_content LIKE "%00964%" OR a.page_content LIKE "%\+964%" -- العراق OR a.page_content LIKE "%024%" OR a.page_content LIKE "%\+24%" -- السودان OR a.page_content LIKE "%00965%" OR a.page_content LIKE "%\+965%" -- الكويت OR a.page_content LIKE "%00974%" OR a.page_content LIKE "%\+974%" -- قطر OR a.page_content LIKE "%00216%" OR a.page_content LIKE "%\+216%" -- تونس OR a.page_content LIKE "%00222%" OR a.page_content LIKE "%\+222%" -- موريتانيا OR a.log_title LIKE "%00213%" OR a.log_title LIKE "%\+213%" -- الجزائر OR a.log_title LIKE "%00966%" OR a.log_title LIKE "%\+966%" -- السعودية OR a.log_title LIKE "%00962%" OR a.log_title LIKE "%\+962%" -- الأردن OR a.log_title LIKE "%0020%" OR a.log_title LIKE "%\+20%" -- مصر OR a.log_title LIKE "%021%" OR a.log_title LIKE "%\+21%" -- المغرب OR a.log_title LIKE "%00964%" OR a.log_title LIKE "%\+964%" -- العراق OR a.log_title LIKE "%024%" OR a.log_title LIKE "%\+24%" -- السودان OR a.log_title LIKE "%00965%" OR a.log_title LIKE "%\+965%" -- الكويت OR a.log_title LIKE "%00974%" OR a.log_title LIKE "%\+974%" -- قطر OR a.log_title LIKE "%00216%" OR a.log_title LIKE "%\+216%" -- تونس OR a.log_title LIKE "%00222%" OR a.log_title LIKE "%\+222%" -- موريتانيا ) GROUP BY a.log_actor ORDER BY r.rev_timestamp DESC;
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...