Untitled query #6203

SQL

use commonswiki_p;
SELECT concat("M",page_id) AS MID, 
    CONCAT("File:",page_title),
    page_links_updated, page_touched, rev_len, rev_timestamp
FROM page
#JOIN externallinks ON page_id = el_from AND  el_to LIKE '//tools.wmflabs.org/geohack/geohack.php%'
#JOIN categorylinks cl2 ON cl2.cl_from = page_id AND cl2.cl_to='Climbing_photographs_by_Jarek_Tuszyński' 
JOIN revision  ON rev_page = page_id and rev_actor=695 
WHERE page_namespace = 6
#AND page_id = 8154627
AND rev_timestamp<page_links_updated
limit 100
SQL

Checking query status...
