JohnCMS 7.1.0

// Список посетителей. у которых есть фотографии
switch ($mod) {
    case 'boys':
       // $sql = "WHERE `users`.`sex` = 'm'";
       $sql = "AND `usr`.`sex` = 'm'";
        break;

    case 'girls':
       // $sql = "WHERE `users`.`sex` = 'zh'";
       $sql = "AND `usr`.`sex` = 'zh'";
        break;
    default:
      //  $sql = "WHERE `users`.`sex` != ''";
      $sql = "AND `usr`.`sex` <> ''";
}

$menu = array(
    (!$mod ? '<b>' . _t('All') . '</b>' : '<a href="?act=users">' . _t('All') . '</a>'),
    ($mod == 'boys' ? '<b>' . _t('Guys') . '</b>' : '<a href="?act=users&amp;mod=boys">' . _t('Guys') . '</a>'),
    ($mod == 'girls' ? '<b>' . _t('Girls') . '</b>' : '<a href="?act=users&amp;mod=girls">' . _t('Girls') . '</a>')
);
echo '<div class="phdr"><a href="index.php"><b>' . _t('Photo Albums') . '</b></a> | ' . _t('List') . '</div>' .
     '<div class="topmenu">' . implode(' | ', $menu) . '</div>';

$idu = $db->query("SELECT `id` FROM `users` usr WHERE `usr`.`id` IN (
	SELECT `user_id` FROM `cms_album_files`
) $sql
")->fetchAll(PDO::FETCH_COLUMN);

$total = count($idu);

if ($total) {
    $id = join(',', $idu);
    $req = $db->query("SELECT `usr`.`id` AS `uid`, `usr`.`name` AS `nick` , (
    SELECT count( * ) FROM `cms_album_files` WHERE `user_id` = `usr`.`id`) 'count'
FROM `users` usr
WHERE `usr`.`id` IN ($id)  $sql
ORDER BY `usr`.`name` ASC LIMIT $start, $kmess
    ");

$total = $db->query("SELECT count(*) FROM `users` usr WHERE `usr`.`id` IN (
	SELECT `user_id` FROM `cms_album_files`
) $sql
")->fetchColumn();

if ($total) {
    $req = $db->query("SELECT `usr`.`id` AS `uid`, `usr`.`name` AS `nick` , (
    SELECT count( * ) FROM `cms_album_files` WHERE `user_id` = `usr`.`id`) 'count'
FROM `users` usr
WHERE `usr`.`id` IN (
	SELECT user_id FROM cms_album_files
	)  $sql
ORDER BY `usr`.`name` ASC LIMIT $start, $kmess
    ");