Vicipaedia:Wikisign

E Vicipaedia

Wikisign est instrumentum quod ad tempus inactivum est.

http://www.wikisign.org/

Database dumps?[fontem recensere]

  • 27.02.2006

Examples for SQL requests[fontem recensere]

Uncategorized pages[fontem recensere]

SELECT cur_namespace, cur_title, DATE(cur_timestamp)
FROM cur
WHERE cur_namespace = 0 and cur_is_redirect = 0
and cur_text NOT Like '%[[Cate%'
and cur_text NOT Like '%{{discretiva}}%'
and cur_text NOT Like '%{{_elenda}}%'
and cur_text NOT Like '%{{_enses}}%'
ORDER BY cur_timestamp
LIMIT 5000

Missing interwiki links[fontem recensere]

SELECT cur_namespace, cur_title, DATE(cur_timestamp)
FROM cur
WHERE cur_namespace = 0 and cur_is_redirect = 0
and cur_text NOT Like '%[[__:%'
and cur_text NOT Like '%{{discretiva}}%'
and cur_text NOT Like '%{{delenda}}%'
and cur_text NOT Like '%[[_ategor%:Nationes%'
and cur_text NOT Like '%[[_ategor%:Urbes%'
and cur_text NOT Like '%{{_ontribuenda%'
and cur_title NOT Like 'Decennium %'
ORDER BY cur_timestamp
LIMIT 5000

Vide etiam[fontem recensere]