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'

;