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 * 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;
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...