Test - Quarry

SQL

use commonswiki_p;
SELECT concat("M",page_id) AS MID, 
	'P1259',
	REGEXP_REPLACE(el_to,'[^&]*&params=([^_]+)_N_([^_]*).*','@\\1/\\2') AS coordinates, 
    'P7787', 
    concat(replace(REGEXP_SUBSTR(el_to, '_heading:([^_&]*)'),'_heading:',''),'U28390') as heading, 
    '/* extracted from {{location}} template */'
    #el_to
FROM page
JOIN externallinks ON page_id = el_from AND  el_to LIKE '//geohack.toolforge.org/geohack/geohack.php%'
JOIN categorylinks cl1 ON cl1.cl_from = page_id AND cl1.cl_to='Pages_with_local_object_heading_and_missing_SDC_heading'
JOIN categorylinks cl2 ON cl2.cl_from = page_id AND cl2.cl_to='Pages_with_maps' 
WHERE 
    page_namespace = 6 
limit 1000
SQL

Checking query status...
