| Sort (cost=202.87..202.89 rows=6 width=224) |
| Sort Key: progress."order" |
| -> GroupAggregate (cost=202.57..202.80 rows=6 width=224) |
| Group Key: progress.id |
| -> Merge Left Join (cost=202.57..202.62 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=201.38..201.38 rows=1 width=18) |
| Sort Key: p.project_progress |
| -> Seq Scan on tbl_projects p (cost=0.00..201.37 rows=1 width=18) |
| Filter: ((bargain_date >= '2022-06-01'::date) AND (bargain_date <= '2022-06-30'::date) AND (project_status = 2)) |