Do not use preg function here, it's way too slow.
avoid using string offsets
[Fix] Sample Data - park blogs module #5185-#5197 sqlazure

This fix solve the issue reported here #5185
and first sovled with #5197 sqlazure
created this one for merge issue with #5174
Update Composer
Fixed an issue causing admin user list to be incorrectly filtered for actived state

Because the field ‘activation’ is defined as VARCHAR in MySQL the
integer zero returns an incorrect result. Casting zero as a string in
the SQL query corrects the issue.
Adding catid to query
Fixing getArticleRoute() calls

There is no need to use catslug in Joomla 3.x because:
1. Core content component doesn't use catslug in article URLs;
2. Process link function - **ContentHelperRoute::getArticleRoute** - requires only catid (integer value).
`/components/com_content/helpers/route.php`
`public static function getArticleRoute($id, $catid = 0, $language = 0)`
Remove optimization bar at the end
Merge pull request #5433 from dgt41/indexer_progressbar

Remove optimization bar at the end of the process
Unnecessary condition in mod_articles_category
Generate a base URL once outside of the results loop since instead of on each iteration. Also, a lot of other cleanup.
tab to space
Fixes highlighiting in "Smart Search"

Both component and module search results were affected.
jquery.autocomplete.min.js was loded before jQuery
Moved jQuery loading at the top

There are other scripts that needs jQuery
Conditional scripts generation

Apparently a major work, actually a small thing...
Changed variable name from 'a' to 'suggest'
Removed unneeded behavior.core

... and fixed JS indenting (thanks @dgt41)
Merge pull request #5154 from okonomiyaki3000/dont-use-preg

Do not use preg function here, it's way too slow.
Fix Syntax Error on Class Tag

@see http://issues.joomla.org/tracker/joomla-cms/5443
@see https://github.com/joomla/joomla-cms/issues/5443
Add Space After combobox Class

After Checking J3.0, J3.1's originally correct versions, there was a space between the combobox class and the custom class.