Re: still repetetive

[Jay Pipes]

Hi Mark!

This is a known issue with subquery optimizations, and is on the block to make it into future MySQL versions (5.2 I think?) For now, simply do:

SELECT *
FROM results0047 r
INNER JOIN items i
ON r.query = i.id
AND i.state = 'deleted'
LIMIT 10;

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com