Wikipédia:Manutenção/Estatísticas/Arquivo

Ferramentas

• Dump
• Wikisign

Outras Estatísticas

• Lixos
• Administrators of various Wikipedias (meta)

---

• Artigo com maior número de redireccionamentos: Fluoxetina (48)

Mapa

Data	Artigos	Sem saída	Órfãos	Vazios	Sem categoria	Procurados	Lixo	Tradução	Esboço	Sem interwikis
02-Out-2004	22713	530	475	38	5950	51506	649	356	2665	16589
10-Out-2004	23315	551	484	37	5643	52642	667	347	2739	16973
24-Out-2004	23885	591	402	45	5525	56484	717	337	2886	17155
31-Out-2004	24255	566	393	46	5638	57518	782	328	3010	17397
08-Nov-2004	24898	536	397	40	4445	58419	804	324	3245	17657
16-Nov-2004	25492	455	405	41	4456	60605	883	323	3448	17734
27-Nov-2004	26236	446	681	36	3655	62400	1050	313	3720	18132
09-Fev-2005				3			1257	331	6128*	19331
09-Mar-2005	33918?	198	318	5	2440	91163?	1271	296	6244*	21416
06-Abr-2005	36487?	366	335	6		100537?	712	294	7521*	21361
16-Mai-2005	50089?	1023	338	13	1894	111848	788	289	12062*	23984
25-Jun-2005	56137?	1149	718	28	1703	127789	1038	313	21584*	26111
17-Jul-2005	?
	?

^* Inclusão dos Artigos mínimos

Queries usadas para obter as

Número de Artigos

SELECT COUNT(DISTINCT a.cur_id)
  FROM cur a 
    LEFT JOIN links ON a.cur_id=l_from
    LEFT JOIN cur b ON l_to=b.cur_id
  WHERE a.cur_namespace=0
    AND NOT a.cur_is_redirect
    AND b.cur_namespace=0;

Artigos sem saída

SELECT COUNT(cur_title) 
  FROM cur LEFT JOIN links ON cur_id=l_from 
  WHERE l_from IS NULL
    AND cur_namespace=0 
    AND length(cur_text)>0;
    AND NOT cur_is_redirect;

Artigos órfãos

SELECT COUNT(cur_title)
  FROM cur LEFT JOIN links ON cur_id=l_to
  WHERE l_to IS NULL
    AND cur_namespace=2
    AND NOT cur_is_redirect;

Artigos vazios

SELECT COUNT(cur_title)
  FROM cur 
  WHERE cur_namespace=0 
    AND LENGTH(cur_text)=0;

Artigos sem categoria

SELECT COUNT(cur_title) 
  FROM cur LEFT JOIN categorylinks ON cur_id=cl_from 
  WHERE cl_from IS NULL
    AND cur_namespace=0 
    AND LENGTH(cur_text)>0
    AND NOT cur_is_redirect;

Artigos em falta

SELECT COUNT(DISTINCT bl_to)
  FROM brokenlinks LEFT JOIN cur ON bl_from=cur_id
  WHERE cur_namespace=0
    AND (bl_to NOT LIKE '%:%');

Artigos com lixo

SELECT COUNT(cur_id)
  FROM cur
  WHERE cur_namespace=0 
    AND (cur_text LIKE '%lixo}}%' 
    OR cur_text LIKE '%impróprio}}%');

Artigos em tradução

SELECT COUNT(cur_title)
  FROM cur
  WHERE cur_namespace=0
    AND (cur_text LIKE '%{{emtradu%' 
      OR cur_text LIKE '%{{emtradu%');

Artigos em esboço

SELECT COUNT(cur_title)
  FROM cur 
  WHERE cur_namespace=0 
    AND (cur_text LIKE '%{{stub}}%' 
      OR cur_text LIKE '%{{stub}}%' 
      OR cur_text LIKE '%{{esboço%' 
      OR cur_text LIKE '%{{esboço%'
      OR cur_text LIKE '%{{mínimo%'
      OR cur_text LIKE '%{{_rtigo mínimo%');

Artigos sem links para outras wikipédias

SELECT COUNT(cur_title) 
  FROM cur 
  WHERE cur_namespace=0 
    AND NOT cur_is_redirect 
    AND LENGTH(cur_text)>0 
    AND cur_text NOT LIKE "%[[__:%"
    AND cur_text NOT LIKE "%[[___:%"
    AND cur_title NOT LIKE '%{{desambiguação}}%'
    AND cur_title NOT LIKE '%{{desambiguação}}%';

Outras queries

Especial:Deadendpages

SELECT concat("* [[",cur_title, "]]")
FROM cur LEFT JOIN links ON cur_id=l_from
WHERE l_from IS NULL
AND cur_namespace=0
AND LENGTH(cur_text)>0
ORDER BY cur_title;

Páginas de discussão sem artigo

SELECT ca.cur_id, ca.cur_title
FROM cur ca
WHERE ca.cur_namespace=1
AND NOT EXISTS ( 
   SELECT cd.cur_id
   FROM cur cd
   WHERE ca.cur_title = cd.cur_title
   AND cd.cur_namespace=0 )

Redireccionamentos duplos

SELECT ca.cur_title
   FROM cur ca, cur cb, links l 
   WHERE ca.cur_is_redirect=1 
   AND cb.cur_is_redirect=1 
   AND l.l_from=ca.cur_id
   AND l.l_to=cb.cur_id 
   AND ca.cur_namespace=0 

Especial:Wantedpages

SELECT bl_to, COUNT(bl_from)
   FROM brokenlinks
   GROUP BY bl_to
   ORDER BY 'COUNT(bl_from)' DESC;

Especial:Uncategorizedpages

SELECT cur_title
   FROM cur LEFT JOIN categorylinks ON cur_id=cl_from
   WHERE cl_from IS NULL
      AND cur_namespace=0
      AND LENGTH(cur_text)>0
      AND NOT cur_is_redirect 
   ORDER BY cur_title;

Lista de páginas pelo número de imagens

SELECT cur_title, COUNT(il_to) AS cont 
   FROM cur, imagelinks 
   WHERE (il_from = cur_id) 
      AND (cur_namespace=0)
   GROUP BY il_from 
   ORDER BY cont DESC 
   LIMIT 50;

ou, as in User:Duesentrieb/Pages by number of images:

select count(*) as numlinks,concat('[[',cur_title,']]') 
from imagelinks,cur 
where cur_namespace=0 and il_from=cur_id 
group by il_from 
order by numlinks desc 
limit 500;

Saltos de domínio

SELECT a.cur_title 
FROM cur a, cur b, links l 
WHERE (a.cur_id = l.l_from) 
   AND (l.l_to = b.cur_id) 
   AND (a.cur_is_redirect) 
   AND (a.cur_namespace = 0) 
   AND (b.cur_namespace <> 0) 
   AND NOT (b.cur_namespace = 1)
   AND NOT (a.cur_title like 'WP:%');

Ecos

SELECT CONCAT('* [[',cur_title,']]'), COUNT(cur_title) AS dups
FROM cur  
WHERE cur_namespace = 0
GROUP BY cur_title
 HAVING dups <> 1 
ORDER BY dups DESC

Artigos com interlinks para redirects

SELECT DISTINCT r.cur_title, d.cur_title 
FROM cur r, cur a, links l, links k, cur d
WHERE r.cur_is_redirect
   AND l.l_from = a.cur_id
   AND l.l_to = r.cur_id
   AND k.l_from = r.cur_id
   AND k.l_to = d.cur_id
   AND d.cur_namespace = 0

Desambiguações com afluentes

SELECT DISTINCT d.cur_id, d.cur_title
FROM cur d, cur a, links l
WHERE a.cur_namespace = 0
   AND NOT a.cur_is_redirect
   AND l.l_from = a.cur_id
   AND l.l_to = d.cur_id
   AND  (d.cur_text LIKE '%{{disambig%'
      OR d.cur_text LIKE '%{{desambig%')
   AND NOT (a.cur_text LIKE '%{{ver desambig%'
      OR a.cur_text LIKE '%{{desambigexplicada%'
      OR a.cur_text LIKE '%{{minidesambig%'
      OR a.cur_text LIKE '%{{desambiguação-redirect%')