// TOP earners
$result = SQL_QUERY("SELECT
- d.`userid`,
- SUM(p.`points` + p.`locked_points`) AS `points`,
- d.`last_online`
+ `d`.`userid`,
+ SUM(`p`.`points` + `p`.`locked_points`) AS `points`,
+ `d`.`last_online`
FROM
`{?_MYSQL_PREFIX?}_user_data` AS `d`
LEFT JOIN
{?_MYSQL_PREFIX?}_user_points AS `p`
ON
- p.`userid`=d.`userid`
+ `p`.`userid`=`d`.`userid`
WHERE
- p.`points` > 0 AND
- d.`status`='CONFIRMED'
+ `p`.`points` > 0 AND
+ `d`.`status`='CONFIRMED'
" . runFilterChain('user_exclusion_sql', ' ') . "
GROUP BY
- p.`userid`
+ `p`.`userid`
ORDER BY
`points` DESC,
- d.`last_online` DESC
+ `d`.`last_online` DESC
LIMIT {?top10_max?}", __FILE__, __LINE__);
$OUT = ''; $count = 1;
// TOP referral "hunter"
$result = SQL_QUERY("SELECT
- d.`userid`,
- SUM(r.`counter`) AS `refs`,
- d.`last_online`
+ `d`.`userid`,
+ SUM(`r`.`counter`) AS `refs`,
+ `d`.`last_online`
FROM
`{?_MYSQL_PREFIX?}_user_data` AS `d`
LEFT JOIN
{?_MYSQL_PREFIX?}_refsystem AS `r`
ON
- r.`userid`=d.`userid`
+ `r`.`userid`=`d`.`userid`
WHERE
- r.`counter` > 0 AND
- d.`status`='CONFIRMED'
+ `r`.`counter` > 0 AND
+ `d`.`status`='CONFIRMED'
" . runFilterChain('user_exclusion_sql', ' ') . "
GROUP BY
- r.`userid`
+ `r`.`userid`
ORDER BY
`refs` DESC,
- d.`last_online` DESC
+ `d`.`last_online` DESC
LIMIT {?top10_max?}", __FILE__, __LINE__);
$OUT = ''; $count = 1;