# Issue in Query Formation using 5.6.7 jar

**URL:** <https://discourse.hibernate.org/t/issue-in-query-formation-using-5-6-7-jar/6492>\
**Category:** Hibernate ORM\
**Created:** [July 14, 2022, 5:08am UTC](https://discourse.hibernate.org/t/issue-in-query-formation-using-5-6-7-jar/6492 "2022-07-14T05:08:59Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Aparna\_Eswaran](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.hibernate.org/aparna_eswaran/32/1913_2.png) [@Aparna\_Eswaran](https://discourse.hibernate.org/u/Aparna_Eswaran)\
**Post date:** [July 14, 2022, 5:08am UTC](https://discourse.hibernate.org/t/issue-in-query-formation-using-5-6-7-jar/6492/1 "2022-07-14T05:08:59Z")

</div>

Hi all, I am facing an issue in the query formation in 5.6.7 hibernate version.

Scenario: I have an object named “ManagedObject” and there are 45 children for this object. These children are further having its own sub tables. One of its children name is “Table1”. I am trying to fetch a “Table1” object using “name” which is being a natural-id in “ManagedObject” using below code.

final NaturalIdLoadAccess naturalIdLoadAccess = session.byNaturalId(c);  
final T result = naturalIdLoadAccess.using(attributeName, value).load();

c is the class (Table1.class)  
attributeName = “name”  
value = “MO1”

The query which is formed using hibernate 5.6.7 jar for this fetching operation is huge and it does “left outer join” of all 45 ManagedObject tables and its sub tables which sums up to 94 "left outer join"s in the query. Since MySQL doesn’t support more than 61 joins in a query, it throws “java.sql.SQLException: Too many tables; MySQL can only use 61 tables in a join”. This also hits the performance badly.

For the same functionality, the query formed using hibernate 5.1.8 jar was crisp. It doesn’t join all the children tables and its sub tables. “Table1” object is fetched using a single query and the properties from it’s subtables are fetched using separate queries.

Why is the query not optimal in 5.6.7 version ? Please suggest some ways to resolve the issue.

Queries are available in first 2 comments below. Please check

---

<div class="post-metadata">

**Author:** ![Aparna\_Eswaran](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.hibernate.org/aparna_eswaran/32/1913_2.png) [@Aparna\_Eswaran](https://discourse.hibernate.org/u/Aparna_Eswaran)\
**Post date:** [July 14, 2022, 5:09am UTC](https://discourse.hibernate.org/t/issue-in-query-formation-using-5-6-7-jar/6492/2 "2022-07-14T05:09:35Z")

</div>

**Query formed using 5.1.8 jar:**

> Hibernate: select managedobj\_.MOID as MOID1\_235\_ from ManagedObject managedobj\_ where managedobj\_.NAME=?  
> Hibernate: select transporte0\_.MOID as MOID1\_235\_0\_, transporte0\_1\_.NAME as NAME2\_235\_0\_, transporte0\_1\_.DISPLAYNAME as DISPLAYN3\_235\_0\_, transporte0\_1\_.TYPE as TYPE4\_235\_0\_, transporte0\_1\_.MANAGED as MANAGED5\_235\_0\_, transporte0\_1\_.STATUS as STATUS6\_235\_0\_, transporte0\_1\_.PARENTKEY as PARENTKE7\_235\_0\_, transporte0\_1\_.PARENTMOID as PARENTMO8\_235\_0\_, transporte0\_1\_.CREATEDTIME as CREATEDT9\_235\_0\_, transporte0\_1\_.LASTMODIFIEDTIME as LASTMOD10\_235\_0\_, transporte0\_1\_.NBINAME as NBINAME11\_235\_0\_, transporte0\_1\_.CLASSNAME as CLASSNA12\_235\_0\_, transporte0\_.userLabel as userLabe2\_496\_0\_, transporte0\_.nativeEmsName as nativeEm3\_496\_0\_, transporte0\_.owner as owner4\_496\_0\_, transporte0\_.softwareVersion as software5\_496\_0\_, transporte0\_.emsType as emsType6\_496\_0\_, transporte1\_.MOID as MOID1\_497\_1\_, transporte1\_.label as label3\_497\_1\_, transporte1\_.nmsPrimaryAddress as nmsPrima4\_497\_1\_, transporte1\_.nmsSecondaryAddress as nmsSecon5\_497\_1\_, transporte1\_.manufacturer as manufact6\_497\_1\_, transporte1\_.zoneType as zoneType7\_497\_1\_, transporte1\_.Discriminator as Discrimi2\_497\_1\_ from Table1 transporte0\_ inner join ManagedObject transporte0\_1\_ on transporte0\_.MOID=transporte0\_1\_.MOID left outer join Table1UserData transporte1\_ on transporte0\_.MOID=transporte1\_.MOID where transporte0\_.MOID=?

---

<div class="post-metadata">

**Author:** ![Aparna\_Eswaran](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.hibernate.org/aparna_eswaran/32/1913_2.png) [@Aparna\_Eswaran](https://discourse.hibernate.org/u/Aparna_Eswaran)\
**Post date:** [July 14, 2022, 5:25am UTC](https://discourse.hibernate.org/t/issue-in-query-formation-using-5-6-7-jar/6492/3 "2022-07-14T05:25:04Z")

</div>

**Query formed using 5.6.7 jar:**

> Hibernate: select mo0\_.MOID as moid1\_235\_41\_, mo0\_.NAME as name2\_235\_41\_, mo0\_.DISPLAYNAME as displayn3\_235\_41\_, mo0\_.TYPE as type4\_235\_41\_, mo0\_.MANAGED as managed5\_235\_41\_, mo0\_.STATUS as status6\_235\_41\_, mo0\_.PARENTKEY as parentke7\_235\_41\_, mo0\_.PARENTMOID as parentmo8\_235\_41\_, mo0\_.CREATEDTIME as createdt9\_235\_41\_, mo0\_.LASTMODIFIEDTIME as lastmod10\_235\_41\_, mo0\_1\_.userLabel as userlabe2\_495\_41\_, mo0\_1\_.nativeEmsName as nativeem3\_495\_41\_, mo0\_1\_.emsType as emstype6\_495\_41\_, mo0\_2\_.productName as productn7\_242\_41\_, mo0\_2\_.communicationState as communic8\_242\_41\_, mo0\_2\_.emsInSyncState as emsinsyn9\_242\_41\_, mo0\_2\_.address as address11\_242\_41\_, mo0\_2\_.manufacturer as manufac12\_242\_41\_, mo0\_2\_.inventoryStatus as invento14\_242\_41\_, mo0\_2\_.sourceOfME as sourceo15\_242\_41\_, mo0\_3\_.transmissionParams as transmis6\_351\_41\_, mo0\_3\_.protectionAssociation as protecti7\_351\_41\_, mo0\_3\_.ptpId as ptpid9\_351\_41\_, mo0\_3\_.sourceOfPTP as sourceo10\_351\_41\_, mo0\_3\_.inventoryStatus as invento11\_351\_41\_, mo0\_4\_.userLabel as userlabe2\_164\_41\_, mo0\_4\_.owner as owner4\_164\_41\_, mo0\_4\_.inventoryStatus as invento13\_164\_41\_, mo0\_5\_.userLabel as userlabe2\_51\_41\_, mo0\_5\_.SourceOfCTP as sourceo11\_51\_41\_, mo0\_5\_.SourceOfCTPDerivation as sourceo12\_51\_41\_, mo0\_6\_.userLabel as userlabe2\_121\_41\_, mo0\_6\_.nativeEmsName as nativeem3\_121\_41\_, mo0\_6\_.owner as owner4\_121\_41\_, mo0\_7\_.nativeEmsName as nativeem3\_119\_41\_, mo0\_7\_.expectedEquipmentObjectType as expected7\_119\_41\_, mo0\_7\_.installedEquipmentObjectType as installe8\_119\_41\_, mo0\_7\_.installedPartNumber as installe9\_119\_41\_, mo0\_8\_.userLabel as userlabe2\_482\_41\_, mo0\_8\_.nativeEmsName as nativeem3\_482\_41\_, mo0\_8\_.sourceOfTL as sourceo11\_482\_41\_, mo0\_8\_.inventoryStatus as invento12\_482\_41\_, mo0\_8\_.tlType as tltype13\_482\_41\_, mo0\_8\_.meVneTLType as mevnetl14\_482\_41\_, mo0\_9\_.supportedRates as supporte6\_285\_41\_, mo0\_10\_.userLabel as userlabe2\_336\_41\_, mo0\_10\_.nativeEmsName as nativeem3\_336\_41\_, mo0\_10\_.owner as owner4\_336\_41\_, mo0\_10\_.protectionGroupType as protecti5\_336\_41\_, mo0\_11\_.userLabel as userlabe2\_114\_41\_, mo0\_12\_.userLabel as userlabe2\_537\_41\_, mo0\_12\_.nativeEmsName as nativeem3\_537\_41\_, mo0\_12\_.location as location4\_537\_41\_, mo0\_12\_.remarks as remarks5\_537\_41\_, mo0\_12\_.inventoryStatus as inventor6\_537\_41\_, mo0\_13\_.userLabel as userlabe2\_532\_41\_, mo0\_14\_.label as label2\_397\_41\_, mo0\_14\_.layerRate as layerrat3\_397\_41\_, mo0\_14\_.sourcePTP as sourcept4\_397\_41\_, mo0\_14\_.destinationPTP as destinat5\_397\_41\_, mo0\_15\_.SOURCEOFSNC as sourceo14\_427\_41\_, mo0\_15\_.SNCOperation as sncoper15\_427\_41\_, mo0\_16\_.state as state2\_11\_41\_, mo0\_16\_.customerName as customer3\_11\_41\_, mo0\_16\_.circuitId as circuiti4\_11\_41\_, mo0\_16\_.label as label5\_11\_41\_, mo0\_16\_.dummyStatus as dummyst12\_11\_41\_, mo0\_16\_.sourceOfService as sourceo13\_11\_41\_, mo0\_16\_.stitchingStatus as stitchi14\_11\_41\_, mo0\_17\_.userLabel as userlabe2\_157\_41\_, mo0\_18\_.userLabel as userlabe2\_159\_41\_, mo0\_18\_.nativeEmsName as nativeem3\_159\_41\_, mo0\_18\_.owner as owner4\_159\_41\_, mo0\_18\_.adminState as adminst11\_159\_41\_, mo0\_18\_.SOURCEOFFDFR as sourceo12\_159\_41\_, mo0\_18\_.FDFrOperation as fdfrope13\_159\_41\_, mo0\_18\_.dummyStatus as dummyst14\_159\_41\_, mo0\_19\_.userLabel as userlabe2\_238\_41\_, mo0\_19\_.nativeEmsName as nativeem3\_238\_41\_, mo0\_19\_.owner as owner4\_238\_41\_, mo0\_19\_.networkAccessDomain as networka5\_238\_41\_, mo0\_19\_.flexible as flexible6\_238\_41\_, mo0\_20\_.reversionMode as reversio7\_504\_41\_, mo0\_20\_.layerRate as layerrat8\_504\_41\_, mo0\_20\_.inventoryStatus as inventor9\_504\_41\_, mo0\_21\_.userLabel as userlabe2\_209\_41\_, mo0\_21\_.nativeEmsName as nativeem3\_209\_41\_, mo0\_21\_.workerTP as workertp8\_209\_41\_, mo0\_21\_.externalCommand as external9\_209\_41\_, mo0\_22\_.userLabel as userlabe2\_494\_41\_, mo0\_22\_.nativeEmsName as nativeem3\_494\_41\_, mo0\_22\_.owner as owner4\_494\_41\_, mo0\_22\_.trailNtwProtectionType as trailntw9\_494\_41\_, mo0\_22\_.protectionGroupAName as protect10\_494\_41\_, mo0\_22\_.protectionGroupZName as protect11\_494\_41\_, mo0\_22\_.apsFunction as apsfunc12\_494\_41\_, mo0\_22\_.networkAccessDomain as network13\_494\_41\_, mo0\_22\_.tnpId as tnpid14\_494\_41\_, mo0\_22\_.SourceOfTNPDerivation as sourceo18\_494\_41\_, mo0\_23\_.userLabel as userlabe2\_542\_41\_, mo0\_23\_.nativeEmsName as nativeem3\_542\_41\_, mo0\_23\_.owner as owner4\_542\_41\_, mo0\_23\_.protectionGroupType as protecti5\_542\_41\_, mo0\_23\_.layerRate as layerrat8\_542\_41\_, mo0\_23\_.inventoryStatus as inventor9\_542\_41\_, mo0\_24\_.userLabel as userlabe2\_270\_41\_, mo0\_24\_.nativeEmsName as nativeem3\_270\_41\_, mo0\_24\_.reversionMode as reversio7\_270\_41\_, mo0\_25\_.ODF\_TYPE as odf\_type2\_319\_41\_, mo0\_25\_.ODF\_CAPACITY as odf\_capa3\_319\_41\_, mo0\_25\_.SITE\_NAME as site\_nam4\_319\_41\_, mo0\_26\_.SplittetType as splittet2\_453\_41\_, mo0\_27\_.Label as label2\_450\_41\_, mo0\_27\_.Capacity as capacity3\_450\_41\_, mo0\_28\_.AENDOBJECTID as aendobje2\_334\_41\_, mo0\_28\_.ZENDOBJECTID as zendobje3\_334\_41\_, mo0\_28\_.AENDOBJECTTYPE as aendobje4\_334\_41\_, mo0\_28\_.ZENDOBJECTTYPE as zendobje5\_334\_41\_, mo0\_28\_.APORTID as aportid6\_334\_41\_, mo0\_28\_.ZPORTID as zportid7\_334\_41\_, mo0\_28\_.APORTROLE as aportro10\_334\_41\_, mo0\_28\_.ZPORTROLE as zportro11\_334\_41\_, mo0\_29\_.userLabel as userlabe2\_420\_41\_, mo0\_29\_.BANDWIDTH as bandwidt3\_420\_41\_, mo0\_29\_.SERVICE\_SOURCE as service\_8\_420\_41\_, mo0\_29\_.ACTIVATED\_DATE as activate9\_420\_41\_, mo0\_29\_.DEACTIVATED\_DATE as deactiv10\_420\_41\_, mo0\_30\_.state as state2\_37\_41\_, mo0\_30\_.direction as directio3\_37\_41\_, mo0\_30\_.stitchingStatus as stitchin9\_37\_41\_, mo0\_30\_.derivedServiceType as derived10\_37\_41\_, mo0\_31\_.userLabel as userlabe2\_409\_41\_, mo0\_31\_.zEndME as zendme5\_409\_41\_, mo0\_32\_.userLabel as userlabe2\_406\_41\_, mo0\_32\_.nativeEmsName as nativeem3\_406\_41\_, mo0\_32\_.owner as owner4\_406\_41\_, mo0\_32\_.bandwidthLockout as bandwid10\_406\_41\_, mo0\_32\_.protocolState as protoco11\_406\_41\_, mo0\_32\_.containingRoutingLink as contain12\_406\_41\_, mo0\_33\_.sourceOfVL as sourceof5\_530\_41\_, mo0\_33\_.inventoryStatus as inventor6\_530\_41\_, mo0\_33\_.aendNEId as aendneid7\_530\_41\_, mo0\_33\_.zendNEId as zendneid8\_530\_41\_, mo0\_34\_.LABEL as label2\_485\_41\_, mo0\_34\_.TOPOLOGYTYPE as topology3\_485\_41\_, mo0\_34\_.TOPOLOGYLEVEL as topology4\_485\_41\_, mo0\_34\_.SOURCEOFTOPOLOGY as sourceof5\_485\_41\_, mo0\_35\_.userLabel as userlabe2\_25\_41\_, mo0\_35\_.zEndCTPMoid as zendctpm8\_25\_41\_, mo0\_35\_.roleOfZEndCTP as roleofze9\_25\_41\_, mo0\_35\_.aEndPTPName as aendptp10\_25\_41\_, mo0\_35\_.aEndPTPMoid as aendptp11\_25\_41\_, mo0\_35\_.zEndPTPName as zendptp12\_25\_41\_, mo0\_35\_.zEndPTPMoid as zendptp13\_25\_41\_, mo0\_35\_.rate as rate18\_25\_41\_, mo0\_35\_.connectionDirection as connect19\_25\_41\_, mo0\_35\_.connectionType as connect20\_25\_41\_, mo0\_35\_.connectionTechnology as connect21\_25\_41\_, mo0\_35\_.sourceOfCFC as sourceo22\_25\_41\_, mo0\_36\_.userLabel as userlabe2\_310\_41\_, mo0\_36\_.roleOfZEndCTP as roleofze9\_310\_41\_, mo0\_36\_.aEndPTPName as aendptp10\_310\_41\_, mo0\_36\_.aEndPTPMoid as aendptp11\_310\_41\_, mo0\_36\_.zEndPTPName as zendptp12\_310\_41\_, mo0\_36\_.connectionDirection as connect19\_310\_41\_, mo0\_36\_.connectionType as connect20\_310\_41\_, mo0\_36\_.connectionTechnology as connect21\_310\_41\_, mo0\_36\_.sourceOfNFC as sourceo22\_310\_41\_, mo0\_37\_.userLabel as userlabe2\_190\_41\_, mo0\_38\_.userLabel as userlabe2\_194\_41\_, mo0\_38\_.nativeEmsName as nativeem3\_194\_41\_, mo0\_38\_.MENAME as mename4\_194\_41\_, mo0\_38\_.EXPORT\_ROUTETARGET as export\_r8\_194\_41\_, mo0\_39\_.userLabel as userlabe2\_447\_41\_, mo0\_39\_.nativeEmsName as nativeem3\_447\_41\_, mo0\_39\_.direction as directio7\_447\_41\_, mo0\_39\_.rates as rates8\_447\_41\_, mo0\_39\_.cost as cost9\_447\_41\_, mo0\_39\_.linkCapacities as linkcap10\_447\_41\_, mo0\_39\_.srlgs as srlgs13\_447\_41\_, mo0\_41\_.userLabel as userlabe2\_232\_41\_, mo0\_41\_.vendor as vendor6\_232\_41\_, mo0\_42\_.userLabel as userlabe2\_231\_41\_, mo0\_42\_.nativeEmsName as nativeem3\_231\_41\_, mo0\_42\_.owner as owner4\_231\_41\_, mo0\_42\_.vendor as vendor9\_231\_41\_, mo0\_43\_.userLabel as userlabe2\_234\_41\_, mo0\_43\_.owner as owner4\_234\_41\_, mo0\_43\_.tpName as tpname5\_234\_41\_, mo0\_44\_.topologyLabel as topology2\_278\_41\_, mo0\_44\_.topologyType as topology3\_278\_41\_, mo0\_45\_.label as label2\_300\_41\_, mo0\_45\_.networkProtectionType as networkp3\_300\_41\_, mo0\_45\_.STITCHING\_STATUS as stitchin4\_300\_41\_, mo0\_45\_.lastModifiedReason as lastmodi5\_300\_41\_, case when mo0\_1\_.MOID is not null then 1 when mo0\_2\_.MOID is not null then 2 when mo0\_3\_.MOID is not null then 3 when mo0\_4\_.MOID is not null then 4 when mo0\_5\_.MOID is not null then 5 when mo0\_6\_.MOID is not null then 6 when mo0\_7\_.MOID is not null then 7 when mo0\_8\_.MOID is not null then 8 when mo0\_9\_.MOID is not null then 9 when mo0\_10\_.MOID is not null then 10 when mo0\_11\_.MOID is not null then 11 when mo0\_12\_.MOID is not null then 12 when mo0\_13\_.MOID is not null then 13 when mo0\_14\_.MOID is not null then 14 when mo0\_15\_.MOID is not null then 15 when mo0\_16\_.MOID is not null then 16 when mo0\_17\_.MOID is not null then 17 when mo0\_18\_.MOID is not null then 18 when mo0\_19\_.MOID is not null then 19 when mo0\_20\_.MOID is not null then 20 when mo0\_21\_.MOID is not null then 21 when mo0\_22\_.MOID is not null then 22 when mo0\_23\_.MOID is not null then 23 when mo0\_24\_.MOID is not null then 24 when mo0\_25\_.MOID is not null then 25 when mo0\_26\_.MOID is not null then 26 when mo0\_27\_.MOID is not null then 27 when mo0\_28\_.MOID is not null then 28 when mo0\_29\_.MOID is not null then 29 when mo0\_30\_.MOID is not null then 30 when mo0\_31\_.MOID is not null then 31 when mo0\_32\_.MOID is not null then 32 when mo0\_33\_.MOID is not null then 33 when mo0\_34\_.MOID is not null then 34 when mo0\_35\_.MOID is not null then 35 when mo0\_36\_.MOID is not null then 36 when mo0\_37\_.MOID is not null then 37 when mo0\_38\_.MOID is not null then 38 when mo0\_39\_.MOID is not null then 39 when mo0\_40\_.MOID is not null then 40 when mo0\_41\_.MOID is not null then 41 when mo0\_42\_.MOID is not null then 42 when mo0\_43\_.MOID is not null then 43 when mo0\_44\_.MOID is not null then 44 when mo0\_45\_.MOID is not null then 45 when mo0\_.MOID is not null then 0 end as clazz\_41\_, table1userdata1\_.MOID as moid1\_496\_0\_, table1userdata1\_.label as label3\_496\_0\_, table1userdata1\_.nmsPrimaryAddress as nmsprima4\_496\_0\_, table1userdata1\_.nmsSecondaryAddress as nmssecon5\_496\_0\_, table1userdata1\_.manufacturer as manufact6\_496\_0\_, table1userdata1\_.zoneType as zonetype7\_496\_0\_, table1userdata1\_.Discriminator as discrimi2\_496\_0\_, table2userdata2\_.MOID as moid1\_258\_1\_, table2userdata2\_.label as label3\_258\_1\_, table2userdata2\_.isGNE as isgne4\_258\_1\_, table2userdata2\_.gneReference as gnerefer5\_258\_1\_, table2userdata2\_.firstClockSourceType as firstclo6\_258\_1\_, table2userdata2\_.firstClockSourcePort as firstclo7\_258\_1\_, table2userdata2\_.secondClockSourceType as secondcl8\_258\_1\_, table2userdata2\_.secondClockSourcePort as secondcl9\_258\_1\_, table2userdata2\_.thirdClockSourceType as thirdcl10\_258\_1\_, table2userdata2\_.thirdClockSourcePort as thirdcl11\_258\_1\_, table2userdata2\_.fourthClockSourceType as fourthc12\_258\_1\_, table2userdata2\_.fourthClockSourcePort as fourthc13\_258\_1\_, table2userdata2\_.ethernetIPAddress as etherne14\_258\_1\_, table2userdata2\_.ethernetSubnetMask as etherne15\_258\_1\_, table2userdata2\_.dcnSubNetworkMask as dcnsubn16\_258\_1\_, table2userdata2\_.domain as domain17\_258\_1\_, table2userdata2\_.communicationStateChangeTime as communi18\_258\_1\_, table2userdata2\_.backPlaneTotalCapacity as backpla19\_258\_1\_, table2userdata2\_.lsrId as lsrid20\_258\_1\_, table2userdata2\_.asonId as asonid21\_258\_1\_, table2userdata2\_.backPlaneUsedCapacity as backpla22\_258\_1\_, table2userdata2\_.fmInventoryName as fminven23\_258\_1\_, table2userdata2\_.technologyOrDomain as technol24\_258\_1\_, table2userdata2\_.deviceType as devicet25\_258\_1\_, table2userdata2\_.switchType as switcht26\_258\_1\_, table2userdata2\_.zoneType as zonetyp27\_258\_1\_, table2userdata2\_.Discriminator as discrimi2\_258\_1\_, table3userdata3\_.MOID as moid1\_371\_2\_, table3userdata3\_.label as label3\_371\_2\_, table3userdata3\_.frequency as frequenc4\_371\_2\_, table3userdata3\_.useInterTechnologyLink as useinter5\_371\_2\_, table3userdata3\_.portRate as portrate6\_371\_2\_, table3userdata3\_.portType as porttype7\_371\_2\_, table3userdata3\_.interfaceType as interfac8\_371\_2\_, table3userdata3\_.portRateSource as portrate9\_371\_2\_, table3userdata3\_.portTypeSource as porttyp10\_371\_2\_, table3userdata3\_.interfaceTypeSource as interfa11\_371\_2\_, table3userdata3\_.dynamic as dynamic12\_371\_2\_, table3userdata3\_.sendTrace as sendtra13\_371\_2\_, table3userdata3\_.receiveTrace as receive14\_371\_2\_, table3userdata3\_.traceSource as traceso15\_371\_2\_, table3userdata3\_.traceStatus as tracest16\_371\_2\_, table3userdata3\_.tracesetTime as tracese17\_371\_2\_, table3userdata3\_.tracereceiveTime as tracere18\_371\_2\_, table3userdata3\_.alarmDetectionCapability as alarmde19\_371\_2\_, table3userdata3\_.tubeColor as tubecol20\_371\_2\_, table3userdata3\_.strandColor as strandc21\_371\_2\_, table3userdata3\_.lagMaster as lagmast22\_371\_2\_, table3userdata3\_.portDomain as portdom23\_371\_2\_, table3userdata3\_.newPortType as newport24\_371\_2\_, table3userdata3\_.currentPortType as current25\_371\_2\_, table3userdata3\_.facingType as facingt26\_371\_2\_, table3userdata3\_.fmInventoryName as fminven27\_371\_2\_, table4userdata4\_.MOID as moid1\_176\_3\_, table4userdata4\_.label as label3\_176\_3\_, table4userdata4\_.ftpRate as ftprate4\_176\_3\_, table4userdata4\_.ftpType as ftptype5\_176\_3\_, table4userdata4\_.ftpDomain as ftpdomai6\_176\_3\_, table4userdata4\_.lagFtp as lagftp7\_176\_3\_, table4userdata4\_.oduFlexEnabled as oduflexe8\_176\_3\_, table4userdata4\_.lagSharingType as lagshari9\_176\_3\_, table4userdata4\_.newFtpType as newftpt10\_176\_3\_, table4userdata4\_.ftpTypeSource as ftptype11\_176\_3\_, table4userdata4\_.ftpRateSource as ftprate12\_176\_3\_, table4userdata4\_.clientOTNBindingPort as cliento13\_176\_3\_, table4userdata4\_.fmInventoryName as fminven14\_176\_3\_, table5userdata5\_.MOID as moid1\_54\_4\_, table5userdata5\_.frequency as frequenc3\_54\_4\_, table5userdata5\_.hangingType as hangingt4\_54\_4\_, table5userdata5\_.isLooped as islooped5\_54\_4\_, table5userdata5\_.isDynamic as isdynami6\_54\_4\_, table5userdata5\_.occCTPTxParam as occctptx7\_54\_4\_, table5userdata5\_.occCTPName as occctpna8\_54\_4\_, table6userdata6\_.MOID as moid1\_123\_5\_, table6userdata6\_.label as label3\_123\_5\_, table6userdata6\_.fmInventoryName as fminvent4\_123\_5\_, table7userdata7\_.MOID as moid1\_125\_6\_, table7userdata7\_.label as label3\_125\_6\_, table7userdata7\_.hardwareVersion as hardware4\_125\_6\_, table7userdata7\_.softwareVersion as software5\_125\_6\_, table7userdata7\_.firmwareVersion as firmware6\_125\_6\_, table7userdata7\_.sfpType as sfptype7\_125\_6\_, table7userdata7\_.equipType as equiptyp8\_125\_6\_, table7userdata7\_.reconEquipType as reconequ9\_125\_6\_, table7userdata7\_.equipmentPortion as equipme10\_125\_6\_, table7userdata7\_.fmInventoryName as fminven11\_125\_6\_, table8userdata8\_.MOID as moid1\_484\_7\_, table8userdata8\_.label as label3\_484\_7\_, table8userdata8\_.derivedTopologyLabel as derivedt4\_484\_7\_, table8userdata8\_.involvedTopologyLabel as involved5\_484\_7\_, table8userdata8\_.asonEnabled as asonenab6\_484\_7\_, table8userdata8\_.interEms as interems7\_484\_7\_, table8userdata8\_.interVendor as interven8\_484\_7\_, table8userdata8\_.vendorName as vendorna9\_484\_7\_, table8userdata8\_.isPhysicalCkt as isphysi10\_484\_7\_, table8userdata8\_.phyLogTLType as phylogt11\_484\_7\_, table8userdata8\_.meMETLAvailabilityForMEVNETL as memetla12\_484\_7\_, table8userdata8\_.linkDomain as linkdom13\_484\_7\_, table8userdata8\_.interDomain as interdo14\_484\_7\_, table8userdata8\_.mplsEnabled as mplsena15\_484\_7\_, table8userdata8\_.logicalTLSubType as logical16\_484\_7\_, table8userdata8\_.bitRate as bitrate17\_484\_7\_, table8userdata8\_.zoneType as zonetyp18\_484\_7\_, table8userdata8\_.zoneConnectivityType as zonecon19\_484\_7\_, table8userdata8\_.siteConnectivityType as sitecon20\_484\_7\_, table8userdata8\_.Discriminator as discrimi2\_484\_7\_, table10userdata9\_.MOID as moid1\_342\_8\_, table10userdata9\_.label as label3\_342\_8\_, table10userdata9\_.rcaPgpHash as rcapgpha4\_342\_8\_, table12userdata10\_.MOID as moid1\_540\_9\_, table12userdata10\_.label as label3\_540\_9\_, table12userdata10\_.networkedge as networke4\_540\_9\_, table12userdata10\_.type as type5\_540\_9\_, table12userdata10\_.iconType as icontype6\_540\_9\_, table13userdata11\_.MOID as moid1\_535\_10\_, table13userdata11\_.label as label3\_535\_10\_, table15userdata12\_.MOID as moid1\_446\_11\_, table15userdata12\_.label as label3\_446\_11\_, table15userdata12\_.customerName as customer4\_446\_11\_, table15userdata12\_.circuitId as circuiti5\_446\_11\_, table15userdata12\_.asonEnabled as asonenab6\_446\_11\_, table15userdata12\_.workerSNCStatus as workersn7\_446\_11\_, table15userdata12\_.protectingSNCStatus as protecti8\_446\_11\_, table15userdata12\_.workerSNCOnHomeRouteEnabled as workersn9\_446\_11\_, table15userdata12\_.protSNCOnHomeRouteEnabled as protsnc10\_446\_11\_, table15userdata12\_.sncType as snctype11\_446\_11\_, table15userdata12\_.asonWorkerPathMD5 as asonwor12\_446\_11\_, table15userdata12\_.asonProtectionPathMD5 as asonpro13\_446\_11\_, table15userdata12\_.asonCombinedPathMD5 as asoncom14\_446\_11\_, table15userdata12\_.circuitProtectionClass as circuit15\_446\_11\_, table15userdata12\_.routeTypes as routety16\_446\_11\_, table15userdata12\_.dynamicSwitchingCapable as dynamic17\_446\_11\_, proprietar13\_.MOID as moid1\_348\_12\_, proprietar13\_.LASTMODIFIEDTIME as lastmodi3\_348\_12\_, proprietar13\_1\_.intended as intended2\_329\_12\_, proprietar13\_1\_.actualState as actualst3\_329\_12\_, proprietar13\_1\_.administrativeState as administ4\_329\_12\_, proprietar13\_1\_.inUseBy as inuseby5\_329\_12\_, proprietar13\_1\_.exclusive1 as exclusiv6\_329\_12\_, proprietar13\_1\_.soureOfSNC as soureofs7\_329\_12\_, proprietar13\_.discriminator as discrimi2\_348\_12\_, table16userdata14\_.MOID as moid1\_17\_13\_, table16userdata14\_.interEms as interems3\_17\_13\_, table16userdata14\_.interVendor as interven4\_17\_13\_, table16userdata14\_.vendorName as vendorna5\_17\_13\_, table16userdata14\_.circuitType as circuitt6\_17\_13\_, table16userdata14\_.circuitDomain as circuitd7\_17\_13\_, table16userdata14\_.circuitSubType as circuits8\_17\_13\_, table16userdata14\_.isASON as isason9\_17\_13\_, table16userdata14\_.trailId as trailid10\_17\_13\_, table16userdata14\_.serviceEligible as service11\_17\_13\_, table16userdata14\_.aEndLocation as aendloc12\_17\_13\_, table16userdata14\_.zEndLocation as zendloc13\_17\_13\_, table16userdata14\_.isDropped as isdropp14\_17\_13\_, table16errordetails15\_.MOID as moid1\_14\_14\_, table16errordetails15\_1\_.REASON as reason2\_502\_14\_, table16errordetails15\_2\_.REASON as reason2\_372\_14\_, table16errordetails15\_3\_.REASON as reason2\_188\_14\_, case when table16errordetails15\_1\_.MOID is not null then 1 when table16errordetails15\_2\_.MOID is not null then 2 when table16errordetails15\_3\_.MOID is not null then 3 when table16errordetails15\_.MOID is not null then 0 end as clazz\_14\_, table18userdata16\_.MOID as moid1\_160\_15\_, table18userdata16\_.customerName as customer3\_160\_15\_, table18userdata16\_.ivId as ivid4\_160\_15\_, table18userdata16\_.circuitId as circuiti5\_160\_15\_, table18userdata16\_.label as label6\_160\_15\_, table20userdata17\_.MOID as moid1\_508\_16\_, table20userdata17\_.label as label3\_508\_16\_, table21userdata18\_.MOID as moid1\_229\_17\_, table21userdata18\_.label as label3\_229\_17\_, table22userdata19\_.MOID as moid1\_480\_18\_, table22userdata19\_.label as label3\_480\_18\_, table23userdata20\_.MOID as moid1\_546\_19\_, table23userdata20\_.label as label3\_546\_19\_, table24userdata21\_.MOID as moid1\_274\_20\_, table24userdata21\_.label as label3\_274\_20\_, table25userdata22\_.MOID as moid1\_320\_21\_, table25userdata22\_.label as label3\_320\_21\_, table26userdata23\_.MOID as moid1\_454\_22\_, table26userdata23\_.label as label3\_454\_22\_, table27userdata24\_.MOID as moid1\_452\_23\_, table27userdata24\_.CustomerName as customer3\_452\_23\_, table28userdata25\_.MOID as moid1\_335\_24\_, table28userdata25\_.label as label3\_335\_24\_, table28userdata25\_.PATCH\_LINK\_TYPE as patch\_li4\_335\_24\_, table28userdata25\_.CRM\_ID as crm\_id5\_335\_24\_, table29userdata26\_.MOID as moid1\_422\_25\_, table29userdata26\_.DESIGNATION as designat3\_422\_25\_, table29userdata26\_.PRODUCT\_TYPE as product\_4\_422\_25\_, table29userdata26\_.MULTIPLE\_CIRCUITS as multiple5\_422\_25\_, table30userdata27\_.MOID as moid1\_35\_26\_, table30userdata27\_.vlanOrSvlan as vlanorsv3\_35\_26\_, table30userdata27\_.cvlan as cvlan4\_35\_26\_, table30userdata27\_.interEms as interems5\_35\_26\_, table30userdata27\_.interVendor as interven6\_35\_26\_, table30userdata27\_.vendorName as vendorna7\_35\_26\_, table30userdata27\_.taggingType as taggingt8\_35\_26\_, table30userdata27\_.trailId as trailid9\_35\_26\_, table30userdata27\_.defaultCosCIRbps as default10\_35\_26\_, table30userdata27\_.defaultCosEIRbps as default11\_35\_26\_, table30userdata27\_.defaultCosPIRbps as default12\_35\_26\_, table30userdata27\_.cos0CIRbps as cos13\_35\_26\_, table30userdata27\_.cos0EIRbps as cos14\_35\_26\_, table30userdata27\_.cos0PIRbps as cos15\_35\_26\_, table30userdata27\_.cos1CIRbps as cos16\_35\_26\_, table30userdata27\_.cos1EIRbps as cos17\_35\_26\_, table30userdata27\_.cos1PIRbps as cos18\_35\_26\_, table30userdata27\_.cos2CIRbps as cos19\_35\_26\_, table30userdata27\_.cos2EIRbps as cos20\_35\_26\_, table30userdata27\_.cos2PIRbps as cos21\_35\_26\_, table30userdata27\_.cos3CIRbps as cos22\_35\_26\_, table30userdata27\_.cos3EIRbps as cos23\_35\_26\_, table30userdata27\_.cos3PIRbps as cos24\_35\_26\_, table30userdata27\_.cos4CIRbps as cos25\_35\_26\_, table30userdata27\_.cos4EIRbps as cos26\_35\_26\_, table30userdata27\_.cos4PIRbps as cos27\_35\_26\_, table30userdata27\_.cos5CIRbps as cos28\_35\_26\_, table30userdata27\_.cos5EIRbps as cos29\_35\_26\_, table30userdata27\_.cos5PIRbps as cos30\_35\_26\_, table30userdata27\_.cos6CIRbps as cos31\_35\_26\_, table30userdata27\_.cos6EIRbps as cos32\_35\_26\_, table30userdata27\_.cos6PIRbps as cos33\_35\_26\_, table30userdata27\_.cos7CIRbps as cos34\_35\_26\_, table30userdata27\_.cos7EIRbps as cos35\_35\_26\_, table30userdata27\_.cos7PIRbps as cos36\_35\_26\_, table30userdata27\_.customerName as custome37\_35\_26\_, table30userdata27\_.circuitId as circuit38\_35\_26\_, table30userdata27\_.label as label39\_35\_26\_, table30userdata27\_.serviceEligible as service40\_35\_26\_, table30userdata27\_.aEndLocation as aendloc41\_35\_26\_, table30userdata27\_.zEndLocation as zendloc42\_35\_26\_, table30userdata27\_.isDropped as isdropp43\_35\_26\_, table31userdata28\_.MOID as moid1\_413\_27\_, table31userdata28\_.label as label3\_413\_27\_, table32userdata29\_.MOID as moid1\_408\_28\_, table32userdata29\_.label as label3\_408\_28\_, table34userdata30\_.MOID as moid1\_491\_29\_, table34userdata30\_.LABEL as label3\_491\_29\_, table34userdata30\_.TECHNOLOGY as technolo4\_491\_29\_, table34userdata30\_.INVOLVEDRATES as involved5\_491\_29\_, table34userdata30\_.INVOLVEDEMSNAMES as involved6\_491\_29\_, table34userdata30\_.AGGREGATENODE1 as aggregat7\_491\_29\_, table34userdata30\_.AGGREGATENODE2 as aggregat8\_491\_29\_, table35userdata31\_.MOID as moid1\_27\_30\_, table35userdata31\_.label as label3\_27\_30\_, table36userdata32\_.MOID as moid1\_316\_31\_, table36userdata32\_.label as label3\_316\_31\_, table36userdata32\_.aEndLocation as aendloca4\_316\_31\_, table36userdata32\_.zEndLocation as zendloca5\_316\_31\_, table37userdata33\_.MOID as moid1\_193\_32\_, table37userdata33\_.label as label3\_193\_32\_, table38userdata34\_.MOID as moid1\_198\_33\_, table38userdata34\_.label as label3\_198\_33\_, table38userdata34\_.fmInventoryName as fminvent4\_198\_33\_, table39userdata35\_.MOID as moid1\_449\_34\_, table39userdata35\_.label as label3\_449\_34\_, table41userdata36\_.MOID as moid1\_241\_35\_, table41userdata36\_.label as label3\_241\_35\_, table42userdata37\_.MOID as moid1\_239\_36\_, table42userdata37\_.label as label3\_239\_36\_, table43userdata38\_.MOID as moid1\_255\_37\_, table43userdata38\_.label as label3\_255\_37\_, table44userdata39\_.MOID as moid1\_282\_38\_, table44userdata39\_.InvolvedEMSNames as involved3\_282\_38\_, table44userdata39\_.MPLSNetworkId as mplsnetw4\_282\_38\_, protection40\_.MOID as moid1\_349\_39\_, protection40\_1\_.workerAEndTP as workerae2\_493\_39\_, protection40\_1\_.workerZEndTP as workerze3\_493\_39\_, protection40\_1\_.protectionAEndTP as protecti4\_493\_39\_, protection40\_1\_.protectionZEndTP as protecti5\_493\_39\_, protection40\_1\_.workerConnection as workerco6\_493\_39\_, protection40\_1\_.protectionConnection as protecti7\_493\_39\_, protection40\_1\_.sourceObjectType as sourceob8\_493\_39\_, protection40\_1\_.sourceObjectOne as sourceob9\_493\_39\_, protection40\_1\_.sourceObjectTwo as sourceo10\_493\_39\_, protection40\_1\_.layerRate as layerra11\_493\_39\_, protection40\_1\_.reversionMode as reversi12\_493\_39\_, protection40\_1\_.wtrTime as wtrtime13\_493\_39\_, protection40\_1\_.holdOffTime as holdoff14\_493\_39\_, protection40\_2\_.FDFR\_NAME as fdfr\_nam2\_127\_39\_, protection40\_2\_.FDFR\_ID as fdfr\_id3\_127\_39\_, protection40\_2\_.FDFR\_LABEL as fdfr\_lab4\_127\_39\_, protection40\_2\_.RPL\_PORT\_NAME as rpl\_port5\_127\_39\_, protection40\_2\_.NEIGHBOURING\_RPL\_PORT\_NAME as neighbou6\_127\_39\_, protection40\_3\_.ReversionMode as reversio2\_501\_39\_, protection40\_3\_.WaitToRestoreTime as waittore3\_501\_39\_, case when protection40\_1\_.moid is not null then 1 when protection40\_2\_.moid is not null then 2 when protection40\_3\_.MOID is not null then 3 when protection40\_.MOID is not null then 0 end as clazz\_39\_, table45errordetails41\_.MOID as moid1\_306\_40\_, table45errordetails41\_1\_.NO\_OF\_GRAPHS as no\_of\_gr2\_128\_40\_, case when table45errordetails41\_1\_.MOID is not null then 1 when table45errordetails41\_.MOID is not null then 0 end as clazz\_40\_ from ManagedObject mo0\_ left outer join Table1 mo0\_1\_ on mo0\_.MOID=mo0\_1\_.MOID left outer join Table2 mo0\_2\_ on mo0\_.MOID=mo0\_2\_.MOID left outer join Table3 mo0\_3\_ on mo0\_.MOID=mo0\_3\_.MOID left outer join Table4 mo0\_4\_ on mo0\_.MOID=mo0\_4\_.MOID left outer join Table5 mo0\_5\_ on mo0\_.MOID=mo0\_5\_.MOID left outer join Table6 mo0\_6\_ on mo0\_.MOID=mo0\_6\_.MOID left outer join Table7 mo0\_7\_ on mo0\_.MOID=mo0\_7\_.MOID left outer join Table8 mo0\_8\_ on mo0\_.MOID=mo0\_8\_.MOID left outer join Table9 mo0\_9\_ on mo0\_.MOID=mo0\_9\_.MOID left outer join Table10 mo0\_10\_ on mo0\_.MOID=mo0\_10\_.MOID left outer join Table11 mo0\_11\_ on mo0\_.MOID=mo0\_11\_.MOID left outer join Table12 mo0\_12\_ on mo0\_.MOID=mo0\_12\_.MOID left outer join Table13 mo0\_13\_ on mo0\_.MOID=mo0\_13\_.MOID left outer join Table14 mo0\_14\_ on mo0\_.MOID=mo0\_14\_.MOID left outer join Table15 mo0\_15\_ on mo0\_.MOID=mo0\_15\_.MOID left outer join Table16 mo0\_16\_ on mo0\_.MOID=mo0\_16\_.MOID left outer join Table17 mo0\_17\_ on mo0\_.MOID=mo0\_17\_.MOID left outer join Table18 mo0\_18\_ on mo0\_.MOID=mo0\_18\_.MOID left outer join Table19 mo0\_19\_ on mo0\_.MOID=mo0\_19\_.MOID left outer join Table20 mo0\_20\_ on mo0\_.MOID=mo0\_20\_.MOID left outer join Table21 mo0\_21\_ on mo0\_.MOID=mo0\_21\_.MOID left outer join Table22 mo0\_22\_ on mo0\_.MOID=mo0\_22\_.MOID left outer join Table23 mo0\_23\_ on mo0\_.MOID=mo0\_23\_.MOID left outer join Table24 mo0\_24\_ on mo0\_.MOID=mo0\_24\_.MOID left outer join Table25 mo0\_25\_ on mo0\_.MOID=mo0\_25\_.MOID left outer join Table26 mo0\_26\_ on mo0\_.MOID=mo0\_26\_.MOID left outer join Table27 mo0\_27\_ on mo0\_.MOID=mo0\_27\_.MOID left outer join Table28 mo0\_28\_ on mo0\_.MOID=mo0\_28\_.MOID left outer join Table29 mo0\_29\_ on mo0\_.MOID=mo0\_29\_.MOID left outer join Table30 mo0\_30\_ on mo0\_.MOID=mo0\_30\_.MOID left outer join Table31 mo0\_31\_ on mo0\_.MOID=mo0\_31\_.MOID left outer join Table32 mo0\_32\_ on mo0\_.MOID=mo0\_32\_.MOID left outer join Table33 mo0\_33\_ on mo0\_.MOID=mo0\_33\_.MOID left outer join Table34 mo0\_34\_ on mo0\_.MOID=mo0\_34\_.MOID left outer join Table35 mo0\_35\_ on mo0\_.MOID=mo0\_35\_.MOID left outer join Table36 mo0\_36\_ on mo0\_.MOID=mo0\_36\_.MOID left outer join Table37 mo0\_37\_ on mo0\_.MOID=mo0\_37\_.MOID left outer join Table38 mo0\_38\_ on mo0\_.MOID=mo0\_38\_.MOID left outer join Table39 mo0\_39\_ on mo0\_.MOID=mo0\_39\_.MOID left outer join Table40 mo0\_40\_ on mo0\_.MOID=mo0\_40\_.MOID left outer join Table41 mo0\_41\_ on mo0\_.MOID=mo0\_41\_.MOID left outer join Table42 mo0\_42\_ on mo0\_.MOID=mo0\_42\_.MOID left outer join Table43 mo0\_43\_ on mo0\_.MOID=mo0\_43\_.MOID left outer join Table44 mo0\_44\_ on mo0\_.MOID=mo0\_44\_.MOID left outer join Table45 mo0\_45\_ on mo0\_.MOID=mo0\_45\_.MOID left outer join Table1UserData table1userdata1\_ on mo0\_.MOID=table1userdata1\_.MOID left outer join Table2UserData table2userdata2\_ on mo0\_.MOID=table2userdata2\_.MOID left outer join Table3UserData table3userdata3\_ on mo0\_.MOID=table3userdata3\_.MOID left outer join Table4UserData table4userdata4\_ on mo0\_.MOID=table4userdata4\_.MOID left outer join Table5UserData table5userdata5\_ on mo0\_.MOID=table5userdata5\_.MOID left outer join Table6UserData table6userdata6\_ on mo0\_.MOID=table6userdata6\_.MOID left outer join Table7UserData table7userdata7\_ on mo0\_.MOID=table7userdata7\_.MOID left outer join Table8UserData table8userdata8\_ on mo0\_.MOID=table8userdata8\_.MOID left outer join Table10UserData table10userdata9\_ on mo0\_.MOID=table10userdata9\_.MOID left outer join Table12UserData table12userdata10\_ on mo0\_.MOID=table12userdata10\_.MOID left outer join Table13UserData table13userdata11\_ on mo0\_.MOID=table13userdata11\_.MOID left outer join Table15UserData table15userdata12\_ on mo0\_.MOID=table15userdata12\_.MOID left outer join ProprietaryTable proprietar13\_ on mo0\_.MOID=proprietar13\_.MOID left outer join SubProprietaryTable proprietar13\_1\_ on proprietar13\_.MOID=proprietar13\_1\_.SNCMOID left outer join Table16UserData table16userdata14\_ on mo0\_.MOID=table16userdata14\_.MOID left outer join Table16ErrorDetails table16errordetails15\_ on mo0\_.MOID=table16errordetails15\_.MOID left outer join Table16ErrorDetails\_1 table16errordetails15\_1\_ on table16errordetails15\_.MOID=table16errordetails15\_1\_.MOID left outer join Table16ErrorDetails\_2 table16errordetails15\_2\_ on table16errordetails15\_.MOID=table16errordetails15\_2\_.MOID left outer join Table16ErrorDetails\_3 table16errordetails15\_3\_ on table16errordetails15\_.MOID=table16errordetails15\_3\_.MOID left outer join Table18UserData table18userdata16\_ on mo0\_.MOID=table18userdata16\_.MOID left outer join Table20UserData table20userdata17\_ on mo0\_.MOID=table20userdata17\_.MOID left outer join Table21UserData table21userdata18\_ on mo0\_.MOID=table21userdata18\_.MOID left outer join Table22UserData table22userdata19\_ on mo0\_.MOID=table22userdata19\_.MOID left outer join Table23UserData table23userdata20\_ on mo0\_.MOID=table23userdata20\_.MOID left outer join Table24UserData table24userdata21\_ on mo0\_.MOID=table24userdata21\_.MOID left outer join Table25UserData table25userdata22\_ on mo0\_.MOID=table25userdata22\_.MOID left outer join Table26UserData table26userdata23\_ on mo0\_.MOID=table26userdata23\_.MOID left outer join Table27UserData table27userdata24\_ on mo0\_.MOID=table27userdata24\_.MOID left outer join Table28UserData table28userdata25\_ on mo0\_.MOID=table28userdata25\_.MOID left outer join Table29UserData table29userdata26\_ on mo0\_.MOID=table29userdata26\_.MOID left outer join Table30UserData table30userdata27\_ on mo0\_.MOID=table30userdata27\_.MOID left outer join Table31UserData table31userdata28\_ on mo0\_.MOID=table31userdata28\_.MOID left outer join Table32UserData table32userdata29\_ on mo0\_.MOID=table32userdata29\_.MOID left outer join Table34UserData table34userdata30\_ on mo0\_.MOID=table34userdata30\_.MOID left outer join Table35UserData table35userdata31\_ on mo0\_.MOID=table35userdata31\_.MOID left outer join Table36UserData table36userdata32\_ on mo0\_.MOID=table36userdata32\_.MOID left outer join Table37UserData table37userdata33\_ on mo0\_.MOID=table37userdata33\_.MOID left outer join Table38UserData table38userdata34\_ on mo0\_.MOID=table38userdata34\_.MOID left outer join Table39UserData table39userdata35\_ on mo0\_.MOID=table39userdata35\_.MOID left outer join Table41UserData table41userdata36\_ on mo0\_.MOID=table41userdata36\_.MOID left outer join Table42UserData table42userdata37\_ on mo0\_.MOID=table42userdata37\_.MOID left outer join Table43UserData table43userdata38\_ on mo0\_.MOID=table43userdata38\_.MOID left outer join Table44UserData table44userdata39\_ on mo0\_.MOID=table44userdata39\_.MOID left outer join PROTECTION\_DETAILS protection40\_ on mo0\_.MOID=protection40\_.MOID left outer join SubProtectionDetails\_1 protection40\_1\_ on protection40\_.MOID=protection40\_1\_.moid left outer join SubProtectionDetails\_2 protection40\_2\_ on protection40\_.MOID=protection40\_2\_.moid left outer join SubProtectionDetails\_3 protection40\_3\_ on protection40\_.MOID=protection40\_3\_.MOID left outer join Table45ErrorDetails table45errordetails41\_ on mo0\_.MOID=table45errordetails41\_.MOID left outer join Table45ErrorDetails\_1 table45errordetails41\_1\_ on table45errordetails41\_.MOID=table45errordetails41\_1\_.MOID where mo0\_.NAME=?

---

<div class="post-metadata">

**Author:** ![beikov](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.hibernate.org/beikov/32/258_2.png) [@beikov](https://discourse.hibernate.org/u/beikov)\
**Post date:** [July 21, 2022, 9:55am UTC](https://discourse.hibernate.org/t/issue-in-query-formation-using-5-6-7-jar/6492/4 "2022-07-21T09:55:45Z")

</div>

Do I understand this correctly, that you have a base entity class `ManagedObject` which uses `JOINED` inheritance and you have 45 subclasses?

I don’t know what is happening exactly, but if you query for a `Table1`, it definitely shouldn’t join all the other subclass tables, so this might be a bug. Could you please create a [reproducer test case](https://github.com/hibernate/hibernate-test-case-templates/blob/master/orm/hibernate-orm-5/src/test/java/org/hibernate/bugs/JPAUnitTestCase.java) and attach that to a [newly created JIRA issue](https://hibernate.atlassian.net)?