
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