NYCPHP Meetup

NYPHP.org

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

David Mintz david at davidmintz.org
Tue Jan 4 15:58:36 EST 2011


On Tue, Jan 4, 2011 at 3:57 PM, Dan Cech <dcech at phpwerx.net> wrote:

> 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.
>
>
>

Indeed, your reply crossed mine in the mail. So it's been an instructive
afternoon. Onward!

Thanks for the help.

-- 
David Mintz
http://davidmintz.org/
It ain't over:
http://www.healthcare-now.org/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20110104/7f214904/attachment.html>


More information about the talk mailing list