Untitled query #50986

SQL

select * from 
enwiki_p.page film 
JOIN enwiki_p.pagelinks links ON film.page_id = links.pl_from and links.pl_namespace = film.page_namespace
JOIN enwiki_p.page original on original.page_title = links.pl_title and original.page_namespace = links.pl_namespace
#join enwiki_p.geo_tags geo on original.page_id = geo.gt_page_id
#join categorylinks on film.page_id = cl_from
where
#cl_to like "%film%" and 
film.page_title ="Mortal_Kombat:_Annihilation" and film.page_namespace = 0 and links.pl_namespace = 0
;
SQL

Checking query status...
