We're getting an error when we have over 10 joins on a DQL.
Is there any way around this?
select * from nike_asset where r_object_id in (select dr1.child_id from dm_relation dr1, dm_relation dr2, dm_relation dr3, dm_relation dr4, dm_relation dr5, dm_relation dr6, dm_relation dr7, dm_relation dr8, dm_relation dr9, dm_relation dr10, dm_relation dr11, dm_relation dr12 WHERE dr1.child_id = dr2.child_id AND dr1.parent_id='084156998005d417' AND dr2.parent_id='084156998005d39a' AND dr2.child_id = dr3.child_id AND dr2.parent_id='084156998005d39a' AND dr3.parent_id='084156998005d3a6' AND dr3.child_id = dr4.child_id AND dr3.parent_id='084156998005d3a6' AND dr4.parent_id='084156998005d3a7' AND dr4.child_id = dr5.child_id AND dr4.parent_id='084156998005d3a7' AND dr5.parent_id='084156998005d3a8' AND dr5.child_id = dr6.child_id AND dr5.parent_id='084156998005d3a8' AND dr6.parent_id='084156998005d3a9' AND dr6.child_id = dr7.child_id AND dr6.parent_id='084156998005d3a9' AND dr7.parent_id='084156998005d3aa' AND dr7.child_id = dr8.child_id AND dr7.parent_id='084156998005d3aa' AND dr8.parent_id='084156998005d3ab' AND dr8.child_id = dr9.child_id AND dr8.parent_id='084156998005d3ab' AND dr9.parent_id='084156998005d3ac' AND dr9.child_id = dr10.child_id AND dr9.parent_id='084156998005d3ac' AND dr10.parent_id='084156998005d3ad' AND dr10.child_id = dr11.child_id AND dr10.parent_id='084156998005d3ad' AND dr11.parent_id='084156998005d335' AND dr11.child_id = dr12.child_id AND dr11.parent_id='084156998005d335' AND dr12.parent_id='084156998005d323')
thanks!
