path: root/gentoobrowse-api/service/sql/users/get.sql

-- libdbpp:no-cursor
SELECT userid, username, userrealname, useremail, signedup, lastmailshot
FROM gentoobrowse.users
WHERE userid = ?
AND verifyguid IS NULL