For faster navigation, this Iframe is preloading the Wikiwand page for Benutzer:APPER/Sortierung.

Benutzer:APPER/Sortierung

aus Wikipedia, der freien Enzyklopädie

Auf Anfrage unter Wikipedia:Bots/Anfragen hier eine Liste (beschränkt auf 500 Seiten) der Artikel, bei denen kein DEFAULTSORT/SORTIERUNG vorhanden ist, aber explizite Sortierungen angegeben sind.

Die Liste kann mit jedem Tool-Labs-Account erneut erzeugt werden (per angegebenem Kommandozeilenaufruf).

Personenartikel mit Sortierschlüssel in der Kat:Mann/Frau: 

mysql --defaults-file="${HOME}"/replica.my.cnf -e "SELECT CONCAT('* [[',page title,']]') FROM page WHERE page_namespace=0 AND page_id NOT IN (SELECT pp_page FROM page_props WHERE pp_propname='defaultsort') AND (SELECT cl_sortkey_prefix FROM categorylinks WHERE cl_from=page_id AND (cl_to='Mann' OR cl_to='Frau'))!='' LIMIT 0,500;" -h dewiki.labsdb dewiki_p > test.txt

Personenartikel mit Sortierschlüssel in einer beliebigen Kategorie (ausgeschlossene Sortierschlüssel: ' ', '!' und alle, die mit '⚭' beginnen): 

mysql --defaults-file="${HOME}"/replica.my.cnf -e "SELECT CONCAT('* [[',page title,']]') FROM page WHERE page_namespace=0 AND page_id NOT IN (SELECT pp_page FROM page_props WHERE pp_propname='defaultsort') AND (SELECT count(*) FROM categorylinks WHERE cl_from=page_id AND (cl_to='Mann' OR cl_to='Frau'))>0 AND (SELECT count(*) FROM categorylinks WHERE cl_from=page_id AND cl_sortkey_prefix!='' AND cl_sortkey_prefix NOT IN (' ', '\!') AND LEFT(cl_sortkey_prefix, 3)!='⚭')>0 LIMIT 0,500;" -h dewiki.labsdb dewiki_p > test.txt

Liste

[Bearbeiten | Quelltext bearbeiten]
More
{{bottomLinkPreText}} {{bottomLinkText}}
This page is based on a Wikipedia article written by contributors (read/edit).
Text is available under the CC BY-SA 4.0 license; additional terms may apply.
Images, videos and audio are available under their respective licenses.
Cover photo is available under {{::mainImage.info.license.name || 'Unknown'}} license. Cover photo is available under {{::mainImage.info.license.name || 'Unknown'}} license. Credit: (see original file).
Benutzer:APPER/Sortierung
Listen to this article

This browser is not supported by Wikiwand :(
Wikiwand requires a browser with modern capabilities in order to provide you with the best reading experience.
Please download and use one of the following browsers:

✕
This article was just edited, click to reload
This article has been deleted on Wikipedia (Why?)

Back to homepage

Please click Add in the dialog above
Please click Allow in the top-left corner,
then click Install Now in the dialog
Please click Open in the download dialog,
then click Install
Please click the "Downloads" icon in the Safari toolbar, open the first download in the list,
then click Install
{{::$root.activation.text}}

Install Wikiwand

Install on Chrome Install on Firefox
Don't forget to rate us

Tell your friends about Wikiwand!

Gmail Facebook Twitter Link

Enjoying Wikiwand?

Tell your friends and spread the love:
Share on Gmail Share on Facebook Share on Twitter Share on Buffer

Our magic isn't perfect

You can help our automatic cover photo selection by reporting an unsuitable photo.

This photo is visually disturbing This photo is not a good choice

Thank you for helping!


Your input will affect cover photo selection, along with input from other users.

X

Get ready for Wikiwand 2.0 🎉! the new version arrives on September 1st! Don't want to wait?