SELECT username,
( abs( joindate - unix_timestamp( now( ) ) ) /86400 ) - post_thanks_user_amount + post_thanks_thanked_times AS free,
post_thanks_user_amount,
post_thanks_thanked_times,
(abs( joindate - unix_timestamp( now( ) ) ) /86400) AS days
FROM `user`
ORDER BY free