select reg.id rid,max(photo.mPhoto),reg.Surname,reg.Name,reg.Country,reg.Region,reg.City,photo.namePhoto from reg left join photo on reg.id=photo.idUser join send s on s.idSender = reg.id where s.idSender = 32 or s.idReceiver = 32 union select reg.id,max(photo.mPhoto),reg.Surname,reg.Name,reg.Country,reg.Region,reg.City,photo.namePhoto from reg left join photo on reg.id=photo.idUser join send s on s.idReceiver = reg.id where s.idSender = 32 or s.idReceiver = 32

--
-- Структура таблицы `photo`
--

CREATE TABLE IF NOT EXISTS `photo` (
  `id` int(5) NOT NULL,
  `idUser` int(4) NOT NULL,
  `namePhoto` varchar(50) NOT NULL,
  `Anons` text,
  `mPhoto` int(1) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8;

--
-- Структура таблицы `reg`
--

CREATE TABLE IF NOT EXISTS `reg` (
  `id` int(4) NOT NULL,
  `Email` varchar(50) NOT NULL,
  `Password` varchar(50) NOT NULL,
  `Surname` varchar(50) NOT NULL,
  `Name` varchar(50) NOT NULL,
  `Sex` int(1) NOT NULL,
  `Nationality` varchar(50) NOT NULL,
  `Country` varchar(50) NOT NULL,
  `Region` varchar(50) NOT NULL,
  `City` varchar(50) NOT NULL,
  `Role` int(1) NOT NULL,
  `Birthday` date NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8;


--
-- Структура таблицы `send`
--

CREATE TABLE IF NOT EXISTS `send` (
  `id` int(4) NOT NULL,
  `idReceiver` int(4) NOT NULL,
  `idSender` int(4) NOT NULL,
  `Text` text NOT NULL,
  `iRead` int(1) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;