LEFT OUTER JOIN (SELECT rt.id,planet,tick FROM raids r
JOIN raid_targets rt ON r.id = rt.raid) rt ON rt.planet = i.target
AND (rt.tick + 12) > i.tick AND rt.tick <= i.tick
LEFT OUTER JOIN (SELECT rt.id,planet,tick FROM raids r
JOIN raid_targets rt ON r.id = rt.raid) rt ON rt.planet = i.target
AND (rt.tick + 12) > i.tick AND rt.tick <= i.tick