Untitled query #26634

SQL

USE commonswiki_p;
SELECT page_title, page_id, img_metadata
FROM recentchanges
INNER JOIN page
    ON page_title = rc_title
    AND page_namespace = rc_namespace
INNER JOIN image
    ON img_name = page_title
LEFT JOIN templatelinks
    ON tl_from = page_id
    AND tl_namespace = 10
    AND tl_title IN ('Location', 'Location_dec')
WHERE page_namespace = 6
    AND (
        img_metadata LIKE '%"GPSAltitude"%' OR
        img_metadata LIKE '%"GPSLatitudeRef"%'
    )

    -- SELECT specific images (debug)
    -- AND page_title IN ('Chur_de_la_basilique_Saint-Sauveur,_Dinan,_France.jpg')

    -- Go over all uploads of a specific user (manual)
    -- AND img_user_text = "Niteshift"

    AND tl_from IS NULL
    AND rc_timestamp > DATE_FORMAT(NOW() - INTERVAL 2 DAY, '%Y%m%d%H%i%S')
    AND rc_log_type = 'upload'
;
SQL

Checking query status...
