Vicipaedia:Wikisign

Wikisign est instrumentum quod ad tempus inactivum est.

Nexus

http://www.wikisign.org/

Database dumps^?

• 27.02.2006

Examples for SQL requests

Uncategorized pages

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

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

• Vicipaedia:Praefatio