جلب اسماء صفحات ارشيف نقاش المستخدم التي تحتوي علي اسماء غريبة

This query is marked as a draft This query has been published by لوقا.

SQL

select count(pa.page_title) from templatelinks as tl 
join page as pa
on tl.tl_from = pa.page_id  
where tl.tl_from_namespace = 3 and tl.tl_title = "أرشيف_صفحة_رئيسية" and pa.page_title not REGEXP "([\w|\W]*?)\/أرشيف" #or pa.page_title like "%/%"
limit 10

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.

SQL

Checking query status...