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