[thesite] Fw: Someone is talking...

[Warden, Matt]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

> From: "rudy" <r937 at interlog.com>
> Subject: Re: [thesite] Fw: Someone is talking...
> 
...
> > SQLGod(tm) 
...
> okay, that's enough, a little flattery is nice but let's not get
> carried away, eh?

*shrug*

Ok. Since you didn't reply to my last email offlist I figured I'd
suck up a bit to make sure everything was kosher.

> i did mention a UNION as the best way to simplify things
> 
> the first query grabs the author, the second query grabs the
> DISTINCT commenters, and UNION  (note: not UNION ALL) takes care of
> removing the doubles where the author is also a commenter

Yup.

And I mentioned that if you make this one query you lose the ability
to make the author's email different than someone who just commented
on an article.

Plus, adding a where clause would be less prone to fux0ring the
surrounding code, no?


- --
mattwarden
mattwarden.com

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBOxbtEngH0dUmEhrcEQJ7GgCfWdPZepDmtzhawAVNOsezy49bEFIAoNfa
zb3X5KJpaCAzdZvzCaQIxCi0
=fiwu
-----END PGP SIGNATURE-----