Untitled query #14390

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",
    CONCAT ("https://it.wikipedia.org/wiki/", 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 
                 AND r.rev_id = (select min(rr.rev_id) from revision rr where r.rev_page = rr.rev_page) )
        #INNER JOIN text t
        #    ON r.rev_text_id = t.old_id
WHERE r.rev_timestamp >= "20160408000000"       
  and r.rev_timestamp <= "20160408235959"
  #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 desc
SQL

Checking query status...
