Utilisateur:ReyBrujo/Dumps

Une page de Wikipédia, l'encyclopédie libre.
Sauter à la navigation Sauter à la recherche
Dumps

April 17, 2007[modifier | modifier le code]

External link dumps[modifier | modifier le code]

Dump table Hits
Articles with more than 50 external links 315
SELECT COUNT(el_from) AS total, el_from, page_title
FROM externallinks, page
WHERE externallinks.el_from = page_id AND page_is_redirect = 0 AND page_namespace = 0
GROUP BY el_from
ORDER BY total DESC;

External link ranking[modifier | modifier le code]

Dump table Hits
Sites linked more than 100 times 361
Sites linked between 50 and 99 times 403
SELECT COUNT(el_to) AS total, SUBSTRING_INDEX(el_to, '/', 3) AS search
FROM externallinks, page
WHERE page_id = el_from AND page_namespace = 0
GROUP BY search
ORDER BY total DESC;

Additional information[modifier | modifier le code]

Some more information about this dump:

  • 477420 articles that are in the main space and not redirects
  • 710265 articles and redirects in the main space
  • 1191619 pages in all namespaces
  • 258327 redirects in all namespaces
  • 1743430 external links in every namespace
  • 984079 external links in the main space

Very probable spambot pages[modifier | modifier le code]

If index.php is found in a page title, it is very likely the article talk page has been created by a spambot. These pages should be deleted and protected if possible.

Article ID Article
1472439 Talk:7z/w/index.php?title=7z/w/index.php
1342973 User:Pelote de laine/index.php

Possible spambot pages[modifier | modifier le code]

Possible pages created by spambots ending with /.

Article ID Article
268833 /
374605 Cap-Chat/
1396313 Fr.wikipedia.org/wiki/Utilisateur:Jborme/Emploi des variantes linguistiques du français (projet de sondage)
1295329 [Utilisateur:Pantoine/Archive2]
693828 User:BM/
139933 User:Bena/test/
643848 User:Cdub/ /
643851 User:Cdub/ / /
643853 User:Cdub/ / / /
1200547 User:Chico/tests/
1321243 User:Chico75/tests/
1476855 User:Fox McCloud/A Lazarus Taxon/
1476856 User:Fox McCloud/Bienvenue/
1476857 User:Fox McCloud/Biographie Sonic Youth/
1476858 User:Fox McCloud/Boites utilisateurs/
1424819 User:Le.iota/Brouillons/
772714 User:Liquid-aim-bot/
677890 User:Liquid 2003/
854004 User:Lorenzoalali/
367955 User:MG/
625423 User:MG/Accueil/
625402 User:MG/Accueil2/
99301 User:MK/
1290062 User:Meodudlye/CFHT/
1256353 User:Oliv21/projet/brouillons/
1281958 User:Olivierschimpf/projet/brouillons/
971781 User:Smily/
394503 User:Soufron/berder/
394544 User:Soufron/berder/bourgine/
402327 User:Soufron/netvibes/
396365 User:Soufron/sartor/
460984 User:Soufron/sparkling/
688922 User:Soufron/wikilab/
1130046 User:SyrFox/A Lazarus Taxon/
1131479 User:SyrFox/Bienvenue/
1133043 User:SyrFox/Biographie Sonic Youth/
1131630 User:SyrFox/Boites utilisateurs/
559894 User:Wart Dark/Musée/Éditeurs problématiques/
646554 User:Wikipedius/
162405 User talk:DIG/DiG/
630221 User talk:GillesC/Catégories créées/
854013 User talk:Lorenzoalali/
791206 User talk:Philippe Kurlapski/2006/
1424365 Wikipedia:Lumière sur/
622184 Wikipedia:Pages soupçonnées de violation de copyright/Within Temptation//* Biographie du groupe */
543266 Wikipedia:Pages à supprimer/
441049 Discuter:Uranium appauvri http://fr.wikipedia.org/wiki/Uranium appauvri/Suppression
949127 Wikipedia:Sélection/
324017 Template:4x4 type square/
590796 Template:ARTICLESPACE/
503693 Template:Portail Humanitaire/
SELECT page_id, page_title, page_namespace
FROM page
WHERE page_title LIKE '%index.php%' OR page_title LIKE '%/wiki/%' OR page_title LIKE '%/w/%' OR page_title LIKE '%/';
Archive

Dump analysis archive[modifier | modifier le code]

This is the archive of dump analysis.