INSERT INTO tribe_scores (tribe_name, tribe_score, last_updated)
SELECT tribe_name, MAX(tribe_score), UNIX_TIMESTAMP()
FROM players
WHERE tribe_name != '' AND tribe_name != 'NoTribe' AND tribe_id > 0
GROUP BY tribe_name
ON DUPLICATE KEY UPDATE
tribe_score = VALUES(tribe_score),
last_updated = VALUES(last_updated);