fenway

What's the error?

There's a sticky on this topic.

No need to upload files -- just post the relevant code snippet in code tags.

And this won't work anyway -- you need INTERVAL for math.

Should be pretty fast, since they're all constant expressions.

First problem -- no join condition. Second problem -- what's being stored in the "theme" column?? I'm confused.

Why are you using backticks?

Well, how else are you going to identify which users we're talking about?

Pretty close.. of course, you'll want back to ReferredBy column itself, and LIMIT 10.

why not simply group by referred_by, and order by the count desc, limit 20?

Don't double-post.

Then echo your $query.

It's your hyphen -- use backticks.

Then jobs.date isn't a DATE field.

See here.

Then dump $resource and see what it really is... those extra parens don't help.

And I assume the refman wasn't helpful?

You mean to say that the second query alone doesn't produce 14 records? If it does, you need a join, not a union. I'm confused, yet again.

This is a moot point -- it's really not going to happen -- and the more posts you have, the less valuable it is to the rest of the members to have anyone's username changed.

Probably not in this case, assuming proper indexes.

Then your import is busted.

I don't follow.

What are you trying to do?

Start thinking in sets, not procedures.

Not what I meant, but that works too.