Yeah, maybe the example isn't that great, I admit so much. :-) However, it's not only about the users as in the visitors of the shop. It can also be a feature

Yeah, maybe the example isn't that great, I admit so much. :-) However, it's not only about the users as in the visitors of the shop. It can also be a feature such as "show similar bicycles" that will require more complicated queries. And while it's of course possible to maybe run multiple queries and combine the results by code, it can be nice to just do it in one query that is easy to understand and debug/optimize because it's pretty much just SQL.