Wikipedia:Elenchi generati offline/Intestazioni errate

Pagine in cui la gerarchia delle intestazioni non inizia con == o con "salti" nella gerarchia. (Possono esserci singole segnalazione false, p.es. se i "=" sono all'interno di un commento o <pre>.)

MediaWiki 1.4

select concat("#[[",cur_title, "]]") 
  from cur 
  where cur_namespace=0 
  and cur_text regexp "(^|\n)=[^=]";

select concat("#[[",cur_title, "]]") 
  from cur 
  where cur_namespace=0 
  and cur_text regexp "(^|\n)={3,}" 
  and cur_text not regexp "(^|\n)==[^=]";

select concat("#[[",cur_title, "]]") 
  from cur 
  where cur_namespace=0 
  and cur_text regexp "(^|\n)==[^=]" 
  and ((cur_text regexp "(^|\n)={4,}" 
      and cur_text not regexp "(^|\n)===[^=]") 
    or (cur_text regexp "(^|\n)={5,}" 
      and cur_text not regexp "(^|\n)====[^=]") 
    or (cur_text regexp "(^|\n)={6,}" 
      and cur_text not regexp "(^|\n)=====[^=]"));

MediaWiki 1.5

SELECT CONCAT("# [[", page_title, "]]") FROM page
  JOIN revision ON page_id=rev_page
  JOIN text ON rev_text_id=old_id
  WHERE page_namespace=0 
  AND old_text REGEXP "(^|\n)=[^=]"
  ORDER BY page_title;

SELECT CONCAT("# [[", page_title, "]]") FROM page
  JOIN revision ON page_id=rev_page
  JOIN text ON rev_text_id=old_id
  WHERE page_namespace=0 
  AND old_text REGEXP "(^|\n)={3,}"
  AND old_text NOT REGEXP "(^|\n)==[^=]"
  ORDER BY page_title;

SELECT CONCAT("# [[", page_title, "]]") FROM page
  JOIN revision ON page_id=rev_page
  JOIN text ON rev_text_id=old_id
  WHERE page_namespace=0 
  and old_text regexp "(^|\n)==[^=]" 
  and ((old_text regexp "(^|\n)={4,}" 
      and old_text not regexp "(^|\n)===[^=]") 
    or (old_text regexp "(^|\n)={5,}" 
      and old_text not regexp "(^|\n)====[^=]") 
    or (old_text regexp "(^|\n)={6,}" 
      and old_text not regexp "(^|\n)=====[^=]"));

=

Attualmente vuoto

=== o più basso

Attualmente vuoto

"Salti" nella gerarchia

Attualmente vuoto