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..103.34 rows=1 width=182)
Index Cond: (project_id = ANY ('{4170,4173,4174,4155,4172,4169,4167,4161,4166,4098,4111,4164,4113,4142,4157,4145,4139,4128,4123,4089}'::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)))