QUERY PLAN
Sort (cost=92.89..92.90 rows=1 width=182)
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..92.88 rows=1 width=182)
Index Cond: (project_id = ANY ('{4118,4103,4115,4130,4124,4094,4121,4127,4085,4101,4112,4100,4116,4119,4093,4102,4096,4090}'::integer[]))
Filter: (((NOT is_complete) OR (end_at >= '2026-05-21 00:00:00+08'::timestamp with time zone)) AND (((is_public = 1) AND (created_by <> 1001)) OR (created_by = 1001)))