fenway

You don't use GROUP BY to select a specific row -- that's what WHERE clause is for.

This topic has been moved to PHP Coding Help. http://www.phpfreaks.com/forums/index.php?topic=353570.0

Are you talking about the query cache?

Database hwo?

As long as you don't need to "parse" the row as part of any query -- then there's nothing wrong with that at all.

How about you post the solution for everyone's benefit....

This topic has been moved to PHP Coding Help. http://www.phpfreaks.com/forums/index.php?topic=353406.0

Sure, you can fake it -- but it will act faked forever.

That makes no sense.

Look up mysql_insert_id().

In general, don't use abbreviations.

SELECT CONCAT_WS('-', account.phone_country_code, account.phone_city_code, account.phone) AS phone FROM account As an added benefit, CONCAT_WS is happy to ignore NULLs -- unlike CONCAT, which barfs.

What do you think that case statement is doing?

I suppose you could use an IF() to determine this in a order by clause inline, but this is much cleaner.

This topic has been moved to PHP Coding Help. http://www.phpfreaks.com/forums/index.php?topic=353305.0

Benchmark it.

Well, you definitely need the parentheses -- don't kid yourself. Also, since you're not using the LEFT JOIN, switch it to INNER JOIN. Is the query returning the right information or not?

You marked this "solved", yet I don't see the solution.

Are you going to make us _guess_ the error?

Since you haven't shown us the query, we cant' help you.

You can add AVG(rating) without incident.

That looks like a join -- what doesn't work?

Ahoy-hoy!

Keep it in the DB.

Are you sure the server is actually reading that startup file?