fenway

If you change FROM goals, games to FROM (goals,games) you'll be ok. In general, don't mix comma and JOIN syntax.

Why the subquery -- just substract.

5000 isn't that many -- the SELECT on such small data should be fairly quick -- of course, how are you determining which 5000 to choose?

It's always simpler to have a shared table.

What does mysql think these values are set to?

Sorry, I don't follow.

It doesn't have to be a page -- use a URL parameter -- and then you can get a pretty URL later.

That's just the wrong tree structure to use.

So group by the same expression.

Sure... STR_TO_DATE().

What's the question?

You'll need to get back to top N for each group, and then just throw out the first one.

TLDR.

You'll need two such where conditions.

Can't see the actual query that way -- echo it with all those variables.

I don't follow.

Why is this marked "solved"?

Change your "*" to "COUNT(*)", and then either use a column alias, or mysql_result.

Well, "TEXT" fields can be very large -- unless you specifically said otherwise. LENGTH() should help.

In the column list.

What's wrong with them?

What makes you think it' secure/

This sounds like a support question for a product that's been released by someone else.

The JOIN is often better for performance.

Sorry, but no one is going to sift to 16kB to figure out your issue -- I doubt it's that complex -- just narrow it down and post the relevant snippet.