Untitled query #10255

SQL

use itwiki_p;
SELECT
    p.page_id AS "page_id",
    CAST(p.page_title AS CHAR(10000) CHARACTER SET utf8) AS "page_title",
    p.page_is_new AS "page_new",
    p.page_namespace AS "page_namespace",
    r.rev_text_id AS "revision_id",
    r.rev_timestamp AS "time Stamp"
    #t.old_id AS "text_id"
FROM
    page p
        INNER JOIN revision r
            ON p.page_latest = r.rev_id
        #INNER JOIN text t
        #    ON r.rev_text_id = t.old_id
WHERE r.rev_timestamp >= "20160506120000"       
  and r.rev_timestamp <= "20160506155959"
  and p.page_is_new = 1
  and p.page_namespace = 1
order by r.rev_timestamp
SQL

Checking query status...
