xF1 Add-on Optimized List Queries by Xon 1.4.3

• Fix bad interaction with per-user news-feeds
• Note; recommend considering disabling the per-user news-feed cache as it is removed in XF2 anyway, as it causes Database write churn without much savings query wise

• Fix News Feed "Show older items" not working as expected

• Fix off-by-1 error when pushing event_date into news feed query to ensure correct index usage.

• Shim news-feed to ensure better index handling
• Backport from XF2 fixes for how XF does bulk rebuilds xf_thread_user_post and xf_post.position entries

• Improve the global RSS feature when selecting threads from a forum with a large number of threads.
  • Avoiding "early joins" can offer significant savings.
  • Disabled by default

• When an error occurs and the unoptimized conversation list query is run, call the right function.

• Fix error on search which can occur when limited to no add-on's are installed.

• Fix "Datas must be string or set automatic_serialization" due to failed serialization.

• Tweak options (add min values where appropriate), change "Faster Members Online Query" default value.

• Fixed missing variable definition breaking search if Post Ratings or Simple Forms are not installed.