UPDATE users SET posts = (SELECT count(id) FROM posts WHERE posts.userid = users.id) 
UPDATE users SET comments = (SELECT count(id) FROM comments WHERE comments.user = users.id) 

UPDATE users SET inverted_added = 4294967295 - UNIX_TIMESTAMP(added);
UPDATE torrents SET inverted_timestamp=4294967295 - UNIX_TIMESTAMP(added)
UPDATE sitelog SET inverted_timestamp=4294967295 - UNIX_TIMESTAMP(added)
UPDATE messages SET inverted_added=4294967295 - UNIX_TIMESTAMP(added)