Изменения
Нет описания правки
<pre>
select user from users u LEFT JOIN map_flat_uid mfu ON u.uid=mfu.uid WHERE u.gid NOT IN (2,15,34,49) AND mfu.uid IS NULL;
</pre>
= Выбор логинов, ФИО, телефонов и адресов отключенных юзеров в файл =
<pre>
SELECT u.user, u.lastname, u.firstname, u.patronymic, u.disabled, u.disable_date,
ms.name, mh.number, mf.number, GROUP_CONCAT(ph.number)
FROM users u, map_streets ms, map_houses mh, map_porches mp, map_flats mf, map_flat_uid mfu,
users_phones up, phones ph
WHERE mh.id = mp.house_id
AND mp.id = mf.porch_id
AND mf.id = mfu.flat_id
AND mfu.uid = u.uid
AND mh.street_id = ms.id
AND up.uid=u.uid
AND ph.id = up.phone_id
AND u.disabled > 0
AND disable_date > '2020-09-30'
AND disable_date < '2020-11-01'
GROUP BY u.user
ORDER BY ms.name
INTO OUTFILE '/var/db/mysql/disabled.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';
</pre>
