Benutzer:Peterlustig/Test

mysql dewiki_p -B -e " SELECT CONCAT('|-|', '[[',page_title,']] || ', page_len,' Bytes || ')  
FROM page, (SELECT cl_from 
            FROM categorylinks
            WHERE 
               cl_to NOT LIKE '%Begriffsk%'
               AND cl_to NOT LIKE '%Gesperrtes Lemma%'
               AND cl_to NOT LIKE '%Liste%') category
WHERE
  page_namespace = 0 AND
  page_is_redirect = 0 
  AND page_len > 0
  AND page_len < 351
  AND page_id <> category.cl_from
  AND page_title NOT LIKE '%/Zahl'
  AND page_title NOT LIKE '%/0-9'
  AND page_title NOT LIKE 'Liste%'
  AND page_title NOT LIKE '%glossar/%'
  AND page_title NOT LIKE '%Begriffsk%'
  AND page_title NOT LIKE 'Portal%'
ORDER BY page_len ASC
LIMIT 2000;