fenway

What does this query do, exactly?

Then let me know which thread this applied to, and I'll merge them.

The spirit of competition always brings out the best in people.

You're new -- please read the rules before posting.

Sorry, lost track of this thread for a while -- any progress/updates?

UTF-8 is highly non-trivial to support -- if you don't need it, then avoid the headache.

Unless you want ALL of them, use * -- if you want something lazy, then write a function that will deal with the column definitions fory ou.

Drop the straight_join -- otherwise, you've told mysql that you're smarter than it.

Just delete the MYI file and repair the able.

The query simply lines up each matching parentid row, pairwise -- then it checks to see which rating column is bigger. Since you want to find the largest one, that's the one where there is no larger value; and in a LEFT JOIN, that's where the rating is NULL.

If your table has more than 50, it's broken.

I suppose so -- you can use a row counter, and roll-your-own average.

And you're posting this thread twice because...?

I feel like you've asked this question before.

Getting closer -- so what output does that produce, and what's wrong about it?

This really isn't the place for php syntax errors.

No one knows what that means.

Sorry, I don't follow.

You really need to convert that to a multi-table join.

You'd have to show us these characters, tell us about your database collations and character sets, and tell us what you mean by "break or not workign".

No problem -- we'll wait.

Like I suggested a long time ago: select Y.terminal, count(Z.id) from (select distinct terminal from stats) Y left outer join stats Z on ( Y.terminal=Z.terminal and Z.timestamp > '2012-01-16' ) group by Y.terminal order by Y.terminal

I'd suggest that you read the sticky on how to provide all of the necessary information.

Those aren't french characters -- those are html entities.

You are correct -- there is no benefit to having a single column index when you a multi-field index and the single column is the first in the mulit-column index.