mysql> select agr.number as dogovor, acc.name as fio, acc.phone as tel, acc.mobile as mobile, acc.phone as tel, acc.fax as fax, acc.email as email, acc.pass_sernum as seriya_passp, acc.pass_no as nomer_pasp, acc.pass_issuedate as data_vid_pasp, acc.pass_issuedep as kem_vid_pasp, acc.birthdate as den_rozhd, acc.birthplace as mesto_rozhd, accaddr.address as adres_prozh 
from agreements as agr, accounts as acc, accounts_addr as accaddr 
where agr.uid=acc.uid and agr.uid=accaddr.uid and accaddr.type=1 and agr.uid in (select uid from vgroups where vg_id in (select vg_id from rad00120150113 where '2015-01-13 19:32' between timefrom and timeto and ip = inet_aton('11.11.11.11')));
+------------+------------------------------------------------------+------+------------+------+------+--------------------------+--------------+------------+---------------+---------------------------------------------------------------------+------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------+
| dogovor    | fio                                                  | tel  | mobile     | tel  | fax  | email                    | seriya_passp | nomer_pasp | data_vid_pasp | kem_vid_pasp                                                        | den_rozhd  | mesto_rozhd             | adres_prozh                                                                                                                           |
+------------+------------------------------------------------------+------+------------+------+------+--------------------------+--------------+------------+---------------+---------------------------------------------------------------------+------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------+
| 11111-ДОГ   | Пупкин Максим Иванович                          |      | 855585 |      |      | pupkin@site.ru | 8888         | 201545     | 2001-19-95    | Отд УФМС Рос                              | 1479-91-94 | г.Город            | Россия,край адрпес 8,,индекс                                                         |
+------------+------------------------------------------------------+------+------------+------+------+--------------------------+--------------+------------+---------------+---------------------------------------------------------------------+------------+-------------------------+---------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.37 sec)

mysql>

mysql> select * from accounts_addr where uid = 2604;
+------+------+---------+--------+------+------+-------+--------+----------+------+------------------------------------------------------------------------------------------------------------------------------------------------+----------+-------+
| uid  | type | country | region | area | city | settl | street | building | flat | address                                                                                                                                        | entrance | floor |
+------+------+---------+--------+------+------+-------+--------+----------+------+------------------------------------------------------------------------------------------------------------------------------------------------+----------+-------+
| 2604 |    0 |       1 |     18 |  363 |  151 |     0 |  58685 |        7 | 3080 | Россия,Адрес                                                           |        0 |     0 |
| 2604 |    1 |       1 |     18 |  363 |  151 |     0 |  58683 |     1088 |    0 | Россия,Другой адрес                                                                 |        0 |     0 |
| 2604 |    2 |       1 |     18 |  363 |  151 |     0 |  58683 |     1088 |    0 | Россия,Адрес                                                                  |        0 |     0 |
+------+------+---------+--------+------+------+-------+--------+----------+------+------------------------------------------------------------------------------------------------------------------------------------------------+----------+-------+
3 rows in set (0.00 sec)

mysql> 

mysql> select acc_adr.address as adres_propiski, max(case when acc_adr.type=1 then acc_adr.address else NULL end) as adres_prozhiv from accounts_addr as acc_adr where uid=2536;
+----------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------+
| adres_propiski                                                                                                 | adres_prozhiv                                                                                              |
+----------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------+
| Россия,Адрес1                                              | Россия,Адрес2                                           |
+----------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------+
1 row in set (0.02 sec)

mysql>