Nathan G wrote:
[snip]

>> Hmmm, you should be using self joins with appropriate indexes.
>
> please elaborate

If I may be so bold: I think Paul is suggesting that you look up 'Self
Joins' in the MySQL documentation or on Google as a learning exercise.