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,'_',' ')="Scrimeri la Jocurile Olimpice de vară din 2016"
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...