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",
    CONCAT ("# [[", p.page_title , "]]") AS "Titolo",
    p.page_is_new AS "page_new",
    p.page_namespace AS "page_namespace",
    p.page_is_redirect AS "page_is_redirect",
    r.rev_text_id AS "revision_id",
    r.rev_timestamp AS "time Stamp",
    p.page_latest, r.rev_id

    #t.old_id AS "text_id"
FROM
    page p
        INNER JOIN revision r
            ON ( #p.page_latest = r.rev_id or 
                 r.rev_page = p.page_id )
        #INNER JOIN text t
        #    ON r.rev_text_id = t.old_id
WHERE #r.rev_timestamp >= "20160508000000"       
  #and r.rev_timestamp <= "20160508235959"
  #and p.page_is_new = 1
  #and p.page_namespace = 0
  #and p.page_is_redirect = 0
  p.page_title = "ALTRAN"
order by r.rev_timestamp
SQL

Checking query status...
