[DiscordArchive] `character_achievement_progress`?
[DiscordArchive] `character_achievement_progress`?
Original source
`character_achievement_progress`?
rektbyfaith
05-17-2023, 07:52 PM #1Archived author: Revision • Posted: 2023-05-17T19:52:02.029000+00:00
Original source
`character_achievement_progress`?
Original source
found it thanks
rektbyfaith
05-17-2023, 08:14 PM #2Archived author: Frost® • Posted: 2023-05-17T20:14:36.816000+00:00
Original source
found it thanks
Original source
SELECT
SUM(characters.character_achievement_progress.counter) AS total_counter,
auth.account.username
FROM
characters.character_achievement_progress
INNER JOIN characters.characters ON character_achievement_progress.guid = characters.guid
INNER JOIN auth.account ON characters.characters.account = auth.account.id
WHERE
criteria = '13138'
GROUP BY
auth.account.username
ORDER BY
total_counter DESC
LIMIT 0, 1000;
rektbyfaith
05-17-2023, 08:14 PM #3Archived author: Frost® • Posted: 2023-05-17T20:14:56.119000+00:00
Original source
SELECT
SUM(characters.character_achievement_progress.counter) AS total_counter,
auth.account.username
FROM
characters.character_achievement_progress
INNER JOIN characters.characters ON character_achievement_progress.guid = characters.guid
INNER JOIN auth.account ON characters.characters.account = auth.account.id
WHERE
criteria = '13138'
GROUP BY
auth.account.username
ORDER BY
total_counter DESC
LIMIT 0, 1000;
Original source
for LK HC ^^
rektbyfaith
05-17-2023, 08:14 PM #4Archived author: Frost® • Posted: 2023-05-17T20:14:59.594000+00:00
Original source
for LK HC ^^
1 Guest(s)
1 Guest(s)