„Benutzer:Peterlustig/Test“ – Versionsunterschied

Versionsgeschichte interaktiv durchsuchen

Inhalt gelöscht Inhalt hinzugefügt

Inline

Aktuelle Version vom 3. September 2006, 12:32 Uhr

mysql dewiki_p -B -e "
SELECT CONCAT('|-|', '[[',page_title,']] || ', page_len,' Bytes || ')  
  FROM page 
  LEFT JOIN categorylinks 
       ON cl_from = page_id 
       AND cl_to IN ( 'Begriffsklärung', 'Wikipedia:Gesperrtes_Lemma', 'Wikipedia:Falschschreibung', 'Wikipedia:URV', 'Wikipedia:Urheberrecht_ungeklärt', 'Teilliste', 'Abkürzung' )
WHERE
  cl_from IS NULL
  AND page_namespace = 0
  AND page_is_redirect = 0 
  AND page_len < 351 
ORDER BY page_len ASC
LIMIT 5000;
"

@@ Zeile 1: / Zeile 1: @@
+<pre>
- <nowiki> SELECT CONCAT('|-| [[',cur_title,']] || ', LENGTH(cur_text),' Bytes || ')  </nowiki>
+mysql dewiki_p -B -e "
-   FROM cur
+SELECT CONCAT('|-|', '[[',page_title,']] || ', page_len,' Bytes || ')
- WHERE cur_is_redirect = 0
+  FROM page
-   AND cur_namespace = 0
+  LEFT JOIN categorylinks
-   AND LENGTH(cur_text) < 351
+       ON cl_from = page_id
-   AND LENGTH(cur_text) > 343
+       AND cl_to IN ( 'Begriffsklärung', 'Wikipedia:Gesperrtes_Lemma', 'Wikipedia:Falschschreibung', 'Wikipedia:URV', 'Wikipedia:Urheberrecht_ungeklärt', 'Teilliste', 'Abkürzung' )
-   AND cur_title NOT LIKE '%/Zahl'
+WHERE
-   AND cur_title NOT LIKE '%/0-9'
+  cl_from IS NULL
-   AND cur_title NOT LIKE 'Liste%'
-   AND cur_title NOT LIKE '%glossar/%'
+  AND page_namespace = 0
+  AND page_is_redirect = 0
-   AND cur_text NOT LIKE '%Begriffsk%'
-   AND cur_text NOT LIKE '%begriffsk%'
+  AND page_len < 351
+ORDER BY page_len ASC
-   AND cur_text NOT LIKE '%isambig}}'
+LIMIT 5000;
-   AND cur_text NOT LIKE '%URV%'
+"
-   AND cur_text NOT LIKE '{{Wiktionary%'
+</pre>
-   AND cur_title NOT LIKE 'Portal%'
-   AND cur_text NOT LIKE '%esperrtes Lemm%'
-   AND cur_text NOT LIKE '%esperrtes_Lemm%'
-   AND cur_text NOT LIKE '{{Falschschreibung%'
-   AND cur_text NOT LIKE '%<nowiki>{{BKL}}</nowiki>%'
-   AND cur_text NOT LIKE '<nowiki>{{Vorlage:Urheberrecht_ungeklärt}}</nowiki>'
- ORDER BY LENGTH(cur_text) ASC, cur_timestamp ASC
- LIMIT 1000;
-{{NUMBEROFARTICLES}}