Search results ordering is inconsistent

Users have noticed that search results appear in a different order for identical queries. This is likely caused by missing ORDER BY clauses in the database query, leading to non-deterministic result sets.