Wikipedia:Elenchi generati offline/Tag font

Da Wikipedia, l'enciclopedia libera.

< Wikipedia:Elenchi generati offline

Vai a: Navigazione, cerca

Pagine del namespace principale e del namespace Template che contengono il tag <font>. Vedasi anche: Wikipedia:Accessibilità del contenuto.

Ultimo aggiornamento: dump del 26 giugno 2008

Indice

1 Namespace principale
- 1.1 Query
- 1.2 Elenco
2 Namespace Template
- 2.1 Query
- 2.2 Elenco

[modifica] Namespace principale

[modifica] Query

SELECT CONCAT("#[[", page_title, "]]") 
  FROM (SELECT page_title, rev_text_id, MAX(rev_timestamp) 
          FROM page 
          JOIN revision ON page_id = rev_page 
          WHERE page_namespace = 0 
          GROUP BY rev_page) AS t1 
  JOIN text ON rev_text_id = old_id 
  WHERE old_text LIKE "%<font%" 
  ORDER BY page_title;

[modifica] Elenco

[modifica] Namespace Template

[modifica] Query

SELECT CONCAT("#[[Template:", page_title, "]]") 
  FROM (SELECT page_title, rev_text_id, MAX(rev_timestamp) 
          FROM page 
          JOIN revision ON page_id = rev_page 
          WHERE page_namespace = 10 
          GROUP BY rev_page) AS t1 
  JOIN text ON rev_text_id = old_id 
  WHERE old_text LIKE "%<font%" 
  ORDER BY page_title;

[modifica] Elenco