Untitled query #80703

SQL

#SELECT p.page_title, p.page_id
#use enwiki_p;

SELECT unique pl2.pl_title #pl2.pl_from, pl2.pl_title, #pl.target_
from pagelinks pl2
JOIN page p on pl2.pl_from = p.page_id
join categorylinks cl ON p.page_id = cl.cl_from 
join categorylinks cl2 ON pl2.pl_target_id = cl2.cl_from 
where pl2.pl_from_namespace = 0
and cl.cl_to LIKE "Golden_Globe_Awards_ceremonies" #pid 81st = 75343509
and cl2.cl_to like "%films"
and p.page_namespace = 0
#limit 100
#Category:1984 films
;
#limit 10;
#FROM  page , categorylinks, pagelinks
#where 
#pl_title=page_title
#AND pl_namespace = 0
#limit 10;
#Where cl_to = 'Begriffsklärung'
#	AND cl_from= page_id
#    AND pl_from_namespace = 10
#    AND pl_from <> 6262673
#    AND cl_timestamp >= DATE(NOW()) - INTERVAL 100 DAY
#Limit 100;
SQL

Checking query status...
