QUERY PLAN
Aggregate (cost=0.11..0.12 rows=1 width=32)
-> Unique (cost=0.02..0.08 rows=1 width=394)
-> Sort (cost=0.02..0.03 rows=1 width=394)
Sort Key: (CASE WHEN (rvr.status = 0) THEN 1 ELSE 0 END) DESC, r.id, r.client_id, r.project_id, r.title, r.status, r.next_verify_user, r.verify_at, r.description, r.refuse_description, r.is_resubmited, r.created_by, r.created_at, r.updated_at, r.supplier_id, r.purchase_contract_id, r.amount, r.borrow_amount, r.borrow_collect_day, r.borrow_collect_status, r.borrow_collect_description, r.borrow_collect_at
-> HashAggregate (cost=0.00..0.01 rows=1 width=394)
Group Key: CASE WHEN (rvr.status = 0) THEN 1 ELSE 0 END, r.id
-> Result (cost=0.00..0.00 rows=0 width=394)
One-Time Filter: false