Jack's Artikel

SQL

USE dewiki_p;
SELECT SQL_BIG_RESULT STRAIGHT_JOIN DISTINCT page_title,
                                             IF(page_is_redirect = 1, "Weiterleitung", IF(tl_from IS NOT NULL, "Begriffsklärung", "–")) AS Typ,
                                             CONCAT(SUBSTR(rev_timestamp, 1, 4), "-", SUBSTR(rev_timestamp, 5, 2), "-", SUBSTR(rev_timestamp, 7, 2) " ", SUBSTR(rev_timestamp, 9, 2) ":", SUBSTR(rev_timestamp, 11, 2) ":", SUBSTR(rev_timestamp, 13, 2)) AS Datum
  FROM revision, page LEFT JOIN templatelinks
                             ON tl_from = page_id
                            AND tl_title = 'Begriffsklärung'
                            AND tl_namespace = 10
 WHERE page_namespace = 0
   AND page_id = rev_page
   AND rev_parent_id = 0
   AND rev_actor = 43
SQL

Checking query status...
