gpsexifbot main query rewrite

SQL

USE commonswiki_p;
SELECT NOW();

SELECT page_title, page_id, img_metadata
    FROM page
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 img_timestamp > DATE_FORMAT(NOW() - INTERVAL 2 DAY, '%Y%m%d%H%i%S')
;

SELECT NOW();
SQL

Checking query status...
