django Join After Group By

Asked May 21 '20 at 16:54

Active May 21 '20 at 17:01

Viewed 155 times

I need to have a subquery as the FROM clause in django, like so

select a.stuff, b.some_stuff, c.other_stuff from (
  select stuff from table 
  where ...
  group by ...
) as a
left outer join table2 as b on ..
left outer join table3 as c on ..

How can I do this ?

Inspired by This post

The reason I need to do this is for speed, as the obvious table1.objects.values(..).annotate('FkeyB__some_stuff', 'FkeyC__other_stuff') produces group bys after the joins which is slow.

edited May 21 '20 at 17:01

asked May 21 '20 at 16:54

jeffli

It'll be easier to help you if you post the querysets you've tried rather than the raw sql. – schillingt May 21 '20 at 18:08
Seems like the solution is [this](https://stackoverflow.com/a/61411052/10981971) – jeffli May 21 '20 at 18:36

django Join After Group By

0 Answers0