Changes between Initial Version and Version 1 of Ticket #29416


Ignore:
Timestamp:
05/18/2018 05:12:18 AM (2 years ago)
Author:
Antoine Pinsard
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #29416 – Description

    initial v1  
    3333As you can see, the ORM appended the subquery `(SELECT COUNT(*) FROM pro_moderation WHERE objType='sponsor' AND objId=ala_sponsor.sponId AND state=2)` to the GROUP BY clause. Which is wrong, and takes forever to execute.
    3434
     35-----
     36-----
     37
    3538I tried to play with `.values('id')` or such as I usually do when I get unexpected GROUP BY. I spent an afternoon on it but there's no way I could get rid of this undesired group by clause. The `order_by` is not to blame either. Here is another example of what I tried:
    3639
Back to Top