SQL Statement Suggestions

[eluser]Fielder[/eluser]
Thanks I'll give it a shot. Does it make sense to put data manipulation into the SQL queries instead of post processing the returned results in php loops? Is it more efficient and better practice? Is there a point where the queries can be so complicated/nested they don't run well?

Also I noticed you didn't include slashes in your date. Can I do that and Mysql will know it's a date?

Thanks.