fenway

Huh?

"a SUM of all sub-account balances for anyone who is a parent" Is that a simply SUM(), GROUP BY, where usr_parent = 0?

You want INNER JOIN, not LEFT JOIN, since you require a match in both tables.

You need an "=" and a LEFT JOIN.. IS NULL.

"Another DB table"? Which table? How is is related?

Can you give some concrete examples -- no code?

Yes, I see. Well, for each record in your temp table, you'll need to query the other tables to see if there are any matches. If so, use that UID. If not, INSERT, then grab the new UID.

I just meant to combine them in php.

I see dozens of queries and 50K of posted code. How about only posting the offending query?

Sounds like you're linking some score to some other relationships.

FTS is weird and magical -- like dragons. It misbehaves on very small datasets -- this is a known limitation.

You need a third table linking movieID to userID -- preferably with a timestamp, too.

There are lots of reasons to use such a loop -- though I doubt this case is one of them.

Sorry, I don't follow -- why is there a temporary table?

I've told you not to double-post before -- last warning.

How about showing us your table structure and the queries you're running, instead of making us guess?

That's because you're missing a JOIN condition.

I can't find the INSERTs in that code.

Technically, you should be counting in each subquery and then summing.

That's a great way to start.

Echo the actual query.

How many threads can you open on what appears to be the exact same query?

FYI, UPPER() still won't guarantee a case-sensitive match.

And that's why it's important to post "solutions".

Yes, if there's something you can "guess at" for the offset (an ID, value, etc.), that helps a great deal.