SQL
x
/*
select * from page
where page_title like "صندوق_مستخدم%"
and page_title like "%/%"
and page_is_redirect = 0
and page_namespace = 2
*/
/*
select templatelinks.*,linktarget.*,page1.page_title from templatelinks
inner join linktarget on linktarget.lt_id = templatelinks.tl_target_id
inner join page page1 on page1.page_id = templatelinks.tl_from
where lt_title in ("مستخدم","صندوق_مستخدم_2")
and templatelinks.tl_from_namespace = 2 and linktarget.lt_namespace = 10
*/
select distinct concat("[[:مستخدم:",page_title,"]]") from page
where page_title like "صندوق_مستخدم%"
and page_title like "%/%"
and page_is_redirect = 0
and page_namespace = 2
and page_title not in (
select page1.page_title from templatelinks
inner join linktarget on linktarget.lt_id = templatelinks.tl_target_id
inner join page page1 on page1.page_id = templatelinks.tl_from
where lt_title in (
"مستخدم",
"صندوق_مستخدم_2",
# for قالب:مستخدم
"صندوق_مستخدم",
"Userbox"
# for صندوق_مستخدم_2
"Userbox-2"
)
and templatelinks.tl_from_namespace = 2 and linktarget.lt_namespace = 10
)
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.