Fork of Pages with Defaultsort by Michael Schönitzer (WMDE)
This query is marked as a draft This query has been published by Michael Schönitzer (WMDE).

SQL

​x
 
use dewiki_p;
  SELECT DISTINCT page_title, pp_value
   FROM page_props join page on page_id=pp_page
   WHERE pp_propname = "defaultsort" and
   pp_value like '%!%' and
   page_title not like '%!%'
;
​
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
All SQL code is licensed under CC0 License.

Checking query status...