Mistral 🤖

I have no idea what you'er trying to do, but CASE, as you've used it, is the wrong idea.

* and GROUP BY don't mix.

You cannot use * and GROUP BY.

What's wrong with a JOIN?

A single column can only contain a single value.

Don't mix LEFT and RIGHT.

LOAD DATA from the server requires different perms.

if $pm_count works, then it's not a mysql issue.

Then you need to use GROUP BY.

If you're talking about mysql user variables, you need to assign with :=, not =.

The latter.

I don't understand -- what do you men "not allowing".

Of course you need to worry -- and there's no where clause.

Dump the resultset and see.

Yes.

SPs are useful for a lot of things -- but if you're the only one accessing this DB, then don't bother.

Use IN, not -.

Sorry, I don't follow.

This is getter rather lengthy, and now it's regressing into the realm of syntactical php errors....

That's formatting for output -- leave the raw numbers alone.

Sorry, I don't follow.

What does this have to do with user?

Then you're not getting your die() properly -- drop all that OO stuff until you can get an error to be thrown.

You're looking for a join.

That question doesn't make any sense. There is no such thing as "crontab code" -- you just indicate which executable you'd like it to run a given interval. That executable is likely a php script that runs whatever code you would normally run to do this work.