# Another subselect instead of join issue

**URL:** <https://discourse.hibernate.org/t/another-subselect-instead-of-join-issue/11130>\
**Category:** Hibernate ORM\
**Created:** [February 28, 2025, 8:07am UTC](https://discourse.hibernate.org/t/another-subselect-instead-of-join-issue/11130 "2025-02-28T08:07:26Z")\
**Posts on this page:** 1\
**Showing post:** 9

<div class="post-metadata">

**Author:** ![rjjb](https://avatars.discourse-cdn.com/v4/letter/r/45deac/32.png) [@rjjb](https://discourse.hibernate.org/u/rjjb)\
**Post date:** [May 30, 2025, 3:43am UTC](https://discourse.hibernate.org/t/another-subselect-instead-of-join-issue/11130/9 "2025-05-30T03:43:53Z")

</div>

Thank you for escalating this issue, despite initially marking it resolved.

I don’t know if any of the workarounds I have found will help you in the meantime, but I have tried to expand on it from my recent experiences.  
[Poorly rendered SQL resulting in extremely slow MySQL 8.0 queries](https://discourse.hibernate.org/t/poorly-rendered-sql-resulting-in-extremely-slow-mysql-8-0-queries/11508)

---

_[View the full topic](https://discourse.hibernate.org/t/another-subselect-instead-of-join-issue/11130)._