fenway

Looks like a double-post to me.

Great... what error, what query?

Not all views can be generated with the MERGE algorithm. And SPs usually slow things down.

Sorry, this seems overly complicated. You're trying to group by the date of the week (e.g. MON/TUE)? That's it?

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.