Sometimes some search or meta query you're trying to do refuses to cooperate and and return results. If you thus find yourself poking around WP_Query's request property, which is a copy of the SQL statement executed to create your query object, you may have noticed some odd and space-inefficient syntax when using the LIKE operator.
Keep on readin' on Remove hashed placeholders when debugging WordPress SQL statements⟶