gpsexifbot main query rewrite

SQL

USE commonswiki_p;
SELECT page_title, page_id, img_metadata
    FROM page, image
LEFT JOIN templatelinks
    ON tl_from = page_id
    AND tl_namespace = 10
    AND tl_title IN ('Location', 'Location_dec')
WHERE img_name = page_title
    AND 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
;
SQL

Checking query status...
