public function getUsers()
{
$query = "\n select\n p.id,\n p.display_name as name,\n p.user_email as email,\n max(IF(pa.meta_key='wp-athletics_gender', pa.meta_value, null)) as gender,\n max(IF(pa.meta_key='wp-athletics_dob', pa.meta_value, null)) as dob\n from " . NRDatabase::USERTABLE . " p\n left join " . NRDatabase::USERMETATABLE . " as pa on p.id = pa.user_id\n group by p.id\n ";
$result = $this->query($query);
$runners = array();
if ($result) {
foreach ($result as $dbrow) {
$user = new Runner($dbrow);
if (!$user->isComplete()) {
$runners[] = $user;
}
}
}
return $runners;
}
