Выборка пользователей по определенным параметрам

$sql = "SELECT u.username, ua.* FROM `modx_users` as u
LEFT JOIN modx_member_groups as g ON g.member = u.id
LEFT JOIN modx_site_content as c ON c.createdby = u.id
LEFT JOIN modx_user_attributes as ua ON ua.internalKey = u.id
WHERE g.user_group = 4
AND c.published = 1
AND u.active = 1
AND c.context_key = 'moscow'
GROUP BY u.id";
$q = $modx->prepare($sql);
$q->execute();
$users = $q->fetchAll(PDO::FETCH_ASSOC);

foreach ($users as $v) {
	echo $v['username'];
}

$q = $modx->newQuery('modUser');
$q->leftJoin('modUserGroupMember',
             'UserGroup',
             'UserGroup.member = modUser.id '.
             'AND UserGroup.user_group = 4');
$q->leftJoin('modResource',
             'Resource',
             'Resource.createdby = modUser.id '.
             'AND Resource.published = 1 '.
             'AND Resource.context_key = "moscow"');
$q->leftJoin('modUserProfile',
             'Profile',
             'Profile.internalKey = modUser.id');
$q->groupby('modUser.id');

$q->select(array(
    'modUser.*',
    'Profile.*'
));

$q->where(array(
    'modUser.active' => 1,
    'Resource.id:IS NOT' => NULL
));

$count = $modx->getCount('modUser', $q);
if ($q->prepare() && $q->stmt->execute()) {
	$users = $q->stmt->fetchAll(PDO::FETCH_ASSOC);
}

echo "<p><b>Всего пользователей найдено: {$count}</b></p>";
foreach($users as $user) {
    echo "<p>{$user['username']} ({$user['internalKey']})</p>";
}