Find files with lat=lon on commons

SQL

#use dewiki_p; set @ns:=0;
use commonswiki_p;set @ns:=6;
set @iso1:='DE';
#set @iso2:='' or code
set @iso2:='';

select gt_lat, gt_lon, gt_page_id, gt_name,
       #(select page_namespace from page where page_id = gt_page_id) as ns,
       #(select page_title from page where page_id = gt_page_id) as title,
       #gt_country,gt_region from geo_tags
       p1.page_namespace as ns,
       p1.page_title as title,
       gt_country,gt_region FROM geo_tags AS g1 JOIN page AS p1 ON g1.gt_page_id = p1.page_id
       where gt_lat = gt_lon
       having ns= @ns
       
#and gt_region is null
SQL

Checking query status...
