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, actor_name Criada_por FROM ( SELECT cl1.cl_from pagid FROM categorylinks cl1 INNER JOIN categorylinks cl2 ON cl1.cl_from = cl2.cl_from WHERE cl1.cl_to = 'Imagens_de_conteúdo_restrito' GROUP BY cl1.cl_from HAVING COUNT(*) = 1 ) pag INNER JOIN page ON pagid = page_id INNER JOIN revision ON rev_page = pagid INNER JOIN actor ON rev_actor = actor_id WHERE rev_parent_id = 0
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...