Gebruiker:Valhallasw/OrphanOverleg

Uit Wikipedia, de vrije encyclopedie

results = Q.do("select p2.page_title, p2.page_id from nlwiki_p.page as p1 right join nlwiki_p.page as p2 on p1.page_title = p2.page_title and p1.page_namespace=0 where p2.page_namespace=1 and p1.page_title IS NULL;") metslash = "" for page in results: 

 if (page['page_title'].rfind('/') > -1):
   if (len(metslash) != 0):
     metslash += " or cl_from="
   metslash += str(page['page_id'])


for page in metslash: 

 heeftcat = Q.do("select * from nlwiki_p.categorylinks where cl_from=" + str(page['page_id']) + " and cl_to='Wikipedia:Archief';")

< select p2.page_title, p2.page_namespace, log_comment from page as p1 right join page as p2 on p1.page_title = p2.page_title and p1.page_namespace=0 left join logging on log_title=p2.page_title where p2.page_namespace=1 and p1.page_title IS NULL and log_action='delete'; >


mysql> select p2.page_title, p2.page_namespace from page as p1 right join page as p2 on p1.page_title = p2.page_title and p1.page_namespace=0 where p2.page_namespace=1 and p1.page_title IS NULL;

ZONDER SLASH +-----------------------------------------------------------------------+----------------+ | page_title | page_namespace | +-----------------------------------------------------------------------+----------------+

+-----------------------------------------------------------------------+----------------+ 532 rows in set (14.79 sec)

MET SLASH


snel gegenereerd uit de directe mysqloutput door s/ / / s/^| \(.*\) | 1 |/Overleg:\1/ er bestaan er een paar niet doordat textpad een UTF-8 snapt. Pythonversie zal uitkomst brengen ;) valhallasw 12 nov 2006 23:18 (CET)

Overgenomen van "https://nl.wikipedia.org/w/index.php?title=Gebruiker:Valhallasw/OrphanOverleg&oldid=5819746"