ويكيبيديا:طلبات توزيع بوابة

SQL

# * [[:قالب:اسم القالب]]>[[:بوابة:اسم البوابة المراد إضافتها]]
# 4143975 is page id (from)
# 8983932 is Portal id that will add
/*
select p1.page_id,p1.page_title from pagelinks
inner join page on page.page_title = pagelinks.pl_title 
where pl_from in (4143975)  and pl_namespace = 0  and pl_from_namespace= 10 and page.page_namespace = 0
AND (p1.page_id, p1.page_title) NOT IN (
  select p1.page_id,p1.page_title from pagelinks 
  inner join page p1 on p1.page_id = pagelinks.pl_from 
  where pl_from_namespace = 0 and pl_namespace = 100 and pl_title in (select page_title from page where page_id in (8983932))
)

*/

#* [[:تصنيف:اسم التصنيف]]>[[:بوابة:اسم البوابة المراد إضافتها]]
# 3318063 is page id (from)
# 8983932 is Portal id that will add

select  p1.page_id,p1.page_title from categorylinks 
inner join page p1 on p1.page_id = categorylinks.cl_from
where cl_to in (select page_title from page where page_id in (3318063)) and cl_type in ("page") and p1.page_namespace = 0
AND (p1.page_id, p1.page_title) NOT IN (
  select p1.page_id,p1.page_title from pagelinks 
  inner join page p1 on p1.page_id = pagelinks.pl_from 
  where pl_from_namespace = 0 and pl_namespace = 100 and pl_title in (select page_title from page where page_id in (8983932))
)

# * [[:بوابة:اسم البوابة]]>[[:بوابة:اسم البوابة المراد إضافتها]]
# 32288 is page id (from)
# 8983932 is Portal id that will add
/*
select p1.page_id,p1.page_title from pagelinks 
inner join page p1 on p1.page_id = pagelinks.pl_from 
where pl_from_namespace = 0 and pl_namespace = 100 and pl_title in (select page_title from page where page_id in (32288))
AND (p1.page_id, p1.page_title) NOT IN (
  select p1.page_id,p1.page_title from pagelinks 
  inner join page p1 on p1.page_id = pagelinks.pl_from 
  where pl_from_namespace = 0 and pl_namespace = 100 and pl_title in (select page_title from page where page_id in (8983932))
)
*/
SQL

Checking query status...
