BiTel

SELECT    ul.id "ID юзера",
   ul.login "Номер договора",
   ul.password "Пароль договора",
   ul.is_juridical "Юр. статус",
   ul.full_name "Наименование",
   ul.`passport` "Паспортные данные",
   ul.juridical_address "Юр. адрес",
   ul.actual_address "Адрес установки",
   ul.`work_telephone` "Рабочий телефон",
   ul.`home_telephone` "Домашний телефон",
   ul.`mobile_telephone` "Мобильный телефон",
   ul.`email` "E-mail",
   a.`balance` "Тек. баланс",
   a.`credit` "Лимит",
   ul.`tax_number` "ИНН",
   ul.`kpp_number` "КПП",
   ul.`bank_account` "Банковские данные",
   ig.`uname` "Логин PPPoE",
   ig.`upass` "Пароль PPPoE",
   t.`name` "Тариф",
   bi.`block_type` "Тип блокировки"
FROM users AS ul
LEFT JOIN accounts AS a ON ul.`basic_account` = a.`id`
LEFT JOIN service_links AS sl ON ul.id = sl.`user_id` AND sl.`is_deleted` = 0
LEFT JOIN iptraffic_service_links AS isl ON sl.id = isl.`id` AND isl.`is_deleted` = 0
LEFT JOIN ip_groups AS ig ON isl.`ip_group_id` = ig.`ip_group_id` AND ig.`is_deleted` = 0
LEFT JOIN account_tariff_link AS atl ON ul.`basic_account` = atl.`account_id` AND atl.`is_deleted` = 0
LEFT JOIN blocks_info AS bi ON ul.`basic_account` = bi.`account_id` AND bi.`is_deleted` = 0
LEFT JOIN tariffs AS t ON atl.`tariff_id` = t.`id`
WHERE ul.`is_deleted` = 0
#AND sl.`is_deleted` = 0
#AND ig.`is_deleted` = 0
#AND isl.`is_deleted` = 0
#AND atl.`is_deleted` = 0
ORDER BY ul.login