SELECT node_id pick_id,
title pickname,
node_id auth_id,
title authname,
experience rep
FROM node,
user
WHERE node_id = user_id
AND (UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(lasttime) < ?)
ORDER BY experience $args{order},
node_id ASC
LIMIT $limit
####
SELECT node_id pick_id,
title pickname,
node_id auth_id,
title authname,
experience rep
FROM node,
user
WHERE node_id = user_id
AND lasttime > date_sub(NOW(), INTERVAL ? DAY)
ORDER BY experience $args{order},
node_id ASC
LIMIT $limit
####
SELECT node_id pick_id,
title pickname,
node_id auth_id,
title authname,
experience rep
FROM node,
user
WHERE node_id = user_id
AND lasttime > date_sub(NOW(), INTERVAL ? SECOND)
ORDER BY experience $args{order},
node_id ASC
LIMIT $limit