Untitled query #12302

SQL

select * from (  select    pl_from,    IF (LOCATE('/C:',pl_title)>0, SUBSTRING_INDEX(SUBSTRING_INDEX(pl_title, '/C:', -1),',',1), NULL) lat_template,    IF (LOCATE('/C:',pl_title)>0, SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(pl_title, '/C:', -1),'!/',1),',',-1), NULL) as lon_template,    IF (LOCATE('/D:',pl_title)>0, SUBSTRING_INDEX(SUBSTRING_INDEX(pl_title, '/D:', -1),'!/',1), '') description,    IF (LOCATE('/O:',pl_title)>0, SUBSTRING_INDEX(SUBSTRING_INDEX(pl_title, '/O:', -1),'!/',1), NULL) ort,    pl_title,    gt_lat lat_page,    gt_lon as lon_page,    page_title     from dewiki_p.pagelinks     left join dewiki_p.geo_tags on gt_page_id = pl_from and gt_primary = 1     left join dewiki_p.page on page_id = pl_from    where pl_namespace=10 AND pl_title LIKE 'Bilderwunsch/code!/%'     ) as asdf where  lat_template is null and lat_page is null and page_title not like 'Liste%' order by 1;
SQL

Checking query status...
