Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Soni
.
Toggle Highlighting
SQL
#SELECT p.page_title, p.page_id #use enwiki_p; SELECT unique pl2.pl_title, pl2.pl_target_id #pl2.pl_from, pl2.pl_title, #pl.target_ from pagelinks pl2 INNER JOIN page p on pl2.pl_from = p.page_id INNER 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;
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...