Sort Key: set_top_at DESC NULLS LAST, (CASE WHEN is_complete THEN 3 WHEN ((NOT is_complete) AND (end_at <= now())) THEN 2 ELSE 1 END), (CASE WHEN is_complete THEN complete_at ELSE NULL::timestamp with time zone END) DESC, (CASE WHEN (NOT is_complete) THEN end_at ELSE NULL::timestamp with time zone END), end_at DESC
-> Index Scan using tbl_schedules_project_id_idx on tbl_schedules (cost=0.29..112.28 rows=1 width=183)
Index Cond: (project_id = ANY ('{3763,3755,3570,3483,3063,3074,2976,2855,2830,2612,1791,2423,1736,1942,1741,3809,3808,3807,3801,3786}'::integer[]))
Filter: (((NOT is_complete) OR (end_at >= '2025-06-21 00:00:00+08'::timestamp with time zone)) AND (((is_public = 1) AND (created_by <> 5250)) OR (created_by = 5250)))