![mysql](https://habrastorage.org/r/w120/webt/5b/53/d5/5b53d5517cb34636505650.png)
MySQL
- 1 ответ
- 0 вопросов
1
Вклад в тег
select calendar.*
left join subscribers_fields
ON calendar.id_object = subscribes_fields.id_field AND subscribes_fields.id_follower = 1 AND calendar.type = 'field'
left join JOIN subscribes_events
ON calendar.id = subscribes_events.id_event and subscribes_events.id_follower = 1 AND subscribes_events.type = 'user'
where subscribers_fields.Id is not null OR subscribes_fields.id_field is not null