Wikipedia:Estaleiro/Estatísticas
Origem: Wikipédia, a enciclopédia livre.
[editar] Ferramentas
[editar] Outras Estatísticas
- Artigo com maior número de redireccionamentos: Fluoxetina (48)
[editar] 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
Índice |
[editar] Queries usadas para obter as estatísticas
[editar] 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;
[editar] 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;
[editar] 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=0
AND NOT cur_is_redirect;
[editar] Artigos vazios
SELECT COUNT(cur_title)
FROM cur
WHERE cur_namespace=0
AND LENGTH(cur_text)=0;
[editar] 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;
[editar] 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 '%:%');
[editar] Artigos com lixo
SELECT COUNT(cur_id)
FROM cur
WHERE cur_namespace=0
AND (cur_text LIKE '%lixo}}%'
OR cur_text LIKE '%impróprio}}%');
[editar] Artigos em tradução
SELECT COUNT(cur_title)
FROM cur
WHERE cur_namespace=0
AND (cur_text LIKE '%{{msg:emtradu%'
OR cur_text LIKE '%{{emtradu%');
[editar] Artigos em esboço
SELECT COUNT(cur_title)
FROM cur
WHERE cur_namespace=0
AND (cur_text LIKE '%{{msg:stub}}%'
OR cur_text LIKE '%{{stub}}%'
OR cur_text LIKE '%{{msg:esboço%'
OR cur_text LIKE '%{{esboço%'
OR cur_text LIKE '%{{mínimo%'
OR cur_text LIKE '%{{_rtigo mínimo%');
[editar] 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 '%{{disambig}}%';
[editar] Outras queries
[editar] 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;
[editar] 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 )
[editar] 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
[editar] Especial:Wantedpages
SELECT bl_to, COUNT(bl_from) FROM brokenlinks GROUP BY bl_to ORDER BY 'COUNT(bl_from)' DESC;
[editar] 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;
[editar] 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;
[editar] 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:%');
[editar] 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
[editar] 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
[editar] 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%')
