$req = mysql_query("
        SELECT
                g.`name` as 'url_prefix' , g.`id` as 'id_general_account' , g.`date_create` , g.`status` , g.`company_name` as 'wimi_real_name' , g.`package` ,
                u.`login` , u.`first_name` , u.`last_name`, u.`id` ,
                ud1.`text` as 'telephone_fixe' , ud2.`text` as 'telephone_portable' , ud1.`id_user` ,

        (SELECT COUNT(*) as 'count'`
                        FROM `mission`
                        WHERE `id_general_account` = g.`id`
                        GROUP BY `archive`) as stats_nb_proj ,

        (SELECT COUNT(*) as 'count'
                        FROM `user`
                        WHERE `id_general_account` =  g.`id`
                        GROUP BY `trash`) as stats_nb_contrib ,
(SELECT SUM(`file`.`size`) as 'file_size' , COUNT(*) as 'files'
                        FROM `mission`
                        JOIN `file` ON `file`.`id_mission` = `mission`.`id`
                        WHERE `mission`.`id_general_account` =  g.`id`) as stats_disk_usage ,

        (SELECT COUNT(*) as 'count' , `todo`.`id_user` , `user`.`id`
                FROM `todo`
                        JOIN `user` ON `user`.`id` = `todo`.`id_user`) as taches

        FROM `general_account` as g
                JOIN `company` as c ON c.`id` = g.`id_company`
                JOIN `user` as u ON u.`id_general_account` = g.`id`

                LEFT OUTER JOIN `user_data` as ud1
                        ON ud1.`id_user` = u.`id`
                                AND ud1.`id_user_data_type` = 2
                LEFT OUTER JOIN `user_data` as ud2
                        ON ud2.`id_user` = u.`id`
                                AND ud2.`id_user_data_type` = 3

        WHERE u.`privileges` > '2' ".$where."
        ORDER BY g.`id` ASC
        ");