fenway

Why not a covering index on ( user, id )?

Huh?

What does this produce?

I meant without the FORCE INDEX....

Table aliases.

It's most definitely slower.

Did you try a manual REPAIR operation?

I'm not faimliar with your DB -- you want to exclude comments that are linked to pictures?

You can order by as many fields as you'd like....

DISTINCT is not a function -- you likely want GROUP BY... but you may need to join on that dervied table.

Did not finish, or crashed? What does CHECK TABLE say?

Yes, joins are the right way to combine conditions across tables.

Why not directly INSERT INTO... SELECT WHRERE?

I don't see two conditions... and we want you to echo $query_mass.

Why not disable FK checks?

You're trying to store multiple values in a single field... it's not fun.

You mean a JOIN?

Can we see the EXPLAIN output?

What do you want to count?

I'm confused... show us some sample output, and what's wrong with ti.

the column "fulltext" is the culprit.

Try: SELECT t1.* FROM terms AS t1 LEFT JOIN terms AS t2 ON ( t2.term_relation_field = t1.term_relation_field AND t2.term_lang = 9 ) WHERE t1.term_lang = 1 AND t2.term_relation_field IS NULL

That's because you need to change your outer quotes to doubles -- otherwise your variable won't get interpolated.

I'm not sure what you mean... but $cookie will not match that string directly, no.

It's a salt. FYI, it's better (more secure) to do this in php, and then pass the salted-and-MD5'd string to the db.