Beiträge eines Users excl. Weiterleitungen

SQL

USE dewiki_p;
SET lc_time_names = "de_DE";
SELECT CONCAT('[[', REPLACE(page_title, '_', ' '), ']]') AS Artikel,
       /*IF((SELECT 1
             FROM templatelinks
            WHERE tl_from = page_id
              AND tl_namespace = 10
              AND tl_title = 'Begriffsklärung'
            LIMIT 1
          ) = 1, "BKL", IF(page_is_redirect = 1 ? "WL" : "")) AS "BKL/WL?", */
       DATE_FORMAT(STR_TO_DATE(rev_timestamp, "%Y%m%d%H%i%s"), "%e.%c.%Y %H:%i:%s") AS "Erstellt am"
  FROM page, revision_userindex, actor
 WHERE page_id = rev_page
   AND rev_parent_id = 0
   AND page_namespace = 0
   AND page_is_redirect = 0 /* */
   AND actor_id = rev_actor
   AND actor_name = 'Jack User'
 ORDER BY rev_timestamp DESC;
SQL

Checking query status...
