Stan kont (holding) i "gotówki" (user_points) wyrażony w Orientach.
Kod: Zaznacz cały
SELECT username, **db**_points_bank.user_id, **db**_points_bank.opentime, **db**_points_bank.holding FROM `**db**_users` LEFT JOIN **db**_points_bank ON **db**_users.user_id=**db**_points_bank.user_id WHERE **db**_points_bank.holding>0;
Kod: Zaznacz cały
SELECT username, user_id, user_points FROM `**db**_users` WHERE user_points > 0 ORDER BY user_points DESC;