NYCPHP Meetup

NYPHP.org

[nycphp-talk] MySQL: count()children on 2 related tables in 1 query

Dan Cech dcech at phpwerx.net
Tue Jan 4 15:57:23 EST 2011


On 1/4/2011 3:56 PM, David Mintz wrote:
> Guess what. The logic of my SQL must be wrong. I finally let it think for
> nearly 12 minutes and the results were f***ed up.

.. snip

> all those count() values that are the same in both columns are way way too
> large. mysql does not understand what I mean.

Yep, see my previous reply.

Dan



More information about the talk mailing list