{!_MYSQL_PREFIX!}_user_data
WHERE
total_logins > 0 AND
- status='CONFIRMED'
+ `status`='CONFIRMED'
ORDER BY
total_logins DESC
LIMIT %s",
p.userid=d.userid
WHERE
p.points > 0 AND
- d.status='CONFIRMED'
+ d.`status`='CONFIRMED'
GROUP BY
p.userid
ORDER BY
r.userid=d.userid
WHERE
r.counter > 0 AND
- d.status='CONFIRMED'
+ d.`status`='CONFIRMED'
GROUP BY
r.userid
ORDER BY