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
Andreyyshore
.
Toggle Highlighting
SQL
use rowiki_p; SELECT pid, title, h.pp_value AS defaultsort FROM ( SELECT f.cl_from AS pid, f.cl_to AS cl_to, g.page_title AS title FROM categorylinks AS f INNER JOIN ( SELECT page_id, page_title FROM page WHERE ((page_title LIKE '%Â%') OR (page_title LIKE '%â%') OR (page_title LIKE '%Î%') OR (page_title LIKE '%î%')) ) AS g ON f.cl_from=g.page_id ) AS i INNER JOIN ( SELECT pp_page, pp_value FROM page_props WHERE pp_propname="defaultsort" ) AS h ON i.pid=h.pp_page WHERE REPLACE(i.cl_to,'_',' ')="Actori brazilieni"
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...