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;