Fork of
Controlchars in sortkey
by Michael Schönitzer (WMDE)
This query is marked as a draft
This query has been published
by Michael Schönitzer (WMDE).
SQL
AخA
use dewiki_p;
SELECT page_title, cl_to, cl_sortkey_prefix
FROM page
join categorylinks on page_id=cl_from
WHERE cl_sortkey_prefix != "" and
page_namespace = 0 and (
cl_sortkey_prefix regexp x'E28080' or
cl_sortkey_prefix regexp x'E28081' or
cl_sortkey_prefix regexp x'E28082' or
cl_sortkey_prefix regexp x'E28083' or
cl_sortkey_prefix regexp x'E28084' or
cl_sortkey_prefix regexp x'E28085' or
cl_sortkey_prefix regexp x'E28086' or
cl_sortkey_prefix regexp x'E28087' or
cl_sortkey_prefix regexp x'E28088' or
cl_sortkey_prefix regexp x'E28089' or
cl_sortkey_prefix regexp x'E2808A' or
cl_sortkey_prefix regexp x'E2808B' or
cl_sortkey_prefix regexp x'E2808C' or
cl_sortkey_prefix regexp x'E2808D' or
cl_sortkey_prefix regexp x'E2808E' or
cl_sortkey_prefix regexp x'E2808F'
)
;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.