Controlling output order: Difference between revisions

replaced: tt> → code> (12)
(Added reference and clarified.)
(replaced: tt> → code> (12))
Line 44:
;''lastedit'': outputs list based on most recent edit to the pages
;''pagetouched'': outputs list based on 'page_touched' timestamp. Read comment on <code>page_touched</code> field in [[mw:Page_table|Page_table]] to see the difference from most recent edit by an author.
;''pagesel'': outputs list based on the names of the reference pages which are used in the selection of a <ttcode>linksfrom</ttcode> or <ttcode>linksto</ttcode> statement. ''pagesel'' only makes sense if there is more than one page mentioned in the <ttcode>linksfrom</ttcode> or <ttcode>linksto</ttcode> condition.
;''title'': outputs list sorted by article (prefix +) title
;''titlewithoutnamespace'': outputs list sorted by the article name regardless of namespace
Line 110:
defines the collating sequence for ordering.
 
Note: A very special (proprietory) function can be used to sort card suit symbols according to the rank of suits that is used in the card game of bridge (this cannot be done by standard collating sequences). To trigger this function set <ttcode>ordercollation=bridge</ttcode>.
 
Example:
Line 116:
<code>ordercollation=<i>latin1_german_ci</i></code>
 
You may want to try <ttcode>latin1_swedish_ci</ttcode> or other collation mapping table names as well.
 
If you use a name for the first time you should make sure that it is correctly spelt. Otherwise you will see a SQL error message.