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
Danilo.mac
.
Toggle Highlighting
SQL
USE ptwiki_p; SELECT CONCAT('Ficheiro:', REPLACE(page_title, '_', ' ')) Página FROM categorylinks cl1 INNER JOIN categorylinks cl2 ON cl1.cl_from = cl2.cl_from INNER JOIN page ON cl1.cl_from = page_id WHERE cl1.cl_to = 'Imagens_de_conteúdo_restrito' GROUP BY cl1.cl_from HAVING COUNT(*) = 1
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...