Benutzer:Peterlustig/Test

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;
"