Defi chef

                    //GET USERS's STATS
                    $sql = 'SELECT COUNT(*) AS users_fails
                        FROM ' . USERS_TABLE . '
                        WHERE user_afl_fail = 1 AND user_type <>' . USER_IGNORE;
                    $result = $db->sql_query($sql);
                    $users_fails = (int) $db->sql_fetchfield('users_fails');
                    $db->sql_freeresult($result);
                    $sql = 'SELECT COUNT(*) AS users_success
                        FROM ' . USERS_TABLE . '
                        WHERE   user_afl_success = 1 AND user_type <>' . USER_IGNORE;
                    $result = $db->sql_query($sql);
                    $users_success = (int) $db->sql_fetchfield('users_success');
                    $db->sql_freeresult($result);
//le défi:
Me réunir tout ça en une seule requete si c'est possible :/
Merci chef :)