#128846 by takashi, chx, bdragon, wedge, salvis, Shiny: rewritten queries on PostreSQL need to have matching DISTINCT ON and ORDER BY expressions

#252921 by David_Rothstein and agentrickard: remove unused join, which caused column type compatibility problems with postgresql; improves postgresql compatibility.

#252580 by Robert Douglass, Gerhard Killesreiter, flobruit: avoid division by zero, when all search weights are set to 0.

- Patch #273761 by catch: removed inconsistent delete behavior of nodes.  It would leave comments, ratings, etc behind in the database.

#155337 by gpk and Bevan: only treat newlines teaser breakers, if the newline filter is present in the particular input format

#214390 by shrop. Partial backport of #153998, use a separate permission for blogapi since it does not depend on blog module.

- Patch #258128 by webchick: @parameter should be @param.  Gets the Most Trivial Patch of the Month Award.
Backport by gpk.

- Patch #191116 by david: make drupal_urlencode() rfc 1738 compliant to make it work correctly with spaces.

#104662 by chx: the search block form might not be available on the search page itself, so that target was not right for search block form submissions. Backport by webchick.

Backport by joshk and stevecrozz.

- Patch #231132 by snufkin: fixed invalid XML-RPC error messages due to HTML tags being inserted in the message string.

5.x backport by Freso.

#232037 by pwolanin: (performance) block regions should only be populated when called for, not in all cases (fixes performance expectation on 403/404 pages)

#244597 by kbahey: remove cruft from user_login(), that added extra message to the form was never used or displayed

Backport in #109459.

#212864 suggestion by pp, patch by gdevlugt: use format_date() for RSS item dates instead of date() to honor site time zone settings