Re: [sqlalchemy] Complicated self join

I thought subquery and alias where equivalent. Thanks Mike! Den fredag 6 mars 2015 kl. 01:29:20 UTC+1 skrev Michael Bayer: Dani Hodovic dani...@gmail.com javascript: wrote: I've been struggling with a query that gets the most recent date as described here:

[sqlalchemy] Complicated self join

I've been struggling with a query that gets the most recent date as described here: http://stackoverflow.com/a/123481/2966951 I've been able to produce a SQLAlchemy variant, but it seems to be MUCH slower when executed with MySQL. It also looks slightly differentwith parameters around the

Re: [sqlalchemy] Complicated self join

Dani Hodovic danih...@gmail.com wrote: I've been struggling with a query that gets the most recent date as described here: http://stackoverflow.com/a/123481/2966951 I've been able to produce a SQLAlchemy variant, but it seems to be MUCH slower when executed with MySQL. It also looks