Просмотр поста

$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
    ");