Seiten ohne Kategorie

SQL

USE dewiki_p;
SELECT COUNT(*) /*wl.page_title, ziel_seite.page_title*/
  FROM page as wl LEFT JOIN categorylinks AS wl_kategorie ON wl_kategorie.cl_from = wl.page_id,
       redirect, categorylinks AS ziel_kategorie, page as ziel_seite
 WHERE wl_kategorie.cl_from IS NULL
   AND wl.page_namespace = 0
   AND wl.page_is_redirect = 1
   AND wl.page_id = rd_from
   AND rd_title = ziel_seite.page_title
   AND rd_namespace = ziel_seite.page_namespace
   AND ziel_seite.page_namespace = 0
   AND ziel_seite.page_id = ziel_kategorie.cl_from
   AND ziel_kategorie.cl_to = 'Ort_im_Bezirk_Rohrbach'
SQL

Checking query status...
