MySQl-Query läuft "ewig"

[omata]

SQL-Code:

SELECT c.timestamp AS time,
       c.new_owner AS new_owner_id
FROM de12_conquer c
INNER JOIN de12_tribe x
  ON    c.new_owner = x.id
     OR c.old_owner = x.id
WHERE (c.timestamp > 0 && c.timestamp < 1213647029734) 
  AND (x.ally = 37038)
ORDER BY c.timestamp DESC LIMIT 50