𝖂𝖎ƙ𝖎𝖊

Wikie:Manutenção/Estatísticas/Arquivo

Predefinição:Mbox

Ferramentas

Outras Estatísticas

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%')

talvez você goste

Permaneça conectado

Parceiros

Dieta Cetogenica | NutriPro Saúde