fenway

There are some excellent stickies on this topic.

I'm confused again... sorry, it's been a while. This gets your clubs for 18 months (though I don't see where the 2 event criterion is satisfied): SELECT r.club, DATEDIFF( MAX( date ) , MIN( t.date ) ) AS diff FROM racing r INNER JOIN tournament t ON ( t.enumber = r.event ) WHERE t.date >= '2007-01-01' AND r.besttime < 99.999 GROUP BY r.club HAVING diff > 4 Now, the next step you want to do is a) limit this to 12 months and, more importantly, b) just get the min() of some column?

Not all fields, and not all separate indexes.... but yes, sometimes for a certain query, it has to be optimized "separately".

Pseudo-random, yes.

You can use IFNULL( dc.division_name, d.division_name ).

Don't double-post.

If you're talking about weighting your search results, you'll have to design this.

Don't do that...mysql has built-in date functions. What's e-day? A timestamp?

Why not use REPLACE?

How about transcatiosn?

I have no idea what you mean.

Why count(id) and not count(*)?

Are you talking about ordering the results after the match?

Then you'll have to JOIN as many levels down (or up) as you need... there's no recursive solution in this case.

I'm not a big fan of re-posting question to multiple forums -- solution is here; next time, please let us know when to stop wasting our time.

What error?

Why are we talking about imaginary queries? I still don't understand.

Maybe now I see what you mean... you want to count down multiple levels of hierarchy?

I don't understand.

You can use MIN(0, <your-expression>) and MAX(16475715,<your-expression)

How about adding mysql_error() to that die() statement?

Maybe you are confusing mysql's DATE() function -- which extracts the date portion of a DATETIME column -- and php's date function.

Depends which version of mysql -- version 5 has index_merge, and might be smart -- impossible to tell without table structure and EXPLAIN output.

Sounds like you have the wrong password. You should be able to start the server and skip priviledges to fix this.

I'm confused... how do you mean?