$classKey = 'modResource'; $c = $modx->newQuery($classKey); $c->innerJoin('modTemplateVarResource', 'users', "users.contentid = $classKey.id AND users.tmplvarid = 14"); $c->select(array( "$classKey.id as id" ,"users.value as users" )); $c->sortby('users.value+0','asc'); $where = array('users.value:>=' => intval($users)); $c->where($where);