Äthiopier und Eritreer

This query is marked as a draft This query has been published by Wurgl.

Äthiopier und Eritreer mit einem Komma in der Sortierung bzw. ganz ohne "{{SORTIERUNG:…}}" bzw. {{DEFAULTSORT:}}

Siehe https://de.wikipedia.org/wiki/Wikipedia_Diskussion:WikiProjekt_Afrika#Sortierung_%C3%A4thiopischer_und_eritreischer_Namen_mit_Patronymen

SQL

SELECT page_title, pp_value AS "Sortierung"
  FROM categorylinks, page LEFT JOIN page_props
                             ON pp_page = page_id
                            AND pp_propname = 'defaultsort'
 WHERE page_namespace = 0
   AND page_id = cl_from
   AND cl_to IN ('Äthiopier', 'Eritreer')
   AND (pp_value LIKE '%,%'
        OR pp_value IS NULL)

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.

SQL

Checking query status...