Vicipaedia:Wikisign
E Vicipaedia
Wikisign est instrumentum quod ad tempus inactivum est.
Index |
[recensere] Nexus
[recensere] Database dumps?
- 27.02.2006
[recensere] Examples for SQL requests
[recensere] 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
[recensere] 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

