I'm having an issue with a query I wrote for a plugin I developed for CS:GO.
I'm using the following query:
SELECT FIND_IN_SET(total, (SELECT GROUP_CONCAT(total ORDER BY total DESC) FROM t_cache WHERE total != 0)) AS rank, steamID, total FROM t_cache
As shown in the image below, it only processes the first 129 people, and fails to FIND_IN_SET
the rest of the users where the points != 0.
I'd like to know if there's a limit for any of the functions I used; and if it can be fixed.
Aucun commentaire:
Enregistrer un commentaire