[thesite] database: content table

[Warden, Matt]

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

> select 
>     content.contentid, replies, categoryid, contentname,
> max(replies.datemod)
> from 
>     content,
>     replies 
> where 
>     replies > 13
>     and contentid <> 3509
>     replies.contentid=content.contentid
> order by replies.datemod, replies desc
> 
> I'm not even sure if that will work,

actually, I'm 100% sure it won't work. this might tho:

select 
    content.contentid, replies, categoryid, contentname,
max(replies.datemod)
from 
    content,
    replies 
where 
    replies > 13
    and contentid <> 3509
    and replies.contentid=content.contentid
order by replies.datemod, replies desc


- --
mattwarden
mattwarden.com

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

iQA/AwUBOw8TangH0dUmEhrcEQJgawCg4IWhiZecQwE+zLOCqofBv84VkiIAoP1g
OB6/hHaaQgizaCvUDz0uNkhH
=8I07
-----END PGP SIGNATURE-----