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
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)`
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
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.
Remove unused string
Merge pull request #5451 from bassmanpaul/patch-1

Fix Syntax Error on Class Tag
Didn't mean to merge direct :(
Merge pull request #5435 from shur/patch-9

Unnecessary condition in mod_articles_category
Merge pull request #5405 from subtext/issue-5307

Fixed SQL query (Ref #5307)
Merge pull request #5425 from shur/patch-8

Fixing getArticleRoute() calls
Merge pull request #5423 from Hackwar/patch-3

Fix notice in content search plugin
Merge pull request #5262 from alikon/patch-8

[Fix] Sample Data - park blogs module #5185-#5197 sqlazure