| Sort (cost=202.96..202.98 rows=8 width=90) |
| Sort Key: progress."order" |
| -> GroupAggregate (cost=202.54..202.84 rows=8 width=90) |
| Group Key: progress.id |
| -> Merge Left Join (cost=202.54..202.60 rows=8 width=32) |
| Merge Cond: (progress.id = p.project_progress) |
| -> Sort (cost=1.23..1.25 rows=8 width=18) |
| Sort Key: progress.id |
| -> Seq Scan on tbl_project_progresses progress (cost=0.00..1.11 rows=8 width=18) |
| Filter: (NOT is_delete) |
| -> Sort (cost=201.31..201.31 rows=2 width=18) |
| Sort Key: p.project_progress |
| -> Seq Scan on tbl_projects p (cost=0.00..201.30 rows=2 width=18) |
| Filter: ((bargain_date >= '2026-01-01'::date) AND (bargain_date <= '2026-12-31'::date) AND (project_status = 2)) |