СОРМ Яхонт, версия 2020

Ключ
Эта строка удалена.
Это слово было удалено. Это слово было добавлено.
Эта строка добавлена.

Изменения (3)

просмотр истории страницы

from ABONENTS A
join
(select distinct abonent_id abon
from users_history
where time_changed between (current_timestamp - 1) and current_timestamp
or abonent_id in (select distinct abonents_id abon from abonents_history where time_changed between (current_timestamp - 1) and current_timestamp)
) user_periodic on user_periodic.abon=a.id
left join USERS U on A.ID = U.ABONENT_ID
left join HOMES H on A.HOME_ID = H.ID
and a.id is not null
and a.parent_id not in (2)
and a.id!=1373 and (u.login in (select uh.login from users_history uh where uh.time_changed between (current_timestamp - 1) and current_timestamp)
or a.id in (select ah.abonents_id from abonents_history ah where ah.time_changed between (current_timestamp - 1) and current_timestamp));
and a.id!=1373;
{code}