Untitled query #11905

SQL

use dewiki_p;

select gt_lat,
       gt_lon,
       gt_page_id,
       gt_name,
       (
        @p:=(cast (@pt:=concat('<a href="https://de.wikipedia.org/wiki/',
                              @pt:=(select page_title from page where page_id = gt_page_id),
                              '">',
                              @pt,
                              '</a>')) as char)
        #replace(replace(replace(@p, '&lt;', '<' ), '&gt;', '>' ), '_', ' ')
       ) as title,
       gt_country,
       gt_region from geo_tags
where 
gt_country='AR' and gt_region not in ('A','B','C','D','E','F','G','H','J','K','L','M','N','P','Q','R','S','T','U','V','W','X','Y','Z')
OR gt_country='BS' and gt_region not in ('AK','BI','BP','BY','CE','CI','CK','CO','CS','EG','EX','FC','FP','GC','HI','HT','IN','LI','MC','MG','MI','NE','NO','NS','RC','RI','SA','SE','SO','SS','SW','WG')
/*
concat('<a href="https://de.wikipedia.org/wiki/',@pt:=(select page_title from page where page_id = gt_page_id),'">',@pt,'</a>')
set @body = cast(
@p:= replace(replace( replace( @p, '&lt;', '<' ), '&gt;', '>' ), '_', ' ')
(
#for xml path( 'tr' ), type 
)
  as char )
*/
#set @body = replace( replace( @body, '&lt;', '<' ), '&gt;', '>' )

#print @body
SQL

Checking query status...
