[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