SELECT u.*,count(u.id) AS sum                     FROM user AS u                    LEFT JOIN post AS p                    ON p.user_id = u.id                     RIGHT JOIN user_has_group as up                    ON up.user_id = u.id                     RIGHT JOIN user_has_email as ue                    ON ue.user_id = u.id                    WHERE u.username != ''                    AND up.group_id = {$args['groupid']}                    AND ue.email = '{$args['useremail']}'                    GROUP BY u.id ORDER BY u.id desc