fenway

$query = "SELECT * FROM database"; Can't possibly not work.

Sorry, I don't follow.

Use code tags next time. Echo the offending queries.

That's an entire script.... what's the isolated mysql issue?

Interesting... I'd find the top one in each division in one query, then the "logical" ordering skipping the first N, and union them.

"Prevent" makes no sense... it's either an number or a string, not both.

What does CHECK TABLES have to say?

Yikes... what's all this about?

Hard to believe... you you mean the count or the record count?

CHECK each table.

Sorry, I don't follow.

There are many such free resources....

And if you manually shut it down and re-start it?

Sure... use DATEDIFF().

Echo the queries and post them.

Show us the actual query, not an intermediate version.

Sorry, I don't follow.

What is your current query?

Only TIMESTAMP fields "know" about server and session timezones.

INNER JOIN -- both tables have to have matching rows LEFT JOIN -- non-matching rows from the table on the "right" will be NULLed out, but still "found".

Yup -- no different that anything else. Make sure you isolate each condition.

What error?

MySQL will never figure out how to do this for you... but it's probably not far from UUID().

That's shouldn't have mattered... where these proper DATE fields?

You'll need sub-queries for this.