SELECT e.id,
       e.name,
       e.date,
       e.location,
       e.description,
       e.category,
       SUM(CASE WHEN ue."isRspv" = TRUE THEN 1 ELSE 0 END)       AS total_rsvp,
       SUM(CASE WHEN ue."isAttendance" = TRUE THEN 1 ELSE 0 END) AS total_attendance
FROM events e
         LEFT JOIN user_events ue ON ue.event_id = e.id
WHERE e.id = 87
GROUP BY e.id,
         e.name,
         e.date,
         e.location,
         e.description,
         e.category
ORDER BY e.date DESC
LIMIT 20 OFFSET 0;

SELECT
    chu.telegram_id as channel_user_tg_id,
  u.tg_id as user_tg_id,
  ub.id AS user_bot_id,
  EXISTS (
    SELECT 1
    FROM user_bot_plans ubp
    WHERE ubp.user_bot_id = ub.id
      AND ubp.retry_date::date >= CURRENT_DATE - INTERVAL '1 day'
  ) AS has_plan
FROM channel_users chu
LEFT JOIN users u
  ON chu.telegram_id = u.tg_id
LEFT JOIN user_bots ub
  ON ub.user_id = u.id
WHERE ub.bot_id = chu.bot_id
  AND chu.created_at::date = CURRENT_DATE - INTERVAL '1 day'
AND chu.bot_id  = 18 AND ub.bot_id = 18;