| Sort (cost=201.49..201.51 rows=6 width=224) |
| Sort Key: progress."order" |
| -> GroupAggregate (cost=201.18..201.41 rows=6 width=224) |
| Group Key: progress.id |
| -> Merge Left Join (cost=201.18..201.23 rows=6 width=166) |
| Merge Cond: (progress.id = p.project_progress) |
| -> Sort (cost=1.19..1.20 rows=6 width=152) |
| Sort Key: progress.id |
| -> Seq Scan on tbl_project_progresses progress (cost=0.00..1.11 rows=6 width=152) |
| Filter: (NOT is_delete) |
| -> Sort (cost=200.00..200.00 rows=2 width=18) |
| Sort Key: p.project_progress |
| -> Seq Scan on tbl_projects p (cost=0.00..199.99 rows=2 width=18) |
| Filter: ((bargain_date >= '2026-01-01'::date) AND (bargain_date <= '2026-12-31'::date) AND (project_status = 2)) |