Revert "LPS-40695 JournalArticle left join should check on workflow status"

This reverts commit 0ef716453e60c7087797334aeddb275b4af1a221.
LPS-42064 Checks if User is <= 0 to remove it from query
LPS-42064 Use the same method
LPS-42064 Fix logic, we should get subfolders only when the rootFolderId != Default
LPS-42064 SF
LPS-42050 Remove one of the equals signs: this has been introduced by mistake during a source formatting process
LPS-41894 Failing Integration test for this issue
LPS-41894 some tests to guard original SQLServerLimitStringUtil logic
LPS-41894 Minimum fix.
LPS-41894 some more QueryUtilTest integration tests to verify logic
LPS-41894 Removing unnesessary code, no logic changes.
LPS-41894 Source formatting
LPS-41894 SF
LPS-42074 Fine tuning portlet publish when in global scope (no layouts and on control panel)