SELECT  `mc_users`.`id`,
        `mc_users`.`name`,
        `mc_users`.`groups`,
        `mc_groups`.`prefix`,
        `mc_stats`.`id` AS `id`,
        `mc_stats`.`placed` AS `placed`,
        `mc_stats`.`destroyed` AS `destroyed`,
        `mc_stats`.`traveled` AS `traveled`,
        `mc_stats`.`player_kills` AS `player_kills`,
        `mc_stats`.`creature_kills` AS `creature_kills`,
        `mc_stats`.`deaths` AS `deaths`,
        `mc_stats`.`joined` AS `joined`,
        `mc_stats`.`last_active` AS `last_active`,
        `mc_stats`.`play_time` AS `play_time`
FROM    `mc_users`
         JOIN `mc_groups`
           ON (`mc_users`.`groups` = `mc_groups`.`name`)
         JOIN `mc_stats`
           ON (`mc_users`.`id` = `mc_stats`.`player_id`)

ORDER BY `mc_groups`.`id` DESC