| Sort (cost=204.34..204.37 rows=8 width=90) |
| Sort Key: progress."order" |
| -> GroupAggregate (cost=203.92..204.22 rows=8 width=90) |
| Group Key: progress.id |
| -> Merge Left Join (cost=203.92..203.98 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=202.69..202.70 rows=2 width=18) |
| Sort Key: p.project_progress |
| -> Seq Scan on tbl_projects p (cost=0.00..202.69 rows=2 width=18) |
| Filter: ((bargain_date >= '2026-01-01'::date) AND (bargain_date <= '2026-12-31'::date) AND (project_status = 2)) |