MySQL Nested Query

[Quoth_The_Raven]

I was wondering if anyone new how to change this nested sql query into one that MySQL could use because MySQL doesn't support nested queries. I do realize that I could do this in php but it'd be much more efficient for me to do it with MySQL.

The Query:
SELECT AVG(s.pr) FROM table s WHERE s.end NOT IN(SELECT r.end FROM table r LIMIT 0, 7)

Any help would be appreciated. Thanks.

[Vex]

Mmm... Not easy... But..

Summat like this maybe?

SELECT AVG(s.pr)
FROM table s, table r
WHERE
s.end != r.end
AND r.id >= 0
AND r.id <= 7

But that's just a guess, and obvious table r needs to have an id column or some other column that will allow you to control how many records come out of the table...

Really not sure whether that will work though, it's just off the top of my head...

[Quoth_The_Raven]

It won't work because the end fields are not always equidistant apart