Switch from LEFT to INNER joins.

INNER joins are often more efficient as they can result in fewer rows
being examined before a result set is generated.

Fixes #3968
Do not translate "CakePHP"
Merge pull request #1486 from dmromanov/translation-title

Do not translate "CakePHP"
coding standards according to new sniffer rules
prevent rtrim to remove whitespace from test
Merge pull request #1492 from dereuromark/master-phpcs

coding standards according to new sniffer rules
Improved code readability

Changed table echo to printf for more readable code
Wrapped sql_dump error message in __d(), as discussed here:
https://github.com/cakephp/cakephp/commit/4c4fdc6f70e5b98b043609af11025200d09263c6#commitcomment-3155723
and here:
https://github.com/cakephp/cakephp/pull/1491/files#r5646701
Merge pull request #1491 from ravage84/sql_dump

Improved code readability
Removed else clauses after redirects and added return before redirect() and flash() calls
Fix unlink() for CacheEngine::clear() failed on windows.
Fixing some errors related to unlink() on windows
Update bakeshell so `bake all` gets the correct connection name.

Fixes #3972
Merge pull request #1497 from hiromi2424/fix-unlink-windows

Fix unlink() for CacheEngine::clear() failed on windows.

Refs #3930
Updating some View files to follow convention
Allow setting path constants in app/Console/cake.php as you can in webroot/index.php
Merge pull request #1507 from ADmad/2.3-console-constants

Allow setting path constants in app/Console/cake.php as you can in webro...
Update version number to 2.3.9
Fixed statement about Security:hash's salt parameter

Just nitpicking, but it prepends the salt, not appends it:
https://github.com/cakephp/cakephp/blob/master/lib/Cake/Utility/Security.php#L120
Merge pull request #1509 from ravage84/prepend-salt

Fixed statement about Security:hash's salt parameter
Making CakeTime display 'about X ago' when time passed is lower than accuracy

Removing unnecessary else

Also support 'about' times for future times

Make 'about' times translateable in all languages