fenway

If you alias that expression, you should be able to use it in the ORDER BY.

Well, you'd have to log the actual query you're running to verify this strange fact -- though you can cheat and output UIDs and see if it's true.

Ugh... evil. Why not use a proper many-to-many table?

Sorry, I don't follow random links... maybe someone else will be brave.

Then use STR_TO_DATE() to fix that up first.

A LEFT JOIN .. is NULL should suffice.

Sorry, I don't follow -- what's the difference?

Why not add this to a WHERE clause?

Who said anything about easy? ... and how can a simple question be "hostile"? And yes, yes, I did think I was helping; and since you won't clearly can't find it yourself, Here you go. And try using "ldd" to see exactly where it's trying to find it -- likely a busted symlink.

Why can't you just UNION all of the tables?

Did you read the sticky on the child board?

I see no reference to "topic_id" anywhere.

I'm not sure I follow.

Does it work or not?

As soon as you mentioned "explode" and "while loops", I knew you were in trouble. You'd have to handle this all in sql -- and you don't have to do it in real-time.

Maybe you're referring to this?

Unfortunately, you still can't use an expression in the limit clause...

I don't see a query anywhere.

No, I don't follow whatsovever.

What do you have so far? EXISTS is an option as well.

Hard to say, having seen none of the actual input.

Like so: select substring_index( trim( "www.mysite.com?id=" from "www.mysite.com?id=33&name=Brenda" ), '&', 1 )

Why do you have duplicate usernames?

You need a sortorder column -- nothing more.

First, make sure the inner tables (before the union) execute as you expect. Second, consider summarizing this data, instead of pulling it in real-time.