Untitled query #11905

SQL

use dewiki_p;

select gt_lat, gt_lon, gt_page_id, gt_name, (@p:=select page_title from page where page_id = gt_page_id replace(replace( replace( @body, '&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')
/*
set @body = cast(
(
#for xml path( 'tr' ), type 
)
  as char )
*/
#set @body = replace( replace( @body, '&lt;', '<' ), '&gt;', '>' )

#print @body
SQL

Checking query status...
